Search results

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

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

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

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

I am using MS Access 2003 on Windows XP. When I am in Design mode of a form, I am trying to open the "More Controls" from the Toolbox. It is not displaying the list. It is not coming back with any error. When I go onto the C:\Windows\System32 folder, I see the OCXs and the DLLs that I am...

I have a combobox that is filled with an ID and a name of all the active users. The data is being pulled from a table. I am concatenating the first and last name together. Here is the code: Trim([LastName]) & ", " & Trim([FirstName]) I am selecting the user from another form and placing...

Hello, I have a form that has a layout like a spreadsheet to be used for scheduling patients. I have the text boxes on the top to be the interns, the text boxes on the left to be the time slots and what is in the middle are the patients. When you click on a text box in the middle, you get...

Hello, I have created an Access 2007 application on my computer for a client of mine. I have split the database so that the data is in a separate database. I emailed both databases to the end user and suggested how to place the databases. He is working from home at the moment, so he is not...

I am adding queries that I created in Access to run in an application. I have given you the meat of the subroutine. The tabledefs.delete is working. It is the rest of the process that is not working. The queries are not displaying any data when I know there is data. If I run in Access, I get...

I am using MS Access 2003 on a Vista machine. I have a database that has a table with two text fields, Bank (2 chars) and BankNbr (3 chars). I have a form that has a text field to enter the Bank. When you click the command buttion, it runs the following code. I am getting an error on the...

Hello, I have added Office 2007 to my PC. I kept Office 2003 in tact so that I can still use Access 2003. When I use the Open With .... to determine which version I am using, I am getting the pop-up that it is installing that version. Is there a way to have both co-exist on a PC...

I am trying to link to some Paradox tables in Access. I am getting the error message of "external table is not in the expected format". I am not sure what to look for. If anyone could enlighten me, that would be great!!. Oh!! My OS is Vista. Thanks for your help in advance!! Eddi Rae

I am trying to add the datalabel via VBA so that it will display the number when viewing. I don't see anywhere that does this. Does someone know how to do this? Thanks in Advance, Eddi Rae

I have an application that is creating pivot tables for multiple users from a base form. This form is copied to create the users pivot form with their name as the form name. What is happening is that if a user has the database open and has his form open, the next user gets an error on the...

I am creating a pivot chart that right now creates the chDimValues using the SUM of the fields. I am needing to use the AVERAGE of the fields. Has anyone done this using VB behind the scenes? I cannot locate how to do this. Thanks for your help Eddi Rae

I was wanting to see how I can delete the additional totals that are being created whenever I open the form. I am programmatically changing all the elements using VB. Since the Totals is displaying the number (3), I want to delete all the totals fields before I open the form so that there is...

I am trying to create a pivot chart that the user inputs what information they want for the series, filter, category before they get to the chart form. They input the information on a form from drop-downs and then they click a button that takes them to the pivot form. The data is based from...