Search results

Thanks for the help. It worked great. Thanks, Jennifer

I have a calculator form in Access that I am trying to create a +/- command button in. This should allow the user to switch a number from negative to positive and from positive to negative. Here is the code that I have written. Private Sub NegativeOrPositive_Click() If txtReadOut.Value > 0...

Here is the second Listbox sample. This is what is would look like when the command button was selected on the main form.

Okay, I am thinking I want to go in a little different direction. This will probably be more complicated, but i think it will look better. What I would actually like to do is create four forms. One form would give three command buttons (select region(s), select state(s), and select showroom...

Thanks! That cleared up that problem, but now it highlights the IIf and gives me an error message that says Wrong number of arguments or invalid property assignment. Sorry if these are stupid mistakes, but I copied code from a different thread and tried to adapt it to my database. Thanks...

Hi Everyone, I am trying to create a query that will allow the user to selct mutiple items from three list boxes. The list boxes are as follows: Region, State, and ShowroomType. I would like the user to select one or many from each of the three lists. I have a form set up with an "OK"...

I checked the security wizard to determine what path it was using. I did actually modify the system.mdw file, but was able to fix it by mapping to another computer that had the original system.mdw file. I just right clicked and dragged the original file to the folder my altered copy was in...

I set up security on one of my access databases and now I have to enter a password everytime I open Access. Once Access is open I can go into any database I want to. I don't want to have to logon everytime I open Access. What did I do to cause this and how do I get rid on the logon scree. I...

That worked GREAT!!:D Thanks for the advice from both of you!!! Jennifer

Everything works great except it does not show the e-mail recipient. I tried to type it in using the persons e-mail address and it comes up with an error. Any suggestions? Thanks, Jennifer:rolleyes:

I have set up a form that will trigger a SendObject e-mail alert depending on what information is entered. For example: when a shipment date is entered, an e-mail is triggered that says the shipment has been sent. What I need to know is if there is a way to automatically include the project...

Will this send out a message for just this one entry or does it then send out a report for all entries. what I need the automatic e-mail to do is...When a PO number is entered into the database, I need it to trigure an e-mail that would read something like...The PO was received for (a certain...

Is there a way to set up an Access query, form, or report to trigger at automatic e-mail message to a predefined list of recipients? What I am trying to do is send out automatic e-mails when certain information is entered into the database. :confused:

I got it. Creating a form manually worked great thanks for your help.:cool:

If I create this from a form, where do I find the option to advance? Is that in the form properties? :)

Is it possible to open a second Access database from the switchboard in the first Access database? I figured out how to run a new Access application, but I can't figure out how to have it open a second database without having to click open and selecting it. I hope this makes sense.:confused: