Search results for query: *

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

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

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

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

I have split my database into 2 as recommended else where in this forum. 1 for tables (backend) and the other for queries forms and code. Do I have to maintain the relationship diagrams in both databases when I change joins/cascades between tables etc? Or can I just maintain the one in the...

I have a form to book in items which have arrived from a supplier. I have some common details such as date arrived, who received them. I also have a sub form with the list of actual items, with the fields specific to the individual items, such as cost, whether they were checked etc. The problem...

I am using access 97, and even when the application is idle the CPU useage for Access is 100%. This occurs on both an NT4 and 98 machine. As soon as the mouse goes over the Database window in a simple table only DB, the cpu usage shoots up. Does anyone else have this problem? I have SR2...

I have create my own menu bar for my Acc97 application. During various stages I want to disable some of the menu items from VBA. How do you do this?

I have a form similar to the Suppliers form in the sample NorthWind database. Like Northwind it suffers from the same annoying problem with an Access error message displayed to the user. To see the problem for yourself do the following in Northwind Open the Suppliers table. Select a new...

I am trying to enable/disable the close button (x) on a form from vba. When I do me.CloseButton = true I get the following error. runtime error 2448 You can't assign a value to this object. * The object may be a control on a read-only form. * The object may be on a form that is open in...