Recent content by StuMunro

Did you find the solution to this problem? Did importing the objects to a new db work?

Have a look at the following link I created faq181-1626

Have a look at the following link I created faq181-1626

You are missing one of the dll's which contain the code functions. make sure you include these files in the setup wizard. You can find the files by opening a code module and looking at the Tools/References menu. The ones with ticks must be installed.

That is what I have done, however it is these queries that make the data exportable.

I have tried to secure my access application so that default users (no password) only have access permissions via the forms and reports. To do this I have removed permissions from all tables and made queries with the RunPermissions set to Owners or RWOP. To allow the forms to work on these...

I have been shown a solution to the above problem. When using autonumber fields as in the above set the option to generate a random number rather than an incrementing number as this will not reuse a previously used autonumber. stu

In my Access 97 database I have several tables such as customer/products all linked to a current orders table. When a new order is placed a new record is created in the current record table, this is unique by using a AutoNumber field. Current Orders table OrderID CustomerID OrderDate etc...

Re: point number 1. I dont think I explained myself clear enough here. I basically want my application to have similar security to that of a VB/C++ program which uses a password protected database to store the data. All access to the database would use a hardcoded password in the VB...

I am just finishing off an application in Access 97. The application is split into a backend for the tables and the front end for the queries and forms etc with linked tables to the backend. I want protect the application so ALL of the following are met. 1) No access to the table data expect...

I am trying to do the following but without success. This is just test code all in the same procedure, the real code is trying to use the forms collection else where. Dim frm As Form_testRepairs Dim f As Form Set frm = New Form_testRepairs For Each f In Forms...

I have tried this with the Required property = yes on the table field but no difference. I think due to the nature of a yesno field it is automatically initialised to 0 (No) Stu

I have a combo box linked to a yes/no field in the table, I want to force the user to chose "yes" or "no", by initially having the combo field blank on a new record, ie I dont want to just use a default of no. I have tried various ways such as setting the rowsource property...

I am having a similar problem with UNION queries. When the results of the query are viewed the yes/no fields have lost their formatting due to the UNION SQL statement they display as 0's and -1's instead of check boxes. How can I get the checkboxs on a union query?? To see what I mean create 2...