Recent content by donnie051280

im not too sure what to change, he is the VB code at the moment Private Sub Command39_Click() On Error GoTo Err_Command39_Click Dim stDocName As String stDocName = "close all" DoCmd.RunMacro stDocName Exit_Command39_Click: Exit Sub Err_Command39_Click: MsgBox...

i have a button on a form which when clicked runs a macro. But i want to add a prompt msg when the button is clicked, which states "do you wish to run the macro". When they click ok they will run the macro otherwise if they select cancel then they just go back to the form thanks

in my table Stock i only want 26 records at a certain point in time.. i created my table in access thanks

sorry im a little confused.. when i click a button i add all the information in the txtfields of that form(subform3) into the table(stock) but if sometimes clicks the button twice the error messages occurs.. This is because the primary key has been entered twice.. the txtfield(pallets_ref) in...

when saving information from the form to a table i sometimes get a prompt msg which states. "mircosoft access set 0 fields to null die to fail conversion failure...1 fields to to key violation etc etc". I understand what this means, as the primary key information has been entered twice into the...

update a table which automatically assigns a new reference number for each individual record. i assign 6 values to the table and i want the 7th value to be the primary key which has a different reference number for each new record

i need to update a field within a table with the results displayed in the combo box. all the fields in that particular table are to be updated with the combo box results thanks

i actually have a button on the form which runs a macro the code is Private Sub Command29_Click() On Error GoTo Err_Command29_Click Dim stDocName As String stDocName = "save transfer" DoCmd.OpenQuery stDocName, acNormal, acEdit Exit_Command29_Click: Exit Sub...

when i save information from a form to a table.. 2 prompt msgs occurs.. Is the anyway i can just save the data from the form without the prompts thanks

actually just one more question??? how to you get rid of that prompt about ammend???

thanks for your help i finally got it working don

or if its makes its easier just a button which saves the data from a form into a table

thanks heaps for your help i have never used VB before so im sorry if this may sound stupid do i need to add any information to this part DoCmd.OpenForm stDocName, , , stLinkCriteria, acFormAdd such as the file to save it to.. etc what is the name of the database file which the information is...

yeah.. that makes sense but how would i save the data in the 7 fields inside the form to a table.. Basically everytime i run the query and get the results on the form i want to have a button on that form which saves all this data to a table sorry if it sounds confusing. thanks don

Hi brief description of what i want: the query takes a reference from form1 then opens form2(the one i want to add the data). The fields all come from different tables but all are related in some way. Example.. the job number number is in one table but i need to find out several different things...