Search results for query: *

Yes, I tried using message boxes to stop, but it didn't work so I just pulled the code out of vba and put them in the menu so the user can run then from there. It didn't solve the issue, but it is actually cleaner. Thanks for your reply, I appreciated it.

Hi all, I am calling a report from a form using the following VBA code: docmd.OpenReport "rpt-5",acViewPreview,,,, "DownloadProcess" In my report, I set Pop Up to No, and Modal to Yes. The report is created and displayed, but my code keeps on truckin... I thought that the modal would make...

Thanks for the help. I couldn't get it with the array embedded in the seek statement, but I split it out and that was the solution! Again - thanks very much...

You can identify which form is displayed upon opening the database by clicking the large circle located at the top right of Access, then click Access Options located at the bottom. Click current database on the upper left. Then, click on display form and select the name of the form you want to...

Hi all, I've never used foreign keys for searching before... so I've researched all morning and I can't find any samples of how to use a unique foreign key that is comrpised of two long fields in an ADO recordset. Maybe it has to be DAO? I want to add new rows to tblEmpSkills from data in two...

I totally forgot about the wizard being on!! Thanks so much, it works wonderfully! Now I am going to add another layer then I'll be done. I really appreciate your help, you made it very easy for me to understand.

Hi - thanks for the help - but I did what you said above and I can see the txtBxLink ID field changing as I click the different orders. However when I try to link my subform to the text box, it doesn't show in the pull-down list. I am assuming since it isn't a field on the table of the main...

Hello all, I'd like to have a tabbed form to show customers on one tab, orders for a selected customer on the next tab, and order details items for the selected order on a third tab. Setting up the first two tabs was easy; I dragged the continuous form onto the tab and linked the Master and...

Thank you for your response - No, I'm not using a timer - however I found that if I disconnect from our network, it doesn't appear to be happening. Could there me something timing out in the network that would affect Access?

This is a sporadic problem: When I toggle to VBA and strike any key, I am immediately switched back into Access. When I toggle back to VBA, the key stroke I entered is there, and I can continue on. This has happened with the Return Key as well as numerous other keys so there isn’t a...

Is there a way to manually create a split form using a continuous form rather than the datasheet used by the wizard. I am restricting one combo box by the selection of a 2nd combo box in the same record and displaying the values using a text field that I lay on top of the combo box. I...

Thanks TheAceMan1 - for both tips. I can see by clicking in another property the SQL statement was updated. Such a small thing can drive one crazy. In addition, I will use NotePad to cut and paste. Again, much thanks.

Thanks - but that is where I am making my change to the SQL statement. I can see the change and when I save the SQL statement to save within the form, the change to the query doesn't take.

I copied an existing form containing two subforms all have embedded queries; then I went into the new forms and wanted to change the embedded query from the current table to a historical table. I usually go to the sql view and cut/paste into Word and make my table name changes and paste back...

You're right, and I know better too. I have a series of queries that I run that are named sequentially... so I just called the name and didn't think anymore about it. I deleted the call and it works fine. Thanks for the reminder!

The query is called from within another query that I am using for the desired end result. I just don't want to visibly see the results displayed to the screen.

I'm calling several stored queries that create temporary files from within VBA using "DoCmd.OpenQuery" calls. One of the queries is a select query. How can I stop the results of the select query from being displayed to the user? Thanks in advance!

Thank you, that took care of it!

I right clicked my query and indicated that I wanted to "hide" it. Actually, what I wanted to do was hide the results from being displayed while processing (which I figured out how to do...) I can't see the query in the database window now --- How do I "un-hide" it? Thanks in advance!

I have some design (built-in) toolbars and Access's main menu bars showing in my application on my end users versions where I do not want them. In Startup, I turn off everything except for Display Status Bar. All I have is my custom menu bar for Menu Bar. If the end user right-clicks on the...