I have a MS Access subform called "Verify". Within verify, there is a field "approved", which is a True/False field. I would like to add a combo box to filter the subform based on the field fo...
I am using access 2003 to open a spreadsheet with 250 sheets. Splitting those sheets into single excel 2003 workbooks and adding some data validation to them via VBA.
Everything was workin...
I have created a form that displays, in labels, information based upon the user's selection from a combobox and allows to edit, delete and create a new record in another form from textboxes(VB...
Automatic Export of a Access 2007 in a Tab Delimited format.
I have a program that I need to export a table T_ExportToAccounting that I need to export in a tab delimited format on to a floppy...
I will like to compact and repair my database each time it closes automatically. Is there VB code that can be used to perform this task. How will this code affect the database if more than o...
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 ...
Hi,
I have inherited some Excel Sheets and Access databases which use the BLP Add-ins to retrive data from Bloomberg.
The Access database is using the Subscribe method - example code below....
Access 2007 VBA - This is probably very simple so appolgies in advance...
I have two forms open. All I need to do is to save the current record in form1 from form 2 (which must keep the focu...
I am using access 97, I would like to be able to make use of a hash-function in my vba code. Does anyone have any examples?
Many thanks
Matt
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 want to send data from a large recordset in VBA, MS Access 2000, into MS Word 2000. The data gets put into cells in a table. The user can set up the table in Word and in the Access program c...
Using Microsoft Acess 2003, VBA coding on Windows XP Professional with Microsoft Outlook 11.0 Object Library.
Trying to find the VBA code to (1) look up a person's name in the address book ...
I have a Access table with a string field ("comments") set to max. 255 characters. I am simply trying to read this value in VBA for a particular record and write it out to a text file. Here'...
I need to be able to go to a website and have VBA automatically enter the Login, Password and client code (all of which I have) and move to the next page.
The following code navigates ther...
Experts,
Can you please help with the code below.
I have a query that returns the number of rows, and I want to assign that value to the variable lnCountReload.
When I try to execute,...
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 ...
I have a button on a form that will delete the current parent record via Me.RecordSet.Delete. This parent form has 5 subforms. Each subform is displaying a record associated with the parent ...
I'm importing an excel spreadsheet in vba code, after it imports there are tons of blank records in the table. Is there anyway possible to not import blanks?
I am using MS Access 2003. I want to have my database open up in maximized view when opened. I have a form open up on startup and I need it to open maximized. I created a macro and in that mac...
I've been working on this piece of code and can't figure out why I'm receiving Run-time error '3020' Update or Cancel Update without AddNew or Edit. I'm just trying to located a record id and ...
Hi
I am developing an Access 2007 application which needs to manipulate an Excel 2007 document. The VBA needs to save an existing Excel doc as a PDF using the Office 2007 Save as PDF add-i...
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...
Hi people - long winded explanation follows...
I have an access application which prompts the user for the location of an Excel file, and imports the data into a SQL table. However some of...
I would like to write a procedure that will link all tables in a SQL I have named all of my tables beginning with "tbl" and all of my views begin with a "v". Is it possible to programaticall...
