Yea, you guys are amazing! Thanks for being so patient !
I almost gave up myself!
Do you know the reason why it worked on some computers but not on others?
I know I don't have very standardized filed names, but I guess that shouldn't be the cause, should it? It works perfectly on 3 other computers.:confused:
I want to thank you first!:) but the problem is not going away!
1. Is this database split - backend with tables only and a COPY of the
frontend on each user's machine?
2. If not, it needs to be.
Yes. We use access as frontend, SQL backend. The access file is located on a network drive...
Hi
Thank you! I tested it. It works fine on mine(as always)...but it still gives the same error at the same line on my co-workers computers!
This is killing me. sad face...
It runs perfectly on my laptop and my desktop, but always gives run-time error 5 on 2 of my co-workers computers.
This is where it stops.
Can anyone help please? Thanks!
I have checked reference on all computers made sure they have the same order.
just checked again, we have the same versions...
how exactly do I do that? I created a Scheduled Task, it only opened Access program for you instead of the query/vba code in xx.mdb file.
Please help. Thanks in advance.
I need to send a weekly report at 11pm every Friday night to someones email.
I think there are 2 things I need:
1. automatically generate a report at that time.
2. automatically send an email with that report attached.
(maybe 3. attach the report to email, I've never done it:confused:)
Right...
I recently upsized my database to SQL server, after that I created a Access Project(.adp ) to replace the original one(.mdb). I thought that's the proper way to use Access as a frontend...
My issue is that I had a table that linked to outlook inbox in my original one database(.mdb), but now...