Search results

Hi, Once upon a time, Screen.Mousepointer = 7 would change the cursor to a double-ended arrow, but it seems to no longer do so. In fact, it does nothing at all. No error, no nuffin. If I put Debug.print screen.Mousepointer on the next line, it shows 7 in the immediate window, but there is no...

Hi, I'm about to create an Excel addin, and would like to deploy as an Excel task pane addin rather than a VBA xla. I prefer this path because it makes the code more secure, the pane is a great UI that will provide guidance for users, and it will run in Excel without needing to download and...

Hi, I'm sending and receiving SMS from Access, and it works very well using email-to-SMS conversion provided by a 3rd party. I'm now moving to an environment where creating and reading emails from the vba will not be available. I've tested using a POST to an API (provided by same 3rd party) -...

Hi, If I create a table in SQL Server Express as below with a default getdate(), and link it in Access, I can add new records via Access, but not update any - instead I get the 'this record has been changed by another user ...'. Changing the default to CURRENT_TIMESTAMP in SQL doesn't work...

Hi, I want to give my users a browse button to pick a folder, but the builtin file and folder pickers are too powerful - the user can, accidentally or deliberately, drag and drop folders, rename and delete from within the dialog. It doesn't seem that there is a way to prevent this - will I have...

Hi, I absolutely agree that these forums are a place for discussion, not advertising. That said, all of a sudden I am on the other side of the fence - my company is now hosting Access/SQL applications in the cloud, yahoo at long last! Folk are posting now and again on that very issue, and I'd...

Hi, Accdb (365) says "MISSING" reference, so I uncheck it, and browse for it, compile, and app works. Close the app, re-open and it says missing again. But the file isn't missing, it's right there! This happens no matter what I do: unregister / reregister DLL, move everything to different...

Hi, I'm running an access runtime on prod machines without Excel, and no hope of getting Excel. I normally create reports and dump data from the access app into Excel, but obviously the normal CreateObject("Excel.Application") ain't gonna woik. So it looks like OpenXML might be the go; I could...

Sorry, but where do I look for the bitness of my Access 365 version? I've hunted high and low - I just assumed it was 64 bit but a client got the following message after opening my new app: "this version was configured for a 32-bit version of access". Any clues would be appreciated...

Hi, I have an Access 365 FE with a SQL Server Express backend. It works fine in test on my machine (which has both FE and BE). FE is 4mb, backend has half a doz fact tables with 2-300 records in each. I've migrated the SQL to the client's (cloud) server, and connected the FE to it from the...

Here I am again, sorry folks, picking your brains ... I was looking into getting my code signed, and found a few CA vendors like Comodo and DigiCert and was considering signing on the dotted line when I found this...

Hi folks, I have distributed split databases for clients over a number of years, with front ends always deployed to each users C drive, and optimised in fairly standard ways that you'd all be familiar with. In the present case, I am deploying to users with weedy little notebooky things that are...

Hi, I have been experimenting with connecting my Access Database to an Odata source. Works a treat. But can it be made secure? And I mean, very secure. Any ideas? Thanks, Jack

Hi, I'm just starting to use Access 365 and a newly downloaded SQL Express. The LTM is confusing. My tables are all connected to a Prod server on a different machine, and I'd like to relink them to my test SQL Server. In the old LTM I'd select 'Prompt for new location', and I would browse for...

Hi all, There was a time when this query would give an error, because you couldn't use a calculated field in a second calculation in the same query: SELECT Len([EntrantName])*[EntrantID] AS EntrantCode, tblEntrants.EntrantName, IIf([EntrantCode]>50,[EntrantCode],[EntrantName]) AS...

Hi, I am creating reports automagically by selecting an existing query and clicking Create Report. Very cool and the layouts are easy to modify. In fact, the same Layout extends from the Header section across the detail section, which makes it easy to resize columns without manually re-aligning...

Hi all, I'm a long-time Access dev, mainly working in Banking and Finance for the last couple of decades. I've led a few access dev teams, and been involved with creation and management of SDLCs, a complex task given the built-in controls and restrictions that banks want - eg software libraries...