Hello,
I am trying to generate a report that displays currency in a few fields. However, I want the currency to change, based on which country is selected. For example, there is someone in th...
I just added some linking between my Access d.b. and Outlook, so I added the Outlook 11 reference.
what if someone has Outlook 10? Would this still work with just the Outlook 11 reference?
I have a SQL column that stores a BLOB which contains labels and values. I want to search the string for the label and then grab the value associated with it.
for example in the BLOB bel...
Is there a way to make a design like this:
I want to open an Excel workbook from an Access switchboard....
Once the file is open there is a button on the worksheet...
When I click the but...
I'm starting to use a lot of functions in modules. I find that it would be nice to somehow "include" a module into a form, so that its functions can be accessed without having to type module1....
In an Access form, I want to clear a txtbox with VBA code. Is this possible? If so, what's the code?
hi
i am using access 2007 and calendar control 12 and wan't to change the back color for a single day , but have no idea where to start with this, is there anyone who can't point me in the...
I have a front end and backend database.
The backend database sits in a folder ("C:\mfsp\mfspb.mdb")
I copy the front end, in the front end I need it to loop through all the tables in th...
Hi
I would like to model an investment portfolio's benchmark in MS Access. For this one could use a formula, say the benchmark return during month 't' is:
benchmark(t) = constant + a *...
I using vba to create an Outlook 2003 email from information in an Access 2003 database. I have the code in place for my addressing needs. In the body of the email I need to loop through a rec...
I realize that when you import an Excel spreadsheet into an existing Access table, the fields need to match. Is there anyway to import to an Access table that has some extra fields added?
...
I found the code below on an old post from the year 2000. I'm an trying to input into my database but I receive a Run Time Error '13': Type Mismatch. My thought is the syntax may be differen...
I am trying to use a floating calendar. I got the code from http://msaccesstips.com/2006/09/command-button-animation.shtml
It works when I open the form by itselfs (Not as a subform).
...
I have a text box with the code
DLookUp("Month 1". "tbl_revenue", "[MID] = #" & Forms!frmreporting!subterm.form!txtMID & "#")
However for some reason it wont work.
i get an #ERROR d...
I have a combo box that is populate by a table. It is populate by the field name. The table also has another field, it is an ID field (Integer). When a user selects an item it will put what...
I found code on exporting access to excel in 01.24.2008 at 03:51AM PST, ID: 20732116. This created one workbook with multiple sheets. How can I alter the code to create one workbook for each...
Every two weeks I create Salesmen Commission Reports, 4 for each store, using ACCESS.
Before I send them to the printer, I open each one in Word as a Rich Text Document, then save as a Wor...
Hi experts,
I am trying to requery a list box that is on a sub sub form. The sub sub form is on a sub form and this sub form is on a switchboard (main form).
I have another sub form on t...
Hi,
I have this code (see example).
This is uploading and then downloading the same files to a temp folder on my computer. I'm trying to find a way which i can then compare the two fold...
Hi,
I have this code (see example). I was hoping that it would upload the files in C:\Documents and Settings\Desktop\TestFolder\email
To
/var/www.html/email
However, nothing happ...
StockCode QtyOnHand ReleaseQty QtyOnB/O
AAA111 1000 994 6
AAA111 1000 988 10
AAA111 1000 978 ...
Hi everyone,
I have a Microsoft Access project. It contains a table with a Date/Time datatype.
But in this column, I do not want to store full-scale date time. I merely wanna store time ...
Hi, I am creating a database where I use a combo box to select a company name which then filters by companyID.
I can use the inbuild function of the combo box to do this but i dont want to, t...
