DoCmd.OpenTable help. - Microsoft Access / VBA

magmike

I am having problems with my OpenTable code. (Sorry, I'm new at this)

DoCmd.OpenTable Potential_Products_Presented

The debugger says I need a table name.

This code is in the Dbl Click event of a form field. Thanks.

Aug 6 '07 #1

Subscribe Reply

10592

fredg

On Mon, 06 Aug 2007 08:47:52 -0700, magmike wrote:

I am having problems with my OpenTable code. (Sorry, I'm new at this)

DoCmd.OpenTable Potential_Products_Presented

The debugger says I need a table name.

This code is in the Dbl Click event of a form field. Thanks.

The name must be a string value, so enclose the name within quotes.

DoCmd.OpenTable "Potential_Products_Presented"

By the way, tables are for storing data, and should not normally be
viewed. It's best to use a form to view your data.

Because forms have events, you can manipulate your records, enter new
records or edit existing ones, and still have some means of assuring
the data is properly entered.

Create a form based upon your existing table.
Then:
DoCmd.OpenForm "Potential_Products_Presented", acFormDS
will open your form in datasheet view.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

Aug 6 '07 #2

Similar topics

3277

help with DoCmd.Close

by: chanchito_cojones | last post by:

hi there, I am needing some help with a database I am putting together. The database works off of a main Form, which then has buttons on it that will open up other forms. The problem I am having...

Microsoft Access / VBA

11038

docmd.transferspreadsheet unexpected error

by: user_5701 | last post by:

Hello, I'm getting an error with a Docmd.Transferspreadsheet line of code: DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel2000, "tblTest", pathAndFilename, True The above line...

Microsoft Access / VBA

3423

Docmd.save Does Not Produce Error

by: WJA | last post by:

I'm probably missing something here but I can't understand the following. When 2 users try to save a record with the same primary key (a number field), the first record saves as expected, but the...

Microsoft Access / VBA

6797

DoCmd.OpenForm Problem

by: Mike | last post by:

I am trying to open a search results form based on the input from a prompt form. I am using the following code: --- Begin Code --- Private Sub btnSearch_Click() 'Dim Variable and assign data...

Microsoft Access / VBA

4534

DoCmd.OpenView error

by: Shals | last post by:

Hi I'm using Command DoCmd.OpenView "dbo.vFDXQryBldgEdit3",acViewNormal,acEdit to open a view vFDXQryBldgEdit3 (written in SQL Server) in the Edit mode. This view is created on single table....

Microsoft Access / VBA

6252

Behaviour of the DoCmd.OutputTo

by: Simon | last post by:

Dear reader, With the DoCmd.OutputTo ...... you have the possibility to write a report to an external location. In case the external location is an existing file the DoCmd is not...

Microsoft Access / VBA

3291

Export table to dbf file and right codepage with DoCmd.TransferText

by: Cuaracao | last post by:

This is my code: Code1: 'DoCmd.OpenTable "tblImport" 'DoCmd.TransferDatabase acExport, "dBASE IV", strOutputDir,acTable,"sel_TblImport", strDbfName & ".dbf", False ' DoCmd.Close acTable,...

Microsoft Access / VBA

49582

DROP TABLE vs DoCmd.DeleteObject acTable

by: Dean | last post by:

My client has a db I am working that uses temp tables. During an update procedure, I had the code If fTableExists(tempTblName) = True Then DoCmd.DeleteObject acTable, tempTblName Then I thought...

Microsoft Access / VBA

6634

DoCmd.OpenReport "Invoice", acPreview

by: gazza10001 | last post by:

Hi i hope you can help my company uses access and has modified for its needs usually what happens is you serach for the invoice by its number and then it brings all the information up such as...

Microsoft Access / VBA

7205

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

7348

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing

7467

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

General

5592

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

Career Advice

5021

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

Microsoft Access / VBA

3175

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The...

Networking - Hardware / Configuration

3166

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

744

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

397

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...

General