Search results

I have two queries. One returns a list of numbers and I would like the other one to use that list in the where statement. Here is the query SELECT WGMAHIST_TIMEDTY.TDYSSN, WGMAHIST_TIMEDTY.TDYLCL, WGMAPROD_EMPLOYM.EMP1ST, WGMAPROD_EMPLOYM.EMPMID, WGMAPROD_EMPLOYM.EMPLST...

I got the report to work however, I am having problems with the subreport format. First off, I am only getting one record per page. I should be getting at least 2. I have tried to adjust the margins but to no avail. Second, I can not see the column headers. I placed them in the page header...

I have looked at the Master and Child links and tried to set them based on the existing fields in the queries. Both queries have a field that is the Bill Of Lading number. They are named differently but the value is the same. When I try to set the link I get a message that tells me that I...

I have created a report that has a header (based on qryHeader) and a subreport (based on qryDetail). I think that my problem is that the two queries are not related because the subreport is not showing up so I assume that it is not being initialized. I need to create a master/detail report...

Sorry, I did not know abut that.

Perfect! thanks.

Thanks for responding. I have it set to that but I am getting is the record ID. I need the text that is displayed in the combo box.

I am creating a report that gets some of its data from a form. One of the items that I need from the form is the text contained in a combo box. All I need is the text that is displayed in the combo box. I have tried some different things but just get errors. I have searched this forum but have...

I took it out of the VBA and I get no prompting. Thanks.

Yes, the query is the record source for the report and I am delimiting it in both places because I don't know what I am doing and I saw an example of this somewhere. If there is a better way please tell me. Thanks for your response.

OK, I had to work on something else for a while but now I am back. I tried what you suggested and it took care of the first variable but the application still asks for the parameter for the ExportCarrierID. this is my Where statement: WHERE...

When I click on the button it prompts me for the parameter. The prompt looks something like this: Enter Parameter value CN0809HOMO ------------------------- | textbox | ------------------------- This is the value that it should be pulling from the form - CN0809HOMO.

That worked. Thanks. Now I have another problem. When I click on the button to print the report I get awindow that pops up stating "Enter parameter value". Above the textbox on the popup is the value of the parameter and then below that I have the textbox to enter the parameter. How do I get...

I have a form that is used for data entry.Once the data has been entered the user can click a button at the bottom of the screen that will print reports. One of the reports is based on a query that takes 2 parameters. When I run the report I get an error saying "You can't reference a property of...

I did that and it threw an error.

I have a query that I need to group by the year of a date that is stored as a string , i.e. 20080630. SELECT WGMAHIST_TIMEDTY.TDYLCL, WGMAHIST_TIMEDTY.TDYTDT, sum(WGMAHIST_TIMEDTY.TDYFND) AS Hrs FROM WGMAHIST_TIMEDTY WHERE WGMAHIST_TIMEDTY.TDYSSN=123456789 group by WGMAHIST_TIMEDTY.TDYTDT...

Got it all figured out. Thanks for your help.

OK, I was able to use the wizard to create a subform for the invoice form. However, I need to be able to change the relationship as to which ID it is referencing. Where do I do that?

I was going to create another subform but there is no Form Wizard on the toolbar.

I have 3 forms that I use in my Access 2007 database. the first form is for data entry, the second form is an invoice which allows edits, and the third form displays the charges and only has one column and may have multiple records. The third form is a sub form and is used on both of the first...