Search results

Why don't you change the acViewPreview to acViewNormal so it opens in a spreadsheet with a scrollbar?

At what point do you get a blank form? I'm having trouble figuring out at what step this is, so I can't explain why it's happening.

lemieux: Download the report I modified for you. The following are the changes that I made. We'll get to the parameter element after. 1. I deleted the annotation.date field - there is no such field, so Access was prompting you to enter a value for it. 2. I moved the 'Annotation' header to the...

Just join on column five (you don't have to have a PK to do a join). SELECT * from table2 inner join table1 on table2.invoiceNum=table1.invoiceNum This will return all records from table2 where there is a corresponding invoiceNum in table1.

Why would you want to do that? Why not create a report that would group based on year, and for each year it would show you any id that was returned in the query corresponding to that year. Wouldn't this be better?

If you export using the docmd.transfertext or transferText macro, or if you just right click on a table or query and export it to a text file, one of the options is using fixed width. Once you choose fixed width, you can create a specs file that specifies exactly how many spaces each field...

Thank you for posting your dbase. The answer to your question is quite simple. The dynamics of the 'Detail' section of a report are such that the detail section is replicated for each record returned by your query. Given that this is the case, and since you bound your report to your query, it is...

Another option you have is, if you want to use days of the week as column headers, you can do the following;PARAMETERS [Enter Begin Sales Date] DateTime, [Enter End Sales Date] DateTime; TRANSFORM Sum(MyQuery.CountOfCRC) AS SumOfCountOfCRC SELECT MyQuery.crc FROM MyQuery GROUP BY MyQuery.crc...

Sorry to bug you again, but what are the parameters necessary to query the $75 - is it a total of a field already listed on the report, or do you need to lookup from another table?

If that's all you wanted, why not try a PivotChart (use the PivotChart wizard). This way, it will come out looking like what you want. See my attachment.

Reports are tricky from crosstab queries given that there is a dynamic number of columns returned depending on the data. As a result, you would need to use VBA to create a report. I don't know how comfortable with VBA, but if you don't mind experimenting a little, check out...

I'm still interested in what your data set is to try and determine why it is printing multiple pages to begin with.

As far as the duplicate pages go, please explain a little more what data your report contains. As far as SendKeys, you need to place the SendKeys command before the print command.DoCmd.OpenReport strDocName, acPreview, , strCriteria SendKeys "{TAB 2}{DOWN}{TAB}1{TAB}1{TAB}1", False...

Why not? I'm obviously missing something here. What are you trying to accomplish exactly? If what you are trying to do is get it to automatically set Print 1 To 1, you can use SendKeys. If not, please explain it a little better.

I hate to be primitive, but you can always cheat and use Sendkeys to change any of the defaults. SendKeys "{TAB 2}{DOWN}{TAB}1{TAB}1{TAB}1", False This will automatically set Page 1 of 1. You can use your own mix to accomplish what ever you want. It's cheating, I know, but at least it can work.

why don't you try DoCmd.OpenReport strDocName, acNormal, , strCriteria instead - this way it goes straight to the printer?

could you explain your question a little better please? What do you mean you have a time frame of 3? What are you trying to do? It sounds like you need a DSum not DLookup.

Your easiest option would be to create a pivot chart (if you use the AutoForm wizard it makes it easy for you). In either case, you need to modify the query if you want it to show you weekdays instead of dates (wouldn't you want to keep the field with a date though?) Modify your query to the...

Does your sales_date_interval return a date or day?

Can there be more than 2 products (ie. more than 2 '|')? What does that mean if the company doesn't respond it says --Not Sure--? We can mix in a couple of iif() statements if we need to check for a limited number of conditions.