Search results for query: *

Environment: Windows XP, MS Office 2000 Scenario: I have a code block that takes the results of a recordset and stores the values within an array of type variant. Results from the array are then written to cells in an MS Excel worksheet. Problem: When dates are retrieved from the array and...

I want to use VBA to set page layout and margins in an MS Access report using MS Acces 2000. Is there a way to do this? Reports in MS Access 2000 do not store these values as part of the reports.

I am successfully exporting data into MS Excel from MS Access using docmd.outputto syntax. I want to add a table title to the exported data and am not sure the best way to do this. Can I use a DDE command to insert a new row 1 into the MS Excel spreadsheet? If so then I could use a DDE POKE...

I have a data entry form that is opened in dialog mode. There is a subform on the data entry form. When I first open the form I can add data through the subform. If I close out of the data entry form and reopen it, The subform becomes "locked" and I cannot move the cursor to any of the text...

I'm receiving this compile error in MS Access 2000 (9.0.6926 SP-3). The compile error occurs at the 5th case in the list of cases. I don't understand why it can see some cases but not see all of them. Is there something wrong with my code? (This code is in a form module on frmSearch that is...

Does anyone know a registry hack or other fix that will allow a list box to display more than 200 results?

I want to integrate two applications together and make the end user feel like they are only using one piece of software. To make the applications talk, I will be using MS Access since one of them uses MS Access for the back-end database. My thought was that I could 1 - create a form that...

I want to integrate two applications together and make the end user feel like they are only using one piece of software. My thought was that I could 1 - create a form that fills the whole screen and 2 - create a subform that fills all the screen except for an allowance on the left side of...

PROBLEM: I have a text box with a start time and a test box with a finish time value. I want to calculate the number of minitues that elapsed between these two values and display it in a 3rd text box. FAILED APPROACH: My first thought was to make a click event that took the date/time value...

I have some VB code snippets that use objects to perform matrix math operations. I would like to use these same code snippets within MS Access 2000 VBA but am experiencing compiler errors when declaring a class. Is it possible to use objects in Access VBA? Do I need to reference a...

I recently set up a test database using MS Access 2000 User and Group security. I do not need the database anymore, but find that every time I 1 - create a new blank database I need to authenticate to the test.mdw file or I cannot create the file 2 - attempt to open an unsecuried MS Access...

I am using an update query to recode values stored within a field through the use of a conversion table. The query mostly works, but I am finding that sometimes values are not being recoded. The conversion table looks something like this: ================ NewCode OldCode 1 A...

I'm working on another solution to this problem (using StatTransfer), but was curious if anyone might be able to explain why it was produced. I was attempting to import data from a fixed width text file that occupies 1,569,735 KB of space. The schema I provided to MS Access had the file layout...

Is it possible to feed multiple OpenArgs? If so, how? Does anyont have a code example? I'm using MS Access 2000. I want to open a form such that both DataEntry = True and NavigationButtons = False when the form is opened from a specific command button. (When opened from another command...

PROBLEM: I cannot figure out how to set the RecordSource property of a pop up form based upon an IsLoaded test. APPROACH: I want to use an IsLoaded test to 1) determine which form is calling a lookup form and then 2) set the RecordSource property based upon the form that is calling it...

I am trying to convert some MS Access 2002 code to MS Access 2000. With this code I am trying to use the QueryDefs collection of query names to populate the RowSource property of a combo box. Within Access 2002 this is done with the following code: Option Compare Database Option Explicit Dim...

I have been using notepad for quite a while to write/edit UNION and other queries. The primary reason for using notepad is to take advantage of the FIND/REPLACE utility. Have any of you ever written a module that would be enable the FIND/REPLACE utility within the SQL VIEW of a query?

I am trying to create a simple character offset encryption function to encrypt specific data fields within a query results output. Though my method appears to work for encrypting data (provided the field is not null), but unfortunately the decrypt function is not working correctly. When...