Search results for query: *

I'm using the following code to loop through records in a test table and output the results to an outlook email (see below). When I run the code as a Private Sub from Access based on a button click event, it works correctly (opens up outlook and sends the email). But when I try to use task...

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

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.

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

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

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

Hi: I have an access front end that links to tables in A MySQL database. But every time open my access front end, and try to connect to one of the linked tables from a button click event on a form, I get a runtime error '-2147467259 (80004005): ODBC--connection to 'MySQL ODBC 5.1...

Hi: This is a yes or no question. If I split the database using the database splitter wizard, and put the backend in a network folder, will multiple users be able to simultaneously link to and perform operations (insert, delete, update statements) on the backend tables from their front end...

Is there anyway to make the data in each field in an access report appear in a different color? Thanks in advance.

Hi: How do I use vba to set the current text entered into an unbound form's textbox (txt1) as that control's default value so when I close and open the form again, that value will be the one appears in that textbox. I tried using the after update property of the textbox in question, and using...

Hi: I used the following code to export data from an Access Table ("Invoice Data") to an existing .xlsm workbook ("Control Chart Test.xlsm). The first row that will receive the data from "Invoice Data" will be A14. How do I define the range so that data will be inserted into the first empty...

Hi. I need the vba code to export two Fields [Date] and [individual Ct Value] of an access query to an existing excel Sheet named "PCR Chart.xlsm without overwritting the existing data, but instead just add to it. Thanks in advance.

Hi: I am exporting a recordset to Excel from Access to create a pivot chart. Everything worked yesterday running on Access and Excel 2007. When I tried to run the same procedure today on a work computer running Access and Excel 2003, I received a run-time error ("The object does not support...

Hi: I have the following code to create a pivot table in Excel using data exported to Excel from an Access database. How can I create an XL3DColumn pivot chart based on this data. There are three columns of exported data: Field Names are: "site number", "quarter", and "cost". In the chart...