Search results

What version of Access is it? (Could be the reason) Acc 97 doesn't have Round in the built in functions, 2003 does! (not sure about 2000)

Thanks for the reply. I have tried and failed to compact/Repair. This throws up the same error. Fortunately the db sits on a controlled Server and has been restored.(Albeit a day out of date). I haven't split the db. This may be a good idea based on what you said. Now I have it a working...

Hi all, Big problems on access 2003. When opening my live db, the message "The Visual Basic for applications project in the database is corrupt." I've had a quick search but can't find a solution. This db has always been access 2003 (Not converted from prior file version). I can't even...

OK, Thanks anyway, Not a big problem anyway, Cheers

Hi Pa3329, I don't use .NET so can't give you a comparision (Maybe MSLADY could????) However, I do know that if you purchase CR V10 for example (I think the current version is 11) and try to open older reports through 10 (lets say v8.5) this is possible, but be careful when exiting as it will...

Thanks. Is this possible in vb code though rather than manually halting it? Ie, I have a few things triggering on Mouse move, but when the mouse rolls over another fields/label, I want it to ignore the code it was running through at the time and start the fresh code.

OK. as a workaround, disabling the button on click appears to work as the user doesn't get the chance to double click it. Just out of interest, does anyone know if it is possible to drop the running code (I've had issues in the past where you get OUT OF STACK SPACE). Thanks

not sure which one of the above is correct but I can't seem to find the solution through search (probably me looking in all the wrong places). ACC 2003 The problem I have is when going from one form to another, there is code placed behind a button triggered by the On Click event (To load to...

Working 97 Version for you to look at. Hope this helps Kempes

http://www.access-programmers.co.uk/forums/showthread.php?t=111233 Try this, although the db example is in acc 2000, the rest might help. Kempes

I could, but I would lose the look of the form I want. I know I'm being picky but it is only one text box that is causing me greif. The feel of the form looks and acts like a web page. This company are not too fond of access and much prefer SQL or Oracle, so to capture their eye I have...

I think I already know what the answer is going to be, but is there a way of putting an outline around the text on a form so it stand out. The problem I have is that I have our company Logo as the background and I want the font colour to be consistent. It is white, however there is a small area...

Glad to help.

This now works. The more data you put in, the more impressive it looks. I've renamed your form to frmcompleted2. Check the query and check the coding in the form. FrmCompleted. I've removed loads of coding cos you don't need it. You will need to put your labels back in but don't have a...

Hi, Our internet was down all afternoon yesterday. I'll take a quick look at your db.

Could you post a trimmed down version of your db?

Set the list box row source to have the record number in column one, then the field value in column two. Column count = 2 Column width = 0cm;5cm for example. This will allow you to select the record number from the list box although display the Field you require. Add a command button called...

I have implemented something similar within my db. Driven from the query you need to set all fields criteria to Like * & .........your criteria. EG, Like * & [Forms]![Myform]![Combo1] Then on the form for each combo box, event procedure on got focus for each. Combo1 = "" Combo1.requery...

Great, thanks for your help again John. Kempes

Don't worry, got it, Thanks John