Search results

Winzip has a comand line add on called wzcline. You could use the shell command in access to run wzunzip from to. You would need a table to store the location and zip file names, and the location for the unzipped files. The help provided with wzcline gives you info and switch information.

What happens if you have more than 999 orders in a year? You want a prefix on the numbers but do they have to run consecutively for each section? or could you have TM4001 ADM4002 ADM4003 TM4004

Use Set Warnings i.e Docmd.setwarnings false Run your query and msgbox then Docmd.setwarnings true Don't forget the last line to turn the warnings back on otherwise you will not receive any other warnings which you may wish to receive

If your users log on and off the database you can count the number of users logged on when it is opened. If that exceeds the number you want the force the database to close. You could either hard code the maximum number or put it in a hidden table according to how secure you want it and whether...

Add a text box to your form and then in the On Open event of the form add the following line Me.txtYourTextBox= GetLinkedDBName("YourTableName")

You can use this function to get the path Function GetLinkedDBName(TableName As String) Dim db As Database Dim Ret On Error GoTo DBNameErr Set db = CurrentDb() Ret = db.TableDefs(TableName).Connect GetLinkedDBName = Right(Ret, Len(Ret) - (InStr(1, Ret, "DATABASE=") + 8)) Exit Function...

If you are distributing an Access 2000 database then you need the 2000 developers edition, which is a lot cheaper than purchasing access for each PC you intend to run your database on. Maybe the cost of your db could include a percentage of the cost of the developers edition. If you have access...

Have a look at http://www.peterssoftware.com he has a great demo for the kind of thing your after.

Have a look at this and see if it helps. I origionaly found it in a microsoft sample db. :cool:

I handle upgrades for my customers using pcAnywhere. I can take over one PC and work as if I were infront of it. I can then install a new FE and copy to all other PCs' on the network as long as the shares are set up. With several of my larger customers I have a FE installed on the server which...

One other shot in the dark. If your running Access 97 or 2K you could try upgrading the db to Access XP. I've had success doing this when a 97 db corrupted and 97 tools wouldn't recover the db. Take note of Jacks comments re back up. You can help your self by backing up your important files...

Check your vb references. Yours has "Image edit control" which is missing on my PC. The example posted has Kodak image scan control Kodak image admin control Kodak image edit control which are part of the kodak imaging for windows program HTH John

Just to throw a spanner in to the works at this stage, what operating system are you planning on using now and in the future? Kodak imaging for windows is int available in Windows XP, though you can extract the files from Windows 2000 and install them manually legally I don't think its legal...

Sorry Pat I don't understand what you mean by saying the file can not be "shared". The file is an access database file with 30 ish tables. Please could you expand a bit. I would also re iterate that all works well in Win98. If there was a problem with the file I would have expected a slow down...

I have a database which is split FE on workstation BE on server (usually a workstation serving the data file pier to pier). With Windows 98 and 2000 everything is OK, with windows XP the opening speed of the database is OK when the first person opens it, but as soon as a second person enters it...

The memo type field does seem to be the most succeptable one for this type of problem. I think it is related to a network issue but have never been able to establish what. As a work around where possible use a text field length 255.

Rich is right Peters software is the only one I'm aware of to resize datasheet subforms http://www.peterssoftware.com/

bpaquette Thanks for your interest. There will be thousands of images which may or may not need rotation. Everywhere I look I'm being told that Access can't do this hence using the office image viewer. (Which should save me some time and coding);)

Thanks Hayley. Good for text but not for images. I've taken to creating a temp tif file and opening it in Microsoft office image viewer, where the temp file can be manipulated and printed. It also sorts out multiple page issues. It would still interest me to know af access can rotate pictures...

I have a tiff image displayed on a form. I need to be able to rotate this image 90 degrees to the left or right. Is there any code to acheive this? John