Search:

Thank you for your help. I finally got it.

Private Sub PreviewReport_Click()
On Error GoTo Print_Click_Err

Dim strDocName As String
Dim strWhere As String
strDocName = "rHardware"
...

When I run the second one it says syntax error.

Do you know how to fix the where line? Basically I am saying to use the number (I think it really should be HWID) for the record I am looking at on...

Or this one:

The form has fields from 2 tables - WRKID is the Primary key of one and is the common field. HWID is the primary field for the second one

Private Sub PreviewReport_Click()
On...

I don't know what is wrong. I have tried the same function in various different ways. For example I get the error "Sub or function not defined" for this code in bold below. I have tried it with and...

I have made a gazillion attempts to get a button to work with no success. Someone recommended run Debug - Compile. It is stopping at each little SUB asking for corrections. In the Visual Basic editor...

I have many XP computers in the library setup to auto logon. It works about 99% of the time. The rest of the time it doesn't logon automatically and the Windows logon screen appears instead. It...

I have many XP computers in the library setup to auto logon. It works about 99% of the time. The rest of the time it doesn't logon automatically and the Windows logon screen appears instead. It seems...

This did not work. I DO want a user named 'public' to logon automatically and I set that up in the registry. The user that keeps coming up in the logon box is not a user and does not appear in the...

I have a strange problem. I have setup a number of different computers (WIndows XP)for the public library. I setup autoadmin logon for our public user with the domain and the username and password...

Nope. I tried cnn.Open. Connection.open ... I had parentheses for each item in the string and I see all of the parts of yours use just one so I tried that.

Thanks.

I'll try this. Where do I put this? I have tried adding it the autoexec converted module and as a event procedure ON OPEN for the form that I could open with a startup action, but don't seem to get...

I have an Access database that I upsized with the wizard wishing to continue using Access for the Front End. I want to be able to connect to the SQL database without having each computer setup for...

I think I have figured it out. For some reason there was a normal.dot in the shared template folder. When someone opened Word 2010 it used that one since there wasn't one in the user's folder. Then...

I understand all of that but for some reason this is not happening with our new installations. The user templates are setup for c:\ and workgroup templates are setup on a shared server. I just opened...

We are just now starting to install Office 2010. Even though in Word it shows a c:\folder for user templates there is no normal.dot or normal.dotm. When you open Word it is using the one that is...

I was under the impression that normal.dotm was a user template not a workgroup template. However it seems that all users are sharing the template that happens to be in the workgroup template folder....

Yes.

I created a 48x48 icon with IconEdit. I set the icon size in the Display Properties | Appearance | Advanced | icon size 48. However when going back to the desktop there is a brief flash and the icon...

I checked all of the permissions -- looked fine and the asst has been granted permission to Send on behalf of the supervisor in Active Directory.

Any other ideas.

Jane

I checked all of the permissions -- looked fine and the asst has been granted permission to Send on behalf of the supervisor in Active Directory.

Any other ideas.

Jane

I checked all of the permissions -- looked fine and the asst has been granted permission to Send on behalf of the supervisor in Active Directory.

Any other ideas.

Jane

I checked all of the permissions -- looked fine and the asst has been granted permission to Send on behalf of the supervisor in Active Directory.

Any other ideas.

Jane

I checked all of the permissions -- looked fine and the asst has been granted permission to Send on behalf of the supervisor in Active Directory.

Any other ideas.

Jane

I checked all of the permissions -- looked fine and the asst has been granted permission to Send on behalf of the supervisor in Active Directory.

Any other ideas.

Jane

I checked all of the permissions -- looked fine and the asst has been granted permission to Send on behalf of the supervisor in Active Directory.

Any other ideas.

Jane