Recent content by lookingforK

Hi all, I found the solution. The problem was caused by a new multi-valued combo-box I created on the form. I used "Format Painter" to copy an existing combo-box (that has a conditional formatting) to this new one. After I removed the formatting from the new one, things become normal...

Thank you VbaInet. Please check the above attached pic . * The relation to the combo box and the action the button takes: when click OK button, values selected could be put in the combo-box; otherwise, no values are gonnna show up in the combo-box. I guess this is a bug for MS Access 2010.

Thank you Gizmo, There is no code for OK button (that is for the Combo-box as attached example).

Hi Experts, I get a bizarre situation while I am using MS Access 2010 to select values with Combo Boxes on a form, i.e.: * After I select one or more values from the drop-down list of a Combo Box, there is no response when clicking OK button using the mouse. It is stalled. I need to do the...

Thank you both ...

Hi, I am using a form based on a table in MS Access 2010 for data entry. The Data Type for column ID is AutoNumber with Increment=1. When I found ID for recent entries gets an anomaly (e.g. should be … 3, 4, 5 …, but it shows … 3, 5, 6 … that misses 4), I tried to refresh/change the ID...

Thank you pbaldy. I got a simple solution: use a Temp Variable i.e. [TempVars]![…]

Thank you pbaldy. Actually, I do use a form for the parameter. But I would like to try another way since I read a post mentioning: "... You can't set the parameter values in this way then use docmd.Openquery. WHen you set the parameters via DAO like this your only setting them for the...

Re: Got pop-up error "Invalid Argument" when using UPDATE query in MS Access 2010 Thank you SOS. It looks like complicated ...

Hi, I am using MS Access 2010 to export data into MS Excel 2010 spreadsheets. I am just wondering: Is there a way to set the Parameter value for the query via VBA? For example: There are 10 regional managers. When I click a button on a form, 10 sets of data per manager are going to be...

Got pop-up error "Invalid Argument" when using UPDATE query in MS Access 2010 Hi, I am using a MS Access 2010 DB that was upgraded from MS Access 2007. When I run a simple UPDATE query (e.g. as follows) that works fine in MS Access 2007 version, I get the pop-up error message "Invalid...

Omg ... Forgot this. Thank you Bob

Hi, I am using MS Access 2007. I would like to find out what data sources (e.g. tables or queries) are used in a report that has already been made. How should I do? I check the report in Design View, and use Control Source with Property Sheet. But I can not identify the data sources...

Thank you gemma-the-husky and boblarson, I find the problem. It works when using the values in Text Boxes as parameters for the query under 1 condition: after I input the values into the 2 Text Boxes, I should left-click the mouse on whatever other place except the 2 Text Boxes. It is...

Thank you boblarson. Still testing ...