473,804 Members | 3,396 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 1881
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
2896
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
1767
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
3418
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
2128
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
10481
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
1968
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
1387
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
10577
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
10320
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
10077
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
1
7620
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 presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
6853
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
5521
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
5651
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
4299
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
3
2991
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.