472,363 Members | 2,067 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,363 software developers and data experts.

Help with VB-Macro

I will be the first to admidt.. I'm a Access-VB Id10t.
Now that we have that covered, this is what I'm trying to do...

In a form I have 2 fields INPUT & LOCVAR, these fields are not attached to any table.

I need a select and update macro that will do the following
After Update of INPUT execute
FIND 'FORM-INPUT' from TapeInfoTable\BarcodeColumm
IF 'FORM-INPUT' is equal to BarcodeColumm
then UPDATE LOCATIONColumn to equal FORM-LOCVAR
also UPDATE TIMEColumn to Now()
After complete, return to form and clear INPUT field for new entry

Any and all help will be appreciated... hopefully that makes sence enough to someone on this llist

Mike
Jan 24 '12 #1
1 1136
NeoPa
32,511 Expert Mod 16PB
What I think you need is a form that maintains the [TapeInfoTable] with an unbound control (TextBox or ComboBox) that enables you to filter the record to update. At that point you can update the [Location] field via its (bound) control on the form. An AfterUpdate of that control could trigger code to set the current time value in the control for [Time]. Use the wizards to help you design the original form and Example Filtering on a Form to help on the filtering side.

Does that all make sense?
Jan 24 '12 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

0
by: Dim S | last post by:
Hi I'm trying to add an OPTION element to a SELECT element inside from VB Dim oSel As HTMLSelectElement Dim oOpt As HTMLOptionElement Set oSel = mDoc.All("oSelect") Set oOpt =...
3
by: Jay | last post by:
I previously posted this question under Visual Basic newsgroup, but was advised to re-post here. I'm hoping someone can help me solve an issue I'm having with VB.Net and Access 2000. Here's...
2
by: serge calderara | last post by:
Dear all, I have build a setup project for my VB.NET application, I need to know the installation path of an application in order to add file in it. How can do that inside my setup project ?...
0
by: Tim | last post by:
Hi, Yesterday I installed VB.NET on my machine. I had been runnng SQL Server 2000. After the install SQL Server will not run. SQLAgent fails with the error "1068: The dependency service or...
0
by: BrianDH | last post by:
Hi I have a web form with a Datagrid. Within the data grid I have a button. If the button is of type "Linkbutton" my VB code-behind will catch the users "click" However, if it is set to...
5
by: Andrew | last post by:
Hey all, Requesting help from the VB.Net gurus in here. I was given a task to write a Windows Service (VB.Net) that would run an external program, and if that program closed for any reason...
0
by: BrianDH | last post by:
Hi I have a VB.Net windows application that’s running on 30 PCs. All in the same network. All PCs run XP Pro. All PCs have Framework 1.1 2 of the PC throw an error when they try to send mail...
0
by: Billie Boy | last post by:
Hi to all. I’m new here and am coming to you from Melbourne Australia. So a big HELLO 2 ALL. Now I am encountering an annoying problem in the SQL builder of the copy of VB.6 that I am using at...
0
by: douglas | last post by:
Can I create my own DLL by vb.net and register as a COM+ service? Can it be referenced by ASP.NET. I want to create a SINGLE COM+ library for many different Web-apps.... Besides COM+, is...
0
by: sheenitmathew | last post by:
Hai all, I developed an application software using VB 6.0 at front end and MS Access 2000 at the back end. The application runs very slow as the size of the database increses. I used ODBC...
2
by: Kemmylinns12 | last post by:
Blockchain technology has emerged as a transformative force in the business world, offering unprecedented opportunities for innovation and efficiency. While initially associated with cryptocurrencies...
0
by: antdb | last post by:
Ⅰ. Advantage of AntDB: hyper-convergence + streaming processing engine In the overall architecture, a new "hyper-convergence" concept was proposed, which integrated multiple engines and...
0
by: AndyPSV | last post by:
HOW CAN I CREATE AN AI with an .executable file that would suck all files in the folder and on my computerHOW CAN I CREATE AN AI with an .executable file that would suck all files in the folder and...
0
by: Arjunsri | last post by:
I have a Redshift database that I need to use as an import data source. I have configured the DSN connection using the server, port, database, and credentials and received a successful connection...
0
hi
by: WisdomUfot | last post by:
It's an interesting question you've got about how Gmail hides the HTTP referrer when a link in an email is clicked. While I don't have the specific technical details, Gmail likely implements measures...
0
by: Rahul1995seven | last post by:
Introduction: In the realm of programming languages, Python has emerged as a powerhouse. With its simplicity, versatility, and robustness, Python has gained popularity among beginners and experts...
1
by: Ricardo de Mila | last post by:
Dear people, good afternoon... I have a form in msAccess with lots of controls and a specific routine must be triggered if the mouse_down event happens in any control. Than I need to discover what...
0
by: Johno34 | last post by:
I have this click event on my form. It speaks to a Datasheet Subform Private Sub Command260_Click() Dim r As DAO.Recordset Set r = Form_frmABCD.Form.RecordsetClone r.MoveFirst Do If...
1
by: ezappsrUS | last post by:
Hi, I wonder if someone knows where I am going wrong below. I have a continuous form and two labels where only one would be visible depending on the checkbox being checked or not. Below is the...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.