Hi..
Thanks for the reply.
I did remove the below code.
.ReminderPlaySo und = True
'add the path to a .wav file on your computer.
.ReminderSoundF ile = "C:\Win95\media \ding.wav"
but if U check the complete code,
there is a line : .ReminderSet = True
Inspite of this line of code, the reminder on the task is not checked.
But the desktop copy...
Shakss2
Last Activity: May 27 '08, 04:38 AM
Joined: Dec 27 '07
Location:
-
Task reminder not working via Citrix
Hi,
I have a application which creates a task in outlook on the click of a button.
I have made set reminder true.
It works fine when it tried on the desktop.
But wne tried the same application via citrix,
The task gets created but the reminder option is not getting checked (on the task screen) due to which the reminder does not popup.
This happens even after set reminder is true....Last edited by Stewart Ross; May 26 '08, 09:35 AM. Reason: added code tags to delineate code section -
Hi...
Thanks a lot for helping and apologies on replying so late.
Your logic worked... Thank U all for the help.
This is what i did:
lsttest_criteri a = lsttest_criteri a & "," & "Forecast_Train ing AS Training_Inform ation" & ""
lsttest_criteri a = lsttest_criteri a & "," & " Mid(Nz(Forecast _Training),256, 255) as T1 " &...Leave a comment:
-
Hi...
Thanks for ur reply.
The memo field has all text data in it & it is often more than 255 chars.
If u could help me with some code which U have suggested than it will be of great help.
As a beginner im not sure if I answered ur Q's.
Thanks again.
ShaqLeave a comment:
-
Export to excel truncates to 255 chars...
Hi...
I am exporting some data from a table with a memo field to excel but the excel report truncates the memo field data to 255 chars.
...Code:Dim strPath As String ' Current path strPath = CurrentProject.Path & "\Adhoc_Report.xls" 'New workbook object Dim sh As Workbook DoCmd.OutputTo acOutputTable, "test2", acSpreadsheetTypeExcel9, strPath, 1Last edited by NeoPa; Feb 22 '08, 02:20 PM. Reason: Replacing plssss to give OP chance of not irritating all the experts. -
Hi...
I did this...n it worked...
DoCmd.OutputTo acTable, "test2", acSpreadsheetTy peExcel9, "strPath", 1
Thanks a lot for ur support
ShaqLeave a comment:
-
I also tried:
DoCmd.OutputTo acTable, "test2", "MicrosoftExcel Biff8(*.xls)", "strPath", 1
But it is still using version 5
ShaqLeave a comment:
-
Sorry for the previous post...
It was my mistake...
That seem to work but it is still using the old version 5.
How can i force it to use version 7 or 8...
Below is the complete code:
Dim strPath As String
' Current path
strPath = CurrentProject. Path & "\Adhoc_Report. xls"
' New workbook object
Dim sh As Workbook
DoCmd.OutputTo acTable, "test2",...Leave a comment:
-
Hey Thanks for that reply...
But im getting the following error if I use this:
Runtime error 429
ActiveX component cant create object
But if I use the below code, it works:
DoCmd.OutputTo acOutputTable, "test2", acFormatXLS, strPath, 1
Below is the complete code:
Dim strPath As String
' Current path
strPath = CurrentProject. Path & "\Adhoc_Report. xls"...Leave a comment:
-
Hey,
Thanks a lot... that worked exactly the way i wanted it.
I have another post in this forum which was not answered yet.
"Excel report using old version of MS excel"
If you have a chance then pls look at it.
Thanks again.
ShaqLeave a comment:
-
Restrict use of special charecters
Hello,
I have a text box where I enter a name.
I want to restrict the users from using a ' symbol or " symbol or any other special charecter in that text box.
How can I achieve it?
its access FE and BE.
Thanks
Shaq -
Excel report using old version of MS excel
Hello all,
Im displaying a report in excel.
below is my code:
Dim strPath As String
' Current path
strPath = CurrentProject. Path & "\Adhoc_Report. xls"
'New workbook object
Dim sh As Workbook
DoCmd.OutputTo acOutputTable, "test2", acFormatXLS, strPath, 1
'Setting obj
Set sh = CreateObject(st rPath)
... -
I got it working... :)
Thanks for helping me with the 1st result.
Regards,
ShaqLeave a comment:
-
Thanks a lot, that works...
But im having another issue.. which looks similar but a bit messed up.
I have a table as below
ProjID b c d e f
2 12 3 1 2 1
3 10 3 0 2 4
4 5 5 6 5 5
5 4 2 0 0 0
6 1 0 0 1 0
8 0 6 0 7 2
10 0 0 0 0 0
I want a o/p in excel like below...
1st column projID
2nd column should be like this:
...Leave a comment:
-
Getting a report from a table
Hello all,
I have a table name "info" which looks like,
ProjectID Consultantname
1 Alpha
1 Beta
1 Charlie
2 James
2 Mario
3 Shak
Now im getting a excel report in the below format.
ProjectID Consultantname
1 Alpha
... -
Thanks a ton to ADezii and missinglinq....
It made my life easy...
it works as said by you guys.
Thanks and regards,
ShaqLeave a comment:
-
code for Find and Replace to default "a part of field"
I have a form, where I can activate the search and replace dialogbox when
pressing a button.
My problem is that the dialogbox opens with the default that it should
search for full match only, and I want it to open with default "a part of
field".
I did change it to default "A part of the field"?
by going to Tools -> Options menu to open the "Options" dialog window.... -
Hi...
Thnx..
It helps.. I also added a vertical scroll bar to the text box.
It was my 1st post to THE SCRIPTS so thanks a lot.
ShaqLeave a comment:
-
Multiline txtbox in an Access Form ?
Hello,
Can I have a multiline text box in a form created in MS access ?
If yes, how can I as I could not find the multiline property.
No activity results to display
Leave a comment: