Search results for query: *

Hello, I have a command button that runs a query and then outputs the query to Excel and then emails it. I did this using the docmd.sendobject. It works fine except when I package it using the Package and deployment wizard. This database is installed on a PC that only has the runtime version...

This works perfectly. Thanks for the tip. Have a GREAT Day! Stacy

Hello, I have a table with two fields called “Name” and “Address”. I have a query based on this table and these two fields. I have gone in the query design mode and typed [Enter Name] on the criteria line for the “Name” field. I did this so the query would prompt me to enter a name when...

Sorry about forgetting this. Thanks for the help. Name Job Title Home Address City State Zip Code Home Phone Category Department Birthday Notes Thomas Beasley Comp. Trainer 3443 cotton road Meridian MS 39305 (601)485-7707 SPS User IS 1/25/1943 3/1/1988 Warren E Lonidier Mailroom Clerk 12 east...

The format is an Excel spreadsheet. It's not a csv file or tab,comma, text delimited. Thanks.

Hi, I have imported some names and addresses from Excel into Outlook. It worked fine except that the birthdays do not show up on the calendar. I can read up a contact, go to the birthday field and retype the birthday and then save the record and it will then show up in the calendar. I do...

Thanks James and Markus for your help. I have an application I may sell. Do you know if it is legal to include the runtime version with an application you wish to sell or do you have to have some type of license? Thanks.

Hello, From everything I have read you must have the deployment and packaging wizard that is on the Access 2000 Developers version if you want run an application on a PC that does not have access installed. My question is this. Does the runtime version have to be installed on the PC before the...

Hello, I have a form with the following fields: Actually I have more but to make it simple I will look at three. 1. Month 2. Sales 3. JanSales When Jan is entered in the month field I want JanSales to equal Sales. I know I can do this with an IF statement using one of the properties of the...

Thanks Ken! This worked. Can you also use nested IF statments in the control source? Thanks, Stacy

Hi, I have a form with four fields. They are as follows: 1. Sales – This is a manual input. 2. Expense – This is manual input. 3. Profit = Calculated with formula (sales – expense). 4. ProfitPerc – Calculated with formula (profit / sales). Everything works fine. My problem is that I do not...

Thanks for the tip. When you say front-end and back-end setup what do you mean? I think I know what you are saying but I want to be sure. Thanks.

I am considering purchasing a copy of Office 2000 Developers Edition. I want to be able to run an Access Database on a PC that does not have Access installed. Has anyone used the developers edition before? How well did it work? What are the pros and cons? Would you recommend using it? Thanks...

DLookup("tips", "perdiem") Worked GREAT. Thanks for the tip.

Hello, I have two forms I am using to enter information about meals. It's an expense report. The first form is called perdiem and has four fields (i.e. breakfast, lunch, dinner, tips). It only has one record. The amount for breakfast, lunch, dinner and tips. The second form is called...

Hello, I have setup a macro using the macro object. I am using the "transfer text" action. The macro works fine but I would like for a box pop up that asks for the "filename" to import. I have been able to get this to work using "msgbox"; however, I would like the ability to browse for the...

Hello, I have a table that I enter events into. For the sake of simplicity it has the following field. 1. EventDate 2. EventName 3. AssignedTo. I would like to be able have a calendar that is linked to the events in this table. If one of the events in the table is: Event Date Event Name...

Hello, I tried docmd.requery on the code behind the command button and it worked. Stacy

I tried docmd.requery([Hotel Arrangements]) but got this error: Microsoft Access can't find the field '|' referred to in your expression. Hotel Arrangements is the subform name. If all else fails I can put docmd.close on the command button. Please let me know what you think. Thanks again for...

Which piece of code should I put this on? Thanks, Stacy