Search results

I was wondering if there is some code that I can used to send an e-mailing using Lotus Notes instead of MS Outlook? Thanks

I run a code that is run when I open a form. But during the code I need to have the option to close the form is something is not done correctly. But I keep getting an error that says "This action can not be carried out while processing a form event." Is there a way I can stop the event and...

Is there a way to disable the fly wheel on the mouse. I have some amny people call me saying, "I lost my form." They don't really but they hit the fly wheel button and moved to a new record. So if there is a way to disable moving records until you hit the complete button, it would make my life...

Hi everyone, Is there any command in vb that will allow me to change the font of a message box? Like bold a certain word, or change the color on this line? Thanks

I have a report that is created and faxed out every time a form is completed. The problem I am having is that when they first fill out the form, and click the print button, the report is printed blank. I think this is due to the fact that the table that is linked to the form has not been...

I wanted to use the format of "AA9999A". Two letters, four numbers and then another letter. It is a sign on Id we use. I was trying to use the on error command but I could not seem to have it fit what I needed. So any help you can give me will help. Thanks

If this inputbox was tied to a form, and I export the response into a textbox, could I then use the inputmask in that field? Then if there was a problem with the export, can their be a way the code understands that the export did not work?

I am looking for a way to be able to ask a user a question using an inputbox that makes a user enter a specific style. I tried to use a inputmask in the formula but could not find one. Any help?

I have been working with a query that filters the records by dates and by using a list box selection that is located on a form. But now I am interested in selecting multiple options in the list box and filtering for all the selected options. The help file informed me on how to change the list...

Is there any vb coding that helps to manipulate a msgbox text. (ie Text Size, Color, appearence.) Thanks Ben Steckler

Thanks for the reply, the only problem is that when I enter that md() function, it gives me an error saying that "sub or Function is not defined." Any ideas on how to fix that? Ben

That would be great. Thanks for think about us out here.

I am trying to have Access create a Random number but when I use the rand() function, it is not reconized. Any ideas?

Is there a command that opens a specific Excel File?

Is there any visual Basic comand that gives you the current week number from a given date. Like the Month([Date]) function gives 10 for Oct 31, 2001 (or whatever date supplied.)

It worked perfectly.

I am having a Problem with a Dlookup. The Help says to use this set up Varx = DLookup("[LastName]", "Employees", "[EmployeeID] = 1") Where [LastName] is the field to look up, "Employees" is the Table or Query and "[EmployeeID] = 1" is the critieria to meet. Here is my problem and I can not...

I have an Autoexec Macro that runs 5 Make Table Queries. The problem is that When run the macro, I then have to Click "OK" on about 15 screens. Is there a way to turn off all the messages using a Module? Thanks Ben_Steckler@hotmail.com

Thanks they both worked great.

Thanks for the reply, In answer to your question: No They are in Separate columns. (Ex: Column one has Check box Titled “Paid” Column two has another titled “Overpayment”) So what I have had to do in the past was make one query that show all Overpayments. Then I would have to make another...