Search results for query: *

I have a program that will be accessing data from over 200 tables in 4 Access Databases. How do I retrieve data from tables from more than one database at a time?? I am running a select statement that requires data from tables from more than one database how can it be done?? Thanks for any...

Hi everyone I have a series of sql statements that are being executed when a name is selected from a list. These sql statements take the field from the record and apply it to the list in the combo box that the statement is being written on. I hope that makes sense. The program executes the...

Hi everyone: I have this select statement that is joining 3 tables, but it is telling me I have a syntax error in the join? Anyone pick out what is wrong with this?? Set rs = db.Execute("SELECT Leagues.[Index], Leagues.[ShortName] FROM Leagues INNER JOIN (Leagues INNER JOIN [Teams] ON...

Hi everyone: I am sort of new to this SQL stuff so I am hoping someone can lead me in the right direction with this: I have a form that has several choices that a user can make to filter the master table by Name. On this form there are 2 sets of option buttons (3 choices each) 3 checkboxes, 8...

Hi eveyrone: I have this Select statement that is giving me an error "missing ).], or item in query expression" Here is the statement: Set rs = db.Execute("SELECT * " & " FROM DraftDetails WHERE DraftDetails.[Player] IN (SELECT Players.[Index]" & " from...

Good Morning everyone: I am creating a program that as the form loads displays a list of approximately 56,000 names. From this list the user will click on a name. As this is done all the informaiton from several tables will appear on the form. The form consists of a Tab Set of 8 tabs. There are...

Ok, I have a complex situation here. I have a database that has 50 tables in it. The tables are all joined by an index field. So I have the Name table with a field in it called Address. I have a table called Addresses with a field called Street. I am using SQL to write the queries with no...

Good Morning everyone: I have a simple question, and it is probably already in a Forum, but the search engine is down here this morning and I need to get this answered. When I retrieve a record from a table to be displayed on a form, I want fields that are empty in the table to appear empty...

Can someone please helph me with this. I have been trying to figure this out for a few days now and its got me ready to jump off the roof!! (not really, but its frustrating) As I click on a name in the list, I want to be able to retrieve the data and display it on the form, but its not...

Hi everyone: I know this can be done, but the layout for it is stumping me. I have a list of players and I want to be able to display the information about the player as his name is selected from the list. How do I connect to the table and take the info on that player from certain fields in...

Hi everyone and Happy New Year I have a question about Listboxes. I have a Listbox set up with a checkbox so that the when the user selects an item from the list it will appear checked. My problem is when I clear it, all the items in the list disappear. I just want the checks to disappear...

I am sort of new to programming and definitely not an experienced one. I have four databases that I need to link to my program, but I have to do it using SQL code, and not data controls which I am accustomed to. I know I could pick it up if I had just a little sample of how it should go. If...

I have 4 databases with several hundred tables. How or Can I use more than one table from the same database using the data controls? Thanks in advance for any help MichHart

I would like to know how to put editing options on a textbox on a form. Such things as copy, paste, font, color, bold, italics, and underline. I have a picture of one that I have seen but I don't know how to do it. I have the textbox created as a richtext textbox, but how do i allow the user...