Search results for query: *

Here's the solution I altered the function that generates the dynamic SQL to include the following line of code: "NVL(TO_CHAR(DECD_BRTH_DT,'MM/DD/YYYY'),' ') AS DOB" Dates in Oracle are stored as a date data type. Regardless of how dates are stored, Oracle seems to always return date values...

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

Alternately, if someone can tell me how to use VBA code to have the form and subform (these forms are deliberately not linked) automatically move to add a new record without having the forms and subform open without using the "DataEntry = True" approach, I might be able to code around my initial...

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

Thanks! I copied/pasted so much that I overlooked what I should have seen had I not been looking at the code so much. The compile error went away with the end with statements.

subfrmOptionValuesStatus (just after the END SELECT statement) should be removed from the module as it does not belong here. Removing this piece of code does not resolve the CASE without SELECT CASE compile error.

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

The listbox shows a list of contacts to disease report cases. As new cases are added and their contacts are entered the list grows and grows fast. I currently have a query string for the rowsource of the listbox, but only the first 200 individuals are listed. The query string is used to...

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

Do you have any thoughts on another language / IDE that would meet this goal?

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

declare your variable in the general declarations section of the module, right where you would normally declare "option explicit" You could define the variable as either a true variable or a constant (const is the keyword if my memory is correct) if that is what you really want to declare.

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

Have you tested your memory for bad registers in the hardware (i.e. memory stick)? This is not the best utility, but has worked well for me and is free. www.memtest86.com/ You might want to do some research to find out what memory test utilites rate better. Microsoft has their own memory...

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

Thanks, commenting that line of code out solved that part of the problem. I still have some more code fixing to make the matrix math work, but will work on that on my own before requesting any additional assistance.

Error message: "Compile Error: Expected end of statement" appears immediately after reading the following lines of code: -------------------------------------- Option Compare Database Option Explicit Public Class MatrixFunctions --------------------------------------

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