Recent content by gar348

Hello Is there anyway to add the SQL server login to the switchboard on my access database ? Ie so this is the first screen the user sees so i can create individual SQL user ids, then when the SQL password is entered the main menu opens.

Hello....... Hope someone can help me out - I have a database form with tab controls and various subforms all linked with child / master fields. When a new record is added in the main form the id in 1 of the subforms remains at (new) until data is added. How can I get this to generate a ID...

guys even with most of the tables stripped out its still 5mb !!! this error is driving me mad - it shouldn't be happening cause its such a simple command !!! dropbox is blocked at work but I will take a copy of the DB home and share from there later today any help is appreciated cause...

No Thank you..... If you by pass the login screen with shift you need to open test form 1 and double click the list into the jobs... On the booking page the job value field is the one with the control in.... Guys the database even without tables is to big to upload !!:banghead: could...

I will need to strip out the data and some of the margin calcs so will upload ASAP

Hello The full code is simple really Private Sub Order_Value_AfterUpdate() Forms!FrmNewcastleQRCJobs!PMUEST2![Sell Price] = [Order Value] End Sub For some reason changing this is kicking out this error..... but like I said if you navigate to PMUEST2 tab before exit this does not happen...

Hello Its updating the field but still coming up with the attached error

That's not possible as the control [sell price] is in a diff subform

Come up with a short term fix - since the form was updating just added the command DoCmd.SetWarnings False to the exit of the form... DoCmd.SetWarnings False DoCmd.OpenForm "TEST FORM 1", acNormal DoCmd.Close acForm, "FrmNewcastleQRCJObs", acSavePrompt

Hello Sorry for the slow reply - had to leave in a hurry last night.... So the actual control is written Forms!FrmNewcastleQRCJobs!PMUEST2![Sell Price] = [Order Value]

hello. . Yes all the fields are bound and in the data source of the main form. . the return to menu button is in the footer of the main form. . . What's really strange is if you change the value. . .navigate to the changed field then hit the exit button you don't get an error

using access 2010 . . return to menu is just close main form open switchboard

Yeah the same thing. . . think of the return to menu button I have I need to put something to mate the tab active. .. .

it's on the lost focus event of the field

Hello....... Need some help with a new problem that has just come up as my database is about to go live..... form design is Main form Tab control Sub form in tab control *********** On tab 1 when a field is changed there is a very basic me1.[xxx]=me2.[xx]. Me 2 is in tab 1 and me...