Search results

Thanks for the reply, Pat. That clears things up a lot for me. Could you point me in the direction of a good (comprehensive if possible) example so that I can see this in action? Thanks, Sam Edit: I suppose I should elaborate somewhat. I want to use QueryDef's to implement a fairly...

If there's no way to do it, could someone post a "No." reply please. Thanks, Sam

I'm having a hard time wrapping my head around QueryDef's--hopefully one of you enlightened individuals can help me out here. I understand that QueryDef's are just a way to dynamically alter existing saved queries, however I have a few questions... 1) The database application I am developing...

Is there any way to get a report to be wider than 22 inches? Thanks in advance, Sam

Yeah, I know "" != NULL, and also that you can't assign a zero-length string to a numeric field...I can't remember exactly what error I was getting, but I think it may have been unrelated, because I just tried doing it again on a fresh form and it seems to work. Here's a quick question for...

Help file Huzzah! CurDir() Sam

Pat: would a Forms!frm_MyForm!txtWhatever.Value = "" clear the value that is currently displayed on the form? I've had trouble with that lately, and that's why I've been just setting the control's focus and updating the Text property...but if it's better to update the displayed value via...

Thanks! In my case, I had 6 columns returned by my select statement, and I only wanted the third and the fourth columns to be displayed in the list box. Setting the Column Count to 2, and the column width's apropriately yielded an empty list box, however, setting the Column Count to 4 with the...

Nobody has any ideas? Come on...I'm willing to try anything here!

Try this... for the employee name and department textboxes, try the following lines instead of what you have: ------- Me!EmployeeName.setfocus Me!EmployeeName.text = "" Me!Department.setfocus Me!Department.text = "" ------- That will work for other textboxes you're trying to clear as well...

New Day...any new ideas? I should note as well that I realize I can return only the columns that I need from within my select statement...however, the application requires the other data, while the listbox does not. I'm looking to select only specific columns from my recordset to display in...

Okay, I've figured out the custom headings thing (that was kind of a dumb question...sorry). How about the other part of my question though? How can I only import certain columns into the listbox? Sam Edit: While I'm rattling off questions...is it possible to get a horizontal scroll bar on...

Hey folks, here's my situation in a nutshell: I've got a "Table/Query" type listbox that I am populating as follows: ------------- SQLStatement = "SELECT * FROM tbl_StrategyDeliverables " & _ "WHERE StrategyID = " & ParentForm.txtID.Value ...

Brilliant! So simple and effective. I can't believe I didn't think of it :confused: Thanks a lot! Sam

I think I may be using the Parent object incorrectly. You're reading my post correctly--I'm trying to access (relatively) the form from which the current form was called (they are both two completely different forms), is there a way I can do this? Thanks, Sam

I currently have a frm_Initiative form which loads a frm_Jurisdiction form in order to collect information that will subsequently be put into some textboxes on the frm_Initiative form. I want to use the parent object within frm_Jurisdiction because there will be a few different forms calling...