Search results

  1. J

    Trying to get a query to change text

    there are about 20 items that i need to do this for F2 1.25" Fiberglass Sucker Rod F2 1" Fiberglass Sucker Rod F2 7/8" Fiberglass Sucker Rod F2 3/4" Fiberglass Sucker Rod And so on other items have F2 in them so i cant just use F2 thanks for any help
  2. J

    Trying to get a query to change text

    I have a report based on a query and it hase a [Product] and a [Quantity] field Quantity Product 80 F2 1.25" Fiberglass Sucker Rod 60 F2 1" Fiberglass Sucker Rod 80 1" coupling 60 7/8" coupling what i am trying to do...
  3. J

    Trying to get this code to work

    What I am trying to do is use the example that Gromit Posted for an Access database, and use it in an ADP
  4. J

    Trying to get this code to work

    just tried you suggestion but it didnt like it
  5. J

    Search Form Example

    it works like a charm. but does anyone know how to get it to work in an ADP. thanks
  6. J

    Search Form Example

    it works like a charm. but does anyone know how to get it to work in an ADP. thanks
  7. J

    Trying to get this code to work

    Hi All, I have been trying for some to to get this code to work in an ADP, it works just fine in and MDB. It has me stumped. I have tried it as a View, SP, Function. I have tried to change the wildcard from * to %, but it still will not work. Like "*" & [Forms]![Searchform]![Searchtext] &...
  8. J

    Search using Popup form

    OldsoftBoss, is there a way to adapt you addition to an ADP thanks in advance
  9. J

    One For the Gurus

    i am trying to use a search form that i got from this forum and i was trying to use it in an ADP. but i cant seem to get the query to work. has anyone ever tried to up grade it to SQL thanks in advance
  10. J

    Would like to know if I can do this

    I have a form that has 2 fields (Quantity) and (Description). Description gets it data from a popup form that inserts it in to the field Now I need to insert a calculation in to the field What I need is a way to multiply the (Quantity) by 37.5 and insert it in to the field like the following...
  11. J

    Save Record

    i have a field that auto generates a order number the problem is that i have 8 users on this db and a soon as they open a new order form it creates the number but if someone else opens the form it gets the same number
  12. J

    Save Record

    ok i have tried to figure it out but i am still having problems i cant figure out how to get the timeinterval back to 0 in VBA thans again jon
  13. J

    Timer event

    But i didnt get an answer he said to set it to 0
  14. J

    Timer event

    Hi all, I know i posted this in another thread but i think it goes here I am wondering if there is a way to save a record in this manner. When the user opens the form wait 1 second and then save. But I would like it to do this only once. I have tried the “on timer” but it keeps saving the...
  15. J

    Save Record

    I understand to set it to 0 but how do i go about doing it in VBA
  16. J

    Save Record

    ok how would i go about doing that
  17. J

    Save Record

    Hi all, I am wondering if there is a way to save a record in this manner. When the user opens the form wait 1 second and then save. But I would like it to do this only once. I have tried the “on timer” but it keeps saving the record every second. Thanks in advance Jon
  18. J

    Return to Null

    Hi all i would like to know if there is a way to return a field to null thanks in advance
  19. J

    Return to Null

    Hi all i would like to know if there is a way to return a field to null thanks in advance
  20. J

    Search Button Help

    Hi all, Here is what I am trying to do. I have a start up form with buttons, I would like to have a button that when clicked it would open a form for the user to put in the “order number” and then click another button that opens the order form to that record only. Thanks in advance Jon
Top Bottom