Recent content by AliyuKatsina

Hi, I wish to convert an imported sharepoint list to local table via vba. the import is successful, however converting the list to a local table is my headache. This is the code I used: DoCmd.TransferDatabase acImport, "Microsoft Access", FPath, acTable, "SchoolList", "AccessTbl", 0...

Hi everyone, I've migrated my access backend data to sharepoint. I however wish to migrate to Azure now. Please idea how to do that? The migration assistance only shows Sql-Server and sharepoint. If i migrated can I work offline and synchronize when I come online like I do with sharepoint...

How can I use conditional compilation?

Just compiling the project to be able to run on that computer.

Hi, I have developed an access project for multi user access through the split db. As I am compiling the front end on my 64 bit HP laptop, any time a user using 32 bit windows installs the front end, it wont run until I give him a copy that I compiled on a computer running 32 bit windows. Is...

Thanks. I have solved the problem by using the tabledef.openrecorset method. thanks

Thanks. I however wish to copy the data (db1) to another db (db2). If I use a select statement the recordset returns nothing. I can connect to db1 from db2 using dbengine.opendatabase, but don't know how to select the table.

Hi. I have a FE DB and a sharepoint BE. Due to our poor network nature I most of the time converts the sharepoint table on the FE to local table. I usually do this from the navigation pane once I right click on the linked table the command (Convert To Local Table) pops up. I however wants to...

If the records are accessed via a form, then to prevent two users editting the same record at the same time you do the following: 1. create a Yes/No field in the underlying table (Let's call it 'Select') 2. On the form where the records are displayed and edited, create a command button (Let's...

Thank you. What I think is happening is the location of the referenced Libraries in both Machines. Is there a way of setting the references to a common path?

The Front end is distributed in .accdr format and users are using runtime 2010. The OS of the computers is 32Bit and the processors are X32 based. The Application is splited into .accdb backend and .accdr front end on a wired LAN. Hope I've supplied all the answers.

Hi, The distributed Front End of my App doesn't open and display the above error on 32Bit computers. However if I compile the vba project on the computer (32bit) the App opens fine. How do I avoid this error?

Thanks Ridders and ypma for your suggessions. Ridders I learned alot from your codes. Thanks a lot. However I created a logout function that creates and execute a batch file that restarts the front end. And it solved my problem. Public FEPath As String Option Compare Database Sub LogOut() Dim...

I have a distributed FE with getVisible callback function on the most of the ribbon controls. So depending on user permission, some controls are visible to some users and not visible to others. The ribbon is attached to the main form that stays open. I created a logout function that closes the...

Let's get something clear. Which value on the form do you want to compare with which record on the table. What connects the form record and the table record?