Search results

I have an Order number register number, i.e. Order number 4564 etc kept in a table from which I have made an form. When I want to create a new order with next order number I open the form try and take the number and put it in a variable called OrdNo: DoCmd.OpenForm ("System") OrdNo = [OrdNo]...

I am trying to use the DateAdd Function on a form. I have a field called 1STDATE once entered the form takes you to a ‘NumberOfDays’ field. Upon leaving that I want it to calculate the last date and populate the active box with it. The Field is called '2ndDate' I am struggling with line...

I created a Database that has been running fine for some years. Sure I've added bits to it, the odd field. pushbutton etc and all was fine until ... when I press a button to open a form I get an error message: Unrecognized Database Format (file path) I have tried to use the "Compact and...

Hi I wonder if you can help I have created a multi record report from a query. The Report breaks upon Branch and lists all stores attached to that branch underneath. I then decided that I needed to make it more specific so added the 1st line of the address to the query then added it to the...

Help please, I am struggling to auto populate a field upon loss focus of another field. I want current date + 7 days. I have tried using: NCD1 = DateAdd(d, 7, Date) and get runtime error 5 - Invalid procedure call or argument From what I have seen on the web there should be a () after the...

I created a database that opens with a switch board that operates off buttons. This worked perfectly okay until one button, opening a form, caused Access to die. Nothing had changed and if you go into another button of the main switchboard and then the problem button the problem button works...

I want to make a password. If I try to do this I get a message box telling me to open the database in exclusive mode. Unfortunately the solutions that I've googled don't seem to apply to Office 365. Can anyone help please? :banghead: Many thanks Ian

Hi All, This is the first post of a frustrated Basic Programmer trying to unlock the power of Access with two guide books :eek: I am trying to program a 'simple' game in which two fields in the character table are co-ordinates X and Y I have a map table which has fields linked to X and Y...