Search results

Is there a way to reference another field in the source query rather than the value of Combo3? Combo3 is the Part Number. The problem I have is that there are many Parts shown on each drawing. In my table (and query) I have the drawing number for each part (Dwg_Num). Can I select a Part Number...

It works, thanks very much

Hi, I have a form with a Combo Box (Combo3) where I can select Part Numbers. I have a Command Button (Command10) that I am trying to use to open a PDF drawing with a file name that matches the part number. (The PDF’s have file names the same as the Part Numbers). The code I have been trying...

Ah both! I did try it (in the bottom box only) and it didn't work. I will give it a try in both. I started a new thread because I wanted to attach the database and couldn't for the life of me find how to attach it to a reply. Thanks very much

Hi, I have attached a database. There is a form displayed when the database is opened. If you select a date (say 21-Jul-2017) you will see that the Subtotal for Project for JC + DC Hours (Text53) is not summing the values for each Project correctly. For each Project the Disciplines are...

It is grouped first by Project and then Discipline. Not every project has the same number of disciplines (Electrical, Mechanical, Painter, etc). Whichever discipline is last (at the bottom) the value for that discipline for PHours plus AHours shows up in the Subtotal text box, not the sum for...

Hi, I have a Report with Planned Hours and Actual Hours fields that is grouped by Project and then Discipline. In the Discipline Footer I have text boxes that show the totals for Planned Hours , with formula =Sum([PHours]), and Actual Hours, with formula =Sum([AHours]). I also have another...

Hi, I want a form that takes values from a table to display titles and general information for each record but with an area where people can leave comments and notes that are saved. I update the table very regularly by deleting everything in the table and pasting in fresh data from Excel so I...

Thanks very much, Galaxiom. Works well!

Hi, I am trying to open and filter a Report from a Command button on a Form. I select a value from a combo box, Combo3, and press the command button, Command6. The field that I want to filter on is called JCARD. The values in the combo box are all of the format JCD-0220-01. The VBA for my On...

Found the problem. I had to format the date to the ridiculous American date format. For Each varItem In Me.lsbWEdate.ItemsSelected strWEdate = strWEdate & ",#" & Format(Me.lsbWEdate.ItemData(varItem) _ , "mm\/dd\/yyyy") & "#"

Actually, when I adjust it to I manually adjust it to just [Reporting Week Ending] IN(#2/06/2017#) the report does not work properly. The report opens with data in it but it is not filtered to just 02/06/2017, it shows all dates. Looks like there is something wrong with my date format? Any ideas?

Hi, I have a report that I am trying to filter with VBA code. After running the code I get the following in the Property Sheet, Data, Filter row: [Project] IN('KLE323 Piperacks EC Project') AND [Reporting Week Ending] IN(#2/06/2017#) The report is not working and always stays blank with...

Thanks jdraw and ridders, I will check out the material suggested by jdraw and see if I can figure this out

I still don't know how to set this up so that I can make a selection from each listbox and run the report.

Thanks, but I don't understand how I could have the Projects and Reporting Week Ending in one list box. I would have a list with Projects and dates? And I then select the projects I want in my report and the reporting week dates in the same list?

Hi, I have a listbox (List10) on a form that has a command button (cmdOpenQuery6) that runs a report (rptJC_Manhours_JC_DC_SI_2) via a query (qryJC_Manhours_JC_DC_SI_3). The row source of List10 is SELECT DISTINCT [tblSMSdata].[Project] FROM tblSMSdata UNION SELECT "ALL" FROM tblSMSdata The...

Thanks so much everybody who has contributed to this discussion.

Sorry if I was not clear. I only need to select a single date, although the code may allow for something else.

Hi Gasman and Markk, thanks for the advice. Unfortunately, this is all way over my head and I have no idea where the code you suggest would go into my code. Can you please advise how it would fit into my code (shown below)? Either solution is fine with me, as long as it works. Thanks very...