Search results for query: *

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

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

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

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

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

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!

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

How do I keep someone from using Shift Double Click in windows from opening the database and having access to the tables, etc. In the start up mode, I don't show the database window, and I even made an MDE file; but - if I shift double-click from windows, I can still get to the database...

On my form I have several fields that I allow the user to "Filter by Selection"; they can filter on up to 5 fields and this works. The records are filter down to the exact ones they want to see. However, the underyling query has a sort on these fields and when filter is off, the sort works...

I want to stop the user from exiting a record if a certain field is empty. I have 2 combo boxes that depend upon each other and if the user hits escape, the one box is ok but the other box will not requery. (The underlying record is fine and contains the value, it just won't display). So I...

I am an Access developer that can't get an answer from my system people... XP is trying to synchronize Access databases and they don't seem to be able to stop it. I can't imagine why XP would want to treat databases the same as word docs and spreadsheets. The databases close and the double...

Instead of having a memo field appear on my form, I'd like to have a button that would call a popup form allowing the user to enter data into the memo field.

I've been using Access 2002 Desktop Developer's Handbook successfully, but on page 367, I'm a bit stuck. I am trying to use a control on a form to limit a recordset I create to populate a combo box. I get the records just fine, and set the combo box's RowSourceType to "Table/Query" and set its...