Search results

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

Re: How to solve error 3828 caused by using a multivalued field & parameters in query I think SHORT should be assigned automatically by MS Access 2007 because I set up the 2 parameters in "Query Parameters" dialog box as Integer. [Forms]![Export Reports]![ComboWKE] & [Forms]![Export...

Re: How to solve error 3828 caused by using a multivalued field & parameters in query Thank you, I tried, but got another error Run-time error '3125'. I am just wondering what kind of function (e.g. DLOOKUP???) I can use to to covert the values in the MVF to strings in query? :banghead:

Re: How to solve error 3828 caused by using a multivalued field & parameters in query SQL: PARAMETERS [Forms]![Export Reports]![ComboWKE] Short, [Forms]![Export Reports]![ComboWIS] Short; SELECT [Week View DS 2013].ID, [Week View DS 2013].AVP, [Week View DS 2013].[Business Unit], [Week View...

Thank you. I tried. But they could not work. I even tried Forms]![Extract Data]![Week From].[text] or Forms]![Extract Data]![Week From].[value]. Can't work too. Looks like only the parameters from combo boxes can work.

How to solve error 3828 caused by using a multivalued field & parameters in query? Hi, I am using VBA with MS Access 2007 to export data from a query to MS Excel 2007. I use {DoCmd.TransferSpreadsheet acExport, , ...} to export data. But I get "Run-time error 3828", that is: Cannot...