Search results

Hey that's cool John!! Thank you that helped heaps!!!:)

Hi All, I have a form "frmLoadAllocation" that has a series of filter command buttons that filters a listbox "lstJDUnallocated" on a form "frmLoadAllocationUN". The each cmd button has a similar OnClick event code as below, the only difference between the buttons is that the ContractID is...

Ah yes!!! Thank you Paul & John, awesome!!! That worked!! Thanks heaps!

I'm unfamiliar with using OpenArgs. Can you show me how to code this?

I have 5 listboxes on one form, "frmDriverEdit". The double click event in each of these listboxes opens the same form "frmLoadControlPanel". I have a command button with a series of 'IF' statements that will fire code depending on which listbox was double clicked in frmDriverEdit. Does...

That is awesome JR!! I can't thank you enough!!! Thank you x million!! :)

JR, I have one other question! If i populate cboLoad & then decide to remove the value in cboLoad i get the following error: Run-Time error '3075': Syntax error (missing operator) in query expression 'DriverNo=1' And LoadBoxNo =' and the code breaks to highlight If Dcount("*", qryDivera"...

JR, That hit the spot! Perfect! Thank you so much!

Thanks Bob. The problem i have is that i can't use MAX, i need to check which LoadBoxNo hasn't been used for the procedure to continue. LoadBoxNo can be any number between 1 and 5 (inclusive). Am i using Dlookup incorrectly here?

OK, thanks JR. cboDriverBD1.Column(1) is a number so i've used your first statement. However, the code is still not firing properly. It seems to be only looking up the very first record in qryDrivera only & not scanning through the whole query. Does this sound right?

Hi All, I have the following code in an onclick event on a form (frmLoadAllocationUN): If DLookup("LoadBoxNo = " & Forms!frmLoadAllocationUN!cboLoad.Column(0), "qryDrivera", "DriverNo = " & Forms!frmLoadAllocationUN!cboDriverBD1.Column(1)) Then MsgBox "You have already allocated a load to...

Yes Bob, that is it!!! My sub-routine now works perfectly!! It looks like this now: Sub VbColour1() '--------------------------------------------------------- On Error GoTo Err If Forms!frmAtaGlance!lstDriverGlance1.ListCount > 0 Then Forms!frmAtaGlance!lstDriverGlance1.BackColor = 16711935...

Hi Bob, I just tried your suggestion and i get the following error: Error 438: Object doesn't support this property of method. Would i be getting this because i am using a pass through query to feed the listbox?

This is really weird. I tried: Forms!frmAtaGlance!lstDriverGlance1.Recordset.RecordCount = 0 and i get the following error: Error 3420: Object Invalid or no longer set If i use IsNull(Forms!frmAtaGlance!lstDriverGlance1) then it colours the listbox even if it doesn't have any data in it. Do...

I've come up with this sub routine that i call from a command button which populates the list box: Sub VbColour1() '--------------------------------------------------------- On Error GoTo Err If Forms!frmAtaGlance!lstDriverGlance1.RowSource = Null Then...

Hi All, Does anybody know how to change the background colour of a listbox when it is populated by data? :confused:

Hi all, I'm developing an Access frontend that is stretched across 4 monitors. Each time i startup the frontend i have to manually stretch the Access window left to right across 4 monitors. Does anyone know how to automatically stretch the window using VBA?

Hi all, I have the following pass through query on a listbox: SELECT tblLocal.LoadLineID, tblLocal.Suburb, tblContract.Contract, tblLocal.Yard, tblLocal.BrickType, tblLocal.Qty, tblLocal.JDNo, tblLocal.DeliveryDate, tblLocal.Plant, tblLocal.SpecialReq, tblLocal.TruckType, tblLocal.AreaKlm...

Hi all, I have an Access 2003 Frontend linked to a SQL Server 2000 backend. I have converted my select query to a pass through query in access. The syntax i have used is: SELECT LoadLineID, Suburb, Plant, LoadBoxNo, Abbrev, DriverID, DeliveryDate FROM dbo.tblLocal WHERE LoadBoxNo=1 AND...

I've also tried doing this on a report without success. Has anyone else ever tried this before?