Search results

I am trying to requery all of the subforms in my tab control when information from a certain unbound form is entered into the tables. Here is what I have so far, but it doesn't seem to want to cooperate. Dim myObj As AccessObject, db As Object Set db = Application.CurrentData 'get...

Its kind of a tricky form, since it is actually a subform. The form itself is bound to a query which pulls from 3 seperate tables (which is a pain in itself when trying to do Ref. Inegrity), there is a subform within the subform, however, that has 2 unbound fields that I would like to track...

Is there a way to grab the data from a form BEFORE the On Current Event. i.e. when the record changes, I want to gather unbound data from the form BEFORE the record changes (the old data on the form, not the new data coming in).

Thanks Glynch, Your post helped me. I also realized that I needed to also change my Record Source (not just my Record Set) for what I was doing. I got it working now.

What is wrong with this Sub Procedure? Private Sub Form_Open(Cancel As Integer) Dim whichSet As String whichSet = "SELECT tblHistory.Comment, tblRma.SerialNum, tblRma.RmaID " & _ "FROM tblRma INNER JOIN tblHistory ON tblRma.RmaID = tblHistory.RmaID " & _ "WHERE (tblRma.SerialNum)=" &...

I decided to make a seperate relationship model using simply "contact company" table and "contacts" table. These table values will display on my form according to the company that belongs to any particular unit. So... Yes, you are right. I was forced to move "Ship To" out of my "Units"...

What if I need info only from "tblCompany" and "Ship To" Table, but none of the tables in between? How would I do this? I haven't had any luck thus far. I would like to have a list of all "Ship To" adresses that have ever been associated with a certain company (I don't care about unit data or...

My company table "tblCompany" currently has a one-to-many relationship with my units table "tblUnits". I would also like my company table "tblCompany", to have a one-to-many relationship with my "Ship To" table and my "Bill To" Table. Is this possible? Here is the current structure of my...

You Rock Tiro, Works like a charm. I found the OnCurrent event of the form and placed my combo requery in there. Thanks...

I think I've got it, my only problem is now the requery event of the combo box. How can I make the combo box requery every new a different record is scrolled to? There is no OnNewRecord Event in the form events collection, is there something similar?

Touche, My brain hurts too much to think about this right now. Algorithmic solution: Follow the previously mentioned steps and then count the number of times a full name appears (maybe w/ another query), then... If the full name appears more than once, filter it out.

That sounds cool, but you're going to have to spell it out more than that for me. I have been staring at this for so long, I don't really even remember what I am looking at.

Create a new field FullName: FullName: =FirstName + LastName Now create the aforementioned field MoreThanOne, but replace TicketNumber with FullName: MoreThanOne: IIf([FullName] > 1, "Yes", "No") This will filter out Full Names. That way if Patrick Henry calls once and then Patrick Swayze...

I have quite a complex set of relationships. I've got a table dedicated to Ship To Adresses. I would like to populate a combo box (cboContact) on a form with only those Contact Names that are associated with the company name that resides in the text box txtCompany. The problem, I can't find a...

Sort by Date (Descending) then by Scanner (Ascending), this will sort the sort the scanners by date. I believe this what was meant by grouping. You can then use the Dlookup function to get the first Date. In your VB Code try this Dlookup("[Date]", "yourQueryNameHere", "[Scanner] = '" &...

Go into design mode directly from the MainForm. Then click on the subform a couple of time until it gets the focus. Now you can do whatever you want in there.

Found it: DoCmd.GoToRecord , , acGoTo, myPos I had a couple of ambiguous statements in my goto parameters

I am using this bit of code within a subform, however, it only works when the form is run independently (not as a subform). DoCmd.GoToRecord acDataForm, Me.Name, acGoTo, myPos The name of the subform is 'Repair Traveler' I get the error 'Repair Traveler' not open I have also tried this...

Does anyone have the inside scoop on GUI cracking? From what I understand, it is the act of putting a form (or button) on top of a precompiled, secure GUI and making the new form (button) have the appearance of being inside the actual precompiled form. My understanding is that this method can be...

Never mind, I'm an idiot. That question you asked about the text box being one line tall... Yeah, that was me, I'm the guy, I never though I'd be the idiot that forgot to check something that simple. Thanks