Recent content by mixedguy

Please HELP! When a user logs in a document no starting with NE, ie NEPR60005 , an error message stating "No Current Record" appears after clicking the Save Record button. If the Document No box starts with anything other than NE, then it saves and goes to the next record fine. There isn't any...

Without using the Autonumber, I'm trying to create a Report where each time the report is run it counts exactly how many records are there. I know how to get the total number of records. I'm just looking for a function where it will put a record count next to my record. ie 1. Record 1 2...

I've read the help section on this Macro but can't seem to apply it to my database. Can someone please provide me a simple example using this Macro option. Any simple example will be an extreme help. Thanks in advance!!!

There are two Forms. The parent form and the child form. The child form source data is a query. Is it possible to open up the subform in the parent form in query design mode? I want to do this b/c customized menus can only be referenced from a form. It can't be referenced from a query in...

Either using Macro - SetMenuItem or VB Code - how would I dim/disable a menu item? I tried using SetMenuItem but can't seem to figure it out. Can you please provide some guidance or even better provide a very simple customized menu where when you click on one menu item another menu item dimms...

Dimming a customized menu button. How do I dim(Gray) menu items using either Macros or VB code? thanks

I'm currently using Microsoft Access 2000. In there I've created a Customized Menu. Now what I'm looking to do is - when I click a menu item, I want it to enable another menu item. I tried using "SetMenuItem Action" but it keeps on telling me that this function only works with customized...

This is a little more complicated solution but it looks like you have a 1 to many search. You have a Name_ID in your combo box (assumption) and when they select their chose in the combo box you want all the records related to that chose to appear at the bottom. Right? If that is the case then...

I need some guidance. My manager has asked me to create a database that will be able to retrieve Outlook Archived emails. I know we can import Outlook emails directly into Access but I've already shown him that and he wants to take it one step further. He wants a form where it displays all...

Is it possible to Import Outlook Messages into an access database that have been archived on the network? I know I can move those messages into a folder on my Outlook application and Import it from there. What I really need to know is whether I can import from a network folder.

I have a form called frmEmail. In the frmEmail I have a text box called txtEmail. I have a query called qryEmail. What I'm trying to do is, allow the user to type anything he/she wants into the text box and i'll filter the query on what ever they type. I know you're suppose to use the Like...

Hi I'm using the "Send Object" in the "Action" of the Macro to try to send out an email when the users click on a button. The attached file will show you the properties of my macro, the error message I receive when I click on the command button to try to run the Macro. Please advise what I'm...

Hello, I'm trying to automate the process of converting Access Reports to PDF Formats. My reports currently are generated when the users click a button and then a "Print Preview" of the report appears. I want to add another button to my form where if the users click on it the reports will...

Hi I have attached a sample DB of what I want done. If you open the DB, you'll see a form called "Form1." If you click on "Code 1" that should pass a value of 1 to the criteria of the query. If you click on "Code 2" that should pass a value of 2 to the criteria of the query. If you click on...

Hi, How would I run a Macro residing on a network database from my macro residing on my Hard drive database? Thanks in advance.