Search results

I am back on the same issue. Dou you think using a macro to open the report instead of Docmd (DoCmd.OpenReport "rptBlrSrchItem1", acViewPreview) would help? I just don't know how to do this inside my click event procedure. Your help is greatly appreciated.

Wiz47, Can you give me some more detailed explanation? You are talking about load event of a report? I don't see that event listed for a report?

bolarson, I added a breakpoint just above the following line and step thru line by line. "DoCmd.OpenReport "rptBlrSrchItem1", acViewPreview" This time I didn't get the 2501 messgae with 'End' and 'Debug' button, but just when it came to that line it crashed. Also, I tried one more error...

Wiz47, I did try this and same err 2501 messgae. Looks like there is no way to trap this error. I tried to trap this on the report's "on close, on error, on open, on no data" and nothing seems to work.

boblarson, Thanks for catching up the mistake. I fixed the line to Err.Number, still same message Error 2501 When I click 'Debug' button it always takes to this line of code: DoCmd.OpenReport "rptBlrSrchItem1", acViewPreview

Folks, Need your help. I searched the entire forum and found couple of postings on this, but none of them indicates if there is any fix for this problem. If there is no data, basically I want to show a message and close the report. I have some code to handle this under no data event like below...

I figured. The following MS article addresses the problem: http://support.microsoft.com/kb/314598

Rickster57, Sorry, I meant to say "NO" to your question.

Rickster57, Yes. I opned another .mdb file and no problem, I can get into DB window.

Folks, Strange, I can't bring my databse window back in my screen. F11 or holding SHIFT key doesn't seem to work. Also, I have checked the check box for "display database window" on startup options. Did "Compact and Repair Databse", nothing seems to help. Any one has any idea on what's...

rborob, Sorry, I couldn't get back to you about how I made up. Unfortunately, I ran into some debugging problems. I tried with some breakpoints in my code and all the sudden it didn't stop at the breakpoints. Finally I got that figured and your suggestion of building SQL did work. Now I can...

rborob, Thanks. The tables tblProjts1 has "projectId" as a primary key and all other tables (tblEffcy, tblAuxPwrConsmptn, etc, I didn't include these tables on my last posting, but I have now without any data) which I select from the combo box has got their own primary key and "projectId" as a...

rborob, Actually, the criteria is in checkBox and OptionButtons. I have attached the GDB_1.zip file which has this search form. If see the from then it will be more clear. Thanks/Shan.

rborob, Thanks for the response. The report is going to be created on the fly, it may include certain criteria that user can pick (which I plan to do later once this code works) before run the click button. I don't have any pre-created report where I can insert an SQL under report's...

Moniker, Rborob and SJ: Thank you for taking time to look into my request. It's greatly appreciated. Moniker, you are correct. I have built a table with the actual table names in column one and the more descriptive name in column two. Is the column index starts with 0 or 1? I have column...

This must be an easy one, but I am having trouble. Can someone help me how to populate a combo box with table names (I have like 50 tables in my database) and then have user pick an item from the como box list and use that item (table name) in a select query? The combo box contains two...

Dear Boblarson, First of all, let me thank you for taking time to look at my request. Please see my response to your questions below in red : As far as creating a report and using that as the recordsource I don't know for sure. But, while reading through your query, it begs the question "Why...

Folks, can someone help me on this? I am not sure why the select query inside this procedure is not working. Here is the that routine: Public Sub temp() Dim strDocName As String Dim strTableName As String Dim strTbl As String Dim aot As Access.AccessObject Dim strSQL As...

Hi folks, Can someone help me here? I have a field with memo data type where I store like 1500 charcaters. I have a command button which when the user clicks export a query to Excel and and format it. The problem is it puts a tiny square on CR and newline as follows: For the guaranteed...

Dear Clerics, Thanks for the tips. I tested your code but still didn't work.