Search results

There is no "appropriate text box." There isn't even "a" text box. In the design view of my main form, there is only a big white box where my subform is. I think this is because the source of my subform is a query, not another form. Is there a good work around for this? I greatly...

I'm still lost. Could you elaborate?

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"...

Well, looks like I'm the only one posting here. I never really solved my problem but I found a good work around. Instead of saving the original file under a new name, I created a copy of the file and saved the copy under a new name. Then I was able to close the orignal file.

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...

OK, thanks. I realized what my problem was. I was using a linked table, but then I changed some field names. My form's record source never picked up on the changes. That's what was causing all of my problems. Thanks for y'alls reponses though.

When I do Me. it doesn't show every field in my table. It only shows all the controls on my form. In other words, I need to do something like Me.Creation_Date = date() but this recieves an error because there is no control on my form named Creation_Date. (I don't want that control on the...

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...