Recent content by michelleb1

I need to find a way to automatically compact my backend, if possible in the middle of the night when nobody is there. It is used pretty much all day by at least 5 or 6 people everyday. Every so often, I get the message: unrecongnized database format. When I compact and repair the backed it...

I need to find a way to automatically compact my backend, if possible in the middle of the night when nobody is there. It is used pretty much all day by at least 5 or 6 people everyday. Every so often, I get the message: unrecongnized database format. When I compact and repair the backed it...

Nevermind. Thanks Anyhow, Michelle

I have a Master Form, a Subform1, and a Subform2 that is contained by Subform1. Subform2 is called CompletedBy. CompletedBy consists of an id, an empid, and the serviceticketid which links it to Subform1. I use a combo box to retrieve emp first and last name so users can select the name and...

I'd like to show as many records as possible and therefor would like to use the Continuous forms setting. However, I do have subform on my master form and Access will not let you set to continuous forms if there is a subform. Is there any way to get around this? Thanks, Michelle

Through a form.

My users want to type the least amount possible. Since the times we are keeping track of are between the nowmal working hours of eight to five. The AM\PM designation really isn't necessary. We'll always know whether it's AM or PM based on the time. The short date format still includes AM PM. Is...

I am trying to create a report called Tech Schedule which lists service calls for a particular date range. It is based on two queries. One contains most of the fields: date, time, customer, address etc. The other query is based on a table called ticketcompletedby which has an EmpID and a...

What's wrong with this AfterUpdate Event Procedure that's supposed to check for duplicates? I used the same procedure for address and it works - all I changed was address to Job# and for some reason it doesn't work for the Job# field. Job# is a text datatype. Private Sub Job__AfterUpdate()...

Yes, I'd rather not use a subform. Here are the details Form 1) Table=LogJobs, Form=ViewLogJobs, PK=LogJobID Form 2) Table=Delivery, Form=Delivery, PK=DeliverID, FK=LogJobID There is a one-to-many relationship between LogJobs and Delivery. LogJobID from ViewLogJobs is the value that I want...

Thanks so much Edski! I appreciate your time and help. I don't know what I would do without you... By the way, if you have a chance to look at my latest post - that would be great thread702-693976

I have a "Jobs" form with the Primary Key - JobID. The form has a "Detail" button which opens the "Delivery Detail" Form that displays data from a child table. I would like the Delivery Detail JobID to automatically be set to the JobID from the parent table\form...

Thank You, Thank You - Okay, but what if Street# and Street Name are two separate fields?

I have a form that accepts a street number and street name for a job. After they have been entered, I want to check if there already exists a record with the same address and if so - I want to display a notification (It's okay if there is, I just need them to know about it)If there isn't then I...

Rolliee, Delivery Date is a field in the query. I have set the criteria for that field to: Between [StartDate] And [End Date], so start date does not appear in the field list Hope this helps Thanks, MB