Search results

You may want start by converting the Tables only. I would Import them to another temporary database. Then convert this database. If you get the error, try importing a couple of tables at a time until you can narrow down the error. Not sure if this is practical, since I'm not sure how many...

I don't believe this is possible using the sendobject command. What you may have to do is make one main report and make the 3 reports you want subreports of the main report. Then use the sendobject to send the main report.

Did you register the control? Also try moving the control up in the reference list. Go to the same place you added the control, select it an use the arrows to move it up in the list.

In the DCOUNT command, you do not necessarily have to use a query, you can use a table name. Here is the syntax: DCount(expr, domain[, criteria]) The domain can be a query or table. Use whatever recordset the report is based upon. If the report is based on a table use: =DCount("*"...

This is probably a reference problem. The Common Dialogue active X control needs to be registered. Choose Tools, then references from the code window and make sure MS Common Dialogue is selected. To then regeister, run the regsvr32.exe command on comdlg32.ocx using a MS Command window.

I am using Access 2002 and Outlook 2002. I am using the SendOjbect command to fax a snapshot of a report. After the command is performed I immediately get a message from System Administration stating the message was undeliverable because the The following recipient(s) could not be reached...

It can be on any shared resource, server or computer being shared. You really would have one front end, you just put separate copies on each workstation that needs to run the application. Then, you can manually link the tables from the backend. Also, you may want to map a drive to the...

I would probably add an InvoiceType field that has a P or S. You can do your users a favor by automatically filling in the field with what type of invoice they are entering. Do this by creating two forms, one for purchases and one for sales. Depending on what form they are in, you can have...

The key here as with Access itself is relationships. You want to build a one-to-many relationship between the patients table and the appointment table. To get a subset of the appointment table you can always query the appoinment table for a particular patient. Using the example by Uncle...

Many people separate their applications into two MDB files. One a Front End w/ forms, queries, reports and modules. Two a Back End with nothing but tables. You then link the front end to the back end tables. You can have multiple Front Ends linked to the same back end (maybe sitting on a...

Try using the dcount command as the datasource for the text field. Here is an example =DCount("*", "QueryName")

The customer is running an .MDE version and we don't believe there are any missing references.

I have a form that is using the Date() function in one of the fields. This was working fine, but the customer installed some other application and now instead of showing todays date, the dreaded #NAME? is showing up. Can anyone give me any idea what library may be having this problem. I found...

I am having the same problem but in a form where I am using the Date() for the default value of a field. Did you ever resolve this problem?

Jon, I am interested. An auction make sense, especially if there are geographical considerations. Count me in for the auction.

You have a normalization problem. Your data design is not valid, so you are bound to have problems. Unless you have a specific reason. You should have one table with all the fields in your two identical tables with and additional CITY field defined. In your definition combine the city, data...

I wouldn't move the post. To run an immiedate window you must place a "?" in front of the function name, but running off the mouse click should be fine. Again, what line of code specifically is the debugger going to on the error. Worse case, if I had the spreadsheet, I could run it through...

OK let me try to explain this. Do not define 3 separate employee fields in the table tblEmpProj. It will ONLY have two fields, a projectid and an employee id. In this table, there will probably be three rows for each project. When populating this table, you must use code to ensure there are...

Sorry, Access is all or nothing. You can not assign properties (Bold, underline, color, etc..) to part of the text.

Here is the function. Run it from the immediate window or call from a button. Before running, you must import the spreadsheet. When importing, tell the import wizard that the first row is the column heading. Also when asked about the primary key select "No primary key". Give this new table...