Search results

I have about 30 queries saved that I need to execute and put in a new database. I've already got code to loop through a list of all my queries but I can not figure out how to execute and put the resulting table in a new database. This is my current code. Public Sub ExportReportQueries() Dim...

This is an example of my db: Items - ID, Description Motors - ID, Speed, Torque Fans - ID, Diameter Where ID in Motors and in Fans correspond to a 1-1 relationship with the ID field in Items.

But since the tables have different data, they can't be union'ed! (right??) The only way i figured out how to union tables that are different is by using, "null as columnname" for each column that wasnt in the other table, but then with that access wont allow you to edit it

How will this work? If I set the subform query to get a 'Pump' item it will automatically show the Pump table fields?

I have 3 tables. Table 'Items' holds an entry to every item and then a table for each type of item that holds more specific data. I want to create a form that lets you browse ALL the items which means that it needs to be able to get and display the data from the 2 other tables which have...

Villarreal68: I don't know what the A or K is, thats what I want to get a list of.

I have a text column that has some Letter in it, the format is #A-##A where A = Alpha, the last Alpha is also not required. What I want to do is get a list of all the first A's, so like i have 11P-23A, 22G-45B, 33K-67C and I want to get A,G,K is this possible?

i have a parent table and a few children table where I want every entry in the parent to have to have an entry in one of the child tables. Is there anyway to force this? The only way I know of is to create a query that finds any that are missing and from the child tables and add them, but if it...

So I've created a form that has a "search" area at the top but if I change from Form View to Datasheet view this goes away. Is there anyway to keep this area so that the Datasheet view can be searched just as easily as the Form View?

Is there anyway to get a list of the fields available on a sub form?

I have a textbox on my form and a sub bound to its change event, whenever someone is typing into the textbox i want to dynamically filter the results as they type. Right now each time i type a character it either highlights the entire textbox thus erasing what you already typed, or the focus...

Im working on that now but my main roadblock at the moment is how to access a controls properties not pre-knowing its name. IE. In vba in my form i can do Me.Field1.Text and get what is in Field1, but how can I then get Field 2 etc etc without pre-progrmaming that in which I dont want to do, I...

well by "row" i didnt mean an entry in the database, i mean a row of controls for the search form. let me post a pic of my form... The circled part is what I want to duplicate.

thanks for the start! :) what about adding a new set of search inputs. So currently I have a Combo Box that displays all fields, a search box for the term, a check box to enable/disable the term being used and a button with a "-" in it meaning to delete the term. That is for each row. When they...

Ok I've setup my form to display a query and I need some way for the user to search for a unique record. I'd like to have at the top of the form an area where they can select what field to search, maybe some options for search and then their search string and then they can add more like that if...

Here is an example db. If you open the ExampleTable Form, you can select a "Name" from the drop down list but it only changes the current entry, what I want is for it to GO to that entry

I don't think I'm allowed to, I'll try to make an example db though

It is not an Autonumber. When I first added the field to the form it was a simple text box showing the current records value, i changed it to a Combo box and in the data properties i changed the Row Source Type to Table/Query and make a query int he Row Source to select all the rows value. But...

I have a form with basically all the fields from a table. I want the primary key field to act as solely a search for the table and not allow them to edit that field at all. how can I do this? If it could be a drop down box to list the entries but also so they can manually type it in (with auto...

I think I can probably figure out how to parse the string (I reserve the right to be wrong and ask for more help lol) The main thing I don't know how to do is access all the records in VBA