Search results

  1. Martyh

    MS Windows Server 2003

    The difference between an MDB file and the actual Access program ... took me a while but I got it !! Thanks Guys
  2. Martyh

    MS Windows Server 2003

    Are you saying that just the MDB file and nothing else need be there? Isn't the MDB file really access?
  3. Martyh

    MS Windows Server 2003

    Then where will I put the backend (the data that is in Access) ? Regards,
  4. Martyh

    MS Windows Server 2003

    Bob, Thanks for your prompt reply. I have another question though: If I use one copy of Access as the Backend on the server, is there any special license arrangement that I need to make before I get the Front end clients using the backend. Each client has their own personal copy of Access (MS...
  5. Martyh

    MS Windows Server 2003

    Hi, I have MS Windows Server 2003 machine and I would like to know if you need a special version of Access 2007 to install it on the machine? or can you just buy a regular version of office 2007 and make it go? Marty H.
  6. Martyh

    Broadcom server adapter

    Huh!! You mean that the access speed even to the very fast 1 Gbps is limited by the S L O W E S T nic say 10 Mbps... tell me it isn't so. :-) Say 2 or 3 slow nics were accessing the 1 Gbps --- you'd have to wait until the 3rd machine was done. Do we get any relief from TOE?
  7. Martyh

    Broadcom server adapter

    Huh ! You mean that that the top speed of the S L O W E S T nic would govern everyone's speed...
  8. Martyh

    Broadcom server adapter

    Thanks for that! It's a standalone database server. Would this be connected to a router? And then all the clients would access it via TCP/IP just as if it were any other computer?
  9. Martyh

    Broadcom server adapter

    Have you heard of a Broadcom server adapter? More specifically NetXtreme II 5708. Does any one know how many users it can serve before becoming too slow? Tried to look for material all over the web but unsuccessful! Marty Habicht
  10. Martyh

    “Requery” problem

    "Requery" still a problem Thanks for your replys Rural Guy, Yes that it my intention: to requery ListBox rather than the form since it has in the list, the “Selected Market” list. I've tried with the list requery (in concert and not) and it doesn't seem to make a bit of difference. Wazz, But...
  11. Martyh

    “Requery” problem

    Hi all, Here is in nutshell what I done and the problem. Could somebody help me out? 1) I Have opened a form called “Car Rental” 2) I Have chosen a control which causes opening of another form “All Markets” Explaination: “All Markets” is a form which allows you to choose which markets you...
  12. Martyh

    Quotation mark problem!

    Hi Guys, I'm back to this ... I must explain "St. John's, NL" is coming from a drop down box --- there is no problem ever "misspelling" --- the problem is with specifically with dlookup! Is there another way to to lookup a name and make sure that this name is in the list (not the drop-down...
  13. Martyh

    Quotation mark problem!

    I've got the patience ... just not the time -- right now! Your right again -- this code snippet is taken from my program ... and i was using it to show the problem. Tomorrow (or monday) I'll have more time... Marty
  14. Martyh

    Quotation mark problem!

    Ken, No -- you are quite correct! Only to add your statement "St. John's NL" is one instance of loc1. The dlookup statement works for all other instances. The problem is that I've got over 300,000 records to use the dlookup on ... and probably more. I thought that there would be another method...
  15. Martyh

    Quotation mark problem!

    Ken, I have no problem with the dLookup function; it has worked 3934 times before! it has do with the pesky single quotation mark. I've tried all the permutation and combination of quote including chr() What I haven't tried is to clense the data beforehand!! I am attempted that right now...
  16. Martyh

    Quotation mark problem!

    Hi Ken, Yes that's right. I narrowed down the problem to "St. John's NL" which happens to be in loc1, the variable name.
  17. Martyh

    Quotation mark problem!

    People, Can anyone think of any way that I could put this question without incurring a Runtime error (3075)? --- "St. John's NL" is actually a variable and not a constant and it is in "qryMarketFrombufCarRentalConvert". ?DLookup("[F1]", "qryMarketFrombufCarRentalConvert", "[F1]= " & Chr(39) &...
  18. Martyh

    Strange Problem II

    Problem II --- reprise Thanks ! I tried that in my office and it didn't work! But I came into the clients site next morning (where the computers are "live") and overnight it must of "repaired itself" because the problem had entirely disappeared!!! I really can't explain it! Marty :o...
  19. Martyh

    Strange Problem II

    Refering to the enclosed graphic, the computer is right about it missing tblTransaction12 !! I used a dummy table to test out everything till it worked well (tblTransaction). Then in a table I called tblTransaction12 I placed all the proper data. I then changed the name back to the original...
  20. Martyh

    Tried to set Default Value

    Thanks guys for answers!! However: RG: I tried setting combobox's Defaultvalue property to "= intFiscalYear" --- does not work PBaldy: I also tried creating a little function that returned the value of the variable, and calling it. But there was still no joy! There must be something that I...
Back
Top Bottom