Search results for query: *

When I run the following SQL statement in the immediate window. I get the following error: The SELECT statement includes a reserved word or an argument name that is mispelled or missing, or the punctuation is incorrect. DoCmd.RunSQL " Select TESTTABLE t, TBL_FieldID f, TBL_Index i WHERE...

I tend to have problems with syntax when mixing strings with variables. For instance, MsgBox "This is:" + variable gives me a type mismatch error or in a SQL statement. Can someone direct me to some Faq or other resource.

I notice when many members post code, they have a neat formatting trick which makes the code more readable on these post. Does anyone know how to perform that action.

This is SQL statement that I'm using in my code. RptValue, and X represent variable that I want to alter. This SQL statement will not put the constant into the SQL string. If I try to do something similar to the following ('RptValue','X')" then I get the words not values. Does anyone have a...

Will the GetAbsolutePathName method return directory of a shared folder. Different users in different regions access a database with different directory letter drives. I'm looking for a way to map a user's drive in an automated manner without concern of the drive letter.

The following line of code was entered in the Immediate Window of Access. I'm following an online tutorial on SQL and VBA coding. When I press enter I get the following error: Run-time error '3290' Syntax error in CREATE TABLE statement. Any clues? DoCmd.RunSQL "CREATE TABLE tblTest...

When I try to execute the following line of code, I get a compile error: Expected: case SELECT MasterTBLReport.[Report Fields]FROM MasterTBLReport This code was generated using the query tool, and it works. It does not work when integrated into VBA. Any clues?

I have a form that populates a list box control after an event click. It dynamically builds the column headers based on selected criteria. My problem is the lack of real estate to show all the columns. If the program selects 5 - 10 field headers, then my application works well. If you need to...

I built a query dynamically, that uses a list box to make multiple selections. How do I determine what is selected from the list box. For instance, I have five entries on the list box that a user may make choices from. If the user makes two choices, how do I determine the choices.

How do you make more than one selection in a list box? I have a list box containing 9 possible choices. I would like to make 4 selections, however I'm limited to one selection at a time. Does anyone have a solution?

I placed an Access database on a shared drive of a server at my company. This database is also password protected. When assigned users of the database attempt to access the database, it opens without requiring a logon. When I attempt to access the database, it works properly. One problem may be...

I have a text box in a form. Each word in the text box is separated by a comma. Each word in this text box control represents a field heading for internal company reports. I want to place each word into a table for comparising purposes. Does anyone have a clue?

I have a two tab form in my database application. When the form opens, a user has to manually move both scroll buttons, the one on the bottom has to be pushed over to the left, and the one on the right side has to be pushed up to the top. Once these actions have been made, then the user can see...

I have created a report based on a specific query, and it works very well. I would like to use the same report for a different form, but I need to change the query that's driving the report. I have searched all over the report's page, checked properties, etc. but not luck. Is it possible, or do...

I have a form which has two tabs. I placed embedded a picture on the form, however, I only want the (picture)symbol to appear on the first tab. Now it appears on both tabs. How do I prevent the picture from appearing on the second tab.

Does anyone know if the right mouse click activity of the mouse control be duplicated using VBA code? Any ideas?

The error message listed below references the following line of code: ' Create a reference to the current objects. Dim Objs As OLEObjects Set Objs = Sheet3.OLEObjects Does anyone have any ideas? --------------------------- Microsoft Visual Basic --------------------------- Compile...

I get the following error message when I attempt to import a table into a different database. I have no clue, does anyone else have a clue concerning error message. The Microsoft Jet database engine stopped the process because you and another user are attempting to change the same data at the...

I want to create a user-friendly command button that will enable a user to import a screen shot into a table field record. Currently, if you right click on the correct cell, the option Insert Object dialog box will open with the various choices associated with the activity. Will any of these...

I currently have a combo box, (Combo7) placed in a form which pulls its drop down list from a table (TBL_Warehouse_Process_Area). This table has one field, [Operations AREA]which simply lists the varied operational processes. This form has 3 combo buttons used to gather information from a user...