Search results for query: *

I'm teaching myself Excel and hope some kind soul will help me get started. I picked what I think should be a very simple starter project. I created a sheet that lists grocery prices at several neighborhood stores. I want to compare the prices and list the lowest price in a separate column...

I right-clicked on the sheet tab and attempted to rename the sheet "1/1/08" (without the quotes). The slashes are not accepted. How can I use special characters in the sheet name? Ann

I have a command button that, when clicked, is supposed to open the popup form called frmErrorCodes. But I keep getting error #2450. I don't see any typos. Anyone see what I'm doing wrong? Dim strErrorCode As String Dim strFormName As String Dim strLink As String...

I want to track the balance due on our health claims. I have a TransAmt field and a TransType field (e.g., "Approved", "Denied", "Pended", "Adjusted". I only want to consider TransAmt if the TransType is "Approved" or "Adjusted"; Claims that are pended or denied still leave the full balance...

I have a report based on a query that lists TransAmt and TransType (payments and denials of payment) to various health care providers. The report is grouped first on the provider then further grouped by TransType. For each provider I show a total for each TransType and a grand total for that...

I've shied away from coding SQL statements and have always used queries instead. I'd like to learn how but got Error #3075 (syntax error/missing operator) on my first attempt: DoCmd.RunSQL "SELECT DISTINCT qryScheduleAppt.WONumber, qryScheduleAppt.ContactID" _ &...

I'm trying to follow the advice I found at thread181-48619 but can't get it to work. I end up with no report title at all. I declared GetReportTitle as a public variable in a standard module. I have this code in a Select Case statement: GetReportTitle = "Need PO&quot...

I have a form that allows the user to enter a filter into a text box. (i.e., open frmEmployeeData where ContractNumber = some text value the user enters) It works fine if I have employees assigned to that contract number. But, if no employees are assigned to that contract number my form opens...

I want to prompt the user for a purchase order number (using an inputbox) then open the form for that specific purchase order. My inputbox works and the correct purchase order is opened but I get a second prompt for the parameter FindPO. How can I set the Where clause of DoCmd.OpenForm to use...

I have an unbound main form that uses a tabbed subform with several pages (e.g., Work Orders, Contacts, Faxes, etc.). Each page has a Save command button on it but the one on the Faxes page doesn't want to work. I keep getting Error #0 with no error description although my error trapping code...

One of my users has an Excel spreadsheet that she uses frequently. From time to time, it prints out very small and in the top left corner of the paper. I'm not very familiar with Excel and haven't been able to help her. Anybody have an idea why this might be happening? Ann

I have a purchase order (frmPO) that has a combo box (cboVendor) to select a vendor. Once the vendor is selected, the various address lines are automatically populated. Below this, I have a combo box (cboPOC) to select the vendor point of contact. Right now, the box displays all POCs in the...

I have a Work Order report with fields for the customer's home phone, work phone, and work phone extension. Frequently, we don't receive the customer's work phone. When that happens, my report shows the Work Phone label and an empty space beside it which is okay. But beyond that empty space...

Can anyone tell me how to find the hostname of a computer on my network if I have their IP and MAC addresses? Ann

Hi folks. I'm absolutely awed by the number of smart people in this forum and have learned so much from y'all over the past months. I'm really a database application person but my company wants me to get more involved with desktop support. They sent me to A+ training (hardware & OS) and it...

I've used Access for years but haven't figured this out yet. I place a label in my header, stretch it across most of the page, then center it. Looks good. Later, I decide to change the wording in the label. When I leave the label, it shrinks and I have to stretch it across the page again...

My boss uses Netscape Messenger on his laptop to get his email and a most curious thing just occurred. He was deleting a bunch of junk mail from his inbox and, instead of the remaining messages moving up (or down), blank lines remained where the deleted messages used to be. Refreshing the screen...

I'm trying to compare invoices generated in May of 2002 to invoices generated in May of 2003 so we can see how much money we made compared to last year at this time. I've tried datediff, dateserial, dateadd but can't seem to get it right. Can some kind soul give me a hand here? Ann

I moved my front-end/back-end databases to a new location and need to relink the tables. In the past, I simply told the wizard to select all tables, checked the box to prompt for a new location, clicked OK, then entered the new location of my back-end database. Now, all of a sudden, I'm being...

Dim CurrentCycleDate As Date CurrentCycleDate = DLookup("CycleDate", "tblCurrentCycleDate") DoCmd.RunSQL "Delete [Tables]![tblHistory].[CycleDate] _ & WHERE tblHistory.CycleDate= #" & CurrentCycleDate _ & "# from tblHistory;" I just can't seem to get a...