Search results

Can anyone help me with this. I followed the link as suggested by John Big Booty which lead me to finding a function for concatenating field values (i am using an access 2003 frontend linked to SQL Server 2000 backend): The function is: Public Function ConcatRelated(strField As String, _...

Thank you so much!

That is correct.

I have a form that has about 40 list boxes on it (i am devising a truck allocation database for a transport company) and i need to show the individual delivery drop suburbs for each truck on the one form. The form will be used as a summary form so the transport allocator can use it to quickly...

Hi John Big Booty, I hope i haven't confused you!! How can i elaborate this further?

Hi all, I've attached 2 attachments to this thread, the 1st attachment 'ListBox1Normal' shows a normal listbox with one record displayed per row. Is it possible to show the same records but all on one row & separated by a delimiter, as per the 2nd attachment 'ListBox1Proposed'? :confused:

OK. Thank you so much.

Hi all, For something that i thought would be quite simple, isn't, I'm having a bit of trouble of minimising one form from another form. My 2 forms are frmTruck1 and frmTruck2. When frmTruck2 has the focus i would like to be able to minimise frmTruck1. Using DoCmd.Minimise minimises...

Wow! Thank you so much Bob, that worked beautifully!!

Hi All, I have coded a custom function to update the 'JDNo' field in my table tblLocal. The strSQL line looks like this: strSQL = "UPDATE tblLocal set [JDNo] = " & Forms!frmLoadAllocationBDLoad.Form!lbl1 & " WHERE [LoadLineID] =" & Forms!frmLoadAllocationBDLoad.Form!lstJD001aBD.Column(0) &...

Thank you!

Hi All, I am really struggling with getting this code to work correctly. I have the code in the after update event of combo box called cboDriver. The idea is when the cboDriver is updated & if DeliveryDate <= 10/11/2009 then the driver rates should be extracted from qryContractRatesAdbri1...

Of course!! Stupid error! Thank you so much pbaldy!!

Hi all, I have the following code on a command button: Me.subfrmAdbriMasonry.Form.RecordSource = "SELECT * FROM qryContractAdbriMasonry WHERE qryContractAdbriMasonry.Plant Like "MOOR" AND qryContractAdbriMasonry.DeliveryDate BETWEEN #" & Format(Forms![frmCandM]![txtStartDate], "mm/dd/yyyy") &...

Hi Bob, You're a legend!!! That worked perfectly!!! Thank you so much!

Hi all, I have 2 unbound text boxes 'txtStartDate' & 'txtEndDate' on my form 'frmLocal' that i use to filter dates on my subform 'subfrmLocal'. The code on my command button is: Me.subfrmLocal.Form.RecordSource = "SELECT * FROM qryLocal WHERE qryLocal.EntryDate BETWEEN #" &...

Yes, the PDF's (which are customer invoices) are related to the Order ID and named using a combination of the value in the OrderID field & 'CI' which stands for 'customer invoice'. The PDF is produced by clicking a checkbox on frmOrderInput; this is an excerpt from my 'on click' event code on...

Hi Bob, Thanks for the suggestion, but this would not be practical for me, given that there are about 19000 PDF's currently stored in S:\Internal Sales\DatabaseFiles\OrderRelated. Is there are way to transform the use of the const into some sort of variable string?

I have a pop-up form (that opens up from frmOrderInput) with a listbox on it (lstCI) and it displays documents that relate to the value in field 'OrderID' (which is the Order number). My code (as seen below) was originally written using a constant path to view the documents Const cPath =...

Please disregard the previous post, i've got it working!!!!!!! (It was my typing error!) Thank you!!!