Search results

I have been an access developer for a very long time, I have a back end database on a QNAP file server 192.168.1.10. I have always connected to that back end using some VBA code with local machines on a FLAT VLAN 192.168.1.0. So imagine my annoyance when i go to connect to that database at an...

This gives me twips / pixel on the main display lDeviceHandle = GetDC(0) but im still looking at how to determine the other displays and which is which. FROM https://stackoverflow.com/questions/1290125/how-can-i-find-the-width-of-the-parent-window-in-ms-access Type Rect x1 As Long...

yes im trying to convert to TWIPS What is the best way to do this im sure this is my issue. ill search some googles for GetDeviceCaps VBA implimentations Honestly though everything I've read uses 15 as the factor to pixels, I'm not sure why my calc should be off so egregiously. The second...

Hi I have some code I use to move a form to a third monitor (if one exists) and everything works correctly except the math calculations based on screen size. intMoveX = 86000 If GetMonitorId > 2 Then 'move to monitor 3 and maximize! (getmonitorid also populates the monitorid array public var...

I dont have a ton of forms with full table recordsets but I do have probably 20 or so, and they are only smaller tables nothing huge , nothing over 8k rows probably. My frustration is even if you have everything based on views or flat out SQL statements the schema is annoying because it...

I used .adp literally from 2002 until now. it was very convenient to modify and create SQL tables and views directly from Access, RIP, it did work well. The other thing i noticed RIP to was Currentproject.connection or Currentproject.execute. Looks like Ill need to write a replacement for the...

Winner Winner Chicken Dinner. I suppose .adp projects use ADODB by default and by defining just recordset.clone I didn't realize I'm using DAO with a different method aka .findfirst! Thanks! Whats funny is once i started find/replacing this i found tons of examples of me using .findfirst as...

Hi everyone, I'm a long time Access developer and I'm migrating an .adp over to a linked table .accdb with a MSSQL backend. No big deal on the actual import of modules/forms/reports and I linked all the tables (althought it names every table dbo_[name of table] which is kind of annoying but Ill...

Yeah I think at this point the problem is the PC, because I cannot unregister C:\Program Files (x86)\Common Files\System\ado\msado15.dll even though I use an admin cmd prompt and it says succeeded. I cannot register my own version of msado15.dll (v10) even though i use a command prompt and it...

Thanks for the comment guys, I appreciate any help even bouncing ideas. Yes that's what I can do for sure, I've been developing in Access for about 20 years so that standard error message definitely tends to mean your .ade just isn't compiling right because of a missing OCX or DLL, so i...

So I have an access runtime project that I deploy out, it runs on the 2016 RTE I get errors with Left() functions and I just know its a tell tale sign of .dll versioning problems because other parts of the software runs fine its not that a .dll or .ocx is flat missing. Customer has No full...

No bitness is always the problem I get that, really just looking for if 2019 has some way to do an offline installer

"its not so bad" is not the answer I'm looking for

Long time access developer started out with 2000. Over the years I've deployed my app with the runtime via the product actual installer to copy the front end backend and assets. I've steadily updated the version over the years, and fought with bitness, I cannot upgrade to 64 bit due to legacy...

I think you might be exactly right on the false missing Thank you David

Client Verison: 16.0.12430.20264 Office 365 CTR 32BIT My Version: 16.0.4266.1001 Office 2016 32 BIT When I deploy the .accdr basic string functions fail hinting to me there are DLL versioning problems somewhere. What can I do? I've been developing with access for a decade plus and this sort...