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...

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

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()...

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...

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...

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...

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...

There are several fields that I need to display on my form but which cannot be edited. I have set their enabled properties to no. Now, since they are "grayed out" they are difficult to read. Is there a way to display these fields more normally and not enabled? Thanks, Michelle

Suddenly I am unable to add new records on my form. I tested it and added new records, made some layout changes and now I cannot add new records. The standard add new record button with the asterisk is now disabled. I don't think I made any significant changes. Even weirder I had a backup copy...