Gents..
I am just looking for ideas as to how to approach the query of DB I am working on.
Basically, it's a database of welding procedures and depending on the metal you choose, appropriate procedure(s) will show up as a link.
I am using parametric query and the search itself is working just fine. I just didn't think about one of the obvious problems.
Overview:
I have a...
tkip
Last Activity: Aug 24 '09, 08:35 PM
Joined: Aug 20 '08
Location:
-
Try using the keyword "like" in your query.
"WHERE table1.recordID Like "*" Forms![InputForm]!cmbRecordID "*" "
May be that's what you are looking for. -
AfterUpdate event won't run until the control's field has been updated. So I didn't place it under AfterUpdate event. But I did change the first line of my code to what you have suggested (cboBMclass1.li stindex < 0 etc...) and placed it on "MouseDown" event to check if cboBMclass1 and cboBMclass2 fields are empty.
I then change the rowsource of combo box on "Form_Curre nt" event. Basically, I just split the code...Leave a comment:
-
onClick event
Hi Guys!
It's been a while I haven't asked questions here mostly because things are working fairly well and I have been able to fix things up on my own.
But this seemingly simply task confused the hell out of me and I know there is a solution for that.
What I have is a form with 4 combo boxes and I just want to change the rowsource property of the coombo boxes based on what I have selected on other 2 comboxes....Last edited by Frinavale; Aug 20 '09, 02:52 AM. Reason: Please post code in[code] ... [/code] tags. Added code tags. -
It is somewhat true that your post pointed me to the place where I should spend more time.
Anyway, thanks for even posting a reply....Leave a comment:
-
Something just came to my mind and there is a flaw in the conditional statement.
Although I want to check if it is the new year, if that is the only condition that the VB codes checks, user will have problem creating new drawing number later on. Say, for example, someone wanted to create a new drawing number but there was no drawing done on the new year's day (usually it is the holiday anyway), then the VB will just simply add one...Leave a comment:
-
Refer to the thread below. Someone at this post is looking for the solution you have and you are looking for the explanation of the solution.
I posted the codes that does what you describes. I think it should help.
http://bytes.com/forum/thread825372.html...Leave a comment:
-
You seems to have the similar problem that I had before I found a solution. All the suggestions you've received so far is very good.
This is my suggestion:
(1) Create a query based on your table ('Printing Table or whatever you call it")
(2) Create a form based on your query
(3) Edit the query
- Select the query you created and click on "View" from toolbar and select "SQL...Leave a comment:
-
Sorry about the late reply. I solved the problem by doing some stuff you suggested and a few others.
Now, I can search for any record in the table with any number of parameters set by the user.
But adding new records is now a problem. Searching the database is something we want to do occasionally. We do, however, add records on daily basis. That "Adding New Record" which I thought will be simpler turned out...Leave a comment:
-
It looks very simple and I am sure I am thinking too hard to see solve a simple problem.
One question though.
How do I associate "Drawing_Number _BeforeUpdate" with a button called "Search"?
That's what I have on the form and that's how I want the operator to search. Type in the "Drawing Number" of interest and then click "Search" button. Then voila ...all the...Leave a comment:
-
Yeah...kinda sound right expect that I don't know how to set filter so that the query takes the "Drawing Number" that user enters.
That is the thing I have been trying to resolve. Have a look at the code from my previous posts. You will see that I try implementing filter of some sort so that the "Drawaing Number" that the operator enters is set as the filter to either query the table or the query itself.
...Leave a comment:
-
Yes. I do not want to update the record.
1) When user enter data into "Drawing Number"
2) Display the mathcing record in the same form
So we are finally on the same page.Leave a comment:
-
Ok.
Forget about the multiple tables and stuff that I mentioned above.
Assume that the following is my current DB:
1) I have a table called "Electrical 2008"
(a) it has these fields in the table
Drawing Number, Title, Job Number, Resource, Project Number
2) I created a query based on the above table and it is called "Elec 2008 Query"
...Leave a comment:
-
I added a few codes to make "Year" field works. It's ture that if I have year as a column in the table, it will make it simpler. I just don't want to start creating everything from ground up. My boos gave me the MS Access DB they have been using since 1999 which doesn't have any sort of form. The only way for them to seperate each drawing is by spearating "Type of Drawing" and "Year". There are a lot of tables. They...Leave a comment:
-
My bad. I just realized that I gave the wrong information. The "Year" field is unbound and it is not a "drop down" list. It's just a field to enter int.Leave a comment:
-
searching a specific record
Hello everyone. I have been working on this DB for quite some time and still can't figure out a way to do what I want to do. It's a database that keep track of drawings and engineering change etc. Aslo, the tables for drawings are grouped by year.
I have a Main Form and on that main form, several cmd buttons to initialize sub forms are located. There are a quite a few tables and the names are quite simple. For example, for drawing...
No activity results to display
Leave a comment: