Search results

Hello, I need to send automatically reports to customers and I need to specify how often to send to each customer so I need multiple timers, one for each customer. How do I approach that? I can have 20-30 customers with different sending frequency. Only way I know if one timer in the form but...

Hi, I have a task where I need to email to customers complex report that is being generated within access and I need to do it in the body of the email. What is the best way to approach that? Seems that I had no luck finding anything in the net. Worst case probably in attachment. Please help...

Hi, I have done this million times with no problem and this simple statement gives me problem "Too few parameters. Expected 2:. What am I missing here? Dim sSQL As String Dim db As Database Dim rs As Recordset sSQL = "SELECT EmailsPeopleM.JobID, EmailsPeopleM.CustName, EmailsPeopleM.[First...

Never mind, I added STEP -1 and all worked :) Thank you

Very nice solution!!! thank you all. Can you guys modify it the way that it will start searching from the end of the string instead of from the beginning?

Hi Ari! thank you very much for your help and for your code!!! I managd to make it work with your help finally. I have 2 questions if you don't mind. First of all, is there way to control <ribbon startFromScratch="true"> in UsysRibbon XML code true/false value via code depending on users access...

I am using Access 2013 with MS SQL 2008 and some stations have runtime Access installed

Hi, I tried to use getVisible but no success... Here is my XML: <customUI xmlns="xxxxxxCanNotUseLinksHerexxxxxxi" onLoad="CallbackOnLoad"> <ribbon startFromScratch="false"> <tabs> <tab id="tab1" label="Operations" > <group id="grp2" label="Login" > <button id="OpenForm1"...

Anyone? :)

Hi everyone! Need your help on creating dynamic RibbonXML where statement will depend on user that is accessing access database. I created DynamicXML no problem and it changes context depending on user but my main problem is refreshing ribbon. I see that UsysRibbons tables changes fine but it's...

I solved my problem. HEre is what i did: create the SQL statement in code and use DAO to update the SQL property of your p-t query: CurrentDb.QueryDefs("qsptYourQueryName").SQL = strSQL Simple and works fast like crazy! thank you

Thank you Galaxiom! I have all indexes in place and yes, I have Access user defined functions in the queries. Ones I moved to SQL Server, everything became very slow and I had to rewrite all code to retrieve records to recordset of controls and all works perfectly now. Only reports are the...

Hi all, please share your knowloedge about my item if someone knows. Have a question. I migrated to MS SQL BE and no I am trying to move all my reports queries to SQL Server as well and need to know how to assign recordset of the report that way that it will run on directly on SQL Server...