Hi, I have an Access module that parses data and creates individual spreadsheets. I'd like to add on the first 4 rows of the Excel spreadsheets some header information (i.e. company name and ...
I have a form (frmMain) with a subform (frmMain_Sub).
In frmMain_Sub, i have a public subroutine in the general section of the VBA code:
public sub HideControls()
me.lstHMI.visible =...
I am using the Outlook mail object to send EMail programatically from an Access app.
Outlook must be open for .Send to work.
How do I find out if Outlook is open. I need to open a messag...
i need a variable to be available to all forms in an access database
i created a module and inserted a public sub that sets the string variable to some text but when i call the sub from a f...
I am adding a set of data from an access 2000 form to an access 2000 table. This all works well until I close and reopen the database. before the database is closed all records are concurrent....
I have a very simple form that I enter temperatures for a range of dates. The fields are Date, High, and Low. The record source is a table called tbl_HighLow. For this particular tables fun...
I have a database, created in ms sql server management studio express, that is maintained in access 2003. I have the following columns: LoanNumber, LoanAmount, LoanTerm, LoanDate, InterestRat...
I have a database of calendar type items. I generate a weekly report that pulls all records with a Start Date of the current date through the next three months using the following function: Be...
Hi,
I want to categorize existing numeric Fields.
For example,
Say, I have Field called [area]
The values of the field in each record are range about 40 to 200.
I want to categorize the ...
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...
StockCode QtyOnHand ReleaseQty QtyOnB/O
AAA111 1000 994 6
AAA111 1000 988 10
AAA111 1000 978 ...
Hi,
I use global variables in my login code [Global CurUser As String] so that i can call the users name when ever i need to add it to a specific database process. My question is, how do i...
I am trying to retrieve and catalog the objects that reside on a list of 115 Access Databases to eliminate duplicates and give certain users access to certain objects in certain databases.
...
Hi,
I have this line of code:
DestinationPathAndName = systemfolderpath & "\" & "documents"
Which sets a path for a document which is being added into the database. What i'm trying 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 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...
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...
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...
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...
Here's my situation
I have 2 MS Access 2003 tables in order table and an order detail table
here is a sample layout for the order table
order_id order_date
1234 2008071...
For example, let's say I programmatically add several fields to a table. Those new fields are placed at the end of existing fields in the order created. How do I reorder the fields programma...
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 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...
