Search results

i know i should know this.. i know how to use link criteria when transfering a key field from one form to the next.. but i am unsure as to how to transfer an unbound value.. on my form frmInvoice i have a button called btnAddInvoice it opens the form frmNewInvoice using this at the moment...

i could just copy and paste that but i dont really understand it.. here are some records for example persontable 1,antony 2,jimmy 3,james 4,lisa 5,jenny placetable 1,heathrow 2,sheraton 3,hilton 4,buckingham palace 5,docklands and here are previous job records jobtable j1,1,1,1,4 (ant...

thanks again

yes.. they are all numeric by the way.. what i need help with is the middle part of the above code i posted.. it has to select tblplace.placeid from tblplace where (tblplace.place id = tbljob.fkjobfrom or tbljob.fkjobto and tbljob.fkbookerid = txtbooker or tbljob.fkpassengerid =...

yes.. i thought there was a way to incorporate both statements into one line.. i was wrong.. this works.. it may not be the neatest but it works.. thank you Private Sub btnDeleteInvoice_Click() Dim strSql, strsql2 As String If Nz(Me.[lstInvoiceRefs], -1) = -1 Then MsgBox "Please select an...

ok.. let me do that...

i have 3 tables.. tblJob tblPerson tblPlace ids are linked in the following way http://www.londonheathrowcars.com/3tablelayout.jpg once the booker id and passenger id fields are populated on the job entry form, i want my 'JobFrom' and 'JobTo' drop downs to be populated with places previously...

this code doesnt delete from both tables.. how should i structure this code to delete two records from 2 separate tables.. Private Sub btnDeleteInvoice_Click() Dim strSql As String If Nz(Me.[lstInvoiceRefs], -1) = -1 Then MsgBox "Please select an Invoice to delete!", vbExclamation Exit...

i tried like this aswell and it only ran the first line of sql strSql = "DELETE FROM tblInvoice WHERE (((tblInvoice.InvoiceRef)= '" & Me.[lstInvoiceRefs] & "'));" strSql = "DELETE FROM tblJobInvoice WHERE (((tblJobInvoice.fkInvoiceRef)= '" & Me.[lstInvoiceRefs] & "'));"

yes i think that has got rid of the problem.. im trying another delete statement where i am trying to delete from two tables.. here is what i tried using.. Private Sub btnDeleteInvoice_Click() Dim strSql As String If Nz(Me.[lstInvoiceRefs], -1) = -1 Then MsgBox "Please select an Invoice...

ok.. please look at this picture.. ive explained a lot more http://www.londonheathrowcars.com/xthis.jpg when you look at that picture.. and look at the code above.. and see where the error is on the bold line.. maybe i am asking if there is a better way to accomplish this feat.. any...

ok.. i think there is some problem with this code..basically there are a few listboxes and my user chooses a job and an invoice and when they are both highlighted they can 'add to invoice' or 'remove from invoice' Private Sub btnRemoveJob_Click() Dim strSql As String If Nz(Me.[lstInvoiceRefs]...

yes.. i have fixed it.. Me.txtbooker = Forms!frm3AddPerson.goodid was refering to a control.. not a variable that i defined in the control.. i just named the control goodid and removed the Dim goodid goodid = Me.txtFoundID and it worked.. thank god for that.. i can proceed..

i have the same code pretty much word for word workin on another database.. im sure everythin is named correctly what could be causing this?

this error is happening now and i dont know why.. it was working fine a little while ago.. i am transfering a textbox value (number) from one form to another.. here is the code that triggers the next form to open.. Private Sub txtbooker_Exit(Cancel As Integer) If Me.txtbooker.Value = 0 Or...

yes.. i realised that to have a 'left frame' wasnt really neccessary.. i just used the form header and footer.. and the middle part scrolls like a charm.. thank you.

yes.. it works perfectly.. thank you

hello.. imagine that FormA and FormB both use FormX while they are open to perform a similar task.. at the moment im using something like this.. FormA & FormB Private Sub txtControl_AfterUpdate() DoCmd.OpenForm "FormX" End Sub txtControl will be placed on both FormA and FormB the purpose...

hello wondering if this is possible like the old 'frame' style websites.. or for those of you that know.. the overflow feature of a div on the content frame.. is it possible to have the form window open in a specific size.. then have a left frame and frame at the bottom that are in a set...

yeah ive thought of the way around it.. wasnt rocket science.. just add another drop down.. thanks