Search results for query: *

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...

Thanks for your help, this is what I wanted to do. Is the error code 2279 specific to date fields or just input masks in general? If it is just a general code, I assume I will have to work out which is the active control to display a specific message? Is there a list of the error codes...

using the object browser the date functions are part of the vba dll which should be located in c:\program files\common files\microsoft shared\vba\vba332.dll stu

I have set up an input mask for a date field text box in my Access 97 based application. 99/99/00;0;_ If I start entering the date ie 25/ and tab out of the text box I get the following warning. "The value you entered isn't appropriate for the input mask '99/99/00;0;_' specified for this...

Watch out, despite the following statement from the previous posts: In Microsoft Access 97, the DoMenuItem method was replaced by the RunCommand method The wizards in Access 97 for buttons etc, still insert code using domenuitem, which I believe will not work in Access 2000 Stu.

Access has predefined short cut keys such as Ctrl-O - open db Ctrl-N - new db Ctrl-S - save object Ctrl-P - print object. My access application is supposed hide all access functionality by using custom menu/toolbars. I have switched off all the default menus/toolbars/special access keys...