I need a VBA Function to retrieve all File Names in and below a directory root. So if I browse to a folder root say S:\Office_Files\ A Text Box named TxtPath will contain the value S:\Off...
I have a large database running just fine in Access 2003 on my computer. I copied the entire database and sent it to a colleague for him to use. The import portion of the database works fine ...
I am comparing the field in a table to one in a combo box on a form.
I can't call the function Like in the query design view. Access 2003 and 2007 is replacing the function with the call to a...
I know this question is asked daily, but for some reason I can't find a solution that actually works! I am simply trying to add a record to a table (SQL SERVER Back-end) and get the ID for th...
Create a Excel document using VBA or VB using specific MS ACCESS Data tables and fields to create a variety of excel worksheets with specified names on the sheets and data placed in specified...
I am using Office 2007 with Vista Home Version; I am working in an MDB by the name of IIM-TEST-EXTRACT.MDB. In the VBA code editor, when the run following function, I get the error message: ...
Heres the code I wrote, But It doesnt seem to work... in the debugger, even when I hover over form!txtcustomer and it says "form!txtcustomer= null" ; my then statement is never executed?? Any ...
Hi, I'm hoping someone can help me with copying a table from a corporate Oracle database to an Access 2003 database on a file server. I've installed the Oracle OLEDB Provider and Instant Clie...
When the user changes the data in a field in a form I'd like to display a message like
"Are you sure?" with a OK and Cancel button.
My attempt hasn't worked. When I change the SubCateg...
I have a large text file with about 100 fields that I import into Access 2007 with a Macro and a Import Spec that works fine. However I would like to write a VBA procedure to import this and ...
Greetings to all experts,
I have an issue that I would love to resolve and move on with. The main goal is to format an excel spreadsheet within the export code. I have a formatted sheet I ca...
I have a button on my form that automatically generates a report based on a query. Except for the address field (which should be filled in by the system) the data on the report is all previou...
I have the following:
Hi, I have two forms namely Dossier and Facture. Facture will contain the Dossier number. Now on the Dossier form, I have a textbox which should display the facture ...
In preparing to migrate to SQL Server, I need to write some code that would remove the spaces from table and field names. Here are the requirements:
From VBA in the front-end, go through e...
I need to create a formula so that a total can be divided by a calendar of only Week Days not Weekends.. This calendar needs to be based on a 4 - 4 - 5 callendar...ie..5 weeks in the months o...
I have code in the On Not In List event of a combobox. After the event fires, focus is regained on the combobox and the list is automatically "dropped down" (if this is proper terminology). ...
I have some VBA Code that goes to a specific directory, and allows the user to choose a file (excel spreadsheet) to open. I need to include in the VBA code, once the spreadsheet is open, it d...
Hi! For my Access database, I am looking for a VBA code that would:
- Open a windows dialog box and let the user select an excel file
- create an empty table called "Import"
- copy the cont...
I have two tables in Access. One each will have a string like this
County of Broward
and the other
Broward County
This is a very simple example. What I'm trying to do is find a m...
Hello. This is something I've tried to do several times in the past, without success...
I have a small Access 2003 mdb app that I've developed for a small biz. As they may changes and req...
I'm trying to take the value in a textbox on a form into a table using an update statement. The textbox value is populated by a calendar control, but when this is passed into the date/time fi...
Is it possible to dyanamically add controls to a report w/ VBA in its open event?
Do not want persistent controls, just want to add them on the fly as needed on each report run (they do not g...
Hello,
I've recently parsed 50k txt files (via cmd line script) then imported into an Access Table. I am attempting to clean the "Size" field, it contains a number stored as a string. There...
The below code is intended to delete the form record. The subform data is deleted via the "delete cascading records" relationship option. The button works with no errors and the final messag...
My old employer built a slick little tool that built an ODBC connect string in Access and then used that string to connect the Access front-end to a SQL Server backend. I know he used some op...
