Search results

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

Like this? One way to do it: Assuming that you have a table [tblticks], upon which you base a form [frmClearTick], that contains 3 fields [TickID] [Tick1] and [Tick2] The query would be something like: UPDATE tblticks SET tblticks.Tick1 = 0 , tblticks.Tick2 = 0 WHERE...

I suggest that you take a look at the TransferText macro and VBA. ;)

Should work just like any other sub-form. Open your form with the tab control in design view. Then go to the database window, and drag the sub-form onto the tab page. The tab page will briefly turn black while you are doing this. Drop the sub-form. Done.

By the way, I have assumed that your statement regarding the inverse COS results from COS - 1, which I do not believe is correct. There is a COS(Angle) function within Access, but not an ACOS function. An ACOS function takes the COS as its parameter and apparently does not give the same...

OK, assuming that you have a data source [tblAngle] that contains the values needed to determine your angle [Side1] and [Side2], a query might look something like: SELECT Cos([Side1]/[Side2])-1 AS InvCos, Sin([Side1]/[Side2])-1 AS InvSin, Tan([Side1]/[Side2])-1 AS InvTan FROM...