Search results

I am running a query that returns the minimum, maximum, and average mileage of a list of cars. I have set decimal places to zero in all places I can think of, but of course the average returns with a long decimal output. These figures are then displayed on a report. How can I truncate the...

I have created a form that has an unbound field into which I'd like the user to be able to enter date parameters such as >5/1/07 or between 5/1/07 and 5/31/07. A query is then run with a button on the form which looks for the criteria on the form. If I enter a date by itself, it runs fine, but...

Driving me nuts! I have a form utilizing combo boxes that is based on a query, I have Data Entry set to No, and a new record is still added to the table on which the query is based. Data deals with cars. I have separate combo boxes for year, make, and model. The user chooses each parameter...

I am trying to project how long it will take to reach the 2GB Access limit in a specific project. My client downloads approx 250,000 records on a monthly basis. I've been provided w/ a sample Excel spreadsheet. I filled a spreadsheet w/ the max number of rows (65536 rows w/ 10 columns of...

I've been asked to assist a local non-profit transfer an Access DB to a new server. The DB was set up a number of years ago and the designers are no longer available. The old server is set up as a workgroup server, and the new server is set up as a domain server. (I am completely unfamiliar...

Hey folks, Using the following code I am creating an e-mail (Outlook) from a form. The issue I want to resolve is in the Subject line. As can be seen in the code, the Subject Line (code highlighted) of the e-mail will have "Patient Note:" in it. I would like to add the last name of the...

I built a multi-user DB in Access 2K (<10 users....perhaps 4 or 5 at a time). It has not been split (as of yet). It has been running fairly well for the past 12 months. I recently have taken a more active role in the group. My new box is built with Win2K and OfficeXP (Access 2002)...

I have seen this mentioned a few times, however I can't seem to get it to work. It would be very helpful at times! Thanks Win2K, Access2002

I am having trouble with a multicolumn report. I have tried to follow the directions in the Help file, but to no avail. I am dealing with patient Lab values on multiple dates. I have it set up with a Report header, which works fine. In the detail section, which I understand is the width of...

I have been experiencing an error in Access2K after viewing a report during the session. When I close the database after viewing a report I get the "Can't save this record at this time....." error msg. I have narrowed it down to running the report. If I open any report during a session I get...