Search results for query: *

I think using .Display instead of .Send should do the trick! Scott. Leadership and learning are indispensable to each other. John F. Kennedy November 22 1963

I often have this problem in the environment that i work in as my outlook profile is set for several mailboxes so i have to chose which one i enter to open it. This causes a problem when using the CreatObject function because of the modal dialogue that is open......i found a quick fix to error...

could you flash an input box and then write the value of it to the comment in a range? ie strcomment = InputBox("Please Write your_ Comment", "Comment") If IsNull(strcomment) Or strcomment = "" Then Exit Sub End If Range(YourRange).Comment.Text (strcomment) this would change a comment on...

Hi mate, I'm not too sure about nesting the sub forms i have only ever worked with one subform on the main form unless i am using a multipage control. I think it should be okay though just work on the same principle The SQL goes in as the Record Source in the forms properties window and as...

Bob thanks for that mate i was just playing with something similar in if me.MyValue > 0.15 then me.MyValue.forecolor = vbred else me.MyValue.forecolor = vbblue end if which is pretty much what you were doing! like i said having one of those days..... Thanks for getting back to...

All, I am sure this is quick and easy however i am having one of those days where i cant figure a thing out......time to go home i think! What i am trying to achieve is when my text box in a report has a value greater than 15% the text is highlighted in red......I am sure its V.Easy and will...

Hi Andrew, By the refernece comment that would be if you are creating a recordset to pass the value into. I think a sub form is def. the easiest way for you to go. After update of the text search field i presume the clients id will be shown in another control....set your sub forms link child...

Andrew i have had this error before i have no idea why it happened but it did......i did manage to get around it by opening the file in Windows XP which allowed me to view and export all of my objects to a new workbook in effect copying it without copying it. Scott Leadership and learning are...

Andrew, have you tried opening the workbook and disabling the macros? If you do not get a message box giving you the option then you will need to go to tools\options\general and you will see the option for macro virus protection check this box. when disabling your macros this will allow you...

Andrew just read one of your other threads and noticed a point you made about keeping it simple so here's an easy way to do it create a sub form that has two fields client id and total time......with this for set the the control source to be this. SELECT Interactions.clientid...

Hi Andrew, I presume the agent picks the client from some sort of combo box or types into text format so in the afterupdate event of these you could write a simple SQL statement that will get the information you require something like StrSQL = SELECT Sum(Interaction_Table.Time) AS TotalTime...

Have you sorted this MetalBoy?? Scott.

Just straying away from the ADOX a little and looking more at the manual ODBC creation could you not just write a simple REG file that the db calls on opening and creates the ODBC for you and you can then use conventional ADO? Just a Thought.

I couldnt find my example however this should work Dim exc As New Excel.Application Dim objexc As Excel.Workbook Dim objsheet As Excel.Worksheet Set exc = CreateObject("Excel.Application") Set objexc = exc.Workbooks.Open("C:\Book1.xls") Set objsheet = objexc.Sheets("Sheet1")...

MetalBoy, you can print an excel sheet from a command button in access what you have to do is add the Excel object library to your references and open excel as a new object and set a reference to the spreadsheet that you wish to print. If you add the object library you will be able to use the...

Hi, As RoyVidar says you can use the docmd.OutputTo command which will output this for you......as for automatic you could be a little cheecky and create a dummy db that has links to your original.....what you do with this then is lock it down and have a startup for on open of the db.....with...

Hi, You can do this by writing a couple of procedures. The first would be to create a recordset that will capture each of your programmes and then you could pass each record in that into a second procedure using the programme name as a variable in this procedure you would simply have the...