Search results

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

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

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

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...

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.

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?

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

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?

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

"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...

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...

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...

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

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...

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...

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.

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) &...

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...

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...

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...