473,836 Members | 1,472 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

use data from form on query?(noob)

I have used the usual method of calculating age from DOB and placed it
on a form, I now need to use this in a query, or place the data in a
table so I can then query it.

I am a noob so be gentle please.
TIA

Nov 12 '05 #1
2 1884
You don`t give much info on your setup but if you have the age in a text box
on a form then the query will grab it from there using something like this in
your
query criteria -- [Forms]![yourformname]![yourtextboxname]

The form always need to be open when you run the query.
HTH
David B
bungle bonce <bu*********@ho tmaiLL.com> wrote in message
news:40******** *************** @news-text.dial.pipex .com...
I have used the usual method of calculating age from DOB and placed it
on a form, I now need to use this in a query, or place the data in a
table so I can then query it.

I am a noob so be gentle please.
TIA


Nov 12 '05 #2
Thanks David.

Will have a try tonight.

"David B" <Da***@marleyco tenospam.fsnet. co.uk> wrote in message
news:c5******** **@newsg3.svr.p ol.co.uk...
You don`t give much info on your setup but if you have the age in a text box on a form then the query will grab it from there using something like this in your
query criteria -- [Forms]![yourformname]![yourtextboxname]

The form always need to be open when you run the query.
HTH
David B
bungle bonce <bu*********@ho tmaiLL.com> wrote in message
news:40******** *************** @news-text.dial.pipex .com...
I have used the usual method of calculating age from DOB and placed it
on a form, I now need to use this in a query, or place the data in a
table so I can then query it.

I am a noob so be gentle please.
TIA

Nov 12 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

13
2898
by: dogu | last post by:
Noob alert. Code is below. File is saved as a .php. What I'm trying to do: User uses 'select' box drop down list to pick a value. Value ($site) is derived from a db query. This works fine. Value selected is used as the 'where' clause of the 2nd query. If $site is a single word, the 2nd query works like a charm. If $site is more than one word (has spaces), the query returns a null
5
1768
by: larry | last post by:
Ok I am working on building my skills to convert my apps to LAMP (read I'm a semi noob), and there was one part I was thinking of. If I create two identical MySQL tables (we'll say, invoice and invoicearc) one will hold current period data and the other will hod out of period data - previous years stuff, which is only used in queries <5% of the time at most. Now can I join these two tables to make one table when doing queries that span...
7
3419
by: Jack | last post by:
Hi, I am trying to test a sql statement in Access which gives me the error as stated in the heading. The sql statement is built as a part of asp login verification, where the userid and password are input in login screen. The password in the database is a number field. I am writing the dynamic sql statement as follows below. I believe I am going wrong in the password section of the code. I appreciate any help. Thanks. Regards.
4
2130
by: bob hicky | last post by:
I have two tables (RadiationOncologists and EvaluationEntry) and forms for each of the two. My problem is that I have a text box in the RadiationOncologists form that is called Number. This field needs to dynamically count each instance of a certain doctors name from the EvaluationEntry table which is RADLNAME and return the total for each doctor listed as there record in the RadiationOncologist Form appears. I can do a count of all...
3
479
by: bungle bonce | last post by:
I have used the usual method of calculating age from DOB and placed it on a form, I now need to use this in a query, or place the data in a table so I can then query it. I am a noob so be gentle please. TIA
8
6859
by: siol | last post by:
Hy! I have htmleditor (from the microsoft's samples page) embeded into my asp.net page. Editor generates some html code inside <div id="oDiv"></div> tags. And what I would like to do is return oDiv.InnerHtml to my "codebehind" (C#) where I would do additional tasks on it. If I do postback the oDiv content is lost. Can anyone help me how to send those data back to codebehind?
5
10483
by: freelancex | last post by:
Hi, Im new to this forum, and new to scripting in general. Im an ICT Technician for a high school and i am designing a Form in visual basic 2005. The intended purpose of the Form, is to prevent student users logging on to their area, without accepting the Acceptable Use Policy which comes up on screen. The form, runs maximized, in full screen mode and is constantly in focus, above all other programs. So Basically, until the form is...
10
2737
by: Himmel | last post by:
Hello, I have a database form that has a tabs control, and on each tab is another form. Each form pulls data from a different query. For example, tab 1 may list personal information (form1), tab 2 shows billing information (form2). I have a rather simple problem, but I can't seem to figure out how to pull data from the form on tab 2 and display it on tab 1. So if the form2 on tab 2 has a field called "balanceDue", I'd like to assign a...
2
1971
by: lindabaldwin | last post by:
Hello everyone, I am fairly new to VBA. I have a worksheet in Excel, named "Data Sheet" from which I am trying to query data. This worksheet contains the following data: unit (column A), date (column B), time range (column C), day of the week (column D), event (column E), and occurrences (column F). I want to be able to identify records that meet user set criteria. I then want to add the number in column F to another number in a different...
2
1388
by: keirnus | last post by:
Hello, I actually don't know where to post for SQL Queries used in MS Access. If this is not the correct thread, please redirect this to the correct one. Anyway, I am kinda newbie to the query I want here. Let's say TABLE1 has the following data: <ColumnLetter> A
0
9825
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, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
9673
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 effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
10859
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, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
1
10602
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
6984
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5829
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
4463
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
4023
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
3116
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

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.