I have an excel spreadsheet with one column as a combo box whose list is populated from values on another sheet in the same workbook. It is set up as so:
Sheet1
Name | Value | Type
PartA $100 (Combo Box Selection)
PartB $200 (Combo Box Selection)
Sheet2
TypeList|
TypeA1 (Shaded Red)...
I am making a database for real estate companies to keep track of their agents. Their commission rate is determined by the money value of their sales per year. The commision rate must autoupdate when they hit a certain point.
What I have done is create a crosstab query totaling their yearly...
Here is what I am trying to do:
I want to count the number of Type 'A' and Type 'B' orders I have made per month and display it on a form.
I know I can easily make a query to calculate each individual month and display the results of that query in a form. But I would like to include multiple...
I've been messing with Access long enough now that I should know this but for some reason this one is kicking my butt.
I have an Access database with mutliple tables:
Customers
Products
Orders
I need to be able to create an order, using autonumber for order id, that can have many products on...
My office is having issues with it's network printing. We are running NT Server 4.0 which spools jobs to a HP JetDirect EX Plus print server. Small print jobs have no issue. Larger print jobs will begin to print normally but will restart at random points into the job. There are two printers...
I have recently installed a windows server 2003 (SBS) at our office and set it up to handle our internal DNS request (for active directory) and set to forward all unknown request to my ISP DNS. Everything works great except for one website where we use a digital certificate. I can get to the...
I don't even know if this is possible but it would cool. Is there a way to create a hot link in an email message that takes you to a record in an MS Access database?
I have a combo box on the main form with values (1,2,3,4). I want to only display a subform nested in the main form if the value of the combo box is 4. Here is the code I have on the afterupdate on the combo box.
If STATUS = "4" Then
ORDERS_subform1.Visible = True
Else...
I'm trying to set up a multiple monitor display for my machine. Machine Specs follow:
Asus A7N266-VM/LAN/AA
AMD Antlon 1500
512 Ram
Windows XP Pro
The Asus board comes with a GeForce 2 onboard. I've came to the conclusion that It's not possible to do the multiple monitor option by using the...
I am running an Access 97 database stored on a server. I have about 6 users adding/chaning records everyday. Recently we have added a new database administrator and purchased a new machine for him. Whenver he makes a change to a form from his machine it prevents all other machines on the...
I have a parameter query with MACHINES as my column heading and DATE as my row heading. The value is the amount of money a machine makes on a particular date. I need to know how to get the sum of the money a machine makes for a range of dates. So I either need to sum the entire row of a...
I just upgraded my computer to a 550MHZ machine. I went ahead and reformatted my hard drive and reinstalled windows 98. Everything worked fine at first but when I installed the new driver for the motherboard IDE controllers my cd-rom detects every cd as an...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.