Search results

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

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

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

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

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

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

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

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

Hi all, I have tried searching the forum for this one but cant quit find it. So here goes I have a form (form1) that has all kinds of data And a form (form2) that only has 3 fields This is what I am trying to do on form1 as the user fills it they come to the section where the address goes...

Trying to figure this out, but I’m not getting anywhere. I have 2 tables one is just a list of options that can be used in a drop down box in the other table. What I am trying to do is create a query that will count how many times the words from the first have been used in the second query. I...

I am trying to make a query that will count how many times a word shows up in a field. I am still new to access and am having trouble with this one. Any help will be greatly appreciated. Thanks in advance Jon

could someone tell me where i went wrong with the code belowi would like to be able to query for last week WHERE (DATEPART(yyyy, dbo.[Inventory Transactions].TransactionDate) = DATEPART(yyyy, GETDATE())) AND (DATEPART(m, dbo.[Inventory Transactions].TransactionDate)...

hi, all Is there any way to tell a tabular form to display the last 31 records when it is opened thanks in advance jon

i cant seem to get this to work. any help would be greatly Appreciated =sum(iif([SADate]>=DateSerial(Year(Date()),Month(Date()),[p])) thanks in advance

Hello all, i have a form with 2 fields [edate] and [qty]. what i am trying to do is sum [qyt] by month i have in the footer for a text box that sums [qty] =sum([qyt]) now i need it to be able to give me the sum of the current month can someone let me know how to do this thanks in advance

hi all i have a form with a list box that is linked to a table, and i have a subform that is linked to a different table. when i select a item in the list box it brings up only the records for that item in the subform. this works great in access. but i needed to upsize my database to SQL...

I have a problem with trying to query the current day, month, and year. i am trying to do this with sums: A Good: Sum([1 1/4 Rod Bodies].[A Good]) A Bad: Sum([1 1/4 Rod Bodies].[A Bad]) i do have a DateModified: field any help will be Extremely appreciated

Hi, I have an issue, i need to query between 0700 and 1900 and 1900 and 0700 i am trying to devide two shifts thanks in advance

Hi, I have a query that sums up 2 colums and then adds them together. now i need to add a year to date query, and a month to date query to this. is there a way that i cam do this. here are my first 3 Fields in my query Sum Of Good: Sum([1 1/4 Rod Body].Good) Sum Of Bad 1st: Sum([1 1/4 Rod...