Recent content by Leigh46137

I'm working with an Access Runtime database. I had to split it in order to be able to make modifications to the user interface. I cannot modify the backend database directly - I can only do it through code. (If I could do it directly, this wouldn't be an issue :) ) As far as I know, I cannot add...

Thanks, but I found that one too. Here's what happened when I tried it: cnn As New ADODB.Connection Compile error: User-defined type not defined

I have a runtime Access database that I have developed using Access 2007. I need to change my price field type from Currency to Decimal. I have to have 2 decimal places and I cannot use the Currency type because I have to export this table to a text file; the program I have to import it into...

The qTransactionSumm is not 'already running'. It is a saved query that would return the sum of all invoices and all receipts for all clients. I want to just run the query but add criteria to return the totals for only one client. This method works perfectly for normal selection type queries...

I’m working on an Access 2007 database. The table named “Transactions” contains the fields: “TranType” (text), “Amount” (currency) and “ClientID” (number). The query named “qTransactionSumm" groups by TranType and sums the Amount. When the user selects a client on a form (lstSelection combo...

Thanks! The Transfer Text method works! I never knew about that one. :)

I have an Access Runtime database (Created in version 2007) that exports the results of a query to a text file that gets uploaded to another application. I have a button that just opens the query for viewing and that works fine. I can scroll through the records and don't get any errors. The...

I wish I knew what caused this to happen. It was working fine on my machine until after the client had problems. Then it started doing the same on mine. I have changed my saved import to import as a "new" table (overwriting the existing one each time) and that works fine.

OH! The trusted location thing might be the problem. When I open the database it gives me the message that it isn't trusted and I select the option to allow the blocked content. Do you think it is still blocking this operation even though I said to allow the content? I did try setting it as a...

I don't think the warnings are turned off. I know I don't have any code that turns them off. I'll run that warningson code just to make sure. I have not tried importing to a new table. I will try that and see what happens to help determine what the problem is. The database is on a machine at...

Strangest problem I've ever seen in Access! I have an Access 2007 database that needs to import from an Excel file. My code just runs a stored import procedure. When that didn't appear to be working, I tried it manually. I clicked External Data, Import Excel. Browsed to my spreadsheet and...

I have a database application that I created in Access 2007. It is split to separate the data from the interface. I have made a runtime application to run it on other machines without (full) Access installed. Now I need to add two more tables to it. I have added very simple tables before, but...