Search results for query: *

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

My form is based on a query that prompts for a start date and an end date. I want to show the dates in the header of the form. I have done this before but only in a report by setting the control source of a text box to "=[startdate]". When I try to do it this way in form it does not...

I have a form which I have set to open in datasheet view and it does when I run the form directly but when I open it through a command button on another form it opens in continuous forms view. Can I make open in datasheet view? Thanks, Michelle

There are several instances in which I have created one-to-many relationships and I'm not sure how to most efficiently extract and import the data from the old flat excel spreadsheets. For example, 'Jobs' was an excel spreadsheet with a field for a customer name. Now it is a table with a...

Is it true that Filter by Form cannot be used to search if you select from a combo-box? I read that in someone's post. I split my db and tried it - everything seemed fine - am I missing something - I really need users to be able to use that feature to search.

The db will have about ten users. I am doing this in stages, so I will definitely be adding & modifying forms and reports. If I don't split - I can just import the new forms and reports into the db on the network. If I do split it, then I'll have to import them from each of the user's machines...