Search results

  1. G

    Error 5941 With Odd Source

    I am helping with a word manipulating Access app written by someone the company lost contact with. This is not my strong area at all, however, most of the time I can sort it out. It's been working well for a while now. Then in the last week, it's suddenly spinning odd errors. Some I have simply...
  2. G

    Troubling Cross Tab Query

    This is proving elusive at best...hair removing is probably a better description. I am mucking with a 'survey' I don't actually think it is, but its what its called, so lets stay with that description for the discussion. In Excel the survey data is presented: There are other complications but...
  3. G

    Make Excel Data Format as a Table

    I am not bad as a hack in Access, however outside it I get very lost very quickly. I have been using some code to export various data from Access to Excel. This is in my Access module: Dim wbook As Object Dim createExcel As Object Dim Wsheet As Object Dim fieldIdx As Integer Dim rowIdx As...
  4. G

    Some People Have Hair...Others Have my Boss

    :banghead: I have been working away and got the tool working how he wants it. Now he wants it changed...of course. I have one field of data it is a list of numbers. For simplicity The data is like: 1 2 3 4 5 and so on. My boss just sent me a mark up and he is asking for it to display on...
  5. G

    Whats the best approach too??????

    So I have a time in for visitors. The visitors stay for an average of 45 minutes. So if they arrive at 8.00 they leave on average at 8.45. I am trying to count something like: Betty arrives at 8.00 (assumed to leave at 8.45) Wilma arrives at 8.15 (assumed to leave at 9.00) Linda arrives at...
  6. G

    Time Queries :confused:

    I have a real hard time with time...sometimes it works fine. Others, well not so much is a nice explanation for not at all rhyming with duck. Todays challenge should anyone choose to accept it before I explode is the following: SELECT qryVisitTime.TimeCut FROM qryVisitTime WHERE...
  7. G

    Hi Hows it Going?

    Well if I don't say it … no one else will. And if we don't give self praise then...well it would be a sad world. I use Access for various work tasks to help me do my job. I figure its better than a bit of chewing gum, a used stapler and a milk crate which is our usual company standard for...
Top Bottom