Search results

  1. R

    Update query

    Don't I feel like a total newbie :o Thank you John :)
  2. R

    Update query

    This is pretty straightforward; I am trying to make an update query where the update to value is specified by the user. (prompted when running the query). What should I do ?
  3. R

    add or change a record

    Pat, thank you for your help, I have redesigned the relationships, and I think I understand a lot more about access now. It is the structure of the relationships that calls in for such a message. I think I have it working now, so I appreciate your help on this. :)
  4. R

    copy and paste

    Mr. B, it's perfectly allright, my problem's solved, there's no need for that. Thanks again.
  5. R

    copy and paste

    @ Mr. B thank you, I appreciate it. @ boblarson, I want to add new records in two tables simultaneously without having to use a subform in my original form. Is there a better way to proceed?
  6. R

    copy and paste

    This one is pretty simple; I have a form with multiple text boxes, and I need a piece of code that immediately copy pastes the content of one textbox into another as the user types into the first one. Many thanks.
  7. R

    add or change a record

    Pat, this does not make any sense to me. Do you mean to join cfID in CustInfo to another cfID in Discounts with a one to many relationship?? What do you mean by foreign key, is that different from a primary key? and should it not be the other way around, i.e. the primary key in CustInfo that...
  8. R

    add or change a record

    Hello, I have a bit of a snag, a "you cannot add or change a record because a related record is required in table"; I have two tables, one that's called "custinfo", and the other "discounts". Each table has "cfID" as an autonumber field, and both are primary keys in each table. I have a field...
  9. R

    Black Highlight

    I have a couple of databases where search boxes highlight the text black for a split second every time I type anything. This is annoying as hell for my users because they use old computers. I need a way to prevent that from occuring.
  10. R

    double click

    Okay, eummm... this code does not work.. I did this instead: Private Sub SearchResults_DblClick(Cancel As Integer) DoCmd.OpenForm "newform", acNormal, , "[RecordID] = " & Me.SearchResults.Column(0) End Sub Now, it works :D Many thanks :)
  11. R

    double click

    I have these 3 fields in the query in the following order in design view: ClientName, RecordID, FatherName. The criteria for ClientName is: Like "*" & [forms]![Form1]![SrchText] & "*" I then skip a line on "or" in RecordID: Like "*" & [forms]![Form1]![SrchText] & "*" And no such thing on the...
  12. R

    double click

    Okay, it gives [RecordID]=ClientName. (ClientName is another field in the list box). This isn't correct. However, I tried putting ClientName instead of RecordID on stLinkCriteria in the code, but it still does not work. same error. Strange...
  13. R

    double click

    The first column (column number 0) is the RecordID, I have created a form (newform in the code above) with a RecordID field, but somehow it gives me this whenever I double click a record in the list box: Syntax error (missing operator) in query expression '[RecordID]=name of the selected client...
  14. R

    double click

    The source is a query with a criteria; http://www.access-programmers.co.uk/forums/showthread.php?t=188663 The first field isn't RecordID, but even if it was, it doesn't work.
  15. R

    double click

    I have pasted a code below which used by John Big Booty in a tutorial to open another form and populate its fields from a list box in another form. After creating a simple form with fields, I have pasted this code in the double click event for the list box, but on double click, access gives me...
  16. R

    first, previous, next, last

    Wow! Thanks a bunch :)
  17. R

    first, previous, next, last

    I want to include first, previous, next, last buttons for a list box,, I am a beginner with VBA, what should be done ?
  18. R

    Search Box in form

    I finally got it to work, I don't know what went wrong, but when I changed the form's name it worked like a charm. Thank you very much Alex.
  19. R

    Search Box in form

    Yes, of course, I followed the steps carefully. It has to be something else.
  20. R

    Search Box in form

    John your tutorial is great, but I keep getting a message on the query and the form asking me to supply the parameter value for the text box SrchText. When I hit cancel, I get a run-time error 3021 in the visual basic window. Can you help me out? thanks.
Back
Top Bottom