Search results

i dont think that is possible. customer account info and such in it. anyways... i restarted the database and I THINK IT WORKS! impossible! let me make sure...

making progress...it runs the report for a single account using the filter i assume. the account its running is in the record set "lettersingleacct" and its the last one on the list. it runs it x amount of times but for the same account. so i get 35 letters of the same account and the...

portfolio, as in the types of characters that make up, can sometimes be numbers and sometimes be numbers + letters. example: cs1234 or 123456 so i can type in portfolio="123456" or portfolio="cs1234" in the filter and it pulls up a single report for that portfolio.

I really think something is wrong with the acctnum variable in the report_Open statement or in the properties of the "letter Single" report. I can manually run the report for each account by going into the "Letter Single" report properties in the VB window and changing it to...

Edit: Snap, I didn't see the reply on the second page. I think this is most of the code that the button uses. I added in additional code that was behind the report that formats the Page Headers. Either thats the problem causing the conflict or its something in the Report_letter Single...

nvm, i didnt realize i needed to add the clCommonDialog to the class module list... It's printing pdf to the location with the filename as the account number but it is still printing all the pages. it looks like filter may not be working correctly...

ok i think ive got it, but for some reason I dont think its running correctly. Its not sending the file to the correct location. its sending it to something like c:\docume~1\user\locals~1\temp\snp28c.snp everything looks good, I think. Do you see anything that may need fixing? Private Sub...

If i understand it correctly i need to add the me.filter to the onOpen event in the report. How do I set up the onOpen event in the report? I found onOpen in the properties of the report but it didnt work. Where do I put Me.Filter = strcriteria Me.FilterOn = True ^^ i don't know where and...

I got it working using lebans but it is back to printing the huge pdfs again. How would I apply the "strcriteria" filter in this function? I'm pretty sure i dont need the Do.Cmd.OpenReport... I may be wrong tho Do Until RS.EOF acctnum = RS!portfolio strcriteria =...

Thanks pBaldy! Adding that comma seems to have done the trick. the acctnum are text, fyi. Do Until RS.EOF acctnum = RS!portfolio strCriteria = "[portfolio]='" & acctnum & "'" DoCmd.OpenReport "Letter Single", , acNormal, strCriteria RS.MoveNext Loop It all...

I am a little confused with this OpenRecordset idea. I created a second query based on your main query that gets a list of the distinct accounts. its output is a nice table, called "LetterSingleAcct", of accounts that I need to have loop'd through: account 123456 234567 345678 So the next...

OK. I am a complete newb when it comes to access. I just want to make sure this is what I need before I spend time on it. And also thanks for helping! I have a query called "transactions" that gathers all the information needed to run the report called "letter single". The output is a huge...

hello, I have a report that prints all the transactions for all the accounts into one giant pdf. I email each of the account letters individually to about 35 accounts and right now its a time consuming task to go in to the giant pdf and extract each accounts pdf individually... I would like...

Got it! Thanks!

i really appreciate the help. Where do i put this code? or better yet what is this sort of thing called? I am new to access and just learning. Thanks for your patience!^_^

the table of accounts I wish to have information returned is filled down the column in a table called accttable. acctnum 012345 123456 234567 the query is organized by each of the transactions per account acctnum--------transactiontype--------producttype 012345--------bought--------producta...

hello,I am new to access and have run into a problem. i have a query that returns information for hundreds of accounts. I only want to return information for about 50 of those accounts. When I try to put the accounts I want to return into the criteria box (example "012345" or "123456" or...