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...

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...

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.

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!

I have 4 Option buttons where I need it to filter a query based on what Option I select. Assumption, if OptionBtn 1 and OptionBtn 3 are selected then that will put the following criteria in my query >=1 And <=3. Another assumption, if OptionBtn 2 and OptionBtn 4 are selected then that will...

Hi, How would I create a customize "Information Message dialog box" on a combo List where the property value is set to "Limit to List." Since the combo box is set to "Limit to List" property value, if the user enters something different from the list an error message will appear. It...

Hello, I'm trying to pass values from a Multiselect list box to sub reports. I have a report with three sub reports. The first sub report is named "Graph1", second "Report1" and third "Report2." How would I pass one multiselect list box to all three of these sub reports. This is the code to...

Hi how would I pass a criteria value directly to a query just using VB Sript. On my form I have 2 combo boxes and I want to pass the values directly to a query that then generates my report. Thanks in advance!