Search results

Hey, I've got some custom navigation buttons on both my main form, a subform, and a sub-subform...nested 3 levels deep. They work. Except that the TotalRecs -- "y" of the "x of y" does not get refreshed for the subforms when I change the main record. I want the subforms to recalculate the...

Thanks (I naively expected to be able to change properties because the table was linked.... :rolleyes: )

Hi all, I have a typical split database - tables in backend, forms in front end. However, I cannot modify the tables' properties in the backend, even though they are just LINKED to the frontend. ("A query or form bound to the table is open...etc") Furthermore, an .ldb file exists for the...

anyone? to sum it up, I need to simulate my subform's OnCurrent Event procedure... which calls this function to set the Total # of Records: Private Function lngGetRecCount() As Long Dim rstForm As Recordset Set rstForm = Me.RecordsetClone On Error Resume Next rstForm.Bookmark =...

The .RecordCount element of the code seems to be working...the problem is, I can't/don'tknowhowto 'requery' it to recalculate the TotalRecs every time the record on the main form changes.... MainForm (DCPs) has nested subform (DCNs) which has nested subform (Docs). You see, one DCP, can have...

No, those are just my dreams: Being paid by line of code and having too much time on my hands. :D I wanted to customize the nav. buttons, so I could put descriptive titles in each nav bar as opposed to 'Record'...I couldn't figure out another way to change the Caption. Also this way, I can...

Hey ya, Take a look at the attachment first. Ok, now here's my problem: I've got some custom navigation buttons on both my main form, a subform, and a sub-subform...(nested 3 levels deep) They work. Except that the "y" of the "x of y" record count, for example, does not get refreshed for...

Thanks a lot Rich, that worked... For anyone with this problem in the future, I called the SaveRecord and Requery on the OnChange for the entire Tab Control, and not the individual Page's OnClick (don't know the science behind it, but it just wasn't calling it )

at the risk of being annoying, i'm bumping this... (but only because I'd imagine the answer is simple...so simple that even I can't get it)

Basically, I'm getting an 'Invalid Argument' error msg pop up when I try to run a make-table query...the select query runs fine. Has nothing to do with the size of the table (mines 1500 records), or if its linked (mines not).... Same problem as this thread...

Thanks for the response Diana...but unfortunately that did not work, (I tried referencing the form in three ways) Forms!frmStatusDCPs!frmStatusDocuments.SetFocus = True Forms!frmStatusDCPs!frmStatusDocuments.Requery Me.frmStatusDocuments.SetFocus = True Me.frmStatusDocuments.Requery...

(I have seen posts on this before, but never a concrete solution...) I've got a tab control running off my main form (frmStatusDCPs)...for simplicity, two tab pages, each with a subform on it: The first tab, has a subform (frmStatusDCNs) which is linked directly to the main (master-child...

Now why didn't I think of that? (11,000 more posts and it'll probably all click) Thanks Pat, that should work great... (and 'he' doesnt have pointy hair....SHE does)

Access reports currently limit you to sorting a maximum of 10 fields...* Is there a way in VBA to sort by more? (I have 11) There is the option that I use a subreport which divide the fields etc...but I'm wondering if theres a workaround to this. Also, sorting the query recordset, doesn't...

thanks for the responses... dcx: we are aware of this all-powerful wheel thingy you speak of...but we can't afford the mandatory chrome rims... :D as rob touched upon, yes there are some severe budget constraints... rob: thanks for the sample, i'll give it a shot pono: i will look up the...

Where to start? Ok, I'm looking for feedback/recommendations/ideas on how to go about the following task: I have to create a messaging-service (think MSN messenger) for use within my department. Sounds like a tall task, but I have some ideas as well as some constraints. My forte is...

i'll defer to the gurus (if Mile and Pat are going with QUOTE, EVERYONE should be going with QUOTE :D ) didnt think of that...i guess the ASCII chr could be used as well

Hi, if SSN is non-numeric ie. String, you might want to try varX = DLookup("[GroupID]", "Data", "[SSN] = '" & Me.SSN & "'") (single inverted comma ' around the me.ssn variable)

Thanks mailman, Actually, that is exactly what i do...in the unsimplified version. I've got another table grouping each query set to an index, and I sequence only the needed groups based on the most efficient function (user defined). Also, the recordset idea was good, (and probably more...

I solved it using SQL....here's the function if anyone's interested: Put the Queries in a table (in this case MODEL_Auto_Query)*** Three Fields (Order, Query, Selected) [Number, Text, Boolean] I call the function through a macro. Function UpdateRefresh() ' Dim db As Database Dim...