I can add files ( with the add option in package and deployment wizard). That's how I add my datbases when I was deploying my applications on the lan drive or on cdrom. But I wanted to add a folder which has 190 sub folders(each one for one country) and each folder has 2 files. The size is not...
I tried a similar trick before I posted this message. I am actually creating an xml file (for 190 countries, for 4 years and around 30 variables) from Vb application using access database. Then I am using an XSL to create country sheets for all those countries. In one shot I could publish on the...
Is there any way to get dot leaders in html tables? (in one column) For example:
Albania .........
Switzerland .....
United States ...
Is there any tag that we could use to repeat a single character several times?
Thanks !
Reading text files:
I did the following to read a text file and then write into database. Have a common dialog control on the form to have a 'open file dialogbox' or in your case may be you can open the file directly - open "C:\mytextfile.prn" for input as #1
It opens the file for...
It is very difficult to understand what you are doing exactly. If you do not mind, semd me your code, I will look into the code. my e-mail address is Ravinuthala@un.org
Could you explain how you are reading each line (parsing the line into different fields, how you are breaking the line). It should not ignore the comma.
To Gaurishankar
Under your connectionobject sql properties, select general tab; use SQl statement, for ex:
Select * from tablex where fieldname1=?
That question mark is important.
Then click parameter tab, you could see '?' under parameters, under 'paramater properties' typr param1, and select...
Yes you can do that
Declare the following in your declarations;
dim cn As ADODB.Connection
On Error GoTo errhandler
Set cn = New ADODB.Connection
cn.ConnectionString = "Driver=Microsoft Access driver (*.mdb);DBQ=c:\Population Policy Database...
For Alan C:
Another quick check is in the following command
DataEnvironment1.Codes_Grouping List1.List(List1.ListIndex)
do instead this
DataEnvironment1.Codes_Grouping n
That n can be any valid number in your combo box.
If you are still getting that error check the parameter tab and lookfor...
To Alan C:
if you do not mind could you send me your files (in a zipped file). my e-mail address is ravinuthala@un.org.
I used a grouping object and it was working finw for me. May be if I look into your code, I might be able to help you.
For Alan C (Data report designer)
Your code should be changed as follows:
DataEnvironment1.Codes_Grouping List1.List(list1.listIndex)
DeptReport_Detailed.Show
and to pass the parameter to your sql:
SELECT * FROM tbl_FaxData WHERE DatePart("m",[AcknowledgedTime])=?
Actually when you...
Sending parameters to your report from user selected values from a combobox ( for that matter from any control):
Suppose your dataenvironment object name is 'deReports', your command name is 'country' (command name is where your sql is), your combobox name is 'cbosource', and 'dataReport1' is...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.