Calling a text box in Code Editor - Microsoft Access / VBA

N. Graves

Thank you for take the time to read my problem!

I'm trying to delete a record in a table with VB code. I have done
this many times and this is not my issue. I need to call a text field
on my Form. I can't seem to figure out the correct syntax for make
the call.

Here are the objects that are involved with my de lima.

FORM = frm_AddEdit_Equipement_Master:
listbox = lst_EquipID
subform = frm_Equip_Tabs
Tabcontrol = TabCtl0
TAB = IP Info
Button = Delete IP record
subform = sfrm_IPAddresses
text field = txt_IPID (IPAddress.IPID)

I need to complete this statement.

SQLDelete = "Delete from IPAddress_tbl where IPID = " & syntax here

Also could you refer me to where I read and learn more about how to
derive this information myself?

Nov 13 '05 #1

Subscribe Reply

1489

MGFoster

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

SQLDelete = "Delete from IPAddress_tbl where IPID = " & Me!TextBoxName

Read the Help articles on queries and query parameters; also, the VBA
help articles on "Form Property."

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQMYGHoechKqOuFEgEQJqvwCg4sZZKWOj3tV2+ebAAZSnak QprtAAoLHz
qYzaqi1pZx9OwNFdUi4jxM1D
=0VZP
-----END PGP SIGNATURE-----
N. Graves wrote:

Thank you for take the time to read my problem!

I'm trying to delete a record in a table with VB code. I have done
this many times and this is not my issue. I need to call a text field
on my Form. I can't seem to figure out the correct syntax for make
the call.

Here are the objects that are involved with my de lima.

FORM = frm_AddEdit_Equipement_Master:
listbox = lst_EquipID
subform = frm_Equip_Tabs
Tabcontrol = TabCtl0
TAB = IP Info
Button = Delete IP record
subform = sfrm_IPAddresses
text field = txt_IPID (IPAddress.IPID)

I need to complete this statement.

SQLDelete = "Delete from IPAddress_tbl where IPID = " & syntax here

Also could you refer me to where I read and learn more about how to
derive this information myself?

Nov 13 '05 #2

Similar topics

3460

Collaborative Text Editor

by: Ed Suominen | last post by:

I'm thinking of implementing a real-time collaborative text editor in Python using Twisted. An initial plan is to use a Twisted PB server daemon that accepts user:password:file connections from...

Python

4880

[Q] Text vs Binary Files

by: Eric | last post by:

Assume that disk space is not an issue (the files will be small < 5k in general for the purpose of storing preferences) Assume that transportation to another OS may never occur. Are there...

.NET Framework

3725

Rich Text Form in JavaScript gives error: Object required

by: IkBenHet | last post by:

Hello, I found this script to create a simple rich text form (http://programmabilities.com/xml/index.php?id=17): <html> <head> <title>Rich Text Editor</title> </head> <body>

Javascript

9738

Get the name of the calling function of an executing function

by: Tony Liu | last post by:

Hi, I want to get the name of the calling function of an executing function, I use the StackTrace class to do this and it seems working. However, does anyone think that there any side effect...

C# / C Sharp

6002

calling a dot net web services from unix

by: Stu | last post by:

Hi, I have a web service which returns a record set and works well integrated with an asp dot net page. However if I decided to develop a unix app will i be able to read the dataset as it is...

.NET Framework

3093

Rich Text Editor - problem with generated HTML

by: pbreah | last post by:

I'm doing a Rich Text Editor (WYSIWYG) in javascript for a game for kids. I'm doing a special case in with every keystroke from A-Z creates a background and foreground color for that letter, witch...

Javascript

2413

Calling a hidden form

by: ahmad.humyn | last post by:

I want to call a hidden form. My code goes something like in which the main calls form1. form1 has a button which creates & calls form2 and hides itself. Now I have a button in form2 which if...

C# / C Sharp

5325

adding rich text editor made me lose focus

by: karen987 | last post by:

I have a web page which used to work fine until i added a rich text editor. the pages are in ASP and it is a news weblog, with a comments section where people click the headline of a comment and...

Javascript

3223

problem while calling two pages which includes Js pages

by: mukeshrasm | last post by:

Hi I am calling two pages using Ajax Get_Pages.php and Get_Content.php from combo box. Both pages are displayed based on selection from combo box. Main problem is that it is not showing the...

Javascript

14545

To construct a text editor by Python

by: danesh1354 | last post by:

Hi All, First I need to construct a text editor by python programming and add this code to a biger code that has been written before, and i would like that by my code for this editor have a...

Python

7108

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

7142

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

7181

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

6847

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

Windows Server

4875

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

4565

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...

C# / C Sharp

3071

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

618

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

272

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