Search results

I tried to revert to previous versions Version 2112 (Build 14729.20260), Version 2111 (Build 14701.20262), Version 2101 (Build 13628.20448). with no luck, then tried to add the DB folder as a trusted location with the same result. what worth mention that the issue I have appeared a couple of...

Application.quit is not working for all senario

Hi, Craigachan I has this problem (Access Not close properly) for two months now, and I living with it since by closing the access app from task manager. But just this morning I decided to troubleshoot the issue thinking the problem from my code. I wasted all morning on it to reach a conclusion...

Thanks, guys. I rolled back the app to my LAN now which has a full version of access, it seems I need to develop some tools to allow logging in the Runtime environment. @Pat Hartman thanks for the example.

Hi Guys, I am not talking about the windows installer and click to run method of installing, I already installed both Office 365 and Access Runtime Environment my question is, is it possible to run the full version of Access while the Runtime is still Installed (because it's given me this...

I do it like this because I am running this app on a server with a runtime environment and it's modifying a backend Database, this gives me hard time but better from copying the backend to another device and copying it back (live users exist). This application pass SQL commands to the back end...

the table name is tlbVATGroup the reference is right. Yes it is, now it's working thanks The Error came from Set Me.Recordset = rs.clone because the I am opening the tables from different database. Set db1 = Workspaces(0).OpenDatabase(strDbPath, False, False, "MS Access;PWD=" &...

I want to mention here the security aspect of this idea, in my opinion, it's not secure to connect your storage to your router, because your router usually is controlled by your service provider and there is a lot of examples of misconfiguration leading to easy access to your router (leading to...

Hi Guys, I don't what I am missing I always assign a recordset to a form but now I am getting this error what I am missing. The form is an unbound one.

Byte Indeed, It worked with the Byte Keyword and changed to (Number > Byte) in the table design view. FYI, the datatype was INTEGER

Hi Guys, I am trying to change a field type using the DoCmd.RunSQL I succeed with other types but I can't change to tinyint datatype (error message attached) DoCmd.RunSQL "ALTER TABLE tblNotification ALTER COLUMN NotificationDate tinyint;"

I bought the App and it's working like a charm thanks.

I checked the FMS site the app is promising, but the last supported version is 2016. I sent them an email asking if the latest version will work on Access 365

Sorry, I didn't get you here, is that an app? thanks for the advice.

I have an idea but I didn't test it and it needs some work to execute, why not use a form(subform) and a wapper around it as a combo box, you can use the wapper for resizing, positioning, hiding, filtering, etc... of the subform and you can do any thing with it, it's a form at the end.

Hi guys, I am looking for a way to compare two databases tables, queries (fields names and properties) programmatically the scenarios as follows: I have an access application in production I developed a while ago, and for my last modifications I outsource the development to a freelancer, but...

Hi Arnelgp, As I understood from Amjad I think he wants the Doc. No. and Rev. combination to be unique, he needs to make both Doc. No. and Rev a primary key. this will prevent users from entering duplicate Doc. No. and Rev. combination.

If I may add, be careful if you decide to disable the shift key PayPass, because you may lock yourself out of your database.

Hi 🖐 and welcome.

Regarding the wifi, I have been using wifi at my workplace for a year now (not recommend) but the no-no for me is to run an update query over the network, all update queries run on the backend directly and I am taking backups frequently in prep. for the dark day that I may encounter. You need...