Search results

Yeah, the string filters the subreport properly when I open only the subreport. Do you have a good starting place for learning about OpenArgs? So far, I haven't learned to code yet.

I'm using the following code to filter a report by using a multi-select box. Private Sub cmdOpenReport_Click() On Error GoTo Err_cmdOpenReport_Click Dim strWhere As String Dim ctl As Control Dim varItem As Variant 'make sure a selection has been made If...

lol. That makes me feel better about myself more than it probably should have!

Okay, I figured it out. I created Query1 that gave me this: Manifest 0001 - H Manifest 0001 - N I created Query 2 that uses Query 1 as a source. I then concatenated the WasteCategories from Query1 in Query2 based on ManifestDataIDPK between Query 1 and 2. This gave me exactly what I needed...

I'm not sure what you mean about the data consistency. I copied and pasted the data in post 9 from post 6. I tried to use the code from Allen Browne to see if I could make it output the WasteCategory (H, N, U) instead of the Waste Category PK (1, 3, 4). I could not. Can I use a query to...

So I found THIS post that allows me to select only the distinct values using the Allen Browne concat module. However, I'm still limited to the ID of the Waste Category (e.g. 1) instead of the category (e.g. H).

Yes. Because each manifest may have multiple line items, I would get multiple Waste Categories (one for each line item) when I only need it to show the unique Waste Categories for each manifest. Manifest #0001 may have 5 line items, and each line item has a Waste Category, like this...

I'm using the report to make labels for folders. There are a number of fields on the report, but the two I'm working on are the Manifest Number and WasteCategory fields, as below. Manifest Number Waste Category Removal Date 0001 H...

So the only real way to do this is with VBA in a module?

The problem is that now I have many lines in the query for one manifest; I don't know how to combine all of the WasteCategory designations (H, N, U, etc) into one field based on the Manifest Number. So I get this: 0001 H 0001 N 0001 P But I don't know how to concatenate the H, N and P.

One Manifest can have many line items. One line item can only have 1 designation. Each manifest may have many line item with same designations. For example: Manifest #0001 Line Item 1: N Line Item 2: H Line Item 3: U Line Item 4: N Line Item 5: P Line Item 6: H Table set-up CurrentCY...

Yeah, ours is essentially for inventory control of wastes that are getting shipped out of our facility.

Yeah, I assumed that comparing records was probably fairly difficult. My initial thought was to have a 'date created' and 'date modified' for each record in all tables, but that's pretty intensive. Thanks for the perspective!

I don't know for sure, but my feeling is that it will happen.

Semi-theoretical scenario: We take our current database from my desktop workstation (the db also has a server location) and put it onto a laptop. We then take the laptop out into the field and we change data in the database. That database (from the laptop) will get loaded back onto the...

Crap, I thought I had done that. I think I did 'form.name'. Thanks for your help!

I got "Invalid Use of Me Keyword" error, so I tried form.name and got a "Object required - 424" error. This is what I used: strSQL = "INSERT INTO " _ & "Audit (EditDate, User, RecordID, SourceTable, " _ & " SourceField, SourceForm, BeforeValue, AfterValue) " _...

So I figured it out. I wasn't calling both modules; I was calling one module and trying to use the code for the second. *DUH* So I got it all patched together and working! How do I reference the name of a form using SQL? This is the current code, and I see that 'frm.recordsource' stores the...

Ok, I still can't figure this out. I think that the converted macro to VBA is not working. This is the code I have for updating the 'Last Modified' data: Private Sub Form_BeforeUpdate(Cancel As Integer) Function LastModified() On Error GoTo LastModified_Err With CodeContextObject...

I'm not having any problems with my audits, but I haven't fully implemented it yet. I got the code from HERE. I still have to add in the portion of the code to account for combo boxes and such. Also, I'm in the US and use US format dates. I don't know the significance of the problem with the...