Recent content by EddiRae

Doc Man, the query for the record is linked to the prior form. Maybe that is it. I did use the code that sxschech posted. This works to where it at least creates a copy and then I go back to the prior form and refresh it so that the new record is visible. Thanks for all of your help with...

The "Allow Edits" is "YES". I even tried this command and I got the same error "DoCmd.RunCommand acCmdUndo"

Hello, I am trying to copy a record in a form using VBA code. I checked online and I am not finding anything that works. This is the last set of code that I found, but I am getting the error above when it tries to run the last statement of PasteAppend. Here is the code: DoCmd.RunCommand...

I found that what I am trying to do wouldn't be feasible. I have created VBA code that goes through each record that is in Access and then uses ADO to update the record on SQL Server. Thanks for everyone's help!! Eddi Rae

Yes, the SQL I mentioned is SQL Server. The values that I will be updating are in a table that is in Access. I tried creating a pass-through query using that table in Access to update the SQL Server, but it stated that it wasn't in the SQL Server database. Here is what I am wanting to do...

Hello, I have an issue that I need help with. I have an SQL table that uses bigint on the primary key field. When I lilnk this table into Access 2010, this table is not even visible because bigint isn't recognized by Access. I have a field on this SQL table that I need to update and I was...

Hello, I am working with an Excel file that has multiple sheets. I only want to pull from one of these sheets that is named "Roster". I am working in a Macro and trying to use the ImportExportSpreadsheet function. I am not seeing where to let this function know that I want to pull data...

Hi All!! I am working in MS Access 2007 and trying to create an TransferSpreadsheet export to a specific range in a file that already exists. I have headers that I want to keep and I want to start the export in A3 of the specific worksheet. I am getting a Run-time error '3125' '' is not a...

FYI!!! I created a macro doing the same process as the vba code and I am getting this same error. I am working in Access 2007. Is there an option that I need to change?

It is showing the file and the path for that file.

On the transfertext statement. It says it cannot find the file

Hello, I have created a subroutine that allows the user to select the file that they are going to import into the Access database. My issue is that after the file is selected, the variable is displaying the complete path and file name, but I am getting an error that stated: "Run-Time error...

I found a way to do this. I used a command button and then scripted it to determine what to run. Here is the code Dim db As Database Dim rs As DAO.Recordset Dim qdf As QueryDef Set db = CurrentDb 'Determine if there are letters for New Cat 1 Set qdf =...

Hello, I am using Access 2007 and I have a macro that currently has seven reports. Some times there isn't any data for the reports. For those, I don't want to have them run at all. I am not sure how to use the "Condition" expressions in this instance. Any suggestions? Thanks!! Eddi Rae

Hello, I have an MS Access database that already has all the queries that I am to use in the VB Application that is to be set up to run automatically on a server. These queries pull information from tables that are using an ODBC connection and updating a table in the Access database. Explain...