MS Access 2003 writing MS Access 2000 database.
I just started trying to write VBA and put two previous code pieces together and of course it does not work. I want to pass a three letter code...
I have table (supplier) which simply combines two primary keys from two other tables Contacts and Items, supplier uses the primary key from items as its own primary key. In a certain form ther...
The answer provided on http://www.experts-exchange.com/Microsoft/Development/MS_Access/Access_Coding-Macros/Q_23859211.html is no longer valid.
The question was "Has anyone seen a 3rd. part...
In Access 2000 I used to be able to do:
MyOptionGroup.value=3, which would select the Option Button that has the OptionValue of 3 assigned to it.
But now in access 2003, I've created an Op...
*************
* Background *
*************
I need to store and update data in a load of global variables:
- When I load up forms I pre-populate the fields with this data.
- When control...
Is it possible to call a private sub let's say 'mysub' on 'myform' from another form 'myotherform'?
The call statement would look something like: myform.mysub in the code for 'myotherform'
I am accessing an excel sheet through VBA I want to set the focus to a specific sheet in the excel workbook. Everything works except for the fact that if the workbook opens to a different she...
I have the following:
strSQL = "Select a ton of stuff"
Set rstTonOfStuff = db.OpenRecordset(strSQL)
db.Execute "Insert Into table (field, field...) Select " & rstTonOfStuff!Field & " ,...
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
I have a spreadsheet with a macro that runs and protects each worksheet. I need to unprotect a specific range in the sheet so that users can type in new numbers. The Columns that need unprot...
Hello all,
I have struggled with this for the past few weeks. All I am trying to do is transfer data from Access to excel via a command button. There are 2 Things I would like to do:
1.D...
I have a MS Access database opening daily, loading a form, running some VBA code on the form open event and saving some reports to a folder then closing the form.
I am having trouble shuttin...
I have a program for sending emails through Outlook I got from BlueClaw. It sends out the same message to about 300 email addresses one at a time. The problem is sometimes Outlook gets backe...
I'm working on an Access project where I need the VBA API for the "Folder Dialog." I'm not sure what the recognized name of the dialog form is, but it's the form that allows the user to selec...
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...
Hi All,
I am developing an Access 2003 application. The application runs from XP clients in a Windows 2003 domain environment. The app is broken into Front-end mde (XP clients) and the Back...
I'm running Microsoft Access 2003 and I'm trying open up a form based on the selection in a subform which is based off of a query. Ideally, when that record is selected(double clicked) I want...
HELP! I'm about to demonstrate my application to some people and all of the sudden its not working.
In the afterUpdate event, I'm selecting item_total from a table and everytime I run this ...
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 have been coding in Access 2007 and it has been coming up with the errors;
"There isn't enough memory to perform this operation. close unneeded programs and try the operation again"
Exam...
I recently upgraded to Access 2007 and can't find a way to export to a csv file either using the UI on the ribbon or in VBA. I expect to use transfer text in VBA but expect I will need to crea...
I'm creating an Access program such as when a button is clicked, it will open 50+ word documents, one by one, then perform a procedure such as getting all the data the document contains. Gi...
I have a motorola i335 that Ive been trying to get unlocked. I asked motorola and they say talk to my provider. I call my current provider and they say talk to the provider the phone from. ...
Right now I have a database that contains liked SQL tables. If I want to analyze data "offline", I simply just cannot copy the database as another .mdb file because the tables are copied as l...
I have a form in Access that sets up a training event. The training coordinator selects the time and location and the attendees from a listbox. I have added a button on the form that is intend...
