Search results

Hi guys I run .mde on .mdb in win 10 all these while, there are no issues. I love old versions of msaccess because it is beautifully light and can serve database needs well. However when i try in on win 11, it seems .mde falters (don;t know what exactly, to be investigated) . I suspect it...

Hi help With ODBC we can link to any table in an SQLite database. How to do table link without ODBC eg with Open table

Hi guys Msaccess is great for small guy like me for VB# & SQL debugging, etc in a database environment. Because of Android popularity I am looking for a similar RAD. Any pointers..🙏😊

Hi contributors I have plan to use SQLite because it LESS many things for small projects. Any caveat or advices to drop to my new venture. Thanks brotherhood.

Guys Just wonder if anyone has tried putting a split database in OneDrive & mapped it as a Netdrive in a PC for msaccess Front end to access. .pros & cons ?

Hi gurus Let's say I create a database in win 10 PC using SQLite. I believe with the right ODBC driver I can have a front end build with msAccess to use this backend. My project is to use Rad studio xe5 to develop a front end in an Android device. I am now trying to figure out how the...

Hi Gurus I use Scripting.FileSytemObject (FS) to check if a shared folder "Data" in a "MainPC" in a LAN Workgroup exist .. as in ... FS.FolderExists("\\MainPC\Data\") Is this a good way or is there another better way to do it.

Hi guys .. back after a long while to bug you I have a perfectly run .mdb file for years that do some housekeeping script from a module before it end up in a form. In this particular win10 tablet it flag error 53 ..file not found. I try to debug it but can't find the line causing it. Guy...

Folks I finally is seriously moving to SQL server .. need a helping hand I think of doing this with command as part of my codes in a FE. I thus start with mdb as template to import from, into a to be created database in SQL server What are the text commands that can achieve my goals.

Hi folks I use mdb as the backend. I will like to import this database to SQL server. If i just import using SQL import function I end up with all tables. I like to keep together in one database as in mdb .. how to get there

Hi friends I am a small guy stretching the dollar to help the small guys thus i still use msAccess 03 which is fast and simple, essentially i can do almost everything (low traffic) inspite of the caveat about vulnerabilty. Having said this I get to what i am thinking about to day. My approach...

Hi gurus When i scan a barcode in what form is the information being captured? How should the captured info be kept in a database.

Hi guys Wow new image .. good show My issue today is i have an toolbar eg "1Views" with an sub menu eg "1V-Sub" which itself contain few controls "SeeIt1", "SeeIt2". My simple wish is to be able to toggle "1V-Sub".Visible between True/False when a certain state occur, thus stopping all its...

Hi guys I have a form with view as 'Pivot Table' and want it to be use for 2 instances with different recordsource. I normally can do this in all my other forms by changing the recordsource at the Open Event, be not with this form. I tried the following options without any success: 1 Change...

Hi members I have a main form with number of subforms separated by tab control. Lets say there is field T1 in SubFrm1 & in subFrm2 there is field FldNew. i want to place T1 in FldNew. What is its field value. EASY but I don't know. PLEASE!

Hi guys First of all, the forum new looks is very good & trendy. Congratulations to the Administators for the upgrade. I am contemplating to install SQL Server Express 2008 R2 to try my hand on using its database. As my favourite is still the older versions of msAccess eg 2003, which version...

Hi peers I am toying with idea to place a Split Back End mdb in Cloud storage. Is this a viable path to take in terms of: 1 Will it be any lag in reading or transferring data to and from the backend? 2 Can we use UNC for the backend eg \\myData 3 What if i want to use sql server then where...

Dear forum members In a report we can cumulate a field value using "running sum" over a group. How can we acheive the same result for a field value in a form? Appreciate guidance

Hi guys I want to change the ControlSource of a field in a report during opening of it but is not allowed in printPreview or after it is started. How to work around this? Help please.

Hi guys i use following to export a table eg Tb01 to a Excel eg X01.xls docmd.transferSpreadsheet acExport, 8, Tb01, X01, true by doing so either 1. if there is no worksheet by the name of Tb01, it will create one & export content to it 2 if there is the folder Tb01 it will just replace it's...