Search results for query: *

Hi - i have a table of data, and have put some conditional formatting on the description field. i.e. if description = "impact", the text goes red... if {FinalReport.description} = "Impact Rating" then crRed else if {FinalReport.description} = "Period QPI" then crRed Now can i change other...

Hi i have set up a mail merge document, and set the datasource to a query in my access 97 database. This works fine. The problem is that i need to change a parameter in the query, based on what record the user is currently looking at. So i need to change the carNo = 1 part of my SQL :-...

If i set up a mail merge document, how can i either change the query parameter(if i store one in the database - access97) or do it programatically from code?

Hi, Can anyone give me some information on what technique is best for sending data from a form (or a dataset which i will put the data into) into microsoft word? I need to set up a template so that the correct information is displayed next to it's template label. Any guidence and/or tutorial...

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 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...

yeah thats what i went with in the end dtpTimeLost.ShowUpDown = True dtpTimeLost.Format = DateTimePickerFormat.Custom dtpTimeLost.CustomFormat = "hh:mm:ss"

Not really, it's just a textbox. i take everything from each textbox on my form and submit a query, i dont bind each column to a field on my form

Hi, i need to change a normal textbox to a hh:mm:ss time format so that a time is entered correctly. Have got an access table behind the scenes... I have tried this but it doesn't do a lot! txtTimeLost.Text.Format("hh:mm:ss") Any help/ideas much apreciated, Al

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

yeah thats what it was, cheers. how do i get the first record to display? at the moment i have to press my next record button to pull up the first record - i'd like it there on load if possible Alex

Hi, i tried using your method - couldn't get it to work I have tried this and it also doent work as it says object reference not instance of object on the top line:- Private Sub NavigateRecords() txtUsername.Text = ds.Tables("Users").Rows(inc).Item("LoginName")...

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...

dont know whats happening to my posts today! seem to have been deleted... i am trying to solve my problem of closing the login a new way. i open the mdiParent form on startup, which calls the login form. i need th login form to close if the password etc is ok and my main menu to open...

no probs, cheers cjard. i know this should be easy but i cant get my login form to close automatically once ive logged in. i've tried me.close in a few places but it doesn't seem to work - this is the write command to use isn't it? if not what should i be using? do i need to close the form...

using the column names like you explained previously gave me an error that i couldn't cast from string userID to integer.... i used get value as its returning an integer dbaCAR.UserId = dr.GetValue("UserID")

ok cool, i'll take all that on board and post back what ive come up with. There is one thing that should be well easy but i cant get it to work. Ive tried using me.close in various places to close the login form when the user has logged in and the main form has opened but it doesn't seem to...