Search results

Private Sub btncard_Click() Dim stLinkCriteria As String DoCmd.RunCommand acCmdSaveRecord stLinkCriteria = "[jobref]=" & "'" & Me![jobref] & "'" DoCmd.Close DoCmd.OpenForm "k_job_card", , , stLinkCriteria End Sub this button code opens the k_job_card form. the form opens and says 'Record 1 of...

sending the id using linkcriteria i dont need it to be saved in the individual module.. it seems to be sending it across ok.. correct me if im wrong

also if i make sure the lock is set to edited record on both forms.. would it be possible to open them both at the same time.. even though they will both be refering to the same record?

yes i still can and it works i think

if i do this then would i need to refer to the 'sendref' variable in the separate module?

one last thing.. in job1.. at the moment it is telling me that i cant create a record because it will create a duplicate value in the primary key.. these two forms populate a single record in a single table.. at the moment im using this.. DoCmd.GoToRecord , , acNewRec in job form to create...

thank you sir..

still the same prob.. its here in 2003 and 97 format.. have a look

ok.. it says error 3008 its trying to open the job1 form but the job form is still open.. this is wat i have at the moment.. Form Module Option Compare Database Public sendref As String job form Option Compare Database Private Sub Command6_Click() DoCmd.RunCommand acCmdSaveRecord...

ahh ok.. so if i use that.. can i just use 'sendref' anywhere i want in my database.. and it will be that value.. what about setting that value.. Modules!ref.sendref.value = me.txtjobref.value and reading it.. Me.txtjobref = Format(Modules!ref.sendref, "00000000") are these correct because...

ok.. i doubt it is as simple as this.. but i reckon its nearly this simple.. ive saved a module as 'ref' with this code Option Compare Database Dim sendref As String and then.. Private Sub Form_BeforeUpdate(Cancel As Integer) DoCmd.RunCommand acCmdSaveRecord Modules!ref.sendref.value =...

i want to send an id from 'job' to 'job1'. the job form needs to be closed before the job1 form opens.. i want to do something like this.. job form Private Sub Form_BeforeUpdate(Cancel As Integer) DoCmd.RunCommand acCmdSaveRecord DoCmd.Close DoCmd.OpenForm "job1" End Sub and then on job1...

right let me spend 3 hours trying to fix this..see if i can sort it

a form should open when a record in a listbox is double clicked.. the form doesnt open.. and when i open it independantly i am unable to edit any of the fields. the form is based on a multi table query. if anyone can suggest why it doesnt work i would be most grateful. 2003 version on my...

yeah i have the habit of asking before trying.. plus i was only working on it for an hour or two today so i tried gettin a quicker answer.. i wont continue this habit

ring ding ding ding ding yeeehaaa

mate.. you know i completely understand.. the creator of the forum rests happilly in his grave... whenever you can give me any help its fine.. thanks for the reply

still nothing bob?

so are you telling me that this code will work?? Private Sub idfound_AfterUpdate() Dim newid newid = idfound.Value If KeyCode = 9 And IsNull(idfound) Then Me.cboname.SetFocus Exit Sub If CurrentProject.AllForms("job_cash_single").IsLoaded Then Forms!job_cash_single!qpax.Value =...

thanks.. im sure its not a huge problem.. i just cant seem to get it working..if anyone else could download the sample database and give it a go i would be most grateful.