I am designing a form and the form is from table and the user will input three values (as table is of cars so user will enter Price, Model & registration) i want to filter the table with the input values and want to show the matching records.
any one guide me on that?
6 1151
I am designing a form and the form is from table and the user will input three values (as table is of cars so user will enter Price, Model & registration) i want to filter the table with the input values and want to show the matching records.
any one guide me on that?
- Dim strCriteria As String
-
-
strCriteria = "[Price]= " & Me![txtPrice] & " AND [Model] = '" & Me![txtModel] & "' AND [Registration] = '" & Me![txtRegistration] & "'"
-
DoCmd.OpenForm "<your form>", acNormal, , strCriteria, acFormEdit, acWindowNormal
NeoPa 32,556
Expert Mod 16PB
I like your example here NeoPa, but I can not open the .mdb file. I am using Access 97, is there away around this?
NeoPa 32,556
Expert Mod 16PB
Only if I redo it all in Access 97 I'm afraid. That may not be easy as I only use that version at work now. I may fit it in if I can, but don't hold your breath due to the difficulties of that sort of thing at work.
Alternatively, just try to follow the instructions and build it again yourself. I will help if you have specific questions or difficulties.
Only if I redo it all in Access 97 I'm afraid. That may not be easy as I only use that version at work now. I may fit it in if I can, but don't hold your breath due to the difficulties of that sort of thing at work.
Alternatively, just try to follow the instructions and build it again yourself. I will help if you have specific questions or difficulties.
Ok sure. I do not want you to take your time to redo it in 97. I will just fumble around with it. I will ask questions if they come up though. Thanks
NeoPa 32,556
Expert Mod 16PB
That's fine.
Probably best if you do it as a separate thread (unless you think it would help anyone else reviewing the thread generally). If you do, you can PM me a link to it. Normally I wouldn't respond to PMed questions, but in a case like this where I have obvious pre-involvement, it would be appropriate.
Sign in to post your reply or Sign up for a free account.
Similar topics
by: TJO |
last post by:
Below is some sample code that fades div tags that is not working in IE
6.0.29 on xp sp2. Can anyone help see why the if(ie5)
document.getElementById(divID).filters.alpha.opacity lines are not...
|
by: omer.mush |
last post by:
Hi,
I am using ASP.Net 2.0 along with C# and Atlas. I have some image
panels alongwith asp:panel controls. I am using image panels as tabs,
when user clicks a specific portion of the image, I...
|
by: kucol |
last post by:
Hi guys,
I wanted to ask you for help as I am struggling with it second evening
already...
I have got tables DEVICES and PARTS.
One device can consist of multiple parts.
But...
I have...
|
by: kucol |
last post by:
Hi guys,
I wanted to ask you for help as I am struggling with it second evening
already...
I have got tables DEVICES and PARTS.
One device can consist of multiple parts.
But...
I have...
|
by: Subha |
last post by:
Hi All,
I'm facing a problem with malloc. I have a program which opens a file
to write something using ofstream.
I used to run more than a process same time and in that case one of the
process...
|
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,...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
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: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
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:
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,...
| |