Recent content by jonwentz

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

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

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

just tried you suggestion but it didnt like it

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

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

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

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

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

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

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

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

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

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

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