Search results

Thank you for your help. I did try did not work. I give you more information: 1.This is unbound form. If I bound form and controls to DB, I have no error and I can save record with this comand: DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70 2.Access DB I am using as...

I have simple form with 3 unbound text boxes. One text box get path (Hyperlink) from OpenFileDialog box. On Save using simple sql statement as strsql = "INSERT INTO fs_attachment_tbl (Attachment_Type_Id, Hyperlink, Site_id)" & _ " VALUES(" & Me.cboAttachmentType & ", '" & me.txtFilePath & "', "...

Thank you. Problem is solved. Server was'nt updated with patches.

I create email attachment (pdf, txt …) from report in Access 2007 with Ribbon Bar. Problem: If I don’t have open Outlook I couldn’t open Attachment for preview before send email. If I have previously open Microsoft Outlook – I have no problem to open Attachment. Thank you for help Mike

Thank you for your help. Mike

I am using web component OWC11.DLL in Access 2003 Now we convert Access from 2003 to 2007 Is anybody knows which web components I have to use similar as OWC11.DLL? Thank you. Mike

I converted application from 2003 to 2007. I have one pivot tbl and I need to export to Excel. I create new ribbon bar with Export to Excel Button working find but when I convert mdb file to mde I am loosing (not visible) excel button group name is here excel button is not. I start using...

I am using custom toolbar in Access 2003 only for Reports not for all application. How I can use custom toolbar in Access 2007 from previouse version only for reports Thank you Mike

All this examples using ADO, my application using DAO. VBA in Access and Access DB tables link to MySql DB This is reason for using qrydef Thank you for your time Mike

Thank you for your help. Unfortunately, I could not see web site(security reason) If you can give me example how to call Stored Function in MYSQL from Access DB or how to call Store Procedure with return parameters. Will be grate!!! Every think is working when I call Stored Procedure or Stored...

I created store procedure in mySql db. SP have statements with update several tables and I passing string as output parameter from Error Handler inside Store procedure. If Transactions is done with out any error after Submit transaction I set this string to "Done" for example. When I call SP...

I found some code on google. Function SelectedRecords() Dim i As Long Dim F As Form Dim RS As Recordset ' Get the form and its recordset. Set F = Forms![Location_Z_Detailed_frm] Set RS = F.RecordsetClone ' Move to the first record in the recordset. RS.MoveFirst '...

How to Count selected record on Continuous Forms before delete this records? Thank you Mike

How to load table from bound control with color and difference font and after that using this field for printing with color and font with property as can grow and can shrink I tried to use OLE control it is hold color and fond as object, but when using this field in report I couldn’t...

Yes, Thank you again Mike

Brian, Thank you very much, it was very good for start. Mike

I am using Excel 2003 I want to copy data from one worksheet to another worksheet in the same workbook under certain criteria and some validations using VBA code. I would like to have a button on first wokrsheet to copy data First column must be a header I have a spreadsheet with say 6 columns...

Thank you very much. It is realy help. This is exactly what I am looking for. Mike

I have DB with a lot of queries and I need to find out witch one using special table with out open all of them in design view. Or how to get list of tables using by this queries. Thank you Mike

Thank you, I did try it is work. It is realy help Mike