Search results

Thanks a bunch Elana, fellow Seattlite!

Error opening query recordset that references control object I have a several saved queries that are hierarchically dependent. In one of my forms I need to access one of the queries. Set rs = db.OpenRecordset("qryCTI_Unbilled") But I get an error: Run-time error '3601': Too few parameters...

I have a saved query (a view) from which I would like to navigate through in its entirety as a recordset. This query is built off of other saved queries. The saved query is called "qryCTI". There are a few queries to which it is dependent upon, but the one that it is directly tied to is...

Thanks for correcting my syntax, Pat. I'm actually using form control objects as the date variables.

You're right, Pat. This was easy enough. All I had to do was use the Date() function in the where clause. SELECT * FROM table WHERE Date() BETWEEN '4/30/02' AND '5/1/03'

I'm working a different database and I still get these annoying "Enter Parameter Value" that has no effect on anything but to cause user confusion. I think this is caused through changes in a query's structure that a form or report has once referenced. Even though it has been taken out...

I am fairly familiar with Access SQL. I know the date function for VB, but I was just wondering if there is one for Access SQL it self. If not, I guess I'll have to use VBA to support it. Thanks, Pat. Yes, Seattle's my favorite city as well, I've been all over to place and this is the place...

This seems like a straight forward function but I don't quite know how to call the current date function in the Access SQL query. SELECT * FROM table WHERE sysdate BETWEEN '4/30/02' AND '5/1/03' (sysdate: the current date function (Oracle current date)) TIA, D

What is the way to select a check box in an option group by VBA? I'm not sure what property to use. I have a form with a combo box of 100 items on it, and an option group with 100 checkboxes. I am trying to synchronize the two, i.e., when an item in the combo box is selected, the appropriate...

Duh... can't believe I didn't think of that. Thanks!

Is it possible to code the form window's X Close button in the upper right hand corner? I want the user to have the normal windows control but I wish to enforce some background code to properly code the form like I have with a cmdClose button on the form. I'm wondering if it's possible to...

Zero-based row index It works! Thank you very much, Jon! Am I correct in saying the following for comboboxes, the row indexes being, zero-based: 1) If column header is shown, then Row index 0 = the column header (or if used in the aforementioned line of code), and the value would be...

I have several forms which contain a set of controls I need to manipulate in VBA. The set of controls are located on the main form (forms that do not have a subform), and on the subform of another form (2 other forms actually). I need to create a public procedure that will modify the...

I have combobox for which I wish to select a value based on an designated index integer N. I tried the following code but it says that I am not using the ListIndex property correctly. Me.cboPosition.ListIndex = N This works for my listbox; I'm trying to get the same effect...

I don't think this will scroll down to the desired record but it should at least select it: listbox.Selected(N) = True (where N is the index)

I know Access VBA does not support Array Ojects, so as an alternative, I created a set of 100 checkboxes naming them with number suffix (chk1 - chk100). I have code to synchronize those 100 checkboxes to 100 rows of a listbox. On one of the forms that I used this on, the listbox is single...

Thanks a lot, John!

What I'm trying to do is to essentially run an AfterUpdate event from a combobox for "cboBox". This time what I've tried is to do is create the Public Sub in a module. It says "Me" invalid keyword. How do I use a String Variable as in assigning values to a control? I thought this would be...

What I am trying to do is assign values to form controls via a public sub procedure called on by a form. So in testing this is what I have done: The first msgbox returns the formname. The second msgbox returns the the value in cboPosition The third msgbox I am attempting to get the same...

Okay, this should be simple, but I don't have much experience using class modules. I tried browsing around for an answer, but I think my level of expertise (or lack thereof) on this matter would make it as easy to find here as the needle in the haystack. I have several different forms that...