Search results

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.

Thanks...this is pretty close to what I'm looking for. I'll need to do some minor tweaks though... How did you create the query "multi_select_Qry" reference table "f "....? I thought that a query always needed to reference a table or another query. In your design structure, the query...

Although you point out a good observation...my users want the capability to select more then one option in the list box to filter on.

Hi, I need help in creating a multiselect list box to requery/refresh my screen. If you look at the attached file, you'll see two multiselect list boxes at the top. I want to allow the users the option to just select from one of the list box or both of them. However the users desire to...

Hi I need to create a form with mulitple "Multiselect List Boxes." I need help with the VBA code. Please look at the attahment, it's a screen shot of my Form. At the top you'll see three Mulitselect List boxes - lst_Project, lst_PE, lst_Approp - the users should be able to select from any...

Option Group - Selecting two options In a traditional Option Group, you're only able to select just one option. What is the code to set the Option Group where you're able to select two options within the option group? Thanks in advance!