Recent content by clyons

  1. C

    linked excel table

    I've got a situation and i'm a bit unsure of if I can do it. I have forms that run to a query which is linked to an excel spreadsheet. Is there a way that I can get the excel spreadsheet to update with that query? or can you run an access database off a server? bit new to this program and...
  2. C

    Text box addition

    I uploaded a copy of the table in excel format, what im trying to do is have the shift 1 operators show each operator that logs in.
  3. C

    Text box addition

    any word of advice on how to do that?
  4. C

    Text box addition

    its a single user environment.
  5. C

    Text box addition

    The only reason I want to do it is just so that I know who was updating it without having too many data fields.
  6. C

    Text box addition

    So we have multiple operators producing items, one opens a form enters the order number, operator number, what he did and saves it. That goes to a table which has the data. Another operator scans that order number which populates the part number and operator field. What im trying to do is get it...
  7. C

    Text box addition

    I have a problem, I've got a form linked to a table cell using text. An operator enters their user number and then saves the form, another operator goes to update this form and the previous operator is called. How can I get that form to show a blank box but add a comma to the first operator...
  8. C

    Quick date question

    Well I feel retarded, ty.
  9. C

    Quick date question

    Does anyone know why when a date is inputted it will convert itself to ############?
  10. C

    filter table and open populated form or new form

    I've tried to call some basic search form functions and find records but im not sure on how to get it to differentiate between opening the new form or update form.
  11. C

    Auto fill data

    I did this a bit different, I selected the field I wanted then added a macro SearchForRecord and in the sql where added ="[Order Number] = " & "'" & [Screen].[ActiveControl] & "'"
  12. C

    filter table and open populated form or new form

    This is what im looking to do. I have a login/home box with an unbound text box. When I enter a number I want it to search through the main table to see if this number exists, if it does I want it to open the corresponding form and autopopulate the fields, if it doesn't exist I'd just like it to...
  13. C

    Auto fill data

    This is pretty much exactly what I need, hopefully someone has it.
See more
Back
Top Bottom