Search results for query: *

Hello: I have Windows 10 and Office 2016 (standalone) on a metered connection to the Internet, and am mostly offline. I have created an MS Access 2016 application and can't disable the "Updates Available" banner, which appears every time I open the app. I can click the "x" to close the...

Hello Duane & Lameid: Thx for your replies! I really appreciate them. Kind regards, Karen

Hi: I am now working as a consultant for small businesses. Should I deploy my Access database solutions to them using Runtime or should I have them get MS Access. I don't think any of these clients are the type that will want to spend any time messing with code or altering the database. What...

One more post from Karen....I am new at posting solutions. I am on the right track, but what I've posted isn't quite perfect...so thank you for your patience. Karen

To MichaelRed: More response from Karen: ============== 1. Varbookmark, Declaration ststements: these are assigned earlier in the procedure. I did not post the whole procedure. 2. My char count only needs to be tested once. If it is under 2000, then the procedure is not needed 3. I am doing...

To michaelred: thx for questions. I will answer some now & some next week when i return to work. 1. Varbookmark, Declaration ststements: these are assigned earlier in the procedure. I did not post the whole procedure. 2. My char count only needs to be tested once. If it is under 2000...

Hi All: I have gotten LOTs of help over the past few years on this and other forums. So...Below is a solution to the Error 3188 (when saving a memo field with over 2000 characters) error - and, by george...it actually works for me. The idea - cut the memo text into sections of less than 2000...

ahh...thank you. I tried this....I get the same result with my message boxes....

Yes...on the "Option Explicit" question... and...the "Debug Compile" option works. No errors come up (I actually fixed a couple a few days ago that I found using the "Debug Compile". Is that what you mean? Thank you again for all of your efforts...

Aceman...Alas...it did not work...

ok...Duane: I pasted your code (a vba version of my query) into my procedure - and....I got the message both before and after. I also deleted the container (in case it was corrupted) and replaced it with a new one - same name. And...still no luck. I don't think it is the code. It is...

Duane: Honestly, I'm not sure how to use a breakpoint. I tried inserting one on the "requery" line of code...but when I click run - it asks for a macro. I've always used msg boxes to frame an area of code I'm working on. Usually I can tell what is and isn't working - as the messages after...

Aceman: Thx for your question. "Container" is the control on the main form which holds the subform. karen

Duane: Good question! You caught me...as actually my statement wasn't very accurate. In fact, I just put message boxes into the procedure (especially before and after the requery). Both messages come up. So the requery statement executes somehow, but doesn't work....does that answer your...

Aceman: I will try your suggestion (though I may have already tried it). Is this the code: [AssemblyDetailDescriptionCtnr].Form.RecordSource = [AssemblyDetailDescriptionCtnr].Form.RecordSource For some reason, the code window height in your msg is about 1/2 of a line high.... thank you...

Aceman - yes, I tried that... Duane - yes...I also tried that....the code trips up at the requery (which is not in code in the subform). The subform is just set up with fields and an Access query - no vba here. I did however, try resetting the Recordsource in code before requerying. Thank...

master/child properties are empty.... thank you, karen

To PH: Well....I tried it - and it still doesn't work...thanks for the suggestion... any other ideas? this always worked well in 2003 - I'm only having the problem with 2007/2010. Something with the form requery is different in the newer versions I'm guessing... Thank you, Karen

Duane: Thx for your email and for looking at this. In the query for the subform requery, the ID txt box on the main form is referred to as: [Forms]![frmViewCreateAD]![txtUserADID] SQL qry text: SELECT DISTINCTROW tblUserAD_Title.UserAD_ID, tblMaterial.Mid, tblUserAssemblyDetail.Qty...

Hi all: From a ComboBox "afterupdate" event in a form, I requery a subform (in a container), based upon the ID of the record the user chooses (me.txtUserADID). This worked fine in Access 2003. The query - at the query level also works fine in 2007 (if I type in the ID) - either in the query...