Search results

I've done searches on the forum for this issue, but no one has gotten this specific. I built a database with some VBA coding in Access 2000. Then, I tried to run the database on Access 2002 and unfortunately, it does not work in two respects. I will try to be as detailed as I can. By the way...

I'm trying to overcome some problems I'm experiencing with my SQL statement that's supposed to update the field type of every cell of a particular column from a text value to a date value. The contents of each cell are in the format x/xx/20xx, so there shouldn't be a problem converting, should...

How can I use the KeyCode of the KeyDown event from within the event? Private Sub ListBox_KeyDown(KeyCode As Integer, Shift As Integer) If ____.KeyCode = 30 Then MsgBox "Up" If ____.KeyCode = 31 Then MsgBox "Down" End Sub

When I create a report with a bound control set to a field in a record source (table) that doesn't have a column corresponding to the bound control in the report, a pop-up box shows up (preceeding report generation) entitled, "Enter Parameter Value" and lists the name of the bound control that...

Is there a way to set the focus and select a particular entry in a list box? This won't do it because it sets the focus to the list box object, but doesn't actually select an entry in the list box. Me.ListBox.SetFocus What I want is something more like this Me.LstTables.ItemData(File).SetFocus...

What is the VB character code for a quotation mark?

The following works for a text box control called "TextBox": Dim CurrentControl As Control Set CurrentControl = Forms!Switchboard.TextBox CurrentControl = "Message" But let's say I want to alter the color of the font from the default (black) to red... how can this be accomplished? (This does...

Is is possible to print a report (that's already been generated and in "preview" mode) by hitting a "print" button that's on a form? I'm trying to do this with DoCmd.PrintOut I realize that this command will print out the currentlyactive object, so I'm thinking I have to make the Report active...

Is there a way to have a Label or Text Box auto-size its width to its dynamically-changing contents with VB (like when you double-click it during design mode)?

Does anyone have some code to enable transparent back color on a list box? It was suggested that perhaps someone may have created a tweaked version of the standard list box as an activex control.

Is there any way I can set my list box so that its background color is transparent?

I've read the Access Help on how to set the default value of a an unbound text box to a default value: Me.TxtBox.DefaultValue = """NULL""" I want to be able to set the default value of the text box to a string variable, but it seems I don't know the correct syntax. Dim TxtValue As String...

update query I want to take some string data (typed by the user in a text box) and save it to all row entries of ONE column in a specific table. Is this possible? I'm assuming a loop is necessary from 1 to COUNT of the table's rows and then I would have to designate which column of the active...

Can anyone post some example code for exporting a table from Access as an Excel file with a file browser? Basically, I want to be able to browse for the path and use that string in the PATH part of the code below. Any help would be great. DoCmd.TransferSpreadsheet acExport...

I'm looking to find out how necessary the function is that replaces a given character in a string with another character (ReplaceG). I'm interested in compacting this code as much as possible without losing its functionality. As you can tell, this is part of the code for importing a spreadsheet...

I'm trying to figure out how to have the default values for a list box automatically set by its row source from 1 to 9999. I'm assuming that by setting its row source type to "value list" and coming up with some kind of simple code for a sequence to denote a list from 1 to 9999, that would do...

Can anyone show me how to use the code DoCmd.PrintOut acPages, Me.TxtFrom, Me.TxtTo to print a report from a form?

I've got a recordsource that feeds the value of the control AddDate in a report. The recordsource is blank/empty/uninitialized/NULL. I want the result of the code below to spit out a pop-up message box that says EMPTY! but it doesn't work. The code is in the Detail_Format section of the report...

The following code works its way through some simple If...Else...EndIf statements and For...Next statements. Me.AddDate is Null. The result of running the code (with the MsgBox "markers") is that the following messages appear (in the order listed): 1) End Add True 2) End Add Checks 3) End Add...

Is there a special function for extracting the name of the file from it's path and extension? (Or do I have to create a loop and check for instances of special characters such as "\" and "." in relation to their expected placement?) For example, I want to extract the name of the file "FILE" from...