By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,380 Members | 3,074 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,380 IT Pros & Developers. It's quick & easy.

Date & installation issue

P: 38
Hi all, I have an order entry database. The problem has happened when I transferred the database to my customers computer running the same OS & same version of office. that I am which is XP Pro & Office 2003 pro.

When I run the invoice icon on the customers machine I get an invald link error.
I then get a VB box that comes up showing the fault.
stDocName = "Invoice"
stlinkcriteria = "[CustomerID]=" & Me.CustomerID & " AND [Order Date]>=" & Date - 7
DoCmd.OpenReport stDocName, acPreview, , stlinkcriteria

Exit_cmdInvoice_Click:
Exit SubExit_cmdInvoice_Click:
Exit Sub

The fault is pointed out is " & Me.CustomerID &" part of the programming.

Not sure what it is, but it works fine on my system but I burnt it to disk using nero and when I installed this on the customers system the database played up.
I protected the unprotected the database in explorer and compacted the database, Still wont work hmm.
Any ideas

One other thing with this invoice button is that it prints a copy of the order on a invoice. Problem is I get asked for the date to print. I just want it to compose my invoice and have the date in there automatically.

Any help you can give me would be great.
Thanks
Mark
Mar 16 '07 #1
Share this Question
Share on Google+
3 Replies


Denburt
Expert 100+
P: 1,356
"invald link" Sounds like your tables are linked and the frontend can't find your linked tables.

If they are linked then try relinking them using the Linked Table Manager.

Hope that helps.
Mar 16 '07 #2

P: 38
I will try it out thanks. wont know till monday..
Thanks
Mark
Mar 16 '07 #3

MMcCarthy
Expert Mod 10K+
P: 14,534
I will try it out thanks. wont know till monday..
Thanks
Mark
Hi Mark

If you're not waiting on this I'll get to it on Monday.

Mary
Mar 16 '07 #4

Post your reply

Sign in to post your reply or Sign up for a free account.