Search results for query: *

Hi experts, Any ideas how i can send a query through so that it powers a mail merge document in ms word? Any help much apreciated guys and gals, Al

Hi experts, i have set up a mail merge in ms word, and have linked it to a query in my access 97 database. Now i want to be able to change a parameter in the query, i.e. CarNo(a number which is unique to each record). How is it best to send this to the query/word document - at the moment it...

Hi experts, i have set up a mail merge in ms word, and have linked it to a query in my access 97 database. Now i want to be able to change a parameter in the query, i.e. CarNo(a number which is unique to each record). How is it best to send this to the query/word document - at the moment it...

Hi, At the moment i have 13 seperate statements selecting a count of records depending on the criteria dates. A few are shown below:- SELECT count(impactID) as period1 FROM tblBaseData WHERE iyear = 2005 AND iperiod = 9 AND impactId = 1 SELECT count(impactID) as period1 FROM tblBaseData...

Hi, VB makes my dates from my datetimepicker into the format mm/dd/yyyy instead of dd/mm/yyyy like i want. Heres how i put the value into a variable to use:- Dim dtResponseReceivedTo As Date = dtpTo.Value.Date I need dd/mm/yyyy, this is how its stored in my access97 database - am usingvis...

hi i have a datagrid all set up, i just need to know how to sort on one of the columns, for example supplierName... I've put my code below to show you how i have it set up. Cheers, al dtAudits = ds.Tables("audits") ' present data With dgAudits...

Hi, I am using a dateTimePicker to select dates so that they can be used in criteria for a query. The problem i'm having is that when i select a date, the current time comes with it, so when searching on the database if a record has say inserted with a date of 01/01/2006 12:04:33, i may search...

Can i do this sql statement? sql2 = "INSERT INTO tblmaterialSupplier (materialId, SupplierID) values (SELECT @identity FROM tblmaterials, '" & intSuppId & "')" I can't get this sql to work - i need to get the last enetered materialId from my materials table... Alex

Hi i have created a dataset of users as shown below:- Public Sub createDataset() Dim ds As New DataSet("Users") Dim strConn, strSQL As String strConn = carDba.getCn strSQL = "SELECT UserId, LoginName, LoginPassword, userLevelId, fullName " & _...

Hi, i am filling a dataset with the contents of a table based on an sql query (see below) If you can imagine, i have textboxes on the form, which i want to bind to the results inside the dataset. ie, the second column in tblCar is carNo, so i want the carNo to be displayed in txtCarNo. This...

Hello all, This is a toughy, for me anyway... I am using an access97 database, with visual studio 2003.. I am creating a 'search' form so that a user can search through a set of records. Now, i will have controls on the form so that they can select the criteria for the query. These controls...

Public Sub btnLogin_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnLogin.Click Dim sql = "SELECT UserID, fullname, userLevel FROM tblUser WHERE LoginName='" & txtUserName.Text & "' AND LoginPassword='" & txtPassword.Text & "'" Dim conn As...

Public Sub calculateDays() ' Calendar Days Dim dtpDateCarSent As New DateTime Dim dtpDateClosed As New DateTime Dim dys As Integer = dtpDateClosed.Date.Subtract(dtpDateCarSent.Date).Days End Sub Hi, im trying to use the above code but it isnt working... I...

hi, i am trying to develop an mdi style system so that one parent form holds all child forms. I think i have set up the mdi form correctly, but i cant get some forms to open inside the mdi. for instance i have a main menu form that does open in the mdi, which has buttons on it which i want...

I am using this componenet to flag blank textboxes etc in my system - Now i think my code is correct,and i have added the conmponent to the form, it catches the error fine. My problem is that i cannot get the icon to disappear once it is displayed (when i go and fill the txtCarNo and press...

Hi, I need to validate my form so that when a user tries to insert a record, certain fields must be completed. If a field isn't filled, i need the label next to it to be highlighted red. I think i'm nearly there but it isnt working quite how i'd like. At the mo, it does the first if, then...

Hi, ihave a simple login page. This works fine, but what i need to do is store the userID that is being selected in the Stored Procedure so that i can use it throughout the rest if the system. Public Sub btnLogin_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles...

Hi all, New to vb.net and the use of datasets... I know this topic has been covered numerous times, but every Q doesn't start from the begining. I simply have a form with a combobox on (cboSupplier) I want to fill it with supplier name from my Access table (tblSupplier) taking the supplierID...

HI, I am writing a stock management database for my dissertation. I have 3 table - Part, Parts_Supplied and Supplier... When i insert a part, i need to also insert a record into Parts_supplied which contains only the part_id and supplier_id. Do i use an oracle insert trigger when the part...

Hi, i have the following sp in which i am passing in two values (i_username, i_password) and want i_role_id to come out. The problem i'm having is that i cant get the role id into i_role_id. The error msg i'm getting is :- PL/SQL: SQL Statement ignored PL/SQL: ORA-00933: SQL command not...