473,406 Members | 2,352 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

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

command button on form to search for serial number

107 100+
Hello,
I have a cmd button on form to search for serial number. I notice when I search for record-that if I don't start at the beginning of records I might not find the record. example: if I am searching for 20th record then I search for 10th record I will have to go to to beginning to search for 10th record.
Any way to not have to go to the start each time?
I have tried using code with find first in it- but it seems like find first is not being recognized in the code.
my field is called serial number.
thank you
I am using xp with microsoft access 2003
Apr 8 '08 #1
2 2256
ADezii
8,834 Expert 8TB
Hello,
I have a cmd button on form to search for serial number. I notice when I search for record-that if I don't start at the beginning of records I might not find the record. example: if I am searching for 20th record then I search for 10th record I will have to go to to beginning to search for 10th record.
Any way to not have to go to the start each time?
I have tried using code with find first in it- but it seems like find first is not being recognized in the code.
my field is called serial number.
thank you
I am using xp with microsoft access 2003
Take a look at this prior Tip of the Week:
How to Find a Record Programmatically
Apr 8 '08 #2
buddyr
107 100+
thank you - this looks like it help me
Apr 9 '08 #3

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

Similar topics

5
by: B.r.K.o.N.j.A. | last post by:
I've made a script for managing shoppingcart (something like cart.php?action=add&item=12345) and it works fine, the problem is: when user hits the back button page after he added something in the...
2
by: Chris Bolus | last post by:
I'm a teacher using MS Access on an RMConnect 2.4 network. On some workstations both I and my students sometimes get an error message when attempting to insert a command button on a form which...
8
by: jquest | last post by:
Hi Again; I have had help from this group before and want to thank everyone, especially PCDatasheet. My database includes a field called HomePhone, it uses the (xxx)xxx-xxx format to include...
1
by: thewhoracle | last post by:
Once i've navigated to a site, is there any way using VB/C# code to force a certain value into a textfield on that site and then fire a buttonpress on a specific button? I want to search and query...
4
by: John Boy | last post by:
Hi, Can anyone help. This is really doing my nut in. 3 years ASP exp. and now doing .DOT which is a step in the wrong direction. Basically I am left with the code of a guy who has left. When I...
1
by: Ed Sutton | last post by:
<Newbie> How can I get arguments, and build a query URL, before a button is pressed? I have a text box to enter a serial number. When the search button is pressed, I wish append the serial...
14
by: David | last post by:
Hi, I have some database records which are listed out in a table on an asp page. The table is within a <formtag. At the end of each record (and table row), I have created a <select> dropdown...
4
by: QntmPg | last post by:
Hi all I am trying to design a database that holds contact/demographic information on a person and what studies they have participated in. I have a few ideas, but wanted to get feedback on...
13
by: Chris Carlen | last post by:
Hi: Having completed enough serial driver code for a TMS320F2812 microcontroller to talk to a terminal, I am now trying different approaches to command interpretation. I have a very simple...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
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,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
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,...
0
jinu1996
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...
0
agi2029
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,...
0
isladogs
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...

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.