|
I'm working on a report which allows the user to select which columns they want to be displayed. For the weight column, the user can select if they want the weight displayed in LBS, ST, or MT (they can choose however many they want). In order to do this, I wrote a simple case statement in my select clause that references three bits that are passed from my form (@ShowWeightLBS, @ShowWeightST, @ShowWeightMT). So if @ShowWeightLBS = 1 Then <weight conversion="" fn.=""> & ' LBS' Else ' ' and so on. For the rest of the columns I thought I would use the same concept (in order to hide the entire column), but I then realized what a mess it would turn into in terms of the column headings matching up with the actual data. I realize I can just "hide" the column by basing the fields suppress value on a formula, but I want the columns to be flush and not have large amounts of empty space between them. Is there a simpler way to hide (and suppress) columns?
Thanks,
Tom 
-- modified at 9:31 Monday 6th February, 2006
|
|
|
|
|
What is the best way of invoking an Excel macro within VB.Net.
I want the macro do something like....all data to be in bold for say a certain range.
Would the best thing be just to code it via VB.Net.
|
|
|
|
|
hello everyone,
I am currently evaluating a citrix product which automates userid/password submission to win32 applications. That means, users do not need to remember the login credentials.
I have tried the same with a vb win32 application which had a login form. Now, I need to try logging into a win32 application which does not use windows forms. Could you please advise for what kind of application would it be? How can i create a win32 vb application which does not use vb form for logging into the application?
please advise. thanks and regards,
Ajay kumar suri
|
|
|
|
|
AjaySuri wrote: , I need to try logging into a win32 application which does not use windows forms.
What do you mean by "no forms"? Then how do the user type in a username and password if there is no interface?
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
Hi, I have made a small application in VB.Net/MSAccess. I want to install this application on a different machine. I have made the setup as per the instructions and installed the application on my machine itself. However, an error message pops up when I run the application. The error message is related to database connectivity. The MS Access DB is located in a folder named database within the application folder.
I need to know what steps are needed to be carried out with respect to the MS Access Database. Do I have to copy the MS Access DB to the specified folder as mentioned in the error message. (It points to C:\Program Files\Database)
Thnx for any help.
With Best Regards,
Mayur
|
|
|
|
|
Try using 'Application.StartupPath'
Dim path As String = Application.StartupPath
Dim cnStr As String = "Provider=Microsoft.Jet.OLEDB.4.0;" _
& " Data source= " & path & "\Database\YourDBname.mdb"
Dim strSelect As String = SelectString
Dim cn As New OleDb.OleDbConnection(cnStr)
Dim cmd As New OleDb.OleDbCommand(strSelect, cn)
Dim da As New OleDb.OleDbDataAdapter(cmd)
|
|
|
|
|
Hey Richard,
Thnx for your help. I have been using the same. please refer to the connection string below.
con.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data source=" & Application.StartupPath & "\..\Database\XYZ.mdb"
This works fine when run on the development machine. However, I need to install this application on another machine. It displays an error message regarding the database connection. Please help me out with this. thnx
With Best Regards,
Mayur
|
|
|
|
|
Hi Mayur
Did you put the actual database connection lines in a Try...Catch block - then you can see exactly what the error is by using MessageBox.Show(ex.message). Post the exact message and maybe I can help.
IS MDAC installed on the target machine?
Try<br />
cn.Open()<br />
da.FillSchema(dt, SchemaType.Source)<br />
Return True<br />
Catch ex As Exception<br />
MessageBox.Show(ex.Message) 'WHAT MESSAGE DO YOU GET?<br />
Return False<br />
Finally<br />
cn.Close()<br />
End Try<br />
|
|
|
|
|
Hey Richard, right now i will not be able to provide you with the exact error message since I am busy with some critical work. However, the error message as far as I remember was something like this "Unable to find the database in C:\Program Files\Database". This has got me stumped. Why does it search in C:\Program Files\Database. Also, can you please tell me how the MS Access database has to be deployed on the client machine.
With Best Regards,
Mayur
|
|
|
|
|
hi all
i have used an ActiveX control in my VB project.
when i run it there are no errors and the forms are displayed.but in design time when i switch to form view(i.e View Object) from code view it displays an error msg "errors during load..refer to log for details".when i referred to the corresponding log file it says "license not found"..
what could be the reason behind it?
-- modified at 6:45 Monday 6th February, 2006
|
|
|
|
|
It's because the design-time license for whatevery control your using doesn't have a design-time license installed on your dev machine. This mieans that you're not authorized to use the control in your own applications. I really can't tell you more than that without knowing which control your trying to use.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
-- modified at 10:02 Monday 6th February, 2006
|
|
|
|
|
Hello,
I am working on an Excel application which is sometimes triggered via OLE by another application. The application sends an OLE-command, which calls a macro inside Excel. This works in most cases.
Sometimes, by hitherto unknown reasons, the OLE command does not arrive to Excel.
Does anybody know possible reasons for this?
Are there possibilities to reestablish the OLE communication?
Regards
Michael
|
|
|
|
|
hi
i want to make addin for outlook thats catches the mouse click on the mailitem(means when i click on any mail in my inbox).
thanks in advance
Ankit Patial
|
|
|
|
|
I havn't seen anything like that, but here is a link to OutlookCode.com
that has a lot of outlook programming stuff.
http://www.outlookcode.com/[^]
progload
|
|
|
|
|
hi my website is done and now i want it to upload to the web. i saved it in c:\inetpub\wwwroot. how do i upload my file to my domain name "www.mydomain.com"
-- modified at 5:11 Monday 6th February, 2006
|
|
|
|
|
Why don't you ask them? You're paying for the space and support, so use it.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
Hello Everyone !
I am fine and hoping the same for you.
I need your help in builing and "scrolling text" application. Actually i want to make an application in which i need to scroll my text (from Database) vertically upward, like we see some websites with Current news etc.
Thanx in advance for helping me.
Bye
Arfan Qadir
|
|
|
|
|
|
I want to make a Connection to a Password protected Access 2003 Database.
I tried to make a "Data Connection" in "Server Explorer" tab. In the "Data link properties" dialog box, I select "Microsoft Jet 4.0 OLE DB Provider" in the Provider tab, and in the Connection tab, I select my Database location and default checked "Blank Password" with username "Admin" (Default). It works fine if the Database has no password set.
But when I set password on Database and unchecked "Blank Password" and enter my password in the field "Password" and then click on "Test Connection", it failed to make a connection to Database.
Please help me solve this problem.
Also i have to give a complete location of database, is there any way to give the location of database to the same of executable, e.g. in the Bin folder both files (Database and MyProgram.exe) present, it automatically collect the location of executable file.
Iftikhar Ali
|
|
|
|
|
Select ”Microsoft Jet 4.0 OLE DB Provider”
Select your database location
Do not change anything.
Select “All” tab
Select “Jet OLEDB:Database Password”
Type your password.
Click OK.
chatura
|
|
|
|
|
I have to change/apply password to Access database by opening it in Exclusive mode and then change/apply password to it.
I then close database file and close Access, and even I restarted my computer and try your instructions but on Test Connection got this error.
"Test connection failed because of an error in initializing provider. Cannot start your application. The workgroup information file is missing or opened exclusively by another user."
I did the same process as you describe before asking this question, but the error above mentioned occured.
So, tell me now what should I do.
|
|
|
|
|
I do not know what your error is, but it worked when I did so. I will try to find it. Try to do kostasdiktia2's example.
chatura
|
|
|
|
|
Nonetheless, thanks.
I'll try kostasdiktia2's example.
|
|
|
|
|
temp = System.IO.Path.GetFullPath("Data.mdb")
temp = "Provider=Microsoft.Jet.OLEDB.4.0;Password="""";User ID=Admin;Data Source=" & temp & ";Mode=ReadWrite;Extended Properties="""";Jet OLEDB:System database="""";Jet OLEDB:Registry Path="""";Jet OLEDB:Database Password="""";Jet OLEDB:Engine Type=5;Jet OLEDB:Database Locking Mode=1;Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Global Bulk Transactions=1;Jet OLEDB:New Database Password="####";Jet OLEDB:Create System Database=False;Jet OLEDB:Encrypt Database=False;Jet OLEDB:Don't Copy Locale on Compact=False;Jet OLEDB:Compact Without Replica Repair=False;Jet OLEDB:SFP=False"
OleDbConnection1.ConnectionString = temp
''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
This is an example with a database from data.mdb file (Access file)!
First, I put in temp the path.
Next, I put in temp the connection string of database (in field #### you must write the password)
*I am not 100% sure if it wants password there or in first line! Make combinations!
And finally, I change the connecion string of my OledbConnection..
-- modified at 19:16 Monday 6th February, 2006
|
|
|
|
|
I'll try your solution.
At this moment, I'm building my software without database password. I'll try your solution and then inform you. While please tell me, in your solution, you use Password string many times and in the end advice me to enter my password in place of ####, tell me I only have to enter password in place of #### or everywhere you use Password.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
