Search results

I connected back the TextBox to the original field from the Table. I added the code. Gettign a complie error: Argument not optional.

Could you please elaborate more on what and where should I do with the DLookup function, the relevant field and the form??

Thanks. Can't see how to combine the DLookup with the need to save the data as explained in the link. I guess my need here is much bigger with less knowledge on my side. I appreciate your help very much. J.

Thanks, worked fine, the DLookup in the field in the main form takes the value from the field in the sub form as required however...since I'm putting the DLookup in the textbox of the field, as u suggested, the source of the field is no longer the record from the main table so any value my field...

it can be the id or the date, as long it is the last record that has statu = close. e.g: if RiskPlan1 = close and also RiskPlan2 = close and RiskPlan3 = open, then data is taken from RiskPlan2. if RiskPlan1 = close and also RiskPlan2 = close and RiskPlan3 = close, then data is taken from...

Table1 - Risks (the main form). ID Name Probability Severity Score UpdatedProbability 1 risk a 5 5 25 ......... Table2 - RiskPlan (my sub form) ID RiskId Name ExpectedProbability ExpectedSeverity Score Status...

Maybe my explanation wasn't clear. Here is an example: Risk number 1 in Table1 has 3 mitigation plans (plan 1, plan 2, plan 3). Each plan has an id, a date, a status and another number field (call it number2). Same for Risk2,3 and so on... The user fills in the data in the above number2...

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...

Had help from another place and found the problem: My file is located on a shared folder so I needed to set the location as trusted: "Code does not run in 2007/2010 unless your database resides in a folder that has been declared a “trusted” location."

Those are 2 separated fields with no connection between them and both do not have a default value.

Status is a combo box (drop down list) field with text data type.

not working. I wrote the code in the BeforeUpdate. I get nothing.

Why the wrong event, don't have I have to check the status after it was updated? Can you point me to the correct solution?

No. I even tried to make it more simple but not working for me. Private Sub status_AfterUpdate() If Me.status.Value = "X" Then MsgBox "you must supply the apply date" End If End Sub What did I do wrong here? Suggestions?

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.

thank but I already watched that video. It is nice but doesn't show the tables structure and other vital info. I followed this video and managed to do the same in a new file but not on an existing one even that I copied all the items one by one.

No matter what I do and which method I choose, I can't get it done on an already existing file/form. It is working only if I create a new access file. Help...

Tried it now and still no good. The funny thing is that if I do the same on a new access file, it is working just fine, but if I add those boxes to an existing form I have on another access file...it is not working. Any idea?

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...