I have had a problems with parts of my access app not working correctly on machines without access installed when distributing using the ODE setup wizard. This included #Name? appearing on some fields on my reports.
The cause and solution was as follows.
I was planning on using MS Word to...
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.
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.