473,385 Members | 1,647 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,385 software developers and data experts.

compile error on goto record from onscreen numberic keypad

I'm using numeric on screen keys to goto specifig record.
when i type the number for example 1234 and hit on screen enter button it has to goto that record. what is the code to be used inthe "enter" button.

here is the code i'm using for the numbers:
Me.Combo117 = Me.Combo117 & "2"

here is the code i'm using for the goto record:
Me.Combo117.SetFocus
DoCmd.GoToRecord = Me.Combo117

At this point i get compile error message and i can not figure it out.

Thanks
Dec 12 '10 #1
1 1492
smartchap
236 100+
I think if u post ur project here, we could solve ur problem as from the post query is not very clear.
Dec 18 '10 #2

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

Similar topics

20
by: DraguVaso | last post by:
Hi, As a former VB-programmer I'm used to the "on error goto"-errorhandling. I see that in actually all the VB.NET-samples I can fin people use the "Try - catch"-errorhandling. Which of the...
5
by: jschilt | last post by:
I'm in a spot of bother... just spent 6 hours trying to figure this one out - getting very frustrated... I have seen many posts on this site and some others... all touching on this subject but not...
4
by: nekker64 | last post by:
Hi, I have this complete Audit database at work that I inherited from someone who left late last year, it has been working fine up until this week. There are report form section that I can select...
6
by: JHNielson | last post by:
This is a very simple question.... I have a form that looks up Records for an unbound drop-down list. It has worked just fine up until last night. Now the button on the form to delete a record...
3
by: alnug | last post by:
Hello, I'm trying to use the following code to read data from Excel files and put the data into an MS Access Table. Some of the Excel files have the tabs in the sequence Chart1, Sheet1, Sheet2 etc...
1
by: izzy79 | last post by:
Hi, I'm trying to error trap an append query, if the record already exists in the table. I'm not sure why the error message ("Rule already exisits") pops up regardless if that record is in the...
9
by: Amit Lamba | last post by:
I am trying to run a module from a button on a form where I populate a subform from Query1 with a product formula. The module is supposed to check whether the product formula can be implemented...
6
by: travjbad1 | last post by:
I am new to the forum and new to Access, so please be simple and descriptive if possible. I am having a problem with a button on a form that saves, opens a report in pdf, and emails the report to the...
4
by: Shona Rennie | last post by:
Hi Self taught user of access and I have the following problem in Access 2003. I have a form with 2 continous subforms. All the data has been added and all information is correctly linking. I...
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 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 former...
0
by: ryjfgjl | last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
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: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
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...

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.