Search results

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 & "', "...

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

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

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

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

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

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

How I set Subform property as AllowEdits from modules? Thank you Mike

How to pass form as form to module with out open a form. I have a lot of users with difference privileges RW, RO, NO Access at all I would like to use one module and passing form as object or form and manipulate with user security. I can pass form as form when form is open. My code: call from...

I am sending report from Access 2003 to Microsoft Outlook wich SendObject with attechment as snapshot. I need to send report with out attachments inside email body(message text) Does anybody khows how I can do this. Thank you very much for your timeI