They can be moved anywhere so the directory should be fine. As for the scripting I did plan on using Access 2010 VBA. If you find samples that owuld be great however I think I have the chain understood given your description.
Thanks for your help!
Andy, That sounds like what I need. Do you have any samples of that code? I hate to ask but I am not a programmer so I always take forever to connect the dots.
Thanks!
I need a little design help on the follow problem, thanks in advance.
Current state: We have 121 rtf documents that users open in word to prepare for a survey.
Use factors: Users select between 5 and 25 documents to print and take with them. The selection is up to the user and cannot be...
Sorry folks I know this is not a typical VBA question but it is driving me nuts.
Situation: I recently changed jobs and have moved from a Blackberry to no work phone. I purchased a Driod and would like to get my calendar events on my Driod Gmail calendar. I can by using Forward as Ical...
Need VBA to link tables to many identical DBs
I have 24 servers that are running the same application. I would like to connect to these via code rather than having to create 240 linked tables.
Need: To link to 10 tables on 24 servers
Good news: I have a local table that has all 24 server...
I have several queries that have static criteria typed in. These are each specific to the user. The users are spread out and need to only see their data sets so I set the criteria then rename and send the DB.
My question is how could I point the various queries and various fields to a table...
Thanks for the help one last thing now that I have done it. How would I set this as a Trusted Connection? I need to use the AD for users so I do not have to always add them.
here is what I have:
Option Explicit
Private Const REG_SZ = 1 'Constant for a string variable type...
Answered my own question. I changed the ODBC on my PC and then tried to open the linked tbl and the link failed. So it looks like the linked tbl is still there and not a new DSN-Less tbl.
Any suggestions or advice?
How can I tell if the code worked?
I ran FixConnections "svrdw", "sales"
in the ctl-G window
with code listed below but in my linked tbls I do not see any change in linked tbl mgr? Any suggestions?
Sub FixConnections(ServerName As String, DatabaseName As String)
' This code was originally...
I am out of my comfort zone and it shows.
I would like to create a command button that creates an ODBC connection for users automatically. I do not care if it is “on the fly” or if the created connection is now present in their ODBC system connections.
I have 2 tables in the DB that get...
OK I really tried to figure this one out and can’t. I need a report that prints Images from a table with images in it on ½ of a sheet of paper. The paper can then be cut in half to make a 5.5 by 8.5 page for books.
So I need to know how you would format a report that is:
Page size 8.5 by...
I have an access app that uses 2 linked tables that are linked via standard ODBC. I use a lot of linked servers in MS SQL and can create those dynamically on the fly. I would like to be able to create the most robust connection type possible given my need.
The use would look like this:
20...
And today is beginning like yesterday. Help with format date. As you can see I want a file saved at 8 am on Jan 1st 2011 to be strfiledate “0800 1-1-2011”. I just need a date/time down to the minute, seconds if it is easy, so I can ensure unique filenames...
Thanks again PHV I have had to pick this DB back up and update a few things and I am very rusty. I moved over to the Barcode and SAP team so not as hands on anymore.
Thanks again!
I am all good now
so I am good with using the query. How would I syntax the control source on the form to take the top 1 (there is only 1 record anyways) of the query. I tried this a while ago and got
=[qry_update_date]![FirstOfUpdateDate]
#Name
I just tried this and it just leaves the field blank
Private Sub Last_Update_Date_BeforeUpdate(Cancel As Integer)
Me.BeforeUpdate = DLookup("[UpdateDate]", "tbl_FGs_with_Family", "[PRDNO]='10084192'")
End Sub
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.