i just want to print out the queries in the access database along with the description that has been entered from [right click on query- properties-description] i can print the query its name etc etc but i cannot find how to get to the description allegedly in containers.documents but its a mystery to me how i get there programatically
View 4 Replies
I have a query which I test and work fine in Access[code]...
When I try it, it comes up with an error: "Undefined function 'Nz' in expression.
Is it possible to add a clickable html link in the description field of an aboutbox? I'd like to include a clickable html link that takes the user to a support web page or use a mailto link to send an email to a support desk.
View 1 RepliesIm working on a small program that is suppost to make my life easier but im running into a little problem:I want to search active directory using the Description field as the search field but somehow my code below doesnt return anything.[code]
View 2 RepliesI am working on a project for work where I am stuck. We have a daily checklist that i have converted into a Tabular text file. In the text file I have 3 pieces of information, DB field reference, Time it should be done by, and task to be completed. I have this part being pulled into the screen with the Code below. My problem is how do I Merge the Database to the TextBox. The Access DB has 50 Columns of for data Labeled 1 through 50 + one date Field
Imports System.IO
Public Class FirstShiftCheckListForm
Dim strlines() As String
Dim strline() As String
Dim strarray(,) As String
[Code] ......
I need to add (Append) additional text to the Comment field in my access database from a RichTextBox. I am having difficulty with the sql connection syntax.
View 6 RepliesInsert Query for inserting date into access from masked text box in vb.net
View 3 RepliesIs it possible to populate an AutoComplete text box property in code from an Access query.
View 6 RepliesI want to put some description/tooltip text within textbox control which will vanish when the focus is on that control. Its similar to that like in the search box above. When the search box is empty it shows "Search MSDN with Bing" and when the contol gets the focus that string vanishes.
View 3 RepliesHow can I go about implementing a popup box or something that shows a simple description of a controls contents if the user hovers over the control?
View 1 RepliesI am connecting to an Access database and using a parameter query with the LIKE operator to return all rows that match query. The string to search for is taken from a Textbox
sql =
"Select * FROM Allview WHERE Info Like" &
"*" &
CStr(TextBox1.Text) &
"*"
The query does not return any data in vb, but when run from access with same string, there is data returned.The connection to the database is done correctly, as I am able to return data with various other queries.
Partial code :
Dim
con As
New OleDb.OleDbConnection[code]....
I am trying to run a query an Access db from VB. The general query which I want to run is
SELECT * FROM Patient WHERE Patient.PatientID = ?
or SELECT * FROM Patient WHERE Patient.PatientLname = ?
I tried using an input box which captured the user input and pass that variable to the query, but that failed. Then I read about writing a function and using that, however, I keep getting an error which says Function not defined, but when stepping through the code, it seems to work. Here is my function: [Code]
I have the following table
[Code]...
if I have an sql as follows with an external(from a list box) selected event & location as follows: Select * From Table Where Subject ='103' or InStr(Subject, '-103-') or mid(Subject,1,len(103)+1)='103-' or mid(Subject,len(Subject)-len(103),len(103)+1)='-103' and Event = 'T178' and Location = 'Yennora' I get more than one record, I should get only record 13
I had been using this way for while, and it seems it work fine with char and numbers.
Dim MyVar1 as String = "Hello"
Dim MyVar2 as Integer = 1
Dim MySQL = "Select * from table where field1 = '<field1>' and Field2 = <field2>"
MySQL = MySQL.Replace("<field1>",MyVar1).Replace("<field2>",MyVar2)
msgbox(MySQL)
But, when I have to deal with blob field, where I store "wav file" for example, I had to read it as array of bytes, and the only way I find to insert the array of bytes in my query string is by using the command.AddParameter
Dim myfile As System.IO.FileStream = System.IO.File.OpenRead("full_wav_file_path")
Dim myArray(myfile.Length) As Byte
myfile.Read(myArray, 0, (myfile.Length))
[Code] .....
Is there another way to insert it without addParameter?
I have a LINQ query:
VB
Dim Db = New MyDataContext
Dim Qry = From cust in Db.Customers
Select cust.ID, cust.Name
And I want to pass it to a function to filter it, like this:
VB
FilterAnyQuery(Qry, cust.ID) ' WHERE "cust.ID" CAN BE ANY FIELD
The Sub should be of this kind:
VB
Sub FilterAnyQuery(ByVal AnyQry As iQueryable, AnyField as ???)
AnyQry = AnyQry.Where(AnyField = "somevalue")
End Sub
How can I pass "AnyField" to the Sub and make the LINQ "Where" clause work?
I have numeric data that I am getting from a database. They are all numeric, but they are a mix of int, money and real
View 2 Replies[code]"An INSERT INTO query cannot contain a multi-valued field." i got this exception while trying to save record in access file.
View 4 RepliesPrivate Sub ButtonSave_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles ButtonSave.Click
[Code]...
Upon entry into my database, frmLot opens. The form opens in datasheet view. It displays several fields to include one named WorkOrder. The user clicks in the cell named WorkOrder. In the On Click property, I store that variable and name it stWorkOrder. What I need to happen then is to pass this variable to the criteria field of a query named qryWorkOrder and have it run and display results.
View 1 RepliesI have a problem with the Validation of a Integer-Field in my application.Its an Access DB on a Windows Form.I implemented the validation in DataSet.vb using an ErrorProvider on my Form.The field name is FNr and should not accept duplicate numbers.If the field value is changed, a query checks if the number already exists in the Datatable and if so it sets the error on that field.If the user tries to change the field to a number which is a duplicate I want to cancel the input back to the original number. This works but the
Error message is still shown by the ErrorProvider.The code is partially in DataSet.vb and in Form.vb
Public Class Funktionen
Private Sub FunktionenBindingNavigatorSaveItem_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles FunktionenBindingNavigatorSaveItem.Click
Me.Validate()[code]......
I have a question, how would i have a button, then when you click it, it puts the text at the text cursor in the RTF?
View 5 RepliesI have users check off lab facilities in a UI. I want to use linq to fetch corresponding records for all of the labs that they have checked off. Basically,
Dim myRecs = (From l As EpiData In myDataContext.EPIDatas Where l.facility= _
one of the checked labs
So basically, I need to write a linq query where the "strings" to match are determined at runtime. Is there any way to do this easily? I know that there is a library out there called dynamic LINQ, but (1) it's in C# and I'm writing in VB (2) I'm really just looking for a single, simple solution for this single case.
Right now I am using this code on client side.
[Code]...
The values for the hidden fields are already set. I want these value to open a window, in which the fields will be already filled using the values passed by this page. This code is working fine on Internet Explorer, but not on other browsers. Moreover, when I don't pass any value and just open the required window, it works on all browsers.
I can save my data to access database and in the access database field I set it to date/time.But problem is when I get the value out from the database.. the format is always month/day/year hour:minutes:seconds example today: 5/2/2011 12:00:00..How to get the value into listview becoming May/2/2011 without the hour..Here's my code to get it from database ListView1.Items(i).SubItems.Add(dt.Rows(i)(14).ToString).The second problem is.When I would like to edit, how can the datetimepicker get the listview value ? [code] info: using access 2003 (.mdb) the Date of Birth field has been set into Date/Time.
View 2 RepliesI download a file into access. One field contains one to many numbers always separated by a colon and a space: I have no control over the download. TheNumbers have a 1 to many relationship to a customer. Each number must then be verified against two separate reference files, and if the numbers match the description related to the number will be displayed.I'm just learning visual basic. I've made the changes manually (yuk-this took forever); I've tried various string/conversion commands; I've taken the data and placed it into excel and tried to manipulate it, without success.In this case is always numeric. In another field, similar problem, it's a combination of text and numbers.
Example: Cust# TheNumbers
99 1234; 12345678; 123123; etc...
88 87654321, 345654, 98989898. etc..
The numbers can vary in length and quantity. For each customer each number must be loaded into one field.
Example outcome:
Cust# TheNumber
99 1234
99 12345678
[code]....
I am trying to get the Sum values of a Column and want to check if entered value in Textbox is valid. Here is my code below
[Code]...
i have a table name product , when i m inserting data into product i need to first check if Product Name already exist in database if yes i want to exit. basically i want to know how to get data from the database and how to access columns in asp.net .
View 4 RepliesHow to get access Field name and type in VB.net Listview?
View 5 RepliesI am new in VB.net. I would like to display picture in Attachement fields in Access table ina Window form with VB.net.I created a Window form using Visual Studio ( sorry, I am new in Visual Studio too and set the Access table as the data source.
View 2 RepliesI need to create a field in my database access throught code... I had this code in VB6 to do the job,but i'm a little confused with the way to do this in VS2008.Off course I know the way to open the database,but the way for create the field I don't know!
Dim tdf As TableDef, fld As Field, Top As TableDef
Dim nCtr As Integer
Dim bFound As Boolean
[Code]....
