Search results

Hi all, Can some one help me with how to set a default text on a combo box whose record source is set to a query? I have a form with two combo boxes. The first combo box’s record source is set to the following query: SELECT chrCategoryID, chrCategoryName FROM tblGuarCategory; My 2nd combo...

Dear folks, I appreciate your help. I don't know how to stop this warning message. Microsoft Office Access can't follow the hyperlink to "rptMyRportName” Please verify the destination. I have a command button on a form whose hperlink subaddress property is set to a report name...

Automation (query for Exporting to Excel) Error - Got it!! I figured it out the "Run-time error ‘3061’:Too few parameters. Expected 1." error. Solution: Do not pass parameter in qryTwo. instead you pass it through VBA via SQL string. Hence, the revised qryTwo should like this: SELECT...

Hi folks, I need your help. Did any one get a error message like the one below: “ Run-time error ‘3061’: Too few parameters. Expected 1. “ Basically I have a form with a command button and a combo box. The combo box's row source property is set to the following sql: SELECT DISTINCTROW...

Hi madrav72, Thanks for your response. Let me take a look at your code and get back. I don't know how your MasterSummary query will look like. But, the equivalent of mine is a big union query with criteria (projectId field) field selected by the combo box bound column. Thanks, again, for...

Folks, I have a form with combo box (cboProjForRptSeltn ) and two command buttons. The combo box is filled with name of the reports. The combo box has two columns, column 1 is the name of the report and column 2 is the bound column which also is the link field (primary key) to limit the...

Dear Tarantula, Thanks a lot. I tried and it works. ShanVel

Hi folks, I have a form with a record source property set to a query which pulls the data by joining two tables. The form also has four navigation buttons (first, previous, next, last) and a ADD record, SAVE record, EDIT record, DELETE record buttons. I also have a unbound combo box (control...

You could use an event procedure in the form's before_update event and let the user go through data validation (ex: You didn't enter a postal code, save anyway?) to check all your rules before allowing the record to be saved. ShanVel

Pat: Thank you for the prompt response. I will try and let you know.

Limitation of Union Query Len, I have the same problem. I have to pull in 65 records from 66 tables with each record containing 19 fields. Access complains with "query is too complex" if I exceed more than 50 tables x 19 fields each. Hence, I split it into two unions and tried to do UNION...