Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Amadea

    Hiding Controls on Report

    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.
  2. Amadea

    Hiding Controls on Report

    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.
  3. Amadea

    Hiding Controls on Report

    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...
  4. Amadea

    Text box value not recognized

    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...
  5. Amadea

    Text box value not recognized

    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...
  6. Amadea

    Inserting records to a table using query and form data

    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...
  7. Amadea

    Inserting records to a table using query and form data

    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...
  8. Amadea

    Inserting records to a table using query and form data

    It’s kind of similar to the question on the list from Jun 27, except I’m not adding unnecessary info (I don’t think ;). I built the database when data was structured differently. Since then, the data structure was significantly changed and I’m just now catching up in revising the database to...
  9. Amadea

    Inserting records to a table using query and form data

    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...
  10. Amadea

    Code branching not accurate

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

    Code branching not accurate

    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...
  12. Amadea

    Code branching not accurate

    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...
  13. Amadea

    Can you 'nest' a WHERE?

    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
  14. Amadea

    Can you 'nest' a WHERE?

    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...
  15. Amadea

    Trouble with rpt preview screen

    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...
  16. Amadea

    Trouble with rpt preview screen

    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...
  17. Amadea

    Adding successive records

    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...
  18. Amadea

    Trouble with rpt preview screen

    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...
  19. Amadea

    Adding successive records

    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...
  20. Amadea

    Adding successive records

    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...

Part and Inventory Search

Back
Top