Search results for query: *

I'm having the same problem. I can't import a form named "attendance" because the class object "Form_attendance" already exists. How can I delete "Form_attendance" from the project explorer?

Get rid of the Val() function, which only returns the numbers in a string. The Mid function will give you alphanumeric data. IIf(Mid([D_Data],51,1)="x",Mid([D_Data],26,9),"") AS [Marginal Unit] Also get rid of the Val in the WHERE clause.

Use the Find Unmatched Query wizard. 1. Go to the Database window. 2. Click Queries. 3. Click New. 4. Choose the Find Unmatched Query wizard. (If you do not see it, you must install it from the MS Office CD.) a. Select the table with the data you want. Hit OK. b. Select the table that...

Ken, You are a super duper VB trooper. It works great. Thanks. Ben

How can I dynamically link the back end of an Access 2000 database? The database has one front end and two back ends. I want to give the user the option of choosing between two data sets residing on the same computer. The link table manager will only set up static linkages to external tables.

Create a form with a text box and a command button. Name the text box txtLeaseNo and the button cmdPreviewReport. Name the form frmCreateLeaseReport. In the criteria row for the Lease field of each query, enter forms!frmCreateLeaseReport!txtLeaseNo. In design view of frmCreateLeaseReport...

In the database window, choose queries and the new button. Choose a table to work with from the dialog. From the table showing, you can just double click the fields you want and they will show up in the fields pane. To preview the query, choose datasheet view from the toolbar. It will not...

This story has a much happier ending, as I have found a perfect solution. Remember what I wrote in the original post about displaying the pictures on detail_format? Well, that's a very bad technique, as it causes Access to load the whole 70 page report before displaying the first page. Plus, it...

I got around the problem by putting the Dir function in a user defined function. The query calls the user defined function. Now it works fine. I tend to agree with PHV and Microsoft that it is a references problem. Manually refreshing the references on the user's machine did not fix it...

PHV, It compiles with no problems.

PHV, Yes, I checked for the references. They are checked in this order on both machines: VBA MS Access 10.0 Object Library OLE Automation MS Office 10.0 Object Library MS DAO 3.6 Object Library ADO is unchecked because DAO is faster. I thought the problem might be permissions, but everyone...

Is there something wrong with the Dir function in MS Access 2002, build 10.2616.2625? I am using the following SQL in build 10.2616.3311 without problems: Select IIF(Dir("C:\appPath\Pictures\" & Personnel.[PersonnelID] & ".jpg")="",False,True) as HasPicture FROM Personnel When executing the...

I like the idea. I'll just replace the picture with an icon that says "Click here to see picture". I'll add logic to only use the real picture when printing. Thanks, Bob and Cosmo. This is a good solution. I appreciate your help. You've done your part for the war effort today.

Cosmo, I have a similar form with pictures from the database itself and it is agonizingly slow to scroll. I can't imagine linked pictures being faster. Thanks for the suggestion, though. Ben

The report shows how much money each soldier is due for the month. The paymasters use the report to determine how much money to draw for the battalion, so it has to be accurate. They like to Print Preview it so they don't waste 30 minutes and 70 sheets of paper printing an inaccurate pay roster.

Bob, I cheated and got around the problem by not showing pictures in Print Preview. It's not ideal, but its better than waiting 6 minutes. The data is of a battalion of soldiers (500 guys) organized into five companies. The printout is used as a pay roster. I can show just one company at a...

Geekmomz, I got close by putting both RMA and PO fields in one header and taking off the grouping on the serial number field. I'm wasn't able to limit each group to ten serial numbers, however. Sorry. Ben

Bob, I guess my only possible option is to use an event procedure with the OpenReport and PrintOut actions inside a loop that can track which page the user wants and only print preview that page. I am a soldier in Afghanistan doing this report for their national army, so I appreciate your help...

Bob, The star is for the information and you coming up on the two year anniversary of your other now-famous thread on this topic. Congratulations. The problem remains, however: why would Access load a 500 record embedded picture Print Preview in 3 seconds when the same database using linked...

I have an Access report of 500 records with linked pictures for each record. Each page shows 8 records. The report takes 6 minutes to Print Preview. It used to take 3 seconds when the pictures were stored inside the database. The database is 95% smaller now, but my report is takes way too long...