Recent content by annsolomon

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

Thanks, Skip. I wonder why the dash is accepted but not the slash. Do you know where I can find a list of other restricted characters? By the way, I intended to collect weekly data on each sheet so 1-1-08 is a Week Ending date. Do you still think I'm off base here? Ann

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

Boy, is my face ever red right now! I had the strLink and strErrorCode lines in reverse order. Thanks so much for your patience and excellent advice. Ann

Pete, here's my Locals window after completing the DoCmd.OpenForm line. strLink is still empty : strErrorCode : "0155" : String : strFormName : "frmErrorCodes" : String : strLink : "[EOB] = ''" : String Ann

Pete, you're right about it being an apostrophe thing. My form now opens but it opens to the first record rather than to the record with the error code I input. I've played with the placement of apostrophes (which is why it took me so long to get back here) but I can't seem to make it filter...

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

Boy, do I feel silly. I forgot all about using OR. I've been out of the look for almost two years and it's amazing how much I've forgotten. Thanks for your help. Ann

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

Thanks, Pete. I've been away from Access for a year and a half and it's horrifying how much I've forgotten. Thanks for your timely and accurate feedback. My report now works perfectly! Ann

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

Ben gave me several pieces of helpful info and advice and I'd like to award a star but my browser is acting up. Is there some kind soul out there that wouldn't mind posting a star on my behalf? Thanks. Ann

Thanks for helping out Ben. I really appreciate it. Ann

Thanks for the advice about queries vs coding SQL. I decided on using spaces instead of the crlf option but now I get Error #2342 (a RunSQL action requires an argument consisting of a SQL statement). This error has me totally clueless. Ann

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" _ &...