Search results

I want the user to click a button on a sub-form (continuous form format) and pass the value of a field (ColorCode) in that record to a new form which opens from the button click and autopopulate the field (ColorCode) on the new form. First Form is: On button click stDocName =...

I want to automate the distribution of individuals Vacation Balance and Usage via email. The data is being pulled from 2 tables related by an Employee ID#. tbl-Employees provides the Header Info for each employee and tbl-VacLog provides the detailed Usage data. I want the output to appear as...

Liberals keep using that word...I do not think it means what they think it means.

Completely void of any accuracy Kraj. Racial tension is a phenomenom perpetuated by liberals who find it's the best way to manipulate people with no logic or self determination. Martin Luther King would be smacking Jesse Jackson, Al Sharpton and even his own wife and kids if he saw what they...

Would you want to set the main menus visible property to false when the report opens and then when the report closes simply make the main menu visible again?

Replace your line of code above with this: =[Address1] & vbCrlf & [Address2] & vbCrlf & [Address3] & vbCrlf & [PostCode]

When I click the print invoice button, my invoice looks fine. When I click the preview invoice button, it previews fine. Sorry I don't see any problems like you've described. I'm running Windows XP Pro and Access 97.

You don't by any chance have a blank record in your query results somewhere that is inserting a blank line? Sorry if this is very basic but often we overlook the simple. We've all had the support call from the guy who's computer doesn't work and after troubleshooting everything else we...

KenHigg submitted this sample in another thread but it is an A2K format. If anyone can convert this to 97 that would be great.

1. Remember; "yous" can be singular or plural. 2. If you are at a loss for words, just say, "Fuggedaboudit." This can mean, "yeah, you're right," "Wow!", "that's terrible," "no big deal, " "What a surprise", "forget about it", or a number of other things known only to wiseguys. 3. If you take a...

:D These are trick questions! :) These answer to all of them is "5" except for question 7 which is "Yes". :D

Maybe what you want is: Go to the tools menu and click options on the keyboard tab there is an "Move after enter" group. Try selecting "Don't Move".

I'm not sure why you would be getting a read only message if you are saving it to your hard drive. I did however remove an unnecessary reference that gave me a problem downloading on another machine. Let me know if you still have an issue and I can try and send it to you directly.

This is a calendar I've been tinkering with that you may be able to use the same principles on a report.

Are you able to use "+" symbols for concantenation in access? I've only seen this in Excel and had to use "&" in access.

Good Point Rich. Thanks for your response. That's exactly what I needed.

I'm modifying a calendar I downloaded from one of the forums. What I want to do is allow the user to double click the specific day, which is a subform in the main calendar form, to open a deatiled view of that days events. The problem is when the detailed view opens, I'm not sure how to pass...

Try the TransferText function under Macros to export it to Word. Maybe as a Mial Merge method.

This is really strange. I made a database into a design master and then created two replicas. While testing, the design master suddenly lost all it's replicable settings and my replicas cannopt sync with it. The database is still listed in the list of sync-able DB's in the replicas. I also...

Thanks for your response Mile. I tried the CDate() and it gave me a Data Mismatch Error also. But I figured to try and remove the DateValue() and it ran fine. Then to make things more odd, I tried removing DateValue() from the Approve query and then that one failed. I may not have thought...