Recent content by lstantliff

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