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

Macro is failed to find specific record on the second try - Access 2013

In my form (frmEmployees) I have combo-box(cboFindRecord) populated with the names of the workers.
The query behind this cbo has 3 columns : IDnomber , FirstName , SecondName . ( 0;2.5;2.5)
The after-update event of this cbo triggers an embedded macro(which has been created automatically by the Wizard, when I had created this combo-box ) with these actions:
[SearcForRecord]
Object Type : [ Form]
Object Name : [ frmEmployees]
Record : [Next]
Where : [="[IDNomber] = " & "'" & [Screen].[ActiveControl] & "'" ]
The first time I choose a worker from the cbo (e.g. Jacob) it work all right
Now when I am trying again to choose another name (e.g. Aric) ,
The macro is failed to move to Aric's record and the current record (Jacob) steel appears.
How can I go around this problem?
Thanks in advance
Aug 27 '16 #1
1 701
I've solved the problem
1. I've added [GoToRecord ] macro action(with [FIRST] as an argument of [Record],
before the only exist macro action which was [SearcForRecord]
2. In the next macro action – [SearcForRecord] -
I've changed the Where clause to : ="[IDNomber] =' " & [forms]! [frmEmployees]![ cboFindRecord] &" ' "
3. Now any up-date of the search control (cboFindRecord) starts the search from the first record
4. Working well
Thank you .
Aug 27 '16 #2

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

Similar topics

3
by: Chris | last post by:
Hello all. I have a database that I use to send email updates to people. Everything is working fine, but one suggestion I keep getting is to add a link to the automatic emails that will open up the...
4
by: jwa6 | last post by:
I have a user/pc specific problem in access. This doesn't occur on any other ( windows xp pc) that I have used the ..mbd on. This involves a query that's using a range of dates as a parm. This...
10
by: Shawn | last post by:
JIT Debugging failed with the following error: Access is denied. JIT Debugging was initiated by the following account 'PLISKEN\ASPNET' I get this messag in a dialog window when I try to open an...
4
by: BerkshireGuy | last post by:
Is there a way to create a shortcut to open a MS Acccess DB and have it go to a specific record? In my DB, when a user delegates a record to another users, I currently send out an email to the...
1
by: zamir | last post by:
hi, i have a login screen where depending on the username and password it will open a main switchboard, and on that switchboard they would be a comand button that will show a specific student...
1
by: Kevin Welch | last post by:
Looking for some expert help here. Caveat: I do not know SQL, and I've built a database basically by trial and error (unfortunately, I don't have much time to learn Access as I would want). ...
1
by: Martin Bentler | last post by:
Right now, I have a form, locked records, on which I have a CommandButton that opens a second form (much like the first) but open for editing, plus allowing the user to manipulate other areas of the...
1
by: aaron knezevic | last post by:
I'm attempting to open an access file, form and go to a specific record from an autocad drawing. using excell and creating a macro I've gotten as far as to get the form open but can't get to the...
6
by: GKJR | last post by:
I have been using Access 2013 (in Office 365) with Windows 8.1 for about a month and a half now. I was a little reluctant to switch from 2010 on Windows 7, but I figured I should try stay ahead of...
7
by: jalbright1957 | last post by:
We have Office365 / Sharepoint online / Exchange online in our organization. I am the only one with the E3 subscription which gives me Access. I have a database that needs to be made available to...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
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: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
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: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
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.