Recent content by T588

Thank you!

This should be obvious. I’m overlooking something? The database I submitted only has the following: 1. Table: “Salespersons” 2. Form: “SelectSalespersons” 3. Query: “SelectSalespersonsQuery” Building off information I found of this site I should be able to open the form (item 2 above) and...

Thank you

Correction....... I realize relationships have nothing to do with the question their on the front end..... I should have asked, "after I link the ODBC tables" will........ I was thinking outloud ........you just couldn't hear me! Vince

I located and placed the needed ODBC tables in my database (note: did not replace – as I left the originals in place (renamed) for maintenance proposes if needed) Question – once I set up the same relationships as the former (natural) tables had – will the ODBC tables populating the access...

Extremely great full for your help… Thanks again Vince

What i'm searching for now is how to do away with the indiviual tables in the access database and link to tables in our sql database. Tables that have already been created in great plains. This eliminates having to update more than 1 set of tables and the SQL tables are already updated (new...

I don't need an autocomplete function - thanks to a post by "Sen.Mem. DBL" all I have to do is select yes to autoexpand and it functions great for auto completion of any entries! Now, I just have to check into the NotINList possibilities. Is the quantity of posts in "Access World" the reason...

I know I didn't look very long before posting the question.... I did find something in the knowledgebase (209836) "NotInList" that keys on the "customer ID" field. I don’t have an ID field. I was wondering that if I had an autocomplete function associated with the "Company" and...

I need some expertise on a project I’m working on. In the stripped down version of the attached database there is an order form, customer table, order table and an order query The only fields on the form are the top combo box (company) below that is another combo box (customer/contact) below the...

Already did the query update.....BUT the ID info is what I needed! I never thought (more on that later!) about the ID column. Right in front of my face. Talk about being SLOW..........I'm a turtle!! Thankyou very much! Vince

I did add a column "CompanyName" to the table. This isn't so much for when entering in new customers but for entering new orders using exsisting customers and the user being able to enter the soldto/shipto info from picking an exsisting company or by picking an exsisting customer (a customer...

This is what I'm trying to do: I have a table(customers)with the following fields: CustID,CustomerName,Address,City,State,Zip. Currently, I have a form with a combobox(Customer)which is tied to the table CustomerName field, selecting a customer from the combobox dropdown list fills in 4...

This wasn't quite what I was looking for.......But I may be left with no other option. What I was looking for is : ComboBox -"A" ComboBox -"B" TextBox - "C" TextBox - "D" TextBox - "E" TextBox - "F" upon selecting value in combobox "A" : Combobox "B" filled...

Thanks -I didn't know what that particular procedure was called. Vince