Search results

Hello all! 2 questions: 1) Could someone clue me in to the best method of creating a dynamic table from a ODBC query that pulls information from a database server? 2) This table will updated several times a day, so I need to overwrite duplicates. Is there a quick way to do this in the...

Hello all! I believe this is a simple one. I have a combo box that has a list of values(drop point names). Depending on the user's choice, I would like to have it display the corresponding drop number in another field on the same form. I have two tables (tblforecast & tbldropnumbers) that...

I have a main form (Main Archive Form) with a subform (frmarchivesubform). The subform's record source is a query called "Dynamic_Query". On the main form I have a combo box and two text boxes that specify search criteria and a command button that executes the search. The command button has...

Hello all! I am trying to setup a basic search parameters and I am new at this. I read the article about how to use Querydefs and am trying to follow it as closely as possible. I gotten to a point where Access keeps returning the following message: Run-Time Error 2001: You cancelled the...

Ok...I think I have successfully confused myself. I have a main form (Forecast) that has a subform (forecastsub) that displays the contents of a table (forecasttbl) in a queried format. I did not link the forms as I want to see all the records that meet my query parameters and let the users...

I have a subform on a main form that loads the contents of a table. Simple. This table contains a closed field and an archived field. Here is what I would like to do: When a user marks a record as closed (checks the checkbox), I would like to see this entire record highlighted in yellow...

I am using a make table query to create an archive table of records that are old but still need to be available through the current db. I understand how to create this, but I do not want Access to delete the table that is there everytime I run the make table query. Is there a way I can prevent...

I am using a make table query to create an archive table of records that are old but still need to be available through the current db. I understand how to create this, but I do not want Access to delete the table that is there everytime I run the make table query. Is there a way I can prevent...

I am trying to figure out a way to display my table within a window or grid on a form. I'm new to the game and any help would be greatly appreciated. Thanks! Steve