Search results

Hi, I'm just trying to add a simple command button on a form based off of a table called tblMain. This table has a key called Entity_id. So on the form, I added a command button to open another form based on tblsupporting materials. This table also had a value called entity_id. So when I use the...

Hi, I haven't done any Access in a while and cant remember how to do this simple thing. I just want to query a suppporting materials table so that all the supporting filenames appear in a list box for a particular person. So I have two tables, One is called Main with all the people each with a...

Hi All :) I have an issue that seem like it would be an easy thing to do but not sure how. I just basically need to get three columns in a table into one column to I can do a query on that one column. But before I do the query I need all the data from the three columns. Whats the best way to do...

Hi,:o I'm stuck on what seems would be fairly easy but its not quite working right. Basically, I just want to do a 2 level query. I have a main table with alot of peoples names (first, middle, last). I have an affiliations table with people who are affiliated to the people in the main table...

Hi All :) I have a pretty basic question but I've never done it before. I built a report called 'rptPrintSearchResults'. I just want to write vba to print it to printer. How do I do that? It's based off a query that will change depending on the search the user does. Once the user does his/her...

Hello, :)What is the best way for me to get the value of a variable from a subroutine into another subroutine ? The code I'm running is below, it calls the btnSearch_Click subroutine (a very long complex piece of code) in the same module. I just need to get the value of 'strFilter' from this in...

Hey :) I need some help figuring out why my subform will not update with new data. The subform is based on a query. The query is based on the search criteria a user selects on the main form. So a user selects a name to search on then click the 'Find' button. This runs code that sends a new query...

Hello All:) I have a pretty basic question ... Whats the best way to go about giving a user to print out a spreadsheet in Access. I have a couple query forms where the user can make several selections and certain fields. Based on those selections, a subform pops up that is based on a table (in...

Hi All, I have a problem with implementing my filter that is pieced together in my VBA code when the filter gets too long. Everything works fine for everyone in my database (1000's of people) except for 4 people. The problem happens in a search for all documents associated with a person when the...

I'm sure this is an easy one but what is the best way to import a table and replace an existing table with it. I know I can use the import data option in a database. I was just going to import the excel file, delete the original table, rename the newly imported table the same name as the old...

Hello all :) I'm trying to figure out the best way to add a value that is not in a drop down combo list. After doing some searching online, I found this code: Private Sub Trait_NotInList(NewData As String, Response As Integer) If MsgBox("The Item Entered is not in database, would you like to add...

Hi All:):) I'm building a database in English but it has arabic people. One of the features that I need to include is some text boxes next to the names in english that will automatically display the name in arabic when the english version is typed in. So far I had added the language update back...