Search results

ok.. here is what i am using at the moment "SELECT tblInvoice.InvoiceRef, tblInvoice.Status FROM tblInvoice, tblAccount WHERE left([tblInvoice].[InvoiceRef],3)=Left([tblAccount].[AccountRef],3)" what this is doing is selecting any invoice number in the database.. basically this code is used in...

SELECT tblInvoice.InvoiceRef, tblInvoice.Status FROM tblInvoice WHERE tblInvoice.InvoiceRef (first three letters) = (tblAccount.Accountref Where tblAccount.AccountID = cboAccount); InvoiceRef and AccountRef are both text datatypes here are sample records from the 2 tables concerned...

if xlook is goin to be null when there are no values found that match the current generated invoice number.. i want the new invoice number to stay put when xlook is null.. so the not shouldnt be there right?

i removed the Not and it seems to be working

this doesnt work..just freezes access.. no error comes up is it in the wrong order? Private Sub btnGenerate_Click() Dim rdm As Long Dim xlook As Variant Do rdm = Int((99999 - 11111 + 1) * Rnd + 11111) Me.txtinvoicenotest = Me.cboAccountRef & rdm xlook = DLookup("[InvoiceRef]", "tblInvoice"...

ok thanks.. ill give it a go

AlienRay.. do you have any further thoughts on this matter?? ill try to code how ken told me.. but i am not optimistic.

just to give you a better idea of what i am doing.. here is the form.. http://www.londonheathrowcars.com/hereitis.jpg you choose an account holder.. and the 3 letter ref is used for that account holder.. eg Mcdonalds is MCD so a ref no would be MCD76885

this loop did nothin useful.. it froze access infact.. in my mind.. im creating an invoice number using the account ref from my combo.. and a random 5 digit number.. i am placing that no in a temp textbox on my form called invoicenotest.. i am then searching the records in the invoice table...

ok.. i think im on to something.. hold on.

...ermm. criteria is not a field.. i must have used another example.. and left that there what should go in the [] then because i have already specified the fieldname i want to search through..which is InvoiceRef

ok have a look at this..im trying to create an invoice number using the account reference.. (from a drop down) and a random 5 digit number.. i want the form to check the invoice table (invoiceref field).. to make sure that invoice number doesnt already exist. Private Sub btnGenerate_Click()...

make a query with all the fields from that table.. set the date field to ascending or descending (however you want it) then use form wizard on that query.

in the form properties.. Other tab.. make pop up yes.. then the form will open at the size you set it in design view.. i think..

hi, i downloaded a calendar sample from this forum.. the actual module that was provided was to add the chosen date to a field.. which is fine.. i have tried using this calendar on my main menu.. i just want it to display todays date.. thats all.. the problem is.. as time passes, the main menu...

ok.. i think i will do that.. (huff and puff.. sulk sulk sulk.. ) thanks for the advice.. i guess i better get back to work.

you know what bob.. all this bother is making me think that i should just store all the addresses in a different table.. and just link the addressid (pk) in the address table to the pickupid (fk) and destinationid (fk) in the job table.. this way the actual textual addresses wont be repeated...

i hate to be the persistent.. nagging.. inpatient.. desperate maniac that i am.. but... hang on hang on.. let me atleast search for what a tree view control is before i ask you how to do it..

so basically what i want to do is impossible.. is that what your sayin? could it be done with a listbox? or does that choose to follow the same path as its bendy cousin the combo?

ok.. for booker id 3 there is one record.. the JobFrom field has: London Palledonium the JobTo field has: Heathrow Terminal 5 the combo is displaying it like this.. London PalledoniumHeathrow Terminal 5 i want it displayed like this.. London Palledonium Heathrow Terminal 5 here is the...