Search results

ok this might be complicated. Background: Risk Management program to write the risk and its contingency plans. long story short - I have Table1 with fields: T1_ID (pk), Number1. I have Table2 with fields: T2_ID (pk), Number2, Date, Status (open/close values), t1_id. The two are connected...

Hi, I'm trying to add Items to my switchboard and I keep getting an error message whenever try to open the pick-list to select the specific form or table I'd like the command to open. The error is: "FillLstArg may not be valid setting for RowSourceType property or there as a compile error in the...

Hi, I have a field named status (pick-list type) and a field named apply_date (date type). How do I make the apply_date field to be mandatory when the status field selected value is 'X' for example. Also presenting a message to the user if he did not set the would be very helpful. Thanks, Jan.

Hi, I tried cascading lists by a single row source table method but with no luck. I created a table named Dep_Wing. I added 2 combo boxes and named them cboDep & cboWing (the dependent combo box). In the row source of the cboDep I put sql to select the department names from...

Hi, My code is working just fine on my computer and I can update the access from my excel. When trying to do the same from one of my user's computer, I get this error message: "Run-time error '3251': Current Recordset does not support updating. This may be a limitation of the provider, or of the...

Hi all, Appreciate your help with this one: I have users filling data (in various cells) in excel template file. Each time a user is filling the same cells and saves the file. Is it possible with a macro/vba, that whenever the user saves the file, the data will be exported to a specific table...