Replies

Hans

How long does take to perform Windows Update to XP-3?

Thanks, John

I just installed it yesterday, It’s a little over my head but it does give a lot of detail that explains what is going on with Startup Control Panel

I thought it would be of interest for you folks that get into the bowels of whats going on!

Additional reasons to use dot

Private Sub LastName_AfterUpdate()
    Dim strLastName As String
    strLastName = Me.la	(this will popup intellisense window so you can choose LastName)
End Sub


‘This will generate an error on compile
Private Sub LastName_AfterUpdate()
    Dim strLastName As String
    strLastName = Me.LastNamex
End Sub


‘This will not generate an error on compile, but will error when run
Private Sub LastName_AfterUpdate()
    Dim strLastName As String
    strLastName = Me!LastNamex

End Sub

Thanks, that did it

Is there any advantage/disadvantage of using DoCmd.CopyObject vrs. DoCmd.TransferDatabase acExport

Hi Batcher

Forgot about the power of DOS, it’s cryptic but it works.

The DOS version of FileFinder v5.2 doesn’t work correctly all the time at command prompt
Would be nice to have a Windows version of the following:
http://www.pcworld.com/downloads/file/fid,…,5/reviews.html[/url]

Can you have it done during your next coffee break?

Thanks, John

Is there a Microsoft Knowledge Base Article/white papper that describes the direction that I’m taking with A2007/A2000 scenario described above to best configure the A2007 system and point out any mine fields I should be aware of?

Thanks, John

Hans

I have A2k, is Microsoft Photo Editor the equivalent?

Can I download and run Microsoft Office Document Imaging?

Thanks, John

How does one obtain Microsoft Office Document Imaging ?

Thanks, John

Here it is!

Check out

post 585769 Update Inventory [In Stock] Amount (Access 2003/SP

HTH, John

That did it, for others here is the code to remove the labels

Thank, John

Private Sub Report_Open(Cancel As Integer)
    
If gloGetValue("TypeOfCheck") = "VENDOR" Then
    Me.PatientLabel.Caption = ""
    Me.MemberLabel.Caption = ""
    Me.BenefitLabel.Caption = ""
    Me.FeeLabel.Caption = ""
End If
    
End Sub

Private Sub Detail_Print(Cancel As Integer, PrintCount As Integer)

If gloGetValue("TypeOfCheck") = "VENDOR" Then
    Me.curTBEN.Visible = False
    Me.curTBenTotal.Visible = False
    Me.curTFEE.Visible = False
    Me.curFeeTotal.Visible = False
End If

End Sub

Reworking the query did the trick, thanks for your help

John

Check out some examples:

Duane Hookom’s Library
At Your Survey
http://www.rogersaccesslibrary.com/OtherLi…sp#Hookom,Duane%5B/url%5D

Sample Survey / Questionnaire Database Version: 2000 (9.0) Noah
http://www.utteraccess.com/forums/showflat…=&Zt=c&Zs=b&Zy=%5B/url%5D

HTH John

Long shot

Office 2003 may be configured to update automatically via Microsoft Update, this has caused me many problems with my client base with strange behavior with combo boxes

There is a bug in Access 2003 (11.8166.8172) SP3

There are a couple of bugs in Office 2003 SP3, and I’ve listed them in a yellow div at the top of this page:
http://allenbrowne.com/tips.html%5B/url%5D

Description of the Access 2003 post-Service Pack 3 hotfix package: December 18, 2007

http://support.microsoft.com/kb/945674%5B/url%5D

Access 2003 (11.8204.8172) SP3 OK after hot fix

HTH, John

Check out

http://www.microsoft.com/downloads/details…&displaylang=en%5B/url%5D