Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gmmastros on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. MICKI0220

    query that uses multiselect from form

    PHV. That worked great for what I was asking for. I have run into another quandry relating to the same query. If my table that I am querying on has a null field for one of the values I have put in the such as (C.szSearch_key Between Nz([Forms]![frmPayrollHistory]![txtCostCode]. Then my...
  2. MICKI0220

    query that uses multiselect from form

    Thank you PHV. I will try it out.
  3. MICKI0220

    query that uses multiselect from form

    I only want the criteria to be what the user populates. For example there are five areas for them to enter data. 2 areas(employee id range and date range) need to be populated. The others areas, they can choose to limit their report furter by choosing , one, two or all three extra areas.
  4. MICKI0220

    query that uses multiselect from form

    I have a form that I need the user to be able to choose what ever they want to fill in to manipulate the query. Currently I can only get a few combinations to work. All combinations require the date range and the employee id range. Currently I can only get the combination of the jobNo to work...
  5. MICKI0220

    autonumber on form from SQL Backend

    I have a form that I input records. It doesn't allow me to save a record because it is not auto populating the field with the automatic number from the sql backend. When I open the form it opens on a new record. How do I get it to automatically assign the number so it will save a record?
  6. MICKI0220

    Change a make table fields data type through code

    I have tried code and I keep getting this error "Syntax Error in ALTER TABLE statement" My code is as follows" DoCmd.RunSQL "ALTER TABLE Dump ALTER COLUMN Notes number(10)" I have tried int, plain number etc. I keep getting the same results. If I manually change it from memo to number it...
  7. MICKI0220

    Change a make table fields data type through code

    Yes I see numbers in the datasheet view of the table I am pulling it from as a memo field. I see it as numbers when I create the table when I use the original query. I do not see anything in the field (null), when I use the "int" conversion. I do not append because it will not append a memo...
  8. MICKI0220

    Change a make table fields data type through code

    The application we are getting this information is a memo field. When we implemented this program we needed a match field created to match up documents with data from two different sources. Unfortunately it is a canned program and the user defined fields are of the memo type and could not be...
  9. MICKI0220

    Change a make table fields data type through code

    I spoke too soon. I just noticed that it does change the data type but no data comes into that field. It should be a a bunch of numbers. I think what has to happen is that the table needs to be created like I do and then run some code to change the data type. Just a thought Micki
  10. MICKI0220

    Change a make table fields data type through code

    Thank you. Thats what I needed to know.
  11. MICKI0220

    Change a make table fields data type through code

    It is created by a query. SELECT dbo_tblApHistHeader.InvoiceNum, dbo_tblApHistHeader.VendorId, dbo_tblApOpenInvoice.InvoiceDate, dbo_tblApHistHeader.Notes, dbo_tblApVendor.Name INTO DUMP FROM (dbo_tblApHistHeader INNER JOIN dbo_tblApOpenInvoice ON (dbo_tblApHistHeader.InvoiceDate =...
  12. MICKI0220

    Change a make table fields data type through code

    I have a table that is created and dropped each week. It is used as an export to populate and update fields in another program. Unfortunately one table has the field as a memo and the table it is going in is a number data type. I manual change the datatype of the memo field to number before I...
  13. MICKI0220

    edit crosstab query by form

    I have a crosstab query that I need the date to be taken from a form when it runs. This is the current code. TRANSFORM Sum(HrsForCrossTab.Hours) AS SumOfdHoursWorked_qty SELECT HrsForCrossTab.EmployeeId, HrsForCrossTab.JobNo FROM HrsForCrossTab GROUP BY HrsForCrossTab.EmployeeId...
  14. MICKI0220

    Create a string from several records

    I think I should mention that there may be several groups of id's such as three records with the same id, 1 record with another id and then maybe 4 of another id. What it needs to do is group the id's together and then concatenate the Description field of the same id's
  15. MICKI0220

    Create a string from several records

    Sort of. I guess I should figure out how to separate my fields up there. The record should be under ID Column Header, just 25093, and then under Description column header should be (Child Support,401K,Life Insurance)
  16. MICKI0220

    filter records that have zero across all fields

    I got it to work by placing it at the field level. Thank you for all your help
  17. MICKI0220

    Create a string from several records

    I have a work table which has two fields in it, a person's id and the deduction description. The person's Id is the matching field in all records. Basically I could group on this field if the other field was a sum or some sort. However the Deftinition is text and I need to create a string of...
  18. MICKI0220

    filter records that have zero across all fields

    lbass I don't understand how you place a formula in the detail section instead on the record or group section?
  19. MICKI0220

    filter records that have zero across all fields

    and what if I have multiple costcodes to do the same thing to....for example [code] //{@Actualqty}: if {Report.CostCode} = "TM10" or "TM20" OR "CF10" Then 0 else {Report.ActualQuantity} //{@estqty}: if {Report.CostCode} = "TM10" or "TM20" OR "CF10" Then 0 else {Report.EstQuantity}
  20. MICKI0220

    filter records that have zero across all fields

    I must apologize, that issue was what I thought my user wanted and now they have clarified it once I made the change. They want two field values in a record to change if the costcode is TM10 etc. My code is something like this WhileprintingRecords; if {Report.CostCode} = "TM10" Then...

Part and Inventory Search

Back
Top