Recent content by atcstech

Heh, as soon as I made that post I realized I was retarded and sitting on a forum asking redundant questions. I was reading that thread when i came back to make a post and let you know I decided to go with just typing the number in myself, makes more sense in case I decide i need to skip a...

that's really friggin cool! i will spend some time this afternoon and try and wrap my head around the code. Do you know of anyway of setting the autonumber to start higher then 1? i want it to start around the 6 thousands.

It's cool, i got 5 computers to work on, so i dont have time to spend on the db right this second anyway. thanks though!!!!

relationships good, now we're in the same boat and it's sinking ever so slowly :D lets see if I can 'splain this better. Table/Field Computer/CompOwner Customers/ContactName I want to type in the ContactName with the Customer Form and when I go to the Computers Form i want a drop down that...

I was working on the relationship thing and it was confusing me. Basically we will input the customers name in the Customer form which writes to the ContactName that we were previously dealing with. When we go to the Computers form i would like to be able to type in the name of the customer or...

that works perfectly!! How would I write If table "Customers" field [CustomerID] = table "Computers" field [CompOwner] Then DoCmd.OpenForm "Computers", acNormal, , "[CompServiceOrder]=" & List44.ListIndex + 1 that would work if one customer had multiple computers, right? I will try to look...

Okay, ya i changed that before and THOUGHT it didn't work, but it does. But to an extent. I have to type in the full name eg - if i search for "Tom" i find nothing, if I search for "Tom Thomas" I find the listing. Is there anyway to add to the script an automatic wildcard (*)? thanks again...

Thank you for your reply. In the Customer table there is a field called ContactName There are two names in there with the first name being 'Tom' and a third with the name I believe is 'Jimmy' Maybe my query from the original post was stated wrong? In the search I want it to search multiple...

hmm, that doesnt seem to work. When i type "Tom" into the search box, it comes back with no listings. I am at home now, but I will spend some time looking at it tomorrow and see waht you did to actually make a functional search and see if i can maybe figure it out. Thank you for trying though!

can anyone help? I'm still stumped.

Okay, So i looked at some of the search functions that some, obviously, excellent programmers put together. My work has put me in charge of building a new database instead of doing everything with pen and paper. The problem is that I am totally clueless when it comes to anything to do with...