Recent content by ImASig

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