Search results

Yep, this is exactly what I found on internet - keeping it at 100% fixes everything. Only problem is that it is hard to read anything at 4K resolution:)

I know this is old thread, but I have this issue and cannot fix it any way:( I have Windows 8 and Office 2007 SP3 installed. Resolution of the y laptop screen is 3200x1080, so had to set display to 200%. After that navigation pane in Access keeps jumping when scrolled. I noticed that pane...

54 views and no reply? Maybe it's in wrong section?

What I want to know is CPU influence on Access processing. Does Access use multiple cores? or Hyper threading? Having same spec but different CPUs - one dual core, one quad - would I see a huge difference between those two? Would quad core be lot faster than dual core CPU?

Guys, I'm after a laptop for Access databases work. Not 100% sure what specification would be best for it. I believe Access doesn't use HT? Does it mean that having 4 cores won't make difference compared to i7 dual core with HT? Would something like Dell XPS 13 MLK be ok for it? It's a...

Re: "File sharing lock count exceeded. Increase MaxLocksPerFile registry entry." I do that 5-10 times a day.

"File sharing lock count exceeded. Increase MaxLocksPerFile registry entry." I'm getting this error every time I'm trying to import large txt file to Access. I know it is common error, but any solution found on the net doesn't work here:( File has 500K or other one - 2M records. Even if I...

Ha! You see, before you out this link to syntax list, I was like :eek: Didn't know what those characters mean:) Now I totally understand this RegExp. Thank you guys for this!

Yep, you're right, those are treated the same. This works great! Now, I have a last question, I promise! How can I get rid of all strings in brackets before I run my function above? I noticed that sometimes I have some not important data in brackets, like that example above has UK. How can I...

Sorry for confusion, I was after getting rid of all non alpha numeric characters. First one works perfectly! Thank you so much for help! If I can only ask you for one more thing: I wanted to have two diffrent options, on that leaves all alphanumeric characters only and second one that also...

Thanks. OK, so I tried your function, but it return digits from the string only. What need is to find any non alphanumeric character in the field and delete it, returning rest of the characters, so for example in filed Name I need to get rid of all spaces, brackets, etc: for "BCD's Exchange 44...

Thanks, let me try it out. Now, can you please tell me where should I copy this VB function and how to run it? I know nothing about it:(

Guys, I was wondering if you could help me. I need to get rid of all non alpha numeric characters in fields. Do you know any quick way to do it? Please have in mind I'm not an expert in vb, so was looking for simpler way to do it, unless you could tell me what exactly write and where to put it...

What do you mean by backend? Do you suggest to install all those tables on SQL server?

But all those databases I use are on my PC, just separated drive:(

Well, yes there are separated databses - tables are sometimes 2M records and in Acces file they take around 1.5GB so I keep them in separated database files and link them. So, could it be it? Do you open this form on any of those databases or on that linked one?

not all of them, but most of the time I work on tables with indexed IDs. Would this make a difference?

nope. It's happening for every query I run. Two tables, records comparison, matching by 3 elements or two tables pulling combined records or one table, pulling records that mean some few criteria. Simple things. Table sizes from 50.000 records to 2M.

Hi guys, I have a strange problem, which is a real pain... after I build a query and click to view results Access starts to calculate it, then after few seconds all CPU cores go idle.. then stay idle for about 30-40 second, then finishes query calculation in next few seconds. Is that normal...

Someone installed SQL with Outlook on domain server and basically using SQL will slow down everything else, so I rather not to do that. I'm not in charge of server, so that is why I wanted to build separated fast c (not dedicated server) to use it. I have tested one of my databases at home on...