Search results for query: *

Sorry....I didn't see your comment. Yes, I do have "Visible" on each control I want to hide/unhide. But it's one of those areas I need to double check. There just must be one thing misspelled or mismatched or something. Thanks for the thought.

Thanks. However, that didn't change the outcome. poo I must have a typo somewhere or something mismatched. I just don't see any reason why the same approach wouldn't work for multiple reports. I'll go over it again, very carefully. Thanks again.

Well, I've looked through the archive and haven't found a solution. I'm trying to use the following code to hide/unhide report controls based on specific criteria. Curiously this same method works just fine on a different report. Private Sub Detail_Format(Cancel As Integer, FormatCount As...

Well, there is a command button that initiates this sequence of events. Based on how the user has completed data entry fields on the form, changes are made to the database tables. In this case, there is a table called InstrName that should be updated based on whether the instructor name fields...

In the following snippet, before Else works fine. You'll remember helping me with interating through a list box. However, after Else fails to pick up the value in Me!CRN. In other words, the new record is added, all the values are entered from the text or combo boxes as indicated except for one...

Yes, CRN is the first column and bound column. So I shouln't have to worry about that. My test data was a little scewey so it looked like nothing was working. Once I cleared up the extraneous stuff "created" during previous tests, it seems to work perfectly now. Thank you all SO MUCH for your...

Thank you. Yes, you understand it completely. Here's what I have, but it's not adding the record. My list box is named lstCombSect and it has 4 columns of data, i.e., CRN, Subj, Num, Xlst. Do I need to specify which column of data? With 'Private i as Integer' in the Declarations. 'Instructor...

...instructor name table Dim db As DAO.Database Set db = CurrentDb If IsNull(Me!XLst) Or Me!XLst = "" Then Set rs = db.OpenRecordset("SELECT * FROM InstrName WHERE CRN = '" & Me!CRN & "' ", dbOpenDynaset) Else Set rs = db.OpenRecordset("SELECT * FROM InstrName WHERE InstrName.XLst = '"...

I've searched the archives and recent posts, but have not found exactly the solution I need. Your help will be much appreciated! I need to add new or update a record in a table. In the code below, the Else part works. It's the first part I just can't get right. What I'm trying to say is for...

You are an angel! I did see the eleven, just foolishly thought it might be a typo. Now I know better. Thanks again.

Great, thank you. I'd forgotten about Trim...a valuable tool. I've since changed the line Me!lstSelectSection.Column(12) referring to a column in a list box, to Me!txtSpeNarr referring to a hidden text box that "displays" the field data I am evaluating. Is there some reason why using...

Hi all, The code snippet below is the last section of an If..Then. The code preceeding checks to be certain combo boxes have a selection. Once that is satisfied, I want the record selected in the list box to be evaluated as to whether the 12th column of information is empty or not. If the column...

Yes, I see. And this helps very much. I see now how I have to state the criteria line. I'll still have to repeat a phrase but not in the format I thought was correct. Thanks!!! Amadea

Hello all. Just wondering. I've included a SQL statement that has a compound WHERE. Now I want to add an additional required condition. Can I nest it by placing parens before and after the current WHERE and add my added condition with an AND before the parens? Like this: "WHERE...

Thanks guys for your input. I think that because I hide the Access window, I cannot minimize the opening form so I'm going to have to abandon the thought of previewing the report. Now I have another problem/dilemma. But I think that belongs on the forms forum, so I'll ask there. Thanks for...

Thank you very much for the information. I've looked through the FAQs and searched other forums without luck in finding the howto. So, I have to ask. Now, the DoCmd.Minimize and .Maximize have no arguments, therefore, how do I specify the forms to minimize/maximize? Below is my code to...

You're the best! I see exactly what you mean. I'm not really thinking everything thoroughly through in setting up the messaging. I'll pay closer attention in the future. Also, the Me.Requery is perfect! Exactly what I was looking for, but obviously didn't know how to look for it. Thanks...

Hope this is the correct forum for this question. All the forms in my database or set to be popup. About three forms deep I've set the "Print Report" button to preview the report before the user chooses to print the report, however, the preview opens underneath all the forms. Why does it do...

Wow, very nice. I think I had Exit Sub when the user selects Cancel, but I've changed that so the user is positioned at the combo box. I'm assuming that if the user chooses to cancel the add event, they will probably want to choose an existing record to edit. If not, then they can click the...

Well, I did a little testing out again and things seem to work now. Am I just imaging this?!? I omitted the docmd.showallrecords because I failed to realize that it removed the filter I have set for the form. Can't do without the filter. And I added a DoCmd.RunCommand acCmdSaveRecord...