Search results

  1. R

    concatenate and Iif

    I have a problem I am working and and am not sure what the best approach is, hoping someone can lend me some insight: I have two fields on a table: SerialNumber....Location I need to concatenate these two (no problem there). However my situation is such that my serial numbers vary in the...
  2. R

    Crosstab #Name? Problem

    Answer Answered by Jon K on the queries post: thread
  3. R

    Crosstab #Name? Problem

    I See Ah, it appears you are correct. You are a genius my friend. Thank You!
  4. R

    Crosstab #Name? Problem

    I originally posted this in queries, it probably actually should be in forms I suppose. I guess I will post it here as well...hope that doesn't piss anyone off. I have a form that uses a crosstab query for it's data. The problem is the crosstab query has a column heading that (in my example)...
  5. R

    Crosstab #Name? Problem

    OK, been awhile since I posted anything here. I have a weird one, hope there is a solution. I have a form that uses a crosstab query for it's data. The problem is the crosstab query has a column heading that (in my example) represents warehouses of which there are ten. So when the form was...
  6. R

    is this possible?

    I would say absolutely possible. Not to boast but, I could make something very kick-ass for this.
  7. R

    Story

    guarded the entrance
  8. R

    Story

    screamed out loud
  9. R

    Story

    and little fuzzy
  10. R

    Story

    they were delicious!
  11. R

    sharing database across a WAN

    Thanks for all of the good information, I'm still listening.
  12. R

    sharing database across a WAN

    Thanks, I think that perhaps terminal services is the way to go on this.
  13. R

    sharing database across a WAN

    I apologize for posting a thread that has most likely been covered in some detail. However I still am not finding any real good solutions to this so, thought it was worthwhile to start a new one: I have created a database for a company that has two branches; one in Seattle and one in Florida...
  14. R

    Office Pranks - April Fools is coming

    This is a nice one if you are a network administrator: Go to someones computer and make their desktop folder shared. Then you can add and remove icons from their desktop at will. Another area that I have always thought was ripe for this kind of thing is the Windows task scheduler. Most people...
  15. R

    finding # in a string

    Answering my own question: Like "*[#]*"
  16. R

    finding # in a string

    OK, here is wierd one: How do I find instances in a string where there are # symbols? For example addresses similar to; 3815 W 11TH #300 I need to find and remove all of the # things but if I say; like *#* it returns every address with a number in it...which is practically everything. I have...
  17. R

    argh!!!

    Try this: Like "*" & [Enter keyword] & "*" also check out this link: http://support.microsoft.com/default.aspx?scid=kb;en-us;304353
  18. R

    Access report to Word or RTF

    Thanks, I will check it out.
  19. R

    Access report to Word or RTF

    It would be of interest as long as it is user friendly. As it is now I can make it so a user can click a command button that will send the report in RTF or SNP. If it could send it in PDF from the command button also that would be preferable, if they had to print it to a PDF printer and then...
  20. R

    Access report to Word or RTF

    I am sure this subject has been broached many times bfore, sorry to start a new thread if that is the case but.... I have created (as I'm sure most of us have) some very nice reports in Access. However there are times when someone for whom I have created a database requests the ability to email...
Back
Top Bottom