Search results

I have almost no experience with word 2007. I work with Access and some Excel. I built a tiny Word 2007 template document that includes different paragraphs dependong on what the customer wants. I then send it to someone else for final update. When this other person opens the document and make...

OOOOPPS, Is it plugged in? Is it turned on? I forgot to change the filed from unbound- when I corrected the field name it fills correctly. Happy camper here- thank for your help again, Bob :) Dave

with the step through all the correct fields are showing under the correct values- it is returning my login ID correctly- it just isn't displaying on the form..

It still will not fill the CompletedBy field... just nothing happens...

That eliminated the error message but the CompletedBy field still doesn't fill- here is the code I have to fill that field, when a command button is pressed.. Private Sub cmdClose_Click() CaseStatus = "Closed" DateCompleted = Now() CompletedBy = UserID() End Sub

The function code is: Public Function UserID() UserID = VBA.Environ(GetUser) End Function The error is: Runtime error 5 Invalid procedure or argumant

Thanks Bob, I can't get that to work either. The link applies to Access 2003- I am using 2007. Anyone found a workaround?

My envoron and getuser function don't work in Access 2007 unless the sandbox mode is changed. Our network administrators will not allow that. Has anyone figured out a way to get the current user LoginID? I am trying to load it into a form field using a command button..... Thanks, Dave

Yes- it just seems to ignore that template

This is my first build using 2007. I set the Object Designer form template to a simple form that has the font name and size I want on all my forms. When I use the autoform tool it is NOT using that font or that size. How do I force new forms to use my font and size? Thanks, Dave

By process of elimination it turned out to be that Data Entry for the sub-form was set to yes. When I changed that setting to no the form printed normally, including the sub-form and it's data. Dave

Anyone have any ideas?

For a very good reason I need to print the form and subform. Any ideas about why this subform won't print?

I need some guidance about where to go to find out why my subform won't print with the parent form? my dbase is filled with records with confidential info so can't post- I will dig around to get it working, just need any ideas anyone has... Thanks, Dave

I read the edrror message more closely- it was the fill-ee and not the fill-er that had the bad syntax. Thanks for your help and the fix! Dave

I tried that and it still is asking for the parameter. Does it require a different method of reference when trying to get a value from a closed table?

I have been fighting with this code the whole day- help, please? Dim stDocName As String Dim stLinkCriteria As String stDocName = "frmTabSurvey" DoCmd.OpenForm stDocName, , , stLinkCriteria DoCmd.ApplyFilter , "Text59 = 'Tables!StoreSurveyNumber!StoreSurveyNumber'" I want to open the form to...

Thanks, Paul :)

My customer is asking for the ability to convert individual records to read-only when the closed date is added to a form. They are concerned about changes being made later. There are several hundred records in their application right now and this number will continue to grow. A little...

Set db = CurrentDb() That was pretty silly.. Thanks, Dave