Search results for query: *

Remou (Man it would be alot easier if you could edit posts and quote replies on here!) My current setup has the comman button using Open Form to open the form. The problem is that it displays all the records and I need to omit other owner's pets. Hence my post. I know how to get it to open...

here's a screenshot of the form. What I'm trying to do is allow the user to check boxes to charge for services, and be able to see the total cost in case the customer asks. http://www.fox302.com/index.pl?s=vf&user=Mikeyis4dcats&category=HELP&file=appt.JPG The fees are based on an IIF...

The subform displays the proper information, my trouble is getting the pop-up form to restrict the records to records for only that client. here's a screenshot of my Customer Info form http://www.fox302.com/index.pl?s=vf&user=Mikeyis4dcats&category=HELP&file=screenshot.JPG Here's a screenshot...

my ultimate goal is to print a report as a receipt, showing that the selected services cost $X and the total was $Y. If I shouldn't save the values in a table, how could I structure a query to obtain that information off the form to display on the report?

I see the Find Record option under the wizard, but that promtpts the user to enter information. I need the button to return record where the CustomerID is a given number. Say, for customer #5, to only return records where the Pet's owner is Cutomer #5. If there are no existing records for...

As I explained in another thread, I want to use a command button to open a form to enter a new record or edit existing records for a specific customer. How can this be done? Remou mentioned in the other thread that one could use a DoCmd.OpenForm argument, but I am a very basic Access user and...

I have a field on a form that is calculating service fees based on whether a box is checked or not. I would like this field to populate a corresponding field in the table the form is based on. How can this be done?

I am working on a form and in the process I deleted an existing command button. When I went to place a new command button on the form, it will not allow me to do so. In fact, it will not allow me to add any features from the Toolbox. I have the wizard button depressed, so that's not it...

Skip, I am aware of that. The problem is that the phone numbers are ALL wrong. For starters the area code (primarily 785) is wrong, it shows 737 or 734 for almost every entry. For example, if the record shows 785-555-1212, the entry may looks osmething like 737-555-1212, but to...

Anyone have any idea why when I try to import an Excel spreadsheet with contact information into Outlook, all the phone numbers are wrong. Ex. 785-555-1000 appears as 737-444-0000. I have stipped out all formatting to get raw numbers and still no luck. This is with Excel 2002 and...

Ok, I see the issue....I was really trying to simplify it but made it more complicated. The merge document has a cell B20 that's pulling an INDIRECT from the data worksheets. It did just dawn on me that it probably won't work that way. How can I change the VB to accomplish this: If the...

Skip, Every row has a property valuation in B20....if it hasn't been done, the value is zero. I want to skip reports where the property has no valuation. I DO want to print the report for all properties with a valuation in cell B20.

I should clarify that this report currently prints for every row with information specific to that row. It prints over 200 reports, and I want to weed out the 50 or so reports where the row has B20 = zero.

Brad, Thanks a BUNCH for your help. Here's what I've got: A list of properties in a spreadsheet, over 200 rows Each row had a value (B20) that is either a number or zero. I want to merge a report that prints for all rows where B20 is NOT zero, and skip printing for that row when B20 is zero...

Sorry i didn't explsain better. That code is a mail merge app for Excel. Currently, it prints a page with some additional text on it merged with the info from the cells for every row (record) on the spreadsheet. I'd like it to skip printing a page for any row when a certain cell's value is...

Can someone help me alter this VB Code to skip printing the current record and move to the next record if a cell "B20" is equal to 0? Any help is appreciated... Code follows>> Sub PrintForms() Dim StartRow As Integer Dim EndRow As Integer Dim Msg As String Dim i As Integer...

Any way to remove the Internet Newsgroups folder in the Public Folders? We have no use for it and it is cluttering up our organization...

We are trying to demote a domain controller in relation to my post about Problems with DB2 and Domain Controller. My IT Consultant is getting an error message saying that Administrator does not have access and to use an account with Enterprise Rights. The Admin account DOES have full...

I want to do just the opposite. I have a sheet with hundreds of phone numbers and contact info to import into Outlook. I need to convert ########## to ###-###-####. Ideas?

Thanks for you help. I will look into it!