Make sure the backend db is set to Shared mode. Just because it's in a shared folder doesn't make it a shared db.
This happened to me one time before and I had accidently left the backend as Exclusive. Works like a charm when set to Shared.
EManning
Last Activity: Oct 16 '08, 01:35 PM
Joined: Sep 26 '08
Location:
-
Add 2 text boxes on your form for beginning date and ending date. Then in your code, add coding something like "ReferralDa te BETWEEN #" & Forms!frmReport Selector!txtBeg inningDate & "# AND #" & Forms!frmReport Selector!txtEnd ingDate & "#".
Did that help???Leave a comment:
-
I'm not sure I follow exactly what you want but maybe this will help guide you to a solution. Use the AfterUpdate event of the true/false field. If true, then set your requested credit amount field to the adjusted amount. If false, then do nothing (or something else).Leave a comment:
-
What's the Record Source for the report? I believe the WHERE claus (Forms!frmInvoi ceQ.BuyersInvoi ceNo = Me.Text296) has to associate with the reports' record source. And the record source would not be a form....Leave a comment:
-
That's not a bad idea but the 2nd user might freak when they try to select a record they know should be there. I could display a message that the record *is* there, just being used by user1.
However! I may have found the answer to my original post. After receiving the warning message that user1 has the record, if user2 clicks on another control other than the combobox, then clicks back on the combobox, it gets requeried. Now I...Leave a comment:
-
My apologies. I am using "requery", not refresh. I say both words but use only "requery" in coding.Leave a comment:
-
Combobox - refresh problem?
Using A2003 w/ tables linked to SQL Server. All users have their own
copy of the mdb. I have a combobox whose rowsource is a query. This
query is based on a table and has a field in it that indicates if the
record has been selected. When user1 selects the record from the
combobox, the field is updated that the record has been selected. If
user2 tries to select that same record, they get a warning that... -
Look in Access Help for more info on this. I got in to this a bit a couple of years ago. Unless you're a programmer-extraordinare, it's a lot easier just to open the master, then do the Tools...Replica tion...Synchron ize Now.Leave a comment:
-
Thanks for your reply, NeoPa.Leave a comment:
-
Have you tried printing it and if so, does it print in landscape? I tried something similar to your problem. I created a bound report, with portrait orientation. I then added coding to open it in landscape. When I previewed the report, it opened in portrait but printed in landscape.
The only way to open the preview in landscape is to set the orientation to landscape in design mode.
You can't open design mode in...Leave a comment:
-
Thanks for your reply. Those settings won't work in a SQL environment. This is weird. I'm not finding anything in newsgroups or other sites where people have had this issue. I can't believe I'm the only one with this problem!Leave a comment:
-
What is orientation set to in design mode (File..Page Setup...Page)? This may be overriding any code you have.Leave a comment:
-
Warn user2 if user1 on requested record
Using Access 2003, linked tables to SQL Server, and using a form that's mostly bound. I need a way to tell if user1 is on the record when user2 tries to open the same record, w/o waiting for the user1 to save the record first. I don't want to wait until the write-conflict error occurs. I want to pre-warn user2 that user1 is on the record. The only way I can think of is by adding a flag to the record and setting it to true when user1 opens the...
No activity results to display
Leave a comment: