Search results

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...

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...

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...

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?

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...

Hi, I am developing a Student Database that shall capture Biometric and Pictures. I got the fingerprint on an access form. However I cannot get image directly from the webcam to an access form. I have to use the manufacturer's software to capture the image before importing to access using...

Hi., I developed a software for managing Junior Secondary School Examination using access 2010. Total number of registered candidates were less than 60,000. I split the db into back-end and runtime front-end. I distributed the front-end to various local clients for entry of examination marks...

Hi, I want to distribute my application to various clients at multiple remote locations for data input. After capturing the data a copy is to be returned to me so that I can synchronize input from various location into a master DB. I used Access 2010. My problem is, the remote computers may or...

Hi, I just upgraded to Access 2010. I was able to solve all migrational issues, but my custom ribbon is showing two File tabs, one that I created and the default access file tab. Any idea on how to get rid of the default File tab or at least disable it?

Hi, I am developing a DB for an organisation with branches all over the country. Is it possible to deploy the Back-end DB in a clouds server so the it can be accessed by all branches with a local copy of the Front-end? :banghead:

Hi, My DB is split into BE and FE into about 5 Laptops. The DB is for entering personal information of pensioners. sometimes it becomes necessary to take a computer away from the office to capture data of sick and aged pensioners. Now if you take the server (BE) out all the other clients (FE)...

Hi, I want to view webcam image on a form with a command button to save the still pic as a bmp file. Can anybody help?

Hi Everyone, As we all know Access do not display numbers in accounting format (NGN1,234.78) in a message box. I developed thes functions to do just that. The functions are Putcommas and IntCommas. The Listings are as follows: Function PutCommas(Amt As String) Dim DotPos As Long, StrLen As...

Hello; I want to display a custom ribbon when I open a report in print preview mode. The ribbon name is PrintRibbon with the following xml: <customUI xmlns="http://schemas.microsoft.com/office/2006/01/customui"> <ribbon startFromScratch="true"> <tabs> <tab id="printMenu" label="PRINT" >...

Hi All, I have a DB for monitoring housing loans. Customers make monthly repayments to my bankers, who sends me an instant email notifying me of the payment. Is there a way I can extract the contents of such mail automatically, so that I can update the my table? I read much about the email...

Hi all, I have a Database that track repayment for housing loans. Each customer usually pays directly to my bank, and the bank sends me an email with customer name and amount paid. Is there a way to update my table using this email?

Hi After much hussle I got my custom ribbon working in 2007 version. Now that I upgrade to 2010 my call back functions are not seen. The office help isn't helpful. Can anybody tell me why? :confused: Engr. Aliyu

I have created a custom ribbon using the following XML <customUI xmlns="http://schemas.microsoft.com/office/2006/01/customui"> <ribbon startFromScratch="true"> <tabs> <tab id="tabMain" label="Pension Commands"> <group id="grpGeneral" label="General"> <button...

I have a table with a date field, a form with two combo boxes (cmbYear and cmbMonth). cmbYear extracts distinct Years from the date field, and cmbMonth display month names based on the year selected in cmbYear. My problem is the months are not arranged January to December in the combo box rather...