Recent content by Trocergian

Update... Per Plog's suggesting I started adding column by colum and quickly noticed the problem was isolated to one particular table in the query. Then per tvanstiphout's suggestion I rebuilt that table just using the needed column and sure enough the union ran fine. I then created a new...

I am running a union query on two queries. Both queries have the exact same columns, both run perfectly well separately, showing all expected data. When running as a union: ELECT qry_POS_X_CurrentPO.* FROM qry_POS_X_CurrentPO UNION ALL SELECT qry_POS_X_E1_OrderQty_X.* FROM...

I am using a wep API to get some weather data. It opens a web page with a text string similar to this...

Good grief, I found where I was going off the rails. I had originally wrote some code in a textbox so the code started out =DLookup(... but what I had wasn't working so I went to testing in the immediate window and didn't notice I was working with ? = DLookup(... there. Once I realized it and...

I can't seem to get this syntax correct trying to use DateAdd as criteria with DLookup. Here's what I think it ought to be: DLookUp("SumOfHours","qryDailyTotal","[WorkDate]=#" & DateAdd('d',1,gStartDate) & "#") with gStartDate being a date variable. However I get "Expected: expression" Where...

Bingo! Thank you so much. I'd been struggling with that for 2 hours trying different permutations. The solution not only works but is much more elegant.

I'm trying to get this filter to work with multiple ANDS/ORS and having trouble. The line is: Me.Filter = "([CustID] = 1030 OR [CustID] = 1044 OR [CustID] = 1051 OR [CustID] = 1055 AND [BoLChk] <> 'X' OR [INVChk] <> 'X')" The filters on either side of the AND work independently, but combining...

I'm attempting to requery a subform using a variable and running into "can't find form" errors. Here's code that works fine when run directly: Forms!frmDashboard!frmDwgStatusSub.Form.Requery But when loaded into a variable and trying to run via: Forms(gSendingForm).Requery throws an error...

Brain nailed the solution - worked perfectly. Thank you! Came while I still have some hair I didn't pull out yet. Excellent! (I just wish I understood exactly what it was doing)

Yeah, those are some of the exact variations I've tried, but no joy. I;ve even tried using the wildcard in combo with known records "45P*" but it won't find any results. I'm beginning to think it's just not possible to use wildcards with the IIF method. That's why I was also asking if anyone...

Is it possible to use a wildcard in an IIF statement as criteria for a query? I want to check a field, and if it's null then use a "*" for the search criteria but I can't seem to get it to work. Here's an example of what I've tried: IIf([Forms]![frmDrawingLocator]![txtPN03] Is...

Hmmm, just doing a quick little test using the IN statement I get results that look like it uses the criteria inside the IN(X) as OR's rather than AND's which is what I need. In other words, I get results listing jobs that contain any of those parts and not just jobs that contain all those...

Although, that does give me an idea. Would it be possible to load the multiple criteria into an array and then read that something like the ItemsSelected feature of a listbox? Or am I out in left field with that line of thinking?

That's probably not really a practical solution being that the current parts table has 6231 items in it and growing. Using that to populate a listbox and then trying to control multiple selections would get a bit unwieldy I think.

Those look more like they are for criteria over multiple fields. Let me try to describe more closely what I have. A table with two fields: Job# and Part# That lists all the parts for each job. I want to be able to enter in various (anywhere from 1 to maybe 10 or so) Part#'s and get a list of...