Search results

You couls copy the design master to an other folder (include tehe secured file as well) open the copy using the shift key tools replication recover design master you now have two design masters (in seperate folders) you can now amend one and do testing and then export these changes to the...

If you are using msaccess 2000 C:\programfiles\microsoft office\office\1033\wrkgadm.exe double click on wrkgadm.exe join browse c:program files\microsoft office\office\system click on system click on open That should solve the problem

You could also do this, create a field in the detail line on the data tab set its control source as = 1 and set running sum to overall

Not sure if the syntax is correct but something like this should work iif([fielda]=0 and iif([fieldb]=0 and iif([fieldc]=0 and iif([fieldd] =0 and iif([datefield] > Date()+30,[thisfield] +1,null)))))

If you need a username and password to open your database you could, Create a table to hold username and datelogged in and date logged out on startup as your form opens you can check this table to see if the current user is logged in if they are output a message saying you are already logged...

Create a query that selects all the required fields and sort on the field you require. Base the form on that query Or if the form is based on the table,look at form properties , data then type the field you want to sort on in the order by section

After logging without using the shift key press the F11 key

Create a table to hold the log in /out info Tab_Accessed User_Name as text Date_Logged_In as date Date_Logged_Out as date When your start up form opens use an update query to write the username and time to the table On your close button (on click event) write an update query to update the time...

If you right click on the group header section then click properties then the format tab then change repeat section to yes. That should solve the problem

create a button on your sub form and in the on click event type Forms![form1]![addressfield1] = me.addressfield1 Forms![form1]![addressfield2] = me.addressfield2 Forms![form1]![addressfield3] = me.addressfield3

RE:RE:Command button Can you post a copy of your database ?

In the on click event of the button type DoCmd.SetWarnings False docmd.openquery "[YourQuery]" DoCmd.SetWarnings true

I'd like to disable the options to see the table or query design Goto tools startup and uncheck display database window (will not show table query design window

This probably isn't ideal but you could; Select the field that contains 0 on the menu bar click on format then conditional formatting Under condition1 select field value is then in the next dropdown box select equal to in the next field type 0 Then click on the A dropdown list and select the...

1. How can I make a new column in an existing table and then fill it with the same value, at the moment I have to copy and paste every record? When creating the column give it a default value. any new record written to the table will give the column its default value 2. How can I convert the...

go to tools ,startup In application Icon supply the path and name of the icon(keep in same directory as your database place a tick in the box labelled Use as form and report Icon Create a short cut to the database right click on the shortcut select properties then the shortcut tab and then...

the code you want is Yourfield.enabled = false yourfield.locked = true If you put the code in the after update event of the combobox it will work but you wont vbe able to re select the combo box to change your selection

SalesLedger - TransactionID, ProductID Vouchers - TransactionID, Voucher_Ref Products - ProductID, Product_Description In your query change the join types to option 2

SalesLedger - TransactionID, ProductID Vouchers - TransactionID, Voucher_Ref Products - ProductID, Product_Description In your query change the join types to option 2

if you select the combox and look at the properties on the format tab set column heads to yes. now when you click on the combo box the column headings will appear