Search results

Thanks Keith! I should have thought of that, I had though about a macro, but only to open the table, then I didn't know where to specify that. But using one to do both would work I hope. I will try that.

Is there a way in a Make-Table query to tell the table to open when it's created? I would assume there is a function or SQL code that would do this, but I know very little SQL. Can anyone point me in the right direction? Thanks!

How do you specify numeric or string w/o doing it in code. Can you do it in the properties box? If so which field? I have been trying to figure this out with no luck. Also, should it be done in the form where I specify parameters, or in the text box where the result is shown? (Confused!!)

:confused: Can anyone tell me what might be wrong with this expression? It is returning "-1". =(IIf([Forms]![AnnualDialog]![Dept]=41,"Casing") Or IIf([Forms]![AnnualDialog]![Dept]=64,"Open Stock")) A parameter (either 41 or 64) is entered on a form (AnnualDialog) and the expression above is...

Not in the least, you wouldn't believe how far I have come in just a few weeks. I was chosen for this job because I had a little basic knowledge of Access and the last person they brought in to do this was a programmer. But I'm always up for the challenge. Don't mind learning. This is just...

Okay - that's simple enough, I was overthinking the problem. Thanks for the help!

Gotcha - can create a button to run report, how does the report and subreports know to use the form as parameters? And for all 4 subreports?

Okay gotcha, will rework and try again - Don't ya hate newbies!! Thanks for the help!

The form is set to open when I open the report. I feel like I need to maybe add an event procedure to the command button OK to not only SetValue, but also to run the report or the subreports. Not sure and have never written an event procedure. Does this make sense?

How do I do that, I never closed the report! Confused!!

Hiya! I would like to start by thanking everyone for their time and expertise!! I created a report with 4 subreports. Each subreport is based on a different query but the same parameters apply to each subreport. When I opened the report, I had to enter the parameters 4 times, one for each...

I thought that is what I did, but it didn't work. I have two command buttons, OK and Cancel on the form. OK has a SetValue macro in the OnClick property. When you open the report, the form pops up, you enter the parameters and press OK - but then nothing happens. What have I missed? Thanks!

Tom, Do you have your paper size set up right? It's under page setup, set your paper size to custom and adjust the size. Not sure if this will work but it might be worth a try! Laura

Hiya! I am using Access 2000 and need to write an event procedure that tells a report to open the subreports within it upon open. I have attached a form to enter parameters for the reports, so my hope is that the form will provide the parameters for all the subreports. I have no idea how to...

I'm kind of a newbie, but I get that a lot. Are your column headings specified in the properties box? Just an idea! Laura

report created - need help with parameters!! I have created the report I needed by creating a subreport for each union query and combining in 1 report. The report now prompts me 3 times for the parameters. Is there a way to only input this info once as the parameters are the same for all...

Consider me a newbie for this thread!! I am trying to create a report with 3 sections, DIRECT HOURS, INDIRECT HOURS, SUMMARY. The information that needs to be viewed under each section is based on a separate union query. Each query is based on parameters, the same parameters apply for each...

Your right Paul, if I run the report for Period 3, then it displays the column headings as Week 10, Week 11, Week 12, Week 13. What was the ADH's solution for this?

Paul - I will look at the link again. The first time it went right over my head. I will put more thought into it. I do appreciate your help.

When I tried to run the query again it just told me that the table already existed. This is a parameter query and result can change. Is there a way to make the table update each time the query is run? --Thanks!