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...

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...

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?

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...

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...

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 have a table that has some malformed data, part of one field is in another field. I would like to create a function to go through all the rows and extract the extra data and put it into the correct field. Can anyone help me do this? I can't seem to figure it out for the life of me!

I have a table that I'm storing Horsepower and Watt in. Is there anyway to set it up so that when I provide Horsepower it automatically populates Watts? (just a simple multiplication)