Search results

Hello, We have access 2003 and are having a hard time to get a chart with the fields and size we would like to have. We have tried to go through with the wizard and it seems to do okay, it shows the data that we are looking for somewhat but the layout isnt as we had hoped. Im not good enough...

Thanks everyone - I removed all the tables that I had created and formed it one table and now things are working alot more smoothly. Now its off to create the seach function so I can allow others to be able query the different error types.

Okay - I think im getting it then - basically - combine all my tables into 1 table and then go from there. That makes sense - I may try that then and create a combo box to display what type of error it is. Then my next quest is to figure out how to create a search / query page.

Okay - tried to do it but it didnt see to take. I am not to sure on what you mean by foreign keys. That may where I am falling short on. I have created a table called: Event Data Field Name: Event ID Data Type: AutoNumber General Field Size: Long Integer New Values: Increment Indexed: Yes...

Thanks for the advice. I think I know what your saying. I'll try to create an event table / make a column that is for the auto number and then relate my other tables to it and see if that does the trick. I will then set the other tables to not auto # and try what you suggest below and see if...

Basically we are a wood shop and we are wanting to track any events that may cause us extra work. IE we have a form if a customer of ours lost their product at a jobsite, we another if the item was stolen from their jobsite, we have a form if the extra order was caused either by them or by one...

That I can do. I have 12 Tables which have alot of fields in them. Not sure if you need all the fields are not. The main field im trying to work with is Column A which is the ID Field. All the tables have pretty much the same column information. Table 1 (Customer Error) Column A (ID) which is...

Sure - not sure how to do that though - if you or something can tell me how to do it i'll get them on here right away. I am sure that my whole database is probably not the best for this is my first attempt at it but im trying.

Hello, Here is another silly question for those out there. We have 8 tables that we are working with and have column 1 in those tables set for autonumber so it will give our forms an ID each time we create a new one. What I am trying to do is setup a relationship so as when we go to create a...

Thank You Uncle Gizmo, I think I am following you on what to try. The main reason for our database is to store information in regards to service requests that we get from our customers. A majority of the information is the same. The only difference in the form is cause of the service...

Hello, Still trying to figure things out with this software. Never have messed with it much. The question that I have is this. We have about 9 forms that we will be filling out. I was originally going to have it to where you swapped between the forms in order to put the data in that we...

Thank you for the information. I'll see if I can find that property in the combo box. I looked in there before but didnt see what should be changed. At least I have an idea of where I need to go now.

Hello, I am new to Access and have a question in regards to the combo box function. I have it setup I think correctly but the problem I have is how its storing the data. What I have done is I have a Table that I created with a field that has set responses that someone can pick from when...