Recent content by viperbyte

  1. V

    How To Get Access To Forget About the Past?

    Yes both are mentioned. My brain is mush. I found the problem. NAME1 is one of the fields in Labels in the label report and that was a problem. I changed it to firstname and put firstname in the sql statements and the paramater input boxes went away. Thanks everyone for looking it over :)
  2. V

    How To Get Access To Forget About the Past?

    The problem didn't go away after compiling. So I opened a copy of the database that has never seen the problematic code that was well behaving. In that copy I added the following code and the now the same thing is happening that I get two input boxes one after the other. One says enter NAME...
  3. V

    How To Get Access To Forget About the Past?

    I wrote a routine that causes input boxes to popup and that was not my intention. I think the following line is what caused that: 'cmdSQLInsert.CommandText = "Insert Into Table1(ID, NAME1, AGE) Values(?,?,?)" I don't need the input boxes and finally wrote this thing to work like I want. But...
  4. V

    Code for for Displaying Form is messed up

    My third message is more specific.
  5. V

    Code for for Displaying Form is messed up

    This can't be done in a query. There will be additional info added conditionally that needs to be done by client side processing. There are three different possible directions to take depending on the comparison of two of the fields in the rs. Then after evaluating that, different data will...
  6. V

    Code for for Displaying Form is messed up

    I have my F8 working. I see that the problem is that I wasn't adding .value to the end of targetRs.Fields(0). So it's MyRecordSet.Fields(0).value. I also added .value to targetRs.Fields. My problem now is that targetRs.Fields(1).value isn't good syntax. targetRs is empty. How do you guys code...
  7. V

    Code for for Displaying Form is messed up

    Oooops; I mis-wrote the title of this thread. It is a REPORT that I am having trouble displaying.
  8. V

    Code for for Displaying Form is messed up

    Hello everyone. I hope somone can help me. I'm new to Access VBA. I'm trying to get a labels report generated. For now I would be content to be able to display only two fields-description and brand in the report. If I can get this far then I'll go deeper in the processing and desision...
  9. V

    VBA Coding Problem

    Thanks Paul :)
  10. V

    VBA Coding Problem

    Good morning all. I'm stuck. I'm trying to copy some data from a result set into a temp table that is created on the fly. After I coded this and tried to run it I get an error dialog box pop up that says: Compile error: Method or data member not found. .cnn1 is highlighed with the error...
  11. V

    How to use button and textbox?

    Thank you very much. That helped tremendously. Super thanks :)
  12. V

    How to use button and textbox?

    Hi guys. New guy; first time here. I'm trying to get some work done by way of when a user clicks a button on a form. When I add a button to a form in Access 2003, it asks me what kind of button do I want:recordset, miscellanious, form, query, macro and so forth. I don't want any of those. I...
See more
Back
Top Bottom