Search results

I have solved the problem, there was nothing wrong with the code at all. I noticed that it was also being referenced by the 'After Update@ property of the text box. Bloody clients who think they an create access db's

Hi Max I have tried that bit of code, hower, it doesn't bring up the second message box. I need to bring up the 2nd message box when the field is null so that the employees know that the core does not exist.

Hi there Have been working for a while on this part of code. Basically beause of the way this clients database is written i have to do many workrounds. This one is stumping me. The idea is simple. If the search text box is empty, the first message comes up. This works. If the search text box...

Well I wish you every success in getting it sorted.

Not sure about the reinstallation, although as will all MS software you could try. As for having a shared drive on your PC, i guess that you would not be abble to do that, security issues ect, however if you share a drive on your machine, install a complete copy of either Access 2000 or XP on...

Thats all you need to say!!! Most IT guys are cool with the majority of things but when talking about security in relation to the federal government then thats a whole new ball game. Perhaps suggesting Kodo's approach would work best in this instance

Sounds like you could be right about the update not being done properly. Yes, you wouldneed to have the Office program on all 10 workstations to be effective really. The quickest way to get that done is let everyone who uses the database complain to the IT department. Sounds like you have a...

Just an idea really but I guess the IT department haven't updated all of the system properly, but don't tell them that, you know what they are like!!!! Hope you manage to get it resolved especially as it is an important database. (IT Department only maintain the hardware!!!!!! wow I have heard...

I know what you mean about IT departments. I am contracted to one at the moment and the two guys I work for a so lazy it beggars belief!!! Enough slating of the IT departments. I have found an article on the microsoft website...

You can open the form in DATASHEET view

Just as a matter of interest, where does the database reside? Does it reside on the central server with everyone accessing it from there or is it a standalone database residing on only a handful of workstations?

Sounds like it might be a corrupt database. You could try creating a new database and then importing everything from the original database into the new one.

Bit of a long shot, but have you rebooted your computer to see if that changes the situation?

Yes there are two There is the Calendar Control and the Date/Time picker. There have been many posts on using them, Mile-o-phile has produced several samples. http://www.access-programmers.co.uk/forums/showthread.php?t=62606

Have you tried setting the printer for the report? In design mode of the report select File and then page setup. Under the page tab there is a option to print either to the default printer or to another printer. Once you have set the correct printer to print to save the report. It should now...

AAhhh that might be why then. I have distiller version 5 which comes with adobe acrobat version 5 Not sure why it defaults to B & W though

You might need to re-install Distiller. I use distiller quite alot for printing from Access. I have never had a problem yet.

You might want to go through your code and remove anything that is no longer required.

btnname.enabled = false

add the following code after DoCmd.GoToRecord , , acNewRec btnname.visible = false