Hello,
Is it possible to have a form label which can input new information as well as find exisiting information.
e.g
user id - if not found add to database?
cheers
9 1458
Hello,
Is it possible to have a form label which can input new information as well as find exisiting information.
e.g
user id - if not found add to database?
cheers
j0rdanf1,
Yes it is.
How are you searching for the user id? Are you using a combo box?
If so you could use the "On Not In List" event to update your listbox.
This will update the underlying table being used as the recordsource.
There's an example in the Access Help files for the NotInList Event.
Or you could send more detail?
Regards,
VALIS
NeoPa 32,556
Expert Mod 16PB
It's good to see more new members coming up with very clear answers to questions.
Ups to you for that Valis.
This is going to be hard to explain but i will give it a bash,
I have a label where you input a new user id, this then gets saved to a table called user (user id being the primary key)
the table looks like this
user id:
first name:
last name:
start date:
transfer:
leave date:
however if i input this information directly into the table and then go into the form and type the user id in, it does not find the user, it then comes up with an error that i cant have a duplicate record. hence why i wish to know if it can do a look up before creating a new record
This is going to be hard to explain but i will give it a bash,
I have a label where you input a new user id, this then gets saved to a table called user (user id being the primary key)
the table looks like this
user id:
first name:
last name:
start date:
transfer:
leave date:
however if i input this information directly into the table and then go into the form and type the user id in, it does not find the user, it then comes up with an error that i cant have a duplicate record. hence why i wish to know if it can do a look up before creating a new record
Do you save the table and refresh the query before searching for this new record? If the form or underlying query behind the control isn't refreshed access won't register the new entry.
Do you save the table and refresh the query before searching for this new record? If the form or underlying query behind the control isn't refreshed access won't register the new entry.
Yes i do, thats what im confused about, it shows up in the table but will not in the form.
Yes i do, thats what im confused about, it shows up in the table but will not in the form.
Is there any coding associated with your form? ( I assume there is since you mention you're using a LABEL to input ) If your code deals with searching for the typed entry in the table it might need a requery statement.
Requery? would this be done on a after-update?
Requery? would this be done on a after-update?
Just a quick update,
Had a look on the internet for a possible solution but it returns an invalid syntax
=DLookup("[First Name]", "[USER]", "[User ID]=" & txtUser ID)
Just a quick update,
Had a look on the internet for a possible solution but it returns an invalid syntax
=DLookup("[First Name]", "[USER]", "[User ID]=" & txtUser ID)
"txtUser ID"
You can't use a name that has a space in it without enclosing in square brackets.
Try this:
=DLookup("[First Name]", "[USER]", "[User ID]=" & [txtUser ID])
Sign in to post your reply or Sign up for a free account.
Similar topics
by: Randell D. |
last post by:
HELP!
I am determined to stick with this... I'm getting there... for those who
haven't read my earlier posts, I'm createing what should be a simple
function that I can call to check that...
|
by: Tonya |
last post by:
Hi,
Does anyone have any example of how i can manage forms in
my application??
I want to be able to reference my form instances that are
currently open from other forms.
why cant i open...
|
by: Gregory A Greenman |
last post by:
I'm trying to write a program in vb.net to automate filling out a
series of forms on a website. There are three forms I need to
fill out in sequence. The first one is urlencoded. My program is...
|
by: Pat Patterson |
last post by:
I'm having serious issues with a page I'm developing. I just need some
simple help, and was hoping someone might be able to help me out in
here.
I have a form, that consists of 3 pages of...
|
by: Lyn |
last post by:
Hi,
I am working on a genealogy form. The only table (so far) lists everybody
in the family, one record per person. Each record has an autonum ID.
The parent form (frmMainForm) displays the...
|
by: Dave Guenthner |
last post by:
I have a csharp form1.cs created with VS. I have added a menu bar
with one option called help. I then created another form in VS called
help.cs. How can I launch the help form from the main form...
|
by: Kathy Burke |
last post by:
HI. in asp.net app, I have an xmlDocument that I transform to the client
html. Using xsl I create a few textboxes to capture user input. Each of
these are related to <data> elements in the xmlDoc....
|
by: Lee Newson |
last post by:
Hi,
I have just written my first application using VB.NET. The app works fine
when i am running it within .NET for debugging purposes, however when i try
to run the app from the .exe file that...
|
by: mohit.akl |
last post by:
Hey guys & gals
I am havng trouble modifying the control box. I want to make the
maximise button invisible and have minimisise button instead of it.
Like this _ X (not like _ o X )
How...
|
by: MikeB |
last post by:
Hi, I'd appreciate some help, please. I'm writing a VS2005 VB project
for school and one of the requirements is that every screen should have
a "Help" button.
I could do it by writing a clumsy...
|
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$) {
}
...
|
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...
|
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
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
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...
|
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: 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,...
|
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...
|
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,...
| |