Advertisement

There's no such thing as a stupid question, but they're the easiest to answer.
Login
Search

Advertisement

Business Applications Business Applications
Search Search
Search for:
Tech Support Guy > > >

Access 2003 help


(!)

jenaid's Avatar
jenaid jenaid is offline
Computer Specs
Junior Member with 24 posts.
THREAD STARTER
 
Join Date: Jun 2011
Experience: Beginner
26-Jun-2011, 04:12 PM #31
I've done that and it does update my printed box to ticked, however when the report opens there are no details in it
jenaid's Avatar
jenaid jenaid is offline
Computer Specs
Junior Member with 24 posts.
THREAD STARTER
 
Join Date: Jun 2011
Experience: Beginner
26-Jun-2011, 04:18 PM #32
I've put your line of command after the open report code rather than close form code and I think this has worked
OBP's Avatar
OBP OBP is offline OBP is a Trusted Advisor with special permissions.
Computer Specs
Trusted Advisor with 18,526 posts.
 
Join Date: Mar 2005
Location: UK
26-Jun-2011, 04:26 PM #33
Sorry, move it to after the
DoCmd.OpenReport stDocName, acPreview
jenaid's Avatar
jenaid jenaid is offline
Computer Specs
Junior Member with 24 posts.
THREAD STARTER
 
Join Date: Jun 2011
Experience: Beginner
26-Jun-2011, 04:28 PM #34
Apart from making it a bit more user friendly and a switchboard i'm almost there! Just the numbering system for the invoice - could you help with that bit please
OBP's Avatar
OBP OBP is offline OBP is a Trusted Advisor with special permissions.
Computer Specs
Trusted Advisor with 18,526 posts.
 
Join Date: Mar 2005
Location: UK
26-Jun-2011, 04:31 PM #35
What format would you like?
jenaid's Avatar
jenaid jenaid is offline
Computer Specs
Junior Member with 24 posts.
THREAD STARTER
 
Join Date: Jun 2011
Experience: Beginner
26-Jun-2011, 04:33 PM #36
First one to start G001, then G002 and so on
OBP's Avatar
OBP OBP is offline OBP is a Trusted Advisor with special permissions.
Computer Specs
Trusted Advisor with 18,526 posts.
 
Join Date: Mar 2005
Location: UK
26-Jun-2011, 04:36 PM #37
What table does the Invoice number field go in and what is the name of the field?
If you want to have a separate Invoice number table you can use a formatted Autonumber field for it.
The only problem is if you do not complete a record the autonumber will be incremented, leaving gaps in the numbering.
__________________
OBP
I do not give up easily
jenaid's Avatar
jenaid jenaid is offline
Computer Specs
Junior Member with 24 posts.
THREAD STARTER
 
Join Date: Jun 2011
Experience: Beginner
26-Jun-2011, 04:42 PM #38
I didn't realise it would have to go in to a table - I thought i'd read on some forum that it could just be set up within the report. I'll set one up. Probably just call Table Invoice Number and field Inv No. I'd like to try and find best way so there are no gaps if possible.
OBP's Avatar
OBP OBP is offline OBP is a Trusted Advisor with special permissions.
Computer Specs
Trusted Advisor with 18,526 posts.
 
Join Date: Mar 2005
Location: UK
26-Jun-2011, 04:45 PM #39
Well you could just enter it on a form so that it appears on a report, but how would you remember what the last one was.

OK, let me know the name of the table and field, so do you want to relate what items are associated with the Invoice?

Do you want the VBA to store the invoice as a Snapshot?
OBP's Avatar
OBP OBP is offline OBP is a Trusted Advisor with special permissions.
Computer Specs
Trusted Advisor with 18,526 posts.
 
Join Date: Mar 2005
Location: UK
26-Jun-2011, 04:52 PM #40
I will have to go now, I have been on here over 12 hours.
I will speak to you tomorrow.
jenaid's Avatar
jenaid jenaid is offline
Computer Specs
Junior Member with 24 posts.
THREAD STARTER
 
Join Date: Jun 2011
Experience: Beginner
26-Jun-2011, 04:53 PM #41
Ok thank you again. If you get chance to send me code for snapshot tomorrow it would be good.
OBP's Avatar
OBP OBP is offline OBP is a Trusted Advisor with special permissions.
Computer Specs
Trusted Advisor with 18,526 posts.
 
Join Date: Mar 2005
Location: UK
27-Jun-2011, 05:59 AM #42
Here is an example of the VBA code to store the Report as a Snapshot document.

Dim stFileName As String, filedate As String, Invoiceno As String
filedate = Left([End Date], 2) & Mid([End Date], 4, 2) & Right([End Date], 4)
stFileName = "C:\Access\Invoices\" & Invoiceno & " " & filedate & ".snp"
DoCmd.OutputTo acOutputReport, "EAgents Invoice Heading", "Snapshot Format", stFileName

We will obviously have to fine tune it so that the atFileName uses your Folder location and the correct name for your Invoice number field. We will replace the "EAgents Invoice Heading" with the name of your Report.
jenaid's Avatar
jenaid jenaid is offline
Computer Specs
Junior Member with 24 posts.
THREAD STARTER
 
Join Date: Jun 2011
Experience: Beginner
28-Jun-2011, 05:55 AM #43
Hi
Thank you for this code. (I was not able to work on this yesterday). Everything up to and including advice note is working great - just need to sort the invoice. I have copied the query used to produce advice note and called invoice query. This has all details I need for invoice except for the price. When I add on price field it duplicates the price for the no. of orders. eg. if original order had 4 lines on it, but the advice note/invoice is only to include one of these lines, I get this one line duplicated four times with each of the original four prices at the end. I've had this before but can't remember how to sort? Would you be able to help me yet again please.
OBP's Avatar
OBP OBP is offline OBP is a Trusted Advisor with special permissions.
Computer Specs
Trusted Advisor with 18,526 posts.
 
Join Date: Mar 2005
Location: UK
28-Jun-2011, 01:09 PM #44
Can you post a screen print of the Query in Design mode?
As Seen On

BBC, Reader's Digest, PC Magazine, Today Show, Money Magazine
WELCOME TO TECH SUPPORT GUY!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.


Tags
access, invoice, query access2003, reports

(clock)
THIS THREAD HAS EXPIRED.
Are you having the same problem? We have volunteers ready to answer your question, but first you'll have to join for free. Need help getting started? Check out our Welcome Guide.

Search Tech Support Guy

Find the solution to your
computer problem!




Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools


WELCOME
You Are Using: Server ID
Trusted Website Back to the Top ↑