Search results for query: *

I did this and I ran into a couple of problems. First I couldn't reference a cell on a different sheet. So I moved my list over to sheet1 just to see if I could get it to go. The next problem I encountered was that it seems I can only create 3 conditions. I have more than 3 colors I need so...

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'm fighting through this as best I can on my own. I have managed to write some VB code that updates the commission to the correct value for the current year. One problem is I'm having to do it as a click on a command button instead of autoupdate. I couldn't seem to get this code to work in...

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...

Ah Hah. I've found a better way to do it. I just made a crosstab to sort by month. Thanks Richard for helping out.

Richard, Thanks for the reply. We're a little off of what I'm needing but I might be able to work off this. In the mean time, let me explain better what I'm doing. I'm trying to count the amount of new customers entered into our database for each month. Our new customers are identified by...

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...

Good Call. I forgot about that sample database. Let me check that out. In the mean time nobody should waste their time on this thread unless I cry for help later :).

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 resolved the issue. The problem was the digital certificate. It somehow got corrupted when I was changing my network settings. I removed it and re-imported it and everything is working fine. Thanks Serbtastic for attempting to help.

It's just your basic this page cannot be displayed error that you get in internet explorer when you can't get to a webpage. Cannot find server or DNS Error Internet Explorer

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...

Update, We have found that if we copy the database to the administrator's machine and set the directory to shared all users can access forms changed by the administrator wihtout any problems. So the issue is now between the admins machine and the server.

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...