Search results

Looks like I found your problem... Check this out from Microsoft: http://support.microsoft.com/default.aspx?scid=kb;en-us;173775&Product=acc HTH

Replication....yuck. Is there a reason you are replicating the database? Are users going to be traveling with a copy of the database, or are outside sources going to be adding and changing data that will need to be Synchronized later? The reason I ask is that I am wondering it a split database...

Converting Queries to VB Code will not necessarily speed up the process. You state that it takes a few seconds for the forms to open, is there code running on the On Current or On Open events of the forms? If so, what is the code?

There are a few password recovery software sites where you can download trail or free versions of VBA password recovery tools. I have used the following in the past: http://www.lostpassword.com/index.htm HTH

Archiving them to another table is moving away from a Normalized database. It is going to cause you problems by requiring you to create additonal forms for accessing old information. A suggestions: Create a DatePd field in your invoice table. You can then enter the date for each paid invoice...

Well...we have been told over and over that stored Queries run faster than coded ones, but see the below: Access Development Best Practices Posted January 7, 2003 Chat Date: October 3, 2002 Chat Participants: Tim Getsch, Microsoft Access Program Manager JP Bagel, Site Manager Mike Wachal...

Sorry David...I wasn't clear... I meant...what did you convert the code too? You stated you were havng problems...what changes did you make? What error did you get? Changing to A: Should be as follows: Public Function BackupAndZipit() 'This function will allow you to copy a db that is...

Have you tried to run a Compact and Repair on the database? Also...a couple of articles from our friends at MS: http://support.microsoft.com/default.aspx?scid=kb;en-us;223235&Product=acc2000 http://support.microsoft.com/default.aspx?scid=kb;en-us;209940&Product=acc2000

What does the current code look like...can you post it?

dlookup("[terms]","last_runs") Name of the field must be in brackets.

Treason: What file type is your EDI format in? Most EDI transactions can be sent in a flat text file format (EXTOL Protal for example). But usually, it is tailored to your company. Each Carrier/Vendor sending EDI information should be structured to match your format. If you are recieving these...

Laurie: In your module goto Tools > References Make sure the following is checked : Microsoft DAO 3.6 object Library HTH

I assume your users are entering the data from a Form, correct? If so, to ensure that they don't enter informtion into the fields that are not supported by the correct Status Codes you can add the following to the After Update event of the Status Code Combobox: If Me.StatusCode = 7 or...

Here is an example of how to use the IN statement... Dim MyDB As DAO.Database Dim qdf As DAO.QueryDef Dim i As Integer, strSQL As String Dim strWhere As String, strIN As String Dim flgAll As Boolean Set MyDB = CurrentDb() strSQL = "SELECT * from tblCustomer" 'If no selection...

When does it have three and when does it have 4 numbers? Is it when the Serial begins with A, X, etc?? Or is it random?

Assuming the textboxes are on the same form as the listbox, just chage the underlining row source to point at the textboxes... Add the following to the criteria of the fields you want to filter: [Forms]![NameofForm]![TextboxName] Then add the following to the After Update event of the...

Great Newman... You may want to do some reading on creating Replicas and Synchronizing Databases. It will allow the ladies to work from home and then come into the office and synchronize with the master db. Just do a Search on Microsoft on "Replicate" Good Luck

Welcome... Good Luck

Rhonda: Have you looked at the example I posted?

Just add the following to an Unbound textbox on the form to get the record count: CurrentRecord &" Of "& RecordsetClone.RecordCount