Recent content by randognb
-
R
Need to enter only unique values between two tables
Hi, I am running a SQL Server 2008 database with an Access 2010 .adp frontend and have two tables: Table 1: TravelerToDrawing with columns: Traveler, DrawingNumber Table 2: Drawings with columns: DrawingNumber, Description The column DrawingNumber is the data that links the Traveler column... -
R
Query with VBA Public function as parameter
Thanks for the reference and the help! I checked out the tools and while they are very useful indeed, I'm not entirely clear how they would let me dynamically change the criteria. They mostly allow editing of an SQL string so would I have to use a querydef callout to pass the edited / updated... -
R
Query with VBA Public function as parameter
I'm working on an ADP pulling the database tables from our SQL server. Can I still just post the ADP? Code should be enabled since i've programmed all sorts of other stuff. -
R
Query with VBA Public function as parameter
by the way, i appreciate your time! -
R
Query with VBA Public function as parameter
hmm very strange... and you were able to add that in as criteria in access' design view mode? I've seen lots of people write and execute the SQL in VBA code... this query is in a subform... is there a way I can write a vba code that adds in the global variable to the query definition and then... -
R
Query with VBA Public function as parameter
The function is in a standard module. It's named "StartUp" -
R
Query with VBA Public function as parameter
Hi, I have a query that I'm working on through Access 2010's design view. I'd like to add a criteria to the query where it only shows results with the employee name column matching a global variable I created that stores the name of the currently logged in employee. Here's my vba code that... -
R
docmd.openform where condition does not update
thanks for responding! If i manually delete the contents and re-run the code then it updates again. I found out that while i was debugging this problem i'd click "Save" when in design mode which was saving the ServerFilter property. So the key is to not save the form after it's opened so that... -
R
docmd.openform where condition does not update
Hi, I am running an .adp accessing data on SQL Server 2008. I'm trying to take a value from a field and use it to show only records that match that value in a continuous form. I programmed a button to run: Dim whereString As String whereString = "[Employee First]='" & Me.txtTest.Value & "'"...