Search results for query: *

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

Looks like I have some more reading to do. I appreciate the help and will repost what works so there is a record. Thanks for the help!

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

sweet! BTW I had to make the variable a variant not date. not sure why date did not like time?

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

Yes I tried to put my dlokup in there and it errored out as ?Name

Great! Thanks to all who helped. It is appreciated!

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