Recent content by TanisAgain

You see this message because the macro security level in Access is set to High and the file that you are trying to open is not digitally signed. If you or a member of your workgroup created this database, you should consider obtaining a certificate and digitally signing the database. You and...

This SQL picks out 30 random records from a table. This is a make table query. SELECT TOP 30 tblRandomRecords.ID, tblRandomRecords.FirstName INTO Newtable FROM tblRandomRecords ORDER BY Rnd([ID]);

I can't see why the code is not working? I must admit, I havn't used it with workgroups. but the code looks right. What error messages are you getting?

The fields do not have to be primary keys. In the table design you will find property called Indexed. Change it to 'Yes(No Duplicates)' Having said that, it would be better if the values were checked in a form. You could still perform data validation there.

If you simply want to open another DB from already open db, then there are a couple of ways to go. You may have to change the path to the application. Private Sub cmdOpenAnotherDatabase_Click() Dim stAppName As String stAppName = "C:\Program Files\Microsoft Office\Office\msaccess.exe DBPath"...

Have a look here. It may well provide the answer. http://support.microsoft.com/kb/263084/en-us

Column count in a combo box starts from (0). Try changing your column count to (1)

Create a new query with the wizard and choose 'Find unmatched query wizard'

Post the SQL

What do you mean by 'system' Is it a table in an Access database? You don't need a form, you would do a comparision by query.

Try the query by form technique. Example here. http://support.microsoft.com/kb/209645/en-us

Thanks folks, problem solved.

I have used the OpenArgs method to pass a parameter to another form, but I now need to psss two parameters, and I am not sure how to do this. On Error GoTo Err_CmdOpenForm_Click Dim stDocName As String Dim stLinkCriteria As String stDocName = "frmName" DoCmd.OpenForm...

The code you are using would be helpful.

Try here. http://support.microsoft.com/kb/210297/en-us