Search results

Good Morning All. I've looked through how to reference a control on a form with VBA, and am looking for a similar type of statement for a table. My issue: 13 columns named N_Month01 through N_Month13, and a For Next loop that steps through 1 to 13. Buried in the code, I determine if there is...

Hi TexasLynn, I am in the same boat that you are describing... I'll summarize what I am trying to do, and let me know if it fits your scenario. I have a table of customer numbers, and the user must select a customer number to work with (the combo box) After a customer number is selected, the...

Hi Doc_Man, Thank you for taking the time to outline a direction that I can get started in. I think I may have to ask for an ‘extension’ on my time to implement this automated database. Can you make a recommendation regarding documentation standards for printing and / or presenting my...

Hi All, I have been tasked with generating a "CFR21 Part 11" compliant database. In a nutshell, I must be able to provide an audit trail for any transaction that changes (creates, modifies, or deletes) any record in the database. The audit trail must consist of which authorized user performed...

TransferSpreadsheet (with a named range) HELP Hello, Thanks for taking the time to read this thread. I have an issue with the TransferSpreadsheet method that I am curious if others have seen this before, and what kind of work around(s) are available. My users have a workbook (Limits.xls)...

Joanna, I have built a small mdb that I believe will do what you want it to. Please UnZip it and open frm_Trial1, then e-mail me directly with your observation(s). I believe we can solve this dilemma with the information you just provided! (don't give up; it's alright to be a little...

Hi again! I must admit I am confused to what your expectations are compared to what the database is doing. I would like you to try another 'experiment' if you could. Open tbl_Customers in a normal view, then enter a 'test case'. When you get to the Subscription field, does the combo box...

Hi again Joanna, It seems to me that you have two tables- tbl_Customers and tbl_Subscriptions that you want to use together. Open tbl_Customers in Design view (you most likely will get a message that you can not modify a linked table. Press 'OK') and check the 'LookUp' properties for the...

Hi Joanna, Tell me more about what you see on the screen when you try to change a subscription; are you in a table view, or have you built a form, and the combo box is on the form (with SubscriptionID as its data source)? -I believe you can 'fix' this issue if you have access to the original...

Hi Joanna, I would like to help you with your request; I have had to perform this sort of task a few times myself. My first question is how are the two tables linked together? You imply that each customer may have a subsrciption that is in one of three states (Proceed, In-Progress, or...

Hi Pat, Thanks for the advice... The requery was / is an attempt to 'update' the worload list for an employee after they change a few of the assessments' status. At this time I have removed the 'Update' button, and state that the user must select a different status (closed, review), then...

Hi everyone, I am new to this forum, and would like to ask for some help with an anomaly that I am experiencing with a linked subform. I have a few workers (employees) that are responsible for filling out paper work assessments within a fixed time period (28 days max). Each assessment has a...