dgunner71
Last Activity: Jun 28 '20, 02:17 PM
Joined: Jun 9 '10
Location: Chicago, IL USA
-
Answered my question perfectly (i.e. it's poor design to design a table this way.) Thank you! -
As always, thank you, NeoPa - I actually was referring to the table (if possible.)
For the field in question, on the lookup tab in table design:
I have the Display Control type set to: ComboBox
The Row Source Type set to: Table/Query
The Row Source set to:
...Code:SELECT tblEmployees.AID , tblEmployees.txtLastName , tblEmployees.txtStatus FROM tblEmployees WHERE (((tblELast edited by NeoPa; Jun 28 '20, 08:54 AM. Reason: Fixed the format of the code and added the mandatory [CODE] tags.Leave a comment:
-
ComboBox Value for Inactive Records
In a Clients table ("tblClients "), I have a ComboBox "Employee" to select from a list of Employees contained in tblEmployees. I only to display / allow employees who are "Active" in the system, however, if any employee was already selected, but is now "Inactive", I would still like them to show up / display.
Scenario:
Tom is the salesperson on client record ABC. Tom then leaves the company... -
Thanks all - this answers my question.
Happy New Year.
GunnerLeave a comment:
-
I also noted that if I do not close the Form B, the animation begins working on its own as soon as the report opens. Not sure if that helps...Leave a comment:
-
Simultaneous Code Execution?
I have a form (Form A) that has a print command button - the resulting report takes about 3 to 5 seconds to open.
To notify the user, I developed a form (Form B) and code to animate a "Your Report is Being Generated" display (there are 4 dots that move across the form.) This is the only purpose of this Form B - it is closed when the calling procedure (located on Form A) completes.
The code on Form B works perfectly... -
Hoo-rah!
Happy holidays.Leave a comment:
-
Thank you NeoPa. I think I was really looking for the answer in #3 (best practices).
Happy holidays!Leave a comment:
-
Recordsets vs. Linking Recordsources to Tables or Queries
All,
I have created several MS Access databases over the last 11 years that have worked very well but I have always set forms to link directly to either a table or query. While this seems efficient, it can cause issues or corruptions in a record being edited when the front end and back end are located on separate machines and there is an interruption in the network.
I have long considered using Recordsets and a save... -
@jforbes - I will circle back. Essentially, I'm going to try to host the front and back ends in the cloud via 365.
The db solution that is hosted in cloud will have a feature to export/download a certain data subset to the local computer (i.e. any unbooked/unposted work orders).
I will have a locally hosted database with very limited functionality on the local computer to import the data into the accounting program....Leave a comment:
-
Thanks so much for all your great insight.
Based on these posts, I'm thinking I may try to host both Front End and Back End in 365 (cloud), providing db access remotely. As for the importing into the accounting system, I believe I should be able to write a procedure to do a daily batch download from the online db to a local db. We can do the (uni-directional) 'push' into the accounting program from the local db. It's not as seamless...Leave a comment:
-
MS Access: Local Front End, Cloud Back End?
I have a client who would like to keep his db front end hosted locally (on several 'clients') while putting the back end in the cloud. The reasoning for this is as follows:
- with data hosted in the cloud, it will be easier to access from anywhere, and will be less likely to be subject to data loss if their server should go down. (this recently happened which is the driver behind this - we recovered all data from nightly backup but their
-
I'm under the impression that setting this master-level function only applies to newly created objects and can simply be over-ridden in the properties.
I have given up on finding a solution to this and have chalked this up (as NeoPa notes) to a Jet issue (which exceeds my knowledge by leaps). I appreciate the feedback / insight, though.
GunnerLeave a comment:
-
Thanks, CN!
If this issue presents itself again (it has mysteriously corrected itself) I'll try to install this hotfix and see if that corrects the issue.
Take good care -
GunnerLeave a comment:
-
Thanks for your replies, NeoPa and ZMBD.
That article was a great insight and, as NeoPa notes, highlights the crux of my dilemma. MS Access 2013 Record-level locking does not seem to be working (i.e. irrespective of the setting, multiple records are locked when editing a record).
I tried the following last night:
Unchecking record level locking. (same result)
Basing the form on a query. (same result)
Opening...Leave a comment:
-
A few more pieces of this 'puzzle':
This is the exact issue I'm referring to - When I open a record, several of the neighboring records are locked along with the edited record. It seems like if I open a record in the middle of a table, 6 (seems to always be 6) records are locked. If I open the last record in the table, it seems like only 2 records are locked.
http://www.access-programmers.co. uk/forums/showthread.php? t=11566...Leave a comment:
-
As an update, msdn.microsoft notes the following:
Edited Record (2) Property Setting -
(Forms and queries only) A page of records is locked as soon as any user starts editing any field in the record and stays locked until the user moves to another record. Consequently, a record can be edited by only one user at a time. This is also called "pessimisti c" locking.
Does anyone have any idea what...Leave a comment:
-
NeoPa,
Thanks for your reply. I did read that the advanced settings screen above is only for newly created forms, but as I noted, this form is indeed set to Edited Record.
If I set the form to 'No Locks', this appears to alleviates the situation. I am using a field called [txtRecordOpenSt atus] that is updated in the OnLoad Event to 'Open - UserID'. If a user tries to open the record, the user is informed that UserID has...Leave a comment:
-
Record Locking Dilemma
Hello once again -
I have a table - tblPurchaseOrde rs.
When I access/dirty a record from tblPurchaseOrde rs via my form, frmPurchaseOrer s, MS Access is locking 5 or 6 records in the vicinity of the record being edited. (If I open the tables and use the keys to move through records, I am getting a circle with a line through it for six records -- I am the only user in the system when this is happening). Sometimes, 6 records... -
Just an update - this code works perfectly -
Thanks again!
GunnerLeave a comment:
No activity results to display
Leave a comment: