Search results

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

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

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

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