Recent content by mattv10

I've figured it out for anyone who is interested. I did a UNION Query.

Hi, I want to create a view of two tables. However, my two tables are very similar in the data they have; there are differences though. I don't want it to paste all the similar data twice though I want it to merge the similar data.. Is this what a view does anyway??? Thanks in advance!

Great! Thanks

Is it possible to write a query that will extract information from two databases??? If so can someone give me a little instruction on how to go about doing this.. Thanks in advance!

Hi, I have the book called Access Cookbook. There is a section in there about dynamically connect SQL Tables to Access without using the File Get External Data menu commands(Linking Tables).. So, I successfully implemented this on Access.. However, I have multiple databases and multiple...

Thanks!! Easier then I thought..

How do you make a form automatically popup when you open the database? Thanks!

Hi, Currently I've created a Form that allows you to type in a textbox and what I type Searches in a listbox. However I want to expand and when I select something out of the listbox and click a button it will either: A. run a query or B. open a subForm and run a query. Which ever would be...

Hi, I'm currently in an internship working solely with databases. I've become really interested in designing databases and I now want to design my own. I was wondering if I explained my table structure then someone could give me their thoughts and ideas for improvement. I have a huge sport...

Will use private messages from this point on. Sometimes forum admins get mad when you continually post numerous threads.. Atleast that is the experience I have had.. Are you firmilar with using Private messages??? If so, send me one and we will continue from there.. I'm alittle confused...

Look your table should look something like this.. Every Table needs a primary key to make it unique so that is harmless. You just always need a Foreign key to make the relationship work. CompanyTbl -------------- CompanyID (PK) Company Address (Whatever else you need) InvoiceTbl...

This is correct, but remember to add a field in your invoice table and you can call it companyID... Then add the the matching companyID to all your invoices. Only having two tables in your entire database is probably going to cause a lot of trouble.. Do you know anything about Database...

Ouch!! Is there anyway around this. The company I'm working for wants a query where you could type something in a textbox and see its other information. For example if you type an athletes name it would display his/her statistics, years of play, etc etc... So, I thought it would be easier to...

Why don't you create a companies table.. You can have a companyID and one company can have many invoices(would be your relationship) Then in your invoice table you can have every possible invoice but use the companyID to verify which one it is. How many tables do you have so far?? Could you...

Hi everyone, I have a general comboBox question. Is there a way to create a form with a comboBox that won't update the records when you make a selection.. I'm trying to run a query based on my combo box selection, but when I made a selection from my combo it changed that fields info. Thanks...