... John, can he not use the bang "!" character to force the input mask to fill from right to left? Also I wonder if #9.00 as the mask does the same thing....
Rick, There are many ways to do this. Let us assume your text box named as A1 and B1. 1. On the forms Current Event you may drop following lines: If Not Isnull...
Hi, I use a provider that is working in the following way: I send the message using e-mail where the first part of the message is the mobile number and the...
I used the Custom dialog box to add the menu item "Compact and Repair..." to a custom menu. The application (an MDE file) will be run using the runtime...
Desmond- You can define a Table Validation Rule. Open the table in Design view and then open the Properties window. In the Validation Rule enter something ...
Thank for the info valentino. I ll look forward more info about the provider in my country Andi ... From: Valentino To: MS_Access_Professionals@yahoogroups.com...
Desmond- Um, I understand your colloquial use of "bomb," but I'm not sure that's a politically correct word to use these days! <s> John Viescas, author ...
I need a field that holds email addresses, and when that record is clicked on in the form, opens the user's default email handler and addresses a new mail....
I've given up trying to figure the problem on my own. Can someone advise why Access has a problem with this VBA code. This code is behind a command button on...
Is your concern to compact the MDE file, or are you referring to the backend data files? And if you don't have a split back end, there's the first approach to...
... Just for an example, let's suppose strNewName was "tblNewName" and lngNameID was 1001. Your SQL statement would end up looking like: UPDATE tblNamesSET...
Chris- You're missing the required delimiters around the string literal. And you're running the parts of the SQL together with no spaces. You should also use...
Dan, I was able to get it to work properly with your suggestions. Thanks. Now I am having trouble incorporating Chr(34) into the syntax (to avoid bombing on an...
Chris- You don't need the extra CHR(34) because the string already includes single-quote delimiters. strSQL = strSQL & "SET tblNames.[Name] = '" & strNewName &...
If you are dealing with SQL Server, you must use apostrophe's instead of quotes. However, chr(34) will be just fine for just Access alone, but you would use...
Thanks John, I've incorporated your suggested Execute method: CurrentDb.Execute strSQL, dbFailOnError Using dbFailOnError, is there anything different that you...
Chris- Your error handler looks just fine. The only enhancement would be to trap common error codes and try to deal with them. You're trying to run an Update...
Elie, Without your Table Structure this could be tough to answer, but let me give it a shot. IDNumber being a TEXT FIELD DateModified being a DATE FIELD Create...
You need to wrap a string with single quotes. strSQL = strSQL & "SET tblNames.Name ='" & strNewName & "' " ... From: goodbruder [mailto:goodbruder@...] ...
Hi John and everyone, Yes, I agree that nowadays one should rather steer clear of the word “bomb”. I come to you with another problem. I will first explain...
Desmond- I would think you could figure out what happened from the records that exist in Table2. If there's only one record, the employee spend the entire day...
Jack, Sample db named NumericOnly_2K.zip (uploaded to the files section of this group) should be able to cover the requirements brought up by you. In view of...
I have recently been asked to design a database for a client and I was wondering if any of you Access gurus have a standard contract that you wouldn't mind...
Jeanette You can find lots of samples on the internet. Search using consulting contract as your criteria. Also spend the money to have a lawyer look it over to...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
