Search results

This may be painful for some of you to read. I am still an Access noob. I have a Form caled FrmProspects with a subform. The subform is based on a query called QryProspects, and just displays a list of records. I'd like to be able to double click on a record inside the subform which would...

I have a table with some fields like "AccountName" "EffectiveDate" etc. I need my users to be able to filter the data however they wish, which I know is possible using a query. However, I don't want them to be able to make edits from a query. Is there a way I can disable a query from making...

I'm having trouble reading text from a word document bookmark Basically my code is Dim wrdApp As Word.Application Dim wrdDoc As Word.Document Set wrdApp = CreateObject("Word.Application") Set wrdDoc = wrdApp.Documents.Open(filepath) wrdDoc.Bookmarks("Bookmark1").Range = "New York"...

I have an Access button that basically does the following: On Button Click open "Account Profile Form.doc" Edit "Account Profile Form.doc" SaveAs("NewUniqueFileName") The first run works fine. However, if I don't close the document then on the second run I get "Account Profile Form...

Forgive me, I'm new to Access. I have a table called Tbl_Prospects and two forms, Frm_View and Frm_Marketing. Currently I have a button on Frm_View called NewProspectButton, and when I click it, a new record gets added to Tbl_Prospects and Frm_Marketing opens. After this new record gets...