I will accept that it is probably not worth the effort.
Thanks for the replies
regards
helpmeplease213
Last Activity: Aug 27 '08, 03:14 AM
Joined: Oct 3 '07
Location:
-
Search
Is there a way that I can search whole words in a line rather than just search every letter.
ie when I am searching I will type AC (air conditioning) in a text box to search for only AC words but my code returns every two letters together that are ac therefore I will get "accept", "active" etc. but I only want AC as a whole word.
But I also want it anywhere in the line so if I have the line ... -
Hello,
I don't quite understand how to go about achieving this. I can get the form I want to popup on the double click event but I don't know how then to assign the data from that row of the form into the popup form. Any help is appreciated.
thanksLeave a comment:
-
So you can do it from a form. Can you point me in the right direction or give me a overview of how to do it?
ThanksLeave a comment:
-
Displaying data
Hello,
Is it possible to have a subfrom in a main table that displays all data that has been entered into the table, when you double click on a particular row a form pops up and displays the data in a pre-determined structure.
So I guess my main question is whether it was possible to have a form pop up when you click on a row in either a table or a query.
Thanks -
Thanks Jim much appreciatedLeave a comment:
-
Hello,
I have a new problem based on the same table and query. For some reason the query returns numbers that are single digits (2, 3, 4) yet I only want numbers >40?
This is the SQL code that is used
SELECT Table1.[Unit No], Table1.[Date Tested], Table1.Pt1, Table1.Pt2, Table1.Pt3
FROM Table1
WHERE (((Table1.[Date Tested])=(SELECT Max([Date Tested]) FROM Table1 MyMaxTable WHERE [Unit...Leave a comment:
-
My Mistake, it works as you said
regardsLeave a comment:
-
Thanks Jim,
I have a couple of questions though
Why does the query when sorting the date out only read the first number.
i.e. if 01/10/2007 and 02/09/2007 it will display 02/09/2007even though it is of a earlier date.
Any ideas?
Also is there any way of only displaying the data with latest date and not displaying any other date of the same unit.
i.e. unit 250 is in the database on...Leave a comment:
-
Only displaying latest date
Hello,
I have a table that has five categories: Unit No, Date, P1, P2, P3.
I have a query that only extracts data from the table that is over 40 for P1, P2 or P3 but I only want the data with the latest date for that particular Unit No to come up. Any Ideas? -
Thanks for the adviceLeave a comment:
-
open form on startup
Hello,
I have a form that I open on start-up but it always opens in a reduce window rather than in a maximum window. Even when I maximise the window and then save and close the application then re-open it opens in the reduced window.
Any help
Regards -
Sorry for my misuse of forum etiquette
the anwer to my problem was to use the "or" option that is below the criteria option.Leave a comment:
-
Disregard question worked out the solutionLeave a comment:
-
Multiple criteria restriction
Hello,
I have query that picks out all data that is above 40 and use >"40" in the criteria section of the query. Now I have three different columns that have this data and a unit column. Now the query will select the row if all three columns are above 40 but if only two or one are above 40 they won't be selected. And I wan't the data to be selected if one two or all three columns are selected. How can this be achieved... -
Displaying data that has been sorted in a list box
Hello,
I have a form which has a option group, when a option in the group is selected it brings up a text box, you then enter a parameter into that text box and the data should be sorted out according to the parameter.
eg select sort by date in option group, date text box appears you then enter the date you want data to be sorted to, that data on that date is displayed in a list box.
I am currently... -
Sorting data in a List Box
Hello,
I have a list box that I want to display data that is sorted by Date and by unit.
This is the current code that I have used but nothing seems to happen when the date text box has the date that I want sorted.
Any help would be appreciated
Thanks
[CODE=vb]Private Sub Optiongroup_Aft erUpdate()
Select Case Me.Optiongroup
Case 2 'Order by Date... -
filtering
Hello
I have a Form which has a subform and its source object is a Query.
Now I also have a option group with three options
1- All
2- Sort by date
3- Sort by unit
"All" displays all data
Now when "sort by date" is selected is it possible to then have a textbox which you type in a date and the table is then sorted from the date typed to the... -
How to open queries in subforms?
Hello,
I have four different queries based on the same table. I would like to open them in a subform using four different button clicks (each query has its own button). How can this be accomplished?
I tried but it doesn't work could I please get an overview of how it can be done?
Private Sub Cmd9_Click()
data_window.Vis ible = True
data_window.Sou rceObject = "RECENT RECORD"
... -
How to open queries in subforms?
Hello,
I have four different queries based on the same table. I would like to open them in a subform using four different button clicks (each query has its own button). How can this be accomplished?
I tried but it doesn't work could I please get an overview of how it can be done?
[CODE=vb]Private Sub Cmd9_Click()
data_window.Vis ible = True
data_window.Sou rceObject = "RECENT RECORD"...
No activity results to display
Leave a comment: