Recent content by coyne

  1. C

    Run time error

    I'm trying to add a graph to a data access page useing the graph wizard but I get an error "Run-time error '424' Object required". Does anyone know what I'm doing wrong? THanks
  2. C

    find record and set active

    I tried a variation of that and it didnt work. I dont want to use a comdo box because evetualy it might have a couple hundred records in it. this is the code, it sets the text0 field active but just the first record, not the one that matches the dategoto text box. Private Sub...
  3. C

    find record and set active

    Maybe someone can help me with this. I'm trying to do a search on a continuos form that will set the record Im searching for to active. I tried to use docmd.Findrecord but I couldn't get it to work, any Ideas. I attached an example. thanks
  4. C

    Update query

    Thanks, thats pretty cool. I'll post again if I have any problems. but I think that should work.
  5. C

    Update query

    That sounds like it might work but how would i do that, do I somehow use the DATEPART function in the default value of the table or would it have to be VBA atached to a update form? My VBA skills are not that great so I might need help with that. I might want to just stick with the table of...
  6. C

    Update query

    It's like a calander showing who's working for each week. I'd like to have it set up for the whole year. is therre a better way to do this? -
  7. C

    Update query

    How can I make an update query to fill a new table with monday dates for the whole year? Thanks
  8. C

    OutputTo question

    I saw the transfertext post similar to this so I tried what was suggested there but I'm getting an error message. "Z:\path\filename" & Format(Date(),"yymmdd") & ".rtf" is my syntax wrong or somethnig?
  9. C

    OutputTo question

    Is there a way to set up the OutputTo macro to apend the date on to the file name? Thanks
  10. C

    query question

    How can I write a query that will show all records entered between a 24 hour piriod of 7am to 7am? Thanks
  11. C

    Wildcard in table?

    This is what I ended up doing. It seems to work ok. This is my first vba script so if I'm missing anything or theirs a more efficient way, let me know. also how do I make the input case sensitive. Dim joblen Dim jobalt Dim Sql_Str As String Dim db As DAO.Database Dim rs As DAO.Recordset...
  12. C

    Wildcard in table?

    I was thinking somthing like this but I dont know how to code the query in . joblen = Len(jobin) While joblen <> 0 jobalt = Left(jobin, joblen) & "*" joblen = joblen - 1 ???? Wend
  13. C

    Wildcard in table?

    I would like to use this data base to pull up a job on my system and find the programer name and failure actions. there is a ton of jobs and many of them have the same failure action and programer name. The jobs naming conventions are in a way that being able to use wild cards in the table...
  14. C

    Wildcard in table?

    Hello how can I make a query to search a table with wildcards in the table. example table: jobA* jobB* searches: jobA11 would return jobA* jobA22 would return jobA* jobB11 would return jobB* . . Thanks Im kinda new to this so any help is appreciated.
See more
Top Bottom