Recent content by sfreeman@co.mer

To answer your last question, I'd serioulsy look at using a Select Case rather than the lengthy If http://support.microsoft.com/kb/141691

George! uda man! simple---elegant--- best of all.... it works thank you for your time--- much appreciated-- Sam :D

I have a main data entry form--- it contains a bound text field to enter case numbers-- The Case Number will always start with a number '2', or a number '0'--- IF the user enters the first digit '2', then that digit will ALWAYS be followed by 8 zeros--- Typical Case numbers: 20000000123456 or...

I am having the same problem locating a decent host - GoDaddy seemed to be good, until you read the user reviews. I am very skeptical of some reviews as they appear to me to be 'fake'. Any real problems with customer service, speed or spam with GoDaddy???

Not sure if it is the most efficient method, but you could just do a lookup of the value in question, assign it to a variable, and then create the SQL statement to send off to MySQL, using the variable value, not the reference to the form. MySQL really does not know anything about Access...

GrandTotal ControlSource should look like: =([Text25]+[Text27]+[Text29]+[Text29]+[Text31]+[Text33]+[Text35]) Each of these fields represents the total for each column. Works on my test. HTH

Make sure you are not opening the db 'Exclusive'. From the Help file: To open the database with exclusive (exclusive: A type of access to data in a database shared over a network. When you open a database in exclusive mode, you prevent others from opening the database.) access, click the arrow...

Malcy: That really does sound like a hardware problem to me. Windows replaced bad clusters, so your physical drive was having issues, unfortunately your db file just happened to live there. Since this is not on a LAN, a network type global backup probably will not work, but I would suggest...

You are not randomizing... look in the help file... Dim MyValue Randomize ' Initialize random-number generator. MyValue = Int((6 * Rnd) + 1) ' Generate random value between 1 and 6.

This should not cause any problem, but suggest you give each user his/her own copy of the front-end. In some cases, if you happen to have ActiveX controls in the FE, you may need to re-register them from the users' PCs.

Take a look: http://www.issociate.de/board/post/182407/Problem_with_Access_form.html

How do you know nothing happens??? Looks to me like you are running code to try to add a db to the db collection. If you actually want the db to open, meaning you want to launch the program, try something like: Private Sub Command0_Click() On Error GoTo Err_Command0_Click Dim PAX As String...

Rigth click the form in the db window and Save As a DAP.

I'm guessing that ther must be an option in Norton to exclude this particluar item from being aborted. I'd start with the Norton app.

Try this: http://www.aspfaq.com/show.asp?id=2332