Search results for query: *

...db As Database Dim strSQL As String Dim blnNewInstance As Boolean Set olMailItem = olApp.CreateItem(0) Set db = CurrentDb() strSQL = "SELECT * FROM Table1;" Set rstOpenTrip = db.OpenRecordset(strSQL, dbOpenDynaset) strAddresses = "someone@gmail.com" If Not rstOpenTrip.EOF Then...

Thanks for your help Skip. Unfortunately I can't use a specification file b/c my company doesn't want Access to throw out an error everytime there are some additional columns in addition to the ones that the database actually uses. As far as I know, this can't be achieved if you use a...

I'm using Docmd.transfertext to import in a .csv file. For one of my columns in the test csv file, the entries were S1, S2, S3, etc... After I imported the file into a database table, access converted this column of data into a currency field $1.00,$2.00,$3.00, etc... I didn't use a...

I'm using Docmd.transfertext to import in a .csv file. For one of my columns in the test csv file, the entries were S1, S2, S3, etc... After I imported the file into a database table, access converted this column of data into a currency field $1.00,$2.00,$3.00, etc... I didn't use a...

Hi: I have a database I built for work that has been converted to Access 2010. But when I make a copy of it (on a thumb drive) to work on it at home using Access 2007, I get an "Unrecognized Database Format" error. This has happened for a couple of days now. When But when I open this same...

Thanks for the help. I changed the original update statement to: S7 = "Update [Assay Mix Replicates_Temp] Set [Date/Time Stamp] = '" & Cstr(Format(Now(), "MM-DD-YY HHnn")) & "'" and changed the datatype for the [Date/Time Stamp] field from Date to text. Everything is working now.

Thanks for your help. I wanted to clarify that what I am doing is importing a .csv file into a database table, and then updating a column (called "current date and time stamp") via update statement using VBA code. S7 = "Update [Assay Mix Replicates_Temp] Set [Date/Time Stamp] = '" &...

Hi: I am trying to use the format now function to display date and time in a Access table in this format: MM-DD-YYYY HHnn(military time) Tried to do this (see below) but it doesn't X = Format(now(),"MM-DD-YYYY HHnnss") Any help is appreciated. Thanks.

I meant runtime 2013, not 2012.

Hi: I am trying to distribute the front end of an Access database application (Access 2010) at work to various computers at my work through runtime. Does using runtime require any other applications to be pre-installed (ie. Microsoft Office standard edition) in order to work. I am asking b/c...

It's working. Thanks.

I have a yes/no message box that will delete an existing table "Well Curve Data" in the database, and recreate a blank one when the user click "Yes". If the user clicks no, it will open a form "Well Curve Analysis" based on the existing "Well Curve Data" table containing old records. But b/f...

I found a solution.

Here is the code I am using. It's based on a button click event on a form with two textboxes: Source Folder (SF1) and Output Folder (SF2). Private Sub ImpWCs_Click() Dim strSourceDir As String Dim strDestDir As String Dim strDestFile As String Dim strTempName As String Dim varFiles() As...

Is there any way to use the CreateObject("Scripting.FileSystemObject") to loop through all subfolders of a particular folder and convert all .bmp files to .jpgs. So far I can only convert files by selecting individual subfolders. Thanks in advance.

Hi guys: I found the solution I was looking for. Thanks.

Hi: I am trying to adapt some code I found online for Excel into access vba that will enable me to loop through all subfolders of a parent folder, and then list the subfolder paths and file names in too separate columns of an access table. But so far, it will only insert the subfolder path and...

Hi: When I try to encrypt my Access 2007 with a password, Access freezes up and displays an error message "Microsoft Access is not responding".

I have a user authentication form (User ID, Password) in an access database. Is there any way to trigger this form when someone tries to import the tables from this database (including my User Accounts table) from another Access database using the DoCmd.TrnsferDatabase cmd.

I have several linked MySQL tables in an Access database using file data source ("C:\MySQL Test Connect\LIMS_backend.DSN"). How can I trigger the MySQL login screen when my Access application opens or on a button click event instead of having to click on one of the linked tables. Thanks in advance.