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!

Register Log in
  • Congratulations dencom 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: *

  • Users: samyers
  • Content: Threads
  • Order by date
  1. samyers

    Return detail records only if all meet a condition?

    I have a challenge with a sales database. There are two tables: header and detail. Header has order_number and order_status, along with various other fields. Detail has order_number, line_number, line_status. The application is supposed to set header.order_status = 'C' when all...
  2. samyers

    Change column names for reporting

    I'm doing a data pull from an Oracle db to a .csv that I then import into Access. One field is a date; it's formatted in the table as mmddyyyy but I want to pull it as mmyyyy. I have this in my query as SELECT to_char(d.posted_dt,'MMYYYY') which works, but the column name then appears as...
  3. samyers

    Import using multiple specs depending on field value

    I don't even know if this is possible in Access, but I'll throw it out there. I have a text file containing an extract from a large mainframe db. Each record contains one 400 character field, and represents one of 3 types of data: CUSSMITH99999123MAINSTNEWYORKNY10011 is a customer...
  4. samyers

    Write conflict error when updating table through form

    I have a table which users need to update via a form. There is a combo box which they use to select the record to update. The box has this code behind it: Private Sub cmbGroup_AfterUpdate() strGrpNumber = "SELECT * FROM tblGroups " _ & " WHERE GrpNumber = '" _ & Me!cmbGroup.Column(0)...
  5. samyers

    Cursor will not advance past a combo box

    I have a form which synchronizes two combo boxes: the contents of box 2 depend on the selection made in box 1. This has been working perfectly, and I haven't modified anything in the form for several weeks. Today I opened the form to check something, and now the cursor will not move past box...
  6. samyers

    Can't print form parameter on report

    I have a form, frmReports, with two fields: txtReportBegDate and txtReportEndDate. I use this to pass the date parameters to the query that is the record source for my report. The query works fine so I'm sure the parameters are being passed. However, I want to use those parameters as part of...
  7. samyers

    Recordsource for form with 3 underlying tables

    I have a form which contains data from 3 tables: Table A - the main table Table B, C - supplemental tables A is linked to B and C in one-to-many relationships. Because there are 3 tables with one-to-many relatioships, this is not an updatable recordset. I can view records but not add, update...

Part and Inventory Search

Back
Top