Haha perhaps. We just hired a new person to be the permanent DBA, so from now on I'll probably only be asking odd questions like this one for my regular...
I am attempting to link forms by the field PreApID, which is a text field in the format LM2007-##However, I keep getting this error box: Enter Parameter value...
DBA or DB application developer? Two different jobs, although currently, I do both. Bill ... so ... one ... clients ... guys ... need ... only ... and ... the ...
Come to think of it, pretty much both. I guess we're hiring a less experienced Bill. He's MS certified and all that. He starts next Monday, but I will be on...
I am using Access 2003. I have a database, and made a replica of it to work from. I did this hoping i could have my original as my back up. I'm thinking now...
I gave up on replicas a long time ago. They're great for keeping a laptop's tables sync'ed with a master when you have a person out in the field, but that's...
Rebuild from scratch? After all your hard work? Balderdash! Maybe just make the tables more workable. Bill ... less ... leaving ... It ... this ... this ... ...
Well, you can barely understand a thing I wrote. Let me fix that. I am using Access 2003. I have a database, and made a replica of it to work from. I did...
Yeah, I think the only problem is normalization. Which is a big problem! ... next ... MS_Access_Professionals@yahoogroups.com, "avmedgnv" ... or ... you ... a...
Thanks, this links correctly, but I'm still getting the second error: "Object doesn't support this property or method" If I ignore it, everything seems fine...
Good Day All, I have a report that I want to calculate the number of hours and minutes (hh:mm) that an employee works. The fields, TimeIn keeps track of the...
I just found it, everything seems to run if I cut out the second set (I couldn't actually get it to show where the code was sticking) Thanks for your help! ...
Bingo Clive, it worked. I'm 95 percent home, but there are times when employees work into the next day - for instance TimeIn = 8:00 p.m. on 4/30/2007 and...
G'Day I was wondering if someone would download the file clientlistv0.01.zip and see where i am going wrong in my code on the frmCriteria. The form is based on...
Hello, I'm relatively new to Access, but did take a 2-day course to learn the basics. My situation is that I need to create some type of interface for people...
Can you export the objects to a new database? Or maybe open a new DB and import the objects? If not, try saving the objects as text if possible. If you can,...
Thank you all for your help. I got it working ... event. ... this ... mojdojo ... that is confidential, legally privileged or protected by copyright. ... ...
Hello, This email message is a notification to let you know that a file has been uploaded to the Files area of the MS_Access_Professionals group. File :...
MS_Access_Professiona...
May 2, 2007 3:54 am
48776
Hi David, Try the function "DateDiff («interval»; «date1»; «date2»; «firstweekday»; «firstweek»)". As interval you can set quarter, month, day, hour,...
Hi David, If you have the DateTimeIn and DateTimeOut then use: Format(DateTimeOut - DateTimeIn, "hh:nn") otherwise use: Format(Dateout + TimeOut - DateIn +...
Hi Adrian, I have downloaded the DB and started looking at it but there at least two missing definitions: FieldTypeName varData I will guess that there is a...
Hi everyone, can someone please help me with exporting a MS Access '97 report as a Word document? Word isn't recognizing it and rtf doesn't keep the format of...
David, Clive, Eddie, Rob, A note covering time calculations based upon date/time type fields or variables is give below, for ready reference. Best wishes, ...
Hello All, I didn't find a solution but I did get a resolution. Apparently, in the changing of the SQL database from compatibility level of 65 to 70, the...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
