Search results

I have a recordset and am looping through the records taking field values and would like to display each one in a separate text box in a form, each textbox has a similar name - Textbox1, TextBox2, TextBox3 etc Is there a way of using a string to reference a textbox so i can just change the last...

Been scouring the internet for ages to understand why this isn't working whenever I run it I get this error message 'Syntax error (missing operator in query expression '((([Asset Group].[Asset Number]) = AN00001) AND ((Group.[Group Type]) = Camera Unit))'. I've copied this code straight out from...

I have a button that opens a form and goes to a new record and vba automatically fills in a textbox and a combo box. I have a canel button that contains Form![FormName].undo DoCmd.Close acForm, "FormName" it deletes everything the user puts in himself but keeps the record with the fields vba...

I was wondering the easiest way to create an unrelated field that the user can just input data on opening of report and it will be displayed on the report. I want to be able to open a report and a user is prompt to enter a string or choose an option (it is current status where it can only be...

I have the three tables related like shown in attachment. I want it to not let a period be created with a projectID and BudgetID that doesn't match any record in the Budget table. I thought the relationship would prevent this, any help appreciated, Thanks

I've created several tables each that are linked and use look ups, the lookups are a couple letters followed by a number e.g. HP00001 and they display correctly in the table they originate from but when in other tables it only shows the number part so just 00001, I don't understand why, any help...