Search results

Change me.email to whatever group email address you desire.

I believe you need quotes around the form name. Try this: DoCmd.OpenForm "formStaffDetails", , True

The user should be able to just delete the text in the field. The user can highlight the entire text and hit the delete button, position the cursor to the right of the last character and backspace to erase all the letters or position the cursor in front of the text and keep hitting delete...

Well you could, but it's a little tricky. The easiest thing would be to have the query filter down to the one record you wanted. If you don't want to use a query, you could run a query to create a temporary file that just contains the one record. Then output the temporary file...

Try this, ZipPlus4 = left([Zip Cod],5) & "-" & right([Zip Code],4) the left command here displays the first 5 characters of the zip code field. the right command displays the first 4 characters of the zip code field starting from the right. You can also play with the format command.

Naw man, no problem. That's why this forum is here. Try using this DoCmd.OutputTo acOutputQuery, "Employees", acFormatXLS, "C:\Employee.xls", True I believe in this case if employee.xls is not there, it will create the file. Look at the help documentation for OutPutTo and...

a.sinatra, Drop some knowledge on me. I know about the NZ command, but he wanted 1 address item per line. Even with the NZ, don't we need some control characters in between (i.e. vbCRLF) and don't we have to account for the new blank lines if an address is null?

Suggestion, don't give the Respond By field a default value. The data in this field should be generated whenever the Date Received field is changed. I'll assume you are using a form to update/change the Date Received field. Assign code to the AfterUpdate event on the Date Received field...

I don't believe there is a way to do this. Since you made the row bigger, you may want to make the text bigger to accomodate the change.

I have a custom toolbar that has about 6 Menu items. When I send my database to a test machine something strange happens. Menu Items 2 - 6 work fine. When the user clicks on them, they drop down a list of items for each respective menu item. The first menu item however does nothing. When...

Use the DoCMD.transferspreadsheet method. Here is an example DoCmd.TransferSpreadsheet acExport, 3, _ "Employees","C:\Lotus\Newemps.wk3", True, "A1:G12" Instead of Employees, you would use your query name. Once you start typing the command you know it will help you with all the...

Not sure if that will give you 1 line per address. You may need to insert some control characters in between the addresses. You may also need to add some immediate Ifs to acount for empty addresses.

How about setting the validation to < 1000?

Wow, not sure now. Two things you may want to try 1) May be some macro in Excel that can give control back to access. 2) Convert the Excel file into some type of text file and import that into Access. This causes a separate step, but may help you in the automation process.

Make the criteria of the query of the subform based on the Combo box or check box. Use the AfterUpdate event of the combo or check box to requery the subform. For instance in the query let's say you want the query to be based on a customer selected in the combo box which is on a form called...

Why do you need to go between both applications? If you need to create a spreadsheet from Access, you can use the SendObject command and still have access be the active application.

If you somehow qualified the leads (talked to the potential customer and see how serious they were, if they were realistic about the price, etc...) you have something. We sell an off the shelf package where my sales person was willing to pay $1500 for about 10,000 qualified leads. We got a...

Thank you. I will try this.

I am sorry, I should have read this post more carefully. You will probably need to make some cross tab query and assign it to the row source of the list box.

Design your form the way you want it to look. This will only apply if you are not using a form View of datasheet for your form. If the form is a single form view, place the fields in the detail section how you want them to appear: Company Contact Address If you want to have multiple...