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

WayneRyan, Ok....I see what you are saying to do, but I am not sure if this will acheive what I am attempting to do. Although I could be completely wrong. Let me explain a little further at what I am attempting: I have two tables currently. One is named tblForcast while the other is named...

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

Thanks Casey! I did what you suggested and it worked like a charm! Like you said, it looks like my QueryDef wasn't updating the subform. I appreciate all of your help!!!!! Steve

I tried what you suggested and it still won't refresh the data. Any other suggestions? Steve

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

Thanks Jon! I appreciate all of the guidance! Hopefully I won't run into too many more snares... Steve

Thanks Jon! This helped immensely! I ended up having to use IfNull statements still, but your example helped me get my head on straight. If you don't mind, could you take a look at my code here and see if you see any problems or have any suggestions? Private Sub Command48_Click() Dim db As...

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

Thanks Jack! That's a great idea. I will give it a run and see if I get the results I need! Thanks all! Steve

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