Search results

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?

I checked the VBA references, the Microsoft Office 14.0 Object Library was already checked, but what I discovered that Microsoft Office 12.0 Authorization control was missing obviously due to the upgrade issue, I corrected that and all is well now. I compiled the project with no errors. Thanks a...

Hi, Thanks Alvino. The error message is that my callback functions are either missing or misspelled, and the application is in a trusted location.

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

Another way is to have the form bound to the table with the loanID field, then create a hidden textbox bound to the loanID field. Each time a number is entered a filter shall be applied to the form to select a loanID equals to the entered number. Then compare the entered number with the loanID...

It really worked! I think microsoft should look at that in their future updates. Thanks

Thanks Avelino, the site solved my problem. The only issue is can you figure why this xml line is not showing the file back up control? <button idMso = "FileBackupDatabase" size ="large"/> Thanks once again.

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

Thanks. I created a month number field on the querry then hid the field in the combo, and it worked fine.

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

Copy your query with another name. Open it in SQL view, you will see the INTO statement. Change Table1 to Table2. Save and run the query. I hope this works

You must use a form with a textbox control for the password input and format the textbox input mask as password.

On the OnOpen event of the form create a string variable containing an SQL statement to select you data then type this code. Set MyRec = CurrentDb.OpenRecordset(mySQL) If MyRec.EOF Then Rc = 0 Else MyRec.MoveLast Rc = MyRec.RecordCount End If If Rc = 0 Then MsgBox "There is no information...