Search results for query: *

i found my "bug" thanks for the help...I was trying to do it with a query....

yes I want to match DESIGNERS with 3YEAR records on the same form... keep in mind...My forms are opened after a job number has been searched for. ONLY then. Thanks for the tip...I will now have to go back and edit my coding and make the changes. =-]

I have a drop down menu (combobox) on a form that i am trying to query 2 tables with. I have a table called 3year with EVERYBIT of customer info you could imagine.. And I have a table called COMP DESIGNERS with only 3 people in it Comp Designers has 2 fields DESIGNER ID(primaryKey) DESIGNER...

Thanks for the help.... After renaming ALL of my forms..it works nice

I'm not trying to insult intelligence here...trust I couldn't figure it out so I came here... but If I typed =OpenMyForms=() into the TAB of the properties...how would It work when I clicked the button? would I wanna make it a module and "onclick" run module ?

Hey all..I just wanted to say thanx again for the help I received last time...here again with a wacky one. I am working in Acesss XP ... I have a form with several command buttons to open different forms. I would like to know If I could create a module somewhere along the lines of IF...

Thank you for realizing that. I think I mentioned in one of my earlier posts that am not a lamer comp user. I'm not lazy. I do give ofrth effort. I also mentioned that I'm a moderator in the Admin-Mod forums and in my Paintball team Forums. I really hate n00bs who haven;t even given an effort...

hey geek! that is not what i was doing! I had written code already and couldn't figure out why it wasn't working. Don't play that game man. Anyways thanx for your help everyone! I did get it to work with the code that throadbnet made up. I had to change on or 2 things. But thank you! I can...

Private Sub cmdjoblocate_Click() 'Dim mydb As Database, MYTABLE As DAO.Recordset Dim MYTABLE As DAO.Recordset Dim sJob As String, sLoc As String Set mydb = CurrentDb Set mydb = DBEngine.Workspaces(0).Databases(0) Set MYTABLE = mydb.OpenRecordset("3year", DB_OPEN_TABLE) MYTABLE.Index =...

ok...yes to all of your questions.... what references is your code using? maybe I'm just not using the right references... Jarnut00 is a member of [url=http://www.teambitm.com /url]

ok. here is what i want.... ============================== Job Number: 201876 WAS FOUND! And is located in: COMP dept. ============================== but as a msg box. Or even If i have to make a new form But that is what I'm reaching for. This is going to be an application distributed...

LOL Ok...I tried what you gave me. AND IT WORKS! Up until it has to go out and get the information from the table and then return it into a new message box with the location info. I added some code to it to try and tweek...same result everytime. Nothing comes up in immediate window. I should...

Thanks !!! I'll give that a go! I know about people bing pains in forums. I admin my own forum now and I moderate Admin Mod forums for the Game Counter-Strike. a game and I'm 25 years old. Heh... Anywyas...lemme give that a go. Jarnut00 is a member of [url=http://www.teambitm.com /url]

Broadbent. I see what you are saying. And I didn't copy his query and use it in mine. I did chaneg the field names. I dont want a virtual table returned. I want just one two fields of one record returned. ex. ============================== Job Number: 201876 WAS FOUND! And is located in...

That works but it doesn't =-] It pops up a box and asks me to enter Job is, Job status, and then the job number....but ir returns me a new table with all sorts of records... I dont want that... I want it to ask me what job i want to find, type in job number, return me a "error box&quot...

What you suggested for me created a new table and when i enetered text it showed up in ever record. I'm kinda stuck between a rock and a hard place here..... My boos (father) believe in the school of hard knocks. I have no training or schooling in access or VB, howver I am comming along. He...

edit ..some spellig corrections Jarnut00 is a member of [url=http://www.teambitm.com /url]

...I'm hard coding it in the background.... Private Sub joblocate_Click() ' this procedure will use records from 3year and cpnames for vitals '****************************************** 'open 3year and get some of the information '****************************************** 'On Error GoTo...

I'm trying to make a command button that on click will pop up a msgbox titled "Job Locater" with the message "What job do you want to find?" prompting the user with an inputbox. Upon hitting enter will search a database and return a pop up saying where the the job is and the...

hello been away for a while Jarnut00 is a member of