Search results

Are you storing the pictures in the db, or storing the path to where the pictures are? The first will grow very quickly and not be managable, the second will reduce the size and be easier to administer if built correctly.

If you use peer to peer you havn't got a dedicated server with Windows 2000 server. This you must have and it doesn't come cheap. I think you should speak to someone who can install and configure a W2K server for further info and quote, they will know the ins and outs, I'm afraid I don't.

When you buy Windows server 2000 you buy client licenses for the number of users who will log on to the system. You would have to buy terminal licenses for the number of people who would log on in that manor. When someone logs on they would get the windows front screen with user name and...

Hi Paul If both sites have ADSL you may find a WAN acceptable. Other options include pcanywhere if just one person needs to access the data from the remote site. Another option if the host site has Windows 2000 server would be to use the termminal services and let users log on using remote...

SAK I've posted a demo here for you. Just click on the dancing girls (yes I know they're a bit skinny!!). The code was origionally posted by someone called Arnu i think and everyone bombarded him to email it to them. I wonder what happened to him? Anyway have a play.:D

As GHudson says above Store the origional values (I only use the horizontal) in a table then you can reverse to the origional settings when you exit the db. The main problems I encountered were: 1. If the user multitasks between apps with the db open they get the other app in the screen...

You can set up a VPN with any version of Windows from 98 on with the right software. I'm not the person to talk to re the finer points other than to confrim that windows 2k and XP come with a wizard to help. Security on the VPN is another issue to research to make sure it really is private. When...

I agree with Autoeng pcAnywhere is good for what you need to do as long as there is a free PC in the office for him to control. Or if you're feeling brave a VPN and give him a front end on his PC.

If isnull(DMax("[IDLocal]", "[tblSentEmail]", " [tblSentEmail]![Ship]=Forms![frmMessaggeType]![Com bo23]")) Or DMax("[IDLocal]", "[tblSentEmail]", " [tblSentEmail]![Ship]=Forms![frmMessaggeType]![Com bo23]") = "" Then Me.IDLocal = "001" Else IDLocal = DMax("[IDLocal]", "[tblSentEmail]", "...

You could adapt this: Public Sub NextInvoiceNo() On Error Resume Next If IsNull(DMax("InvoiceNo", "Invoice")) Then Forms!F_Invoice!InvoiceNo = 1 Else Forms!F_Invoice!InvoiceNo = DMax("InvoiceNo", "Invoice") + 1 End If Forms!F_Invoice.Refresh If Err = 3022 Then Forms!F_Invoice!InvoiceNo = ""...

Jon Here's an example of what I use, I think it Originated from the Access Cookbook. John

I think the most secure way would be to convert your mdb file to a mde file and distribute that file as no one can get to any of the code (not even you). Make sure that you keep a copy of the mdb file for your development and update purposes. Alternatively if your using Access 2000 or xp you...

Tom If everyone logs on and off the db you can create a table of people who have logged on and not logged off. A Yes/No Field will suffice, however you could store the userID, computer name, user name for the pc, log on time and log off time. When someone logs on to the db you could count the...

You could create the file and set the properties to read only. Its not permanent but it may be enough.

Try this SQLStatement:="SELECT * FROM [Customers] WHERE [MailingListID] = " & Forms!FormName!MailingListID

What version of access are you using? If 97 is it possible your db has bee converted to 2000? or did you last use access 2000 and now you are opening your db from a shortcut or the file directly. If so Open Access97 and then try opening your db.

Hold the shift key down when you start the database and see if that brings up the db window

When you select the links to be updated you can go through network neighbourhood using the full UNC path as you wish to.

In Access 2K Go to the menu Tools, Database Utilities, Linked Table Manager. In Access 97 its Tools Addins Linked Table Manager. You can then refresh your links to the path of your choice. HTH John:D

Wow that works for both alfa numeric pad and qwerty. Does exactly what I want. Thanks :D