Search results for query: *

I've got a tab control that drives several things, and I'm running into a problem. The user searches for a particular patient using unbound controls, and a patient subform displays the associated results. When the user selects the patient they want in the sub form datasheet, this selection...

Hi, I've got an ASK field that prompts for a simple string, and the result is stored in a bookmark. I want to be able to use the bookmark in both a document heading and page footer of my document. My footer font size is, say, 11, while the heading is bold and size 14. The problem is, when...

To sum up the scenario: I have a loop that moves through a recordset of field values, of text data type, that I'm attempting to assign to a field in another table bound to my form. For example, consider the following column: SOURCE_VALUE ----------- Now str_user_ID ----------- Now, in my...

To be brief, my situation is this: I have a main form with several text and combo boxes, as well as a subform, and the form's operations are driven by a binary option group, as follows: If option 1 is selected, all controls are programmatically unbound, the form's recordset is dumped, and the...

All, I'm querying a table that, for the sake of discussion, has the following data: MODEL DESC_LINE DESCRIPTION ***** ********* *********** X 1 Super high-efficiency X 2 unit with widgets and X 3 gizmos. Y 1...

Hi, I have the following line in a master workbook that passes certain variables to a given function in other workbooks: bActivity = ActiveWorkbook.Application.Run(vArray(y, 4) & "!" & _ vArray(y, 6), vArray(y, 3), vArray(y, 5), vParameters(y)) All of my vArray()...

Hi, I have a "switchboard" form that opens up several accounts in a personal finance database I'm trying to write. Whenever I click on an account label in the switchboard, I have a dummy transaction form that comes up, for which I'd like to display a recordset of all transactions...

Hi, I believe this is a simple command - at least it is with Excel VBA, but what kind of code will automatically open a particular form upon opening an Access database? I thought it had to do with the way you declare the procedure name (i.e., Sub Auto_Open), but I'm not so sure. Thanks for...

Hi, I've got a pass-through query that I create programmatically with "strSQL", and I'm having trouble editing the recordset based on the query once I call it. Here's the code: Set dbs = CurrentDb CurrentDb.QueryDefs("GenericPassThrough").SQL = strSQL Set rst =...

Hi, I have a current setup between Access and Excel where, using Access forms, I generate queries and transfer them out to a pre-defined workbook that has a macro stored with it. Once the workbook loads, the user clicks a simple button to execute the macro. I'd like other users to use my...

Hi, Is there any particular reason related to syntax that would prevent an outer join from executing correctly? I have several tables in my FROM clause, but only two are outer joined. My recordset, however, is restricted only to those records where the joined fields are equal. I can post my...

Hi, I'm trying to use the SQL below to create a summary of the count and sum of contracts submitted either on paper or via the Internet. I'm new to the DECODE function, but because our Internet contracts have a certain Internet code, it's my understanding that using the nested DECODEs below...

Hi, I'm trying to write my own pass-through queries in Access to query our Oracle database, so I'm trying to learn the SQL behind many of the things I've been doing, or would like to do, with our information. One very big question of mine is this - how do you utilize different criteria for the...

Hi, I'm using an Access front-end form to dynamically create some SQL from our Oracle server via a generic pass-through query, due to the fact that the query can routinely concern several thousand records that would otherwise consume a lot of time using Jet SQL. At any rate, I would like to...

Hi, I have a form in Access that transfers a query using the DoCmd.TransferSpreadsheet method to a predefined Excel spreadsheet. After the DoCmd, I then define an Excel application object to open the workbook automatically that received the transfer. Within the workbook, I have an Auto_Open...

Hey, I have an Access form that I use, among other things, to output the results of a query to a specified workbook in Excel. My workbook originally has a macro that cleans up the data and formats it nice and neat. The problem is, when the OutputTo method in my Access code executes, the macro...

Hey, I have an Access form that I use, among other things, to output the results of a query to a specified workbook in Excel. My workbook originally has a macro that cleans up the data and formats it nice and neat. The problem is, when the OutputTo method in my Access code executes, the macro...

Hi, Is there an Excel method, or any other quick and easy way to remove blank cells from a range, either row or column. In my case, I have a sheet of records that randomly contain blank cells, and I'd like to delete the cells and shift all remaining data to the left, so that I have one...

Hey, I have a spreadsheet of data grouped by customers, and what I'd like to do is copy each grouping of customer into a separate workbook. However, some groupings might need to be saved as two different workbooks. So, I've set up a range list of all unique customers along with an adjancent...

Hey everyone, I purchased a baseline HP desktop back in 2000, and now that I'm getting into VBA, I've noticed that many people on Tek-Tips recommend using the Help file within the VBA environment to learn. Problem is, I don't have the files, and the recovery software that came with my computer...