Search results for query: *

Hello. I have a database that needs to be accessed at times by more than one person. In other words, Employee "A" opens the database. Since Employee "A" is the first person to open it, she/he would be able to add/delete/modify records as necessary. While Employee "A" has the database open...

Hi. I'm attempting to upgrade from Office 2K to Office2K3 and am getting the following error message: CR561401.CAB Not Found This CAB file does exist on both the CD and on my HDD (I copied the CD(s) to my hard drive). I've pointed to both locations when prompted and continue to get the same...

Hi. I was wondering if there's a way to take the decimal value of a month and covert it to the string value. For example 1 = January, 2 = February, etc

Hi. I recently developed an Access 2000 database for a client. She recently upgraded her computer from Windows 98SE to Windows XP. The program ran perfectly on her Win 98 OS but is now getting a #Name error in a combo box. This combo box uses a "month" table to allow the user to "enter" a...

Hi. Was just wondering if it's possible to have Outlook (2K2) folders displayed non alphabetically? For example, Under "Inbox" folder, I have 3 sub folders: Aardvark, Tiger, and Zebra. Is it possible to have them listed in the tree as: Inbox -Tiger -Zebra -Aardvark This question...

Hi. I'm new to XML and will be taking a formal XML class next month and have been doing some pre-emptive studying using the (working) code below. I was hoping you'd be able to clarify something for me: The first line is the version/character set declaration. The second line is a "comment"...

Hi. I'm new to XML and hoped someone could recommend some resources (books, etc) to get me started. Many TIAs K

Hi. After reading the FAQs and the posts here referring to limiting the values of one combo box based on the value selected in a different combo box, I've tried to set one up myself but am having a problem. Here's what I'm trying to do: Enter an Insurance Broker's information (name...

Hi. I have an Access 2000 database which tracks finncial brokers and their commissions. Up to now everything has worked fine but the client has called and wants me to "fix" a limitation on report generation. I think my question will make better sense if I give a brief synopsis of...

Hi. I'm sure this has been addressed already, but I have been unable to find the answer so please pardon me for asking it again. I've created a report that lists the top 50 sales people (based on total sales obviously) for a given month. I use the "Top Values" function and it works...

Hi. I know I saw an answer to this question somewhere on the forums but can't seem to find it. When printing a report (either preview or hard copy), how do I change the field's colour to red if the value is negative? For example, if the report is as follows: Name CompanyA CompanyB...

I have a report that uses an underlying select query (which is based on a crosstab query). This report allows the user to generate sales figures for all salespeople within the company for a selected month. The user gets prompted to enter a month (1-12). For example, we have 100 salespeople...

Hi. Just wondering if anyone knows of any problems when running an Access database created in Access 2000 and running it with Access 2002? I have been working on an Access 2000 project (let's call it Version 1) and copied it to a computer running Access 2002. I then installed an updated...

Hi. I'm have a report based on numerous select queries and one crosstab query. This report is set up as follows: Sales Broker Comp A Comp B Comp C Comp D Total John Chevy 150.00 100.00 250.00 Mary Dodge 80.00...

Hi. I have a select query based on a crosstab query. All the fields are number (currency) fields. I needed to check for NULL values and used the following to great success: OakvilleUNUMMS: NZ([qryYTDBusLSMS].[qryYTDBusMS_CrssTb.UNUM],0) Thus, if the value of "OakvilleUNUMMS" is...

Hi. I've created 4 separate queries that each lists the top salespeople (by total YTD commissions) depending on their office location. There are 4 different office locations (NYC, Chicago, Philly, Miami) hence the 4 different queries. I've put the name of the office location in the...

Hi. Here's one for the pros! I have a database that tracks sales commissions for our team of independent salespeople. The commission calculations are based on forumulas dependent on the individual sales person and the company that the sale was made on behalf of. For example, Salesperson Jane...

Hi. I'm creating a tabbed control to use as my switchboard. I was wondering if it were possible to change the tabbed control's background colours? I changed the form's background and now want to change the tabbed control's colour to contrast a bit better (gun ship gray isn't always the most...