Recent content by laythss

Sonny, I am actually having trouble with the code. Dim db As DAO.Database I am getting an error: 'user defined type not defined'

sonny, Thank you for the code, I have not tried it yet, but I am sure it works. VB always works. So now I am wondering now if it is even possible at all to do many of the functional form things without using VB?

Allright, I might have not explained myself clearly in the first post. My second table which is tblAddress is just a list of all zip codes and the cities and states they point to. It's main reason would be to lookup (automate) the form when a user enters a zip code. So when the user enters a...

A very simple question I have 2 tables, a tblClient: ClientID(autoNumber) ClientName ClientCity ClientState ClientZip and tblAddress: Zip City State so now I made a form and I am trying to understand if it is possible without writing VB to be able to do the following: 1- input the client...

allright I bought a database with a table of the information for $9. now I tried to make simple form where when the user enters the zip it will give you the city and state, but my problem was you had to press a Find button, which brought up a find window... Not exactly what I needed. Here is a...

I am including an updated file, Including my last question in the past post about indexes, how would the form be constructed to be user friendly ---> how would the user figure out the 'MachineProductID' ? Check the 'Enter Readout' Form in the attached file to see what I mean.

I am sorry Pat. I just deleted a whole paragraph explaining why I was looking for something else on this post, and then after reading you threads again on the last posts .. They seem to be the same. My mind is just getting twisted with these tables, and I am still not getting it all figured...

Does any one know of a place online where you can get the tables (for free I hope) for a city state zip comboboxes, or at least the tables for all cities in the US.

Hello all, I am starting to get an idea of how access works (at least I know now where the surface is). I am having a design/table/form problem. Here is what I have: a form called 'Enter Product' , in this form I have a YearDate, YearMonth,YearDay fields (I am not sure how queries work at this...

Background: I have the foloowing tables tblClient: ClientID (PK) ClientName other client details tblMachine: MachineID (pk) SerialNumber ClientID (fk to tblClient) other machine details tblProduct ProductID (PK) ProductName tblReadout: year_date month_date(pk fld1) day_date(pk fld2)...

Thanks You Pat, I was reading one of the Help Tutorial in access and noticed what you said, I have my relationships upside-down. I constructed the tables in access, but I am still not sure how to make the most important part: which is the readouts. Every machine gets readout every week, and...

More detail qestion Can a Foreign Key point to ONE of the Combined Keys in a another table?? I read an article about rules of normalization etc (figured that was a good place to start) so I am running into the following problem. I have a table (Clien_info) as follows: ID(Auto)[PK] Client_Name...

hello all, I am very new to access (my background is in VBA Excel, but I am not using VBA for access yet). I was wondering if some of the more advanced people can give me pointers on how to accomplish (or work my way) to make the kind of form I am trying to do. What I am trying to do is the...

I am just starting with access and I have a VERY stupid question. I made a combobox (it gets its values from a table with 2 colums the first the ID and the second is the products) when a user selects one of the products in the combobox the combobox is supposed to update another table with that...

Hello all, I am all new to access and I am trying to convert a program I made from excel VBA to ASP.net using access data bases. I am not even sure if this is possible, but I started looking into access couple of days ago, and reading examples of using it for websites etc. that I think it might...