Search results

Hi All, Still very new to MS Access but learning fast!! I have two tables. The following is a simplified example structure for each. Table_A Field_1; AutoNumber index Field_2; String of codes e.g. MAR;2CH;HOM;;;;;;; Field_3; String to hold expanded code descriptions. Table_B...

Hi Chris, Thanks very much for this and for taking the time to create such a customised solution :) It's working 'almost' perfectly. The only strange thing is that I've recreated the cboCustomer combo box exactly as in your example, but it's showing 2 columns - custkey and customer. I can...

Cheers Chris. I'll have a look and see how I can apply it to my application. David

I have a multi-record form which opens and is populated from a query Q_JobsToPass which looks like: SELECT T_CallDetails.* FROM T_customers INNER JOIN T_CallDetails ON T_customers.custkey = T_CallDetails.custkey WHERE (((T_CallDetails.Job_Passed)=False)) ORDER BY T_customers.customer...

Hi Paul. OK, I see what I did wrong now. Thanks. Have managed to get the value returned from form B OK using the public variable getReturnedString. It wasn't working earlier as I was declaring it in the wrong place. So everything is working as planned now. Thanks again for all your help. David

Hi Paul, Thanks for speedy reply. Yes, that's worked! As I said, I'm new to VBA and totally reliant on the help system and inline completion etc. Both of these put the acDialog (WindowMode) before the openArgs docmd.OpenForm(FormName, View, FilterName, WhereCondition, DataMode, WindowMode...

Hi everyone, I'm new to the world of Access and VBA. Have an excellent book, use VBA help and have scoured the web for a solution to my problems, but no joy so far. What I want to do is pretty simple. It's just a look-up and selection of an address from one form to another. I have 2 seperate...