microsoft.public.access.gettingstarted | Forum profile

  On Tue, 6 Jan 2009 20:02:01 -0800, Richard <Richard@discussions.microsoft.com> wrote: > I created and split my database. I then exported all the tables from the >Warehouse_be.mdb to our SQL Server. I used ODBC Data Source Administrator to >create a new SQL Server data source. Next I linked the front-end to the >tables on the server. The database performs very well. > > Here is...

  I think you may be confused about what you input and what is really in the DB You can set the Input mask (to short time) to give you 18:30 And you can set the field format to this as well But this is not what is stored You store the full time date value in any time date field - even if you can't see it. Just play around with the format property of the field until you are happy with the result and then set the input mask to the...

  Thanks that's what I was looking for.. "MikeJohnB" wrote: > Try the following > > Private Sub Label30_Click() > Dim strWhere As String > Dim L As Long > > If Me.Dirty Then 'Save any edits. > Me.Dirty = False > End If > > If Me.NewRecord Then 'Check there is a record to print > MsgBox "Select a record to...

  What do you mean by: "....each record could contain multiple bits of information....."? If you are recording something like the contents of the box, then you shouldn't be recprding this data in notes. Rather you should have a separate table. Your tables would look like: TblBox BoxID <Descriptive fields about the box> TblBoxContent BoxContentID BoxID <Descriptive field about the item in...

  Try posting in microsoft.public.outlook for help. this ng answers questions about MS Access relational database software. "l89015o" <l89015o@discussions.microsoft.com> wrote in message news:A98A2D3F-24DA-4703-A3C4-BFDF702D16BE@microsoft.com... >I no longer can listen to e-mails that have sound in an attachment. This > started happening in the last week or so. My speakers work for...

  I would create a separate table for notes and use the other table's primary key as the foreign key within the notes table and then use a subform to enter as many notes as needed. -- Bob Larson Free MS Access Tutorials and Samples at http://www.btabdevelopment.com __________________________________ "Timothy Millar" wrote: > I have a database that I use to track boxes. Each record is a single box as...

  Hi Wayne Thanks for your advice, I've been using Office since it started and this is my first venture into Access. Kind regards Brian "Wayne-I-M" wrote: > I think you may be confused about what you input and what is really in the DB > > You can set the Input mask (to short time) to give you 18:30 > And you can set the field format to this as well > But this is not what is...

  P.S. I might need some help building my query, I will let you know after I build those tables. Thanks Again. M "Marilyn Myers" wrote: > I will try this tomorrow when I go back to work. Thank you so much for your > help and Happy New Year! > Marilyn > > > "Steve" wrote: > > > It's virtually impossible to programattically determine...

  Thank You very much! I will goto B&N tonight and peruse the shelves... -- Thanks a lot! "John W. Vinson" wrote: > On Mon, 5 Jan 2009 16:03:00 -0800, r4pugh <r4pugh@discussions.microsoft.com> > wrote: > > >Helllo Everyone, > > > >I am a new Access 2003 user. In new i mean i just finished all the MS online > >tutorials...

  Thank you, I am new to this site and was on the wrong selection, I have re-posted my question on the Excel Discussion board -- "If you can''''t have the best of everything make the best of everything you have"...BIAKathy "BIAKathy" wrote: > I have a spreadsheet that is date by colume and customers by rows and I need > to concatenate the date and comment for each...