Search results

There is code in the API section at www.mvps.org/access that will allow you to open the standard Windows file open dialog. You can set the default folder to open based on the client ID.

Hmm, you do seem to have some circular references, but its not clear what's causing them.

If you are basing a report on a query and the query returns no records, the report won't work. You can use the On No Data Event to produce a message that there are no records or change the Recordsource to a dummy table that returns a blank record.

Using CurrentUser() requires using Access security. I don't particularly like Access security. I find it cumbersome. You can do the same thing using Environ("Username"). This functions returns the network login ID for the PC. You would then go with something like Smart recommended, where you...

Can you explain more about what you want this link to do?

If you have aliases in the Relations window it probably means circular references. You might want to do a screen shot and attach it.

It amazes me too. Generally, I've heard that Access starts to bog down after 20 concurrent users and that's on a split database. I will repeat something I have said before. EVERY database that is either multi-user or supported by someone other than the user NEEDS to be split. This is an...

I agree with ssteinke. The method in the indicated in the article he links to is the preferred one. You can use the same method if an unbound image control on forms as well as report. For a Form you use the On Current event to set the imagepath. In your case, since you want to store multiple...

glad to assist

I apologize. I did misread your note. I thought you were advocating add a field to a table, not a column to a query or a control on a form. Scott<>

Toni, You are missing the point. This can be done VERY easily if you use a normalized structure. Just follow my suggestions for table structure. If you have been entering data we can help you transfer the data to the correct structure. Once you have this strucutre, you can create a query...

You can reference the value of a control on a form using the syntax: =Forms!formname!controlname

Your structure is incorrect. It needs to be normalized. Something like this: tblDocuments DocumentID (Primary Key Autonumber) DocName DocLocation tblDocType DocTypeID (PK Autonumber) DocumentID (Foreign Key) DocTypesID (FK) tluDocTypes DocTypesID (PK Autonumber) DocTypesCode (1A through 8E)...

This looks fine to me, though you could take it to extremes with a separate address table and lookups for City, Postal code etc. You might also need to account for books that are collaborations and have multiple authors. That would require a junction table: tjxBookAuthors BookAuthorID BookID...

That's because it shouldn't be in the table. One of the principles of relational databases is to eliminate redundant data. Since you can get to The Service Issue by joinng to that table using the IssueCode you don't need to store it in the Service Calls table. You just want to display it on the...

Go to File>Page Setup in Report design mode. Set the report to be in columns and set the columns to Across then Down.

There is no way to block them from using the keyboard. They can still type in a value instead of picking one. However, if you set the LimitToList property of the combo to Yes, they will get message that the value isn't in the list and it won't be accepted.

Make sure the Data Entry property is set to No.

Unique records eliminates any records that are total duplicates in every field.

Try using the SWITCH function.