Search results

OK, this looks like it could be the solution! I tried this and it worked fine. But I actually have 3 more fields (It's the PlanWeklyRev broken up into 3 categories). The union query worked fine when I added the 3 fields. But when I ran the Crosstab query I got an error message about...

Good catch about the output table not matching the input. I pasted from an excel sheet and for some reason the data was slightly re-arranged. Will give this a shot!

I would totally do this as a solution but I am trying to create a form/report on the screen the user can view. Not sure how to rotate the screen!

Honestly, I didn't get too far with the Crosstab because it limited me to only 3 fields to use for Row headings.

I just tried and this and it looks like it would work well! But was hoping to find a solution that I can use within a front end of an access database. Maybe from within the front end I can automate opening an excel file that already has the power query and data linked to the access database?

not sure what you mean by the query SQL. Unless you mean the query I use to get the original data?

Trying to post a .txt file

I have been trying to figure out how to transpose a query per a customer request (they want to read the information horizontally instead of vertically). But I am struggling with the Crosstab query in access. Is there a way to transform the below data: Week Order Calendar Week LDOW Previous...

Yes, i see it now. I got rid of all that stuff and stuck with just opening the form i need. I think I originally put those lines in there before I created the new forms I wanted to open.

I was using the recordset to lookup a specific record based on a date selected from a Summary query. Here is the rest of the code: Dim rs As Recordset Set rs = CurrentDb.OpenRecordset("SELECT TOP 1 LDOW FROM qryWeeklyForecast WHERE LDOW=""" & LDOW & """", dbOpenSnapshot)...

I'm trying to fix a code that was working the last couple weeks but suddenly stopped working. I have a form with a cells that fire actions when the user double clicks. So, out of no where, I am getting this error message regarding the below line of VBA: Set rs =...

Ah, that seems to work! amended his code: If lst Is Nothing Then For Each varItem In colDirList Debug.Print varItem Next Else For Each varItem In colDirList lst.AddItem "'" & varItem & "'" Next End If

I have the code: Call ListFiles("K:\CONTROLLED_DOCS\Drawings, CasaBella (SDRxxx)vE\9 Install Dwgs", , , Me.lstFileList) The list box only lists "K:\CONTROLLED_DOCS\Drawings" (which is the same for every file in this folder)

Tried using Allen Browne's code but the the file paths have a comma so the list box is only showing the file path up to the comma. When I call ListFiles in the immediate window it gives the full path. How can I adjust the code to deal with the comma?

The flicker was not the big problem (I haven't tested this out on other machines but it could be my machine is a little slower). I couldn't figure out why I was getting the 2424 error from the subform when switching records on the parent form. But per MajP it may be a timing issue related to...

Gasp! You are an Access VBA Savant! Works like a charm. I only added an If Then statement to differentiate backcolor and forecolor for non-colors (white or raw). With con If color = 0 Then .ForeColor = RGB(0, 0, 0) .BackColor = RGB(255, 255, 255) Else...

Thanks for this advice! Each order typically has only 3-4 different colors at at time. You are suggesting delete the code in the on load event and move it to the current event of the subform? Remove first, then add in the current event?

This works great! I just had to make a small adjustment to the HextoRGB field to give a 0 for few of the color codes. Just one clarification: this will only work for up to 50 colors?

Nice! But with conditional formatting I would be limited to 50 colors, right? I am told that the color list would grow to 90. We started with 9 and we are now up to 15 a couple months later. . . I am also not crazy about how the On paint event constantly fires. Maybe I can stay with...