Search results for query: *

I have a similar function on one of my forms. If your query is a recordset object, something like this will work for you (in the button's Click event): ***************************************************** Dim con As Object Dim rs As Object Dim stSql As String Set con =...

Judge, again, I thank you for your helpful spirit and good intentions, but my question was not one of licensing or the legalities of active-x distribution... Those issues were distractors to my real problem--I simply wanted to make this control work in my db on other PC's. The simple and...

That's very interesting... I assumed that because my Windows Explorer view settings are such that no files are ever hidden from view, that the search function would automatically look at all system and hidden files. Wrong! You are right, evalesthy--the mscomct2.ocx *is* in the system32...

Yeah, I have read other threads/articles/stuff that led me to look at the mscomct2.ocx issue, however, on my PC (where the date picker works perfectly) I do not have this ocx anywhere on the machine. And what's with the "MSComCtl2" (with the "l") in the control's properties...

No offense, but that was a completely worthless and entirely unhelpful thread...

In an Access XP DB, I have an Access form on which I use Date Picker Active X controls. The control's properties lists it as 'MSComCtl2.DTPicker.2' The Date Picker controls look and work great on every PC I've tried it on *except* for the 3 PC's on which I really need them to work. On those...

Danvlas, you are right... thanks! Here's what I did. Put an unbound, hidden text box on the main form, and when my PK was generated on the first tabbed form, I had the aformentioned main form PK textbox populated with the value. I then used the tab change event with a select case statement...

Hi All, I've got a tab control with forms on each tab. The first tab holds my (autonumber) primary key field, which I need carried over to the other forms on the other tabs to serve as foreign keys in their respective tables. So, I create a new record, which populates my PK field on tab 1...

Robert, Your explanation helped me with the fundamentals of form/subform usage and behavior. I truly appreciate your time and response. I did find an elegant and simple way to control a subform's record via a button on the main form, so my desired (albeit more difficult) method of form layout...

TIA for any help... I have a main form, on which I have a tab control, and each tab has a subform. On the main form, I have command buttons in the footer ('Add New Record', 'Save Current Record', 'Delete Current Record') to do the appropriate things in each tab/subform, but the code behind the...

Well that's just slicker than snot on a marble! I knew it'd be something simple like that, I just couldn't figure it out. A thousand Thank You's...

Hi & thanks in advance for any assistance... In a simple asset db, I have an 'event' table that deals with events related to each asset. Each record in the event table has an asset serial number and a date/time associated with each event. There are duplicates of serial numbers in the table...

It's a little thing, but it's killin' me... I have the standard form w/ subform. The user makes a combobox selection on the main form to select a record to which to add associated data in the subform. The subform is set to 'continuous forms' to allow lots of easy data entry. So far so...