Search results for query: *

OK, give myself a pink star please. Don't know why it wouldn't accept the d.o.b etc. However, I changed the field to a textbox and gave it the mask ##/##/#### and it all works and no longer crashes my application. Isn't it always the way when you ask a question you end up finding the answer...

I have a list of people in a database. The db is being used as part of a project I am building in VB2005. I have a date of birth column but I cannot get dates to be in the format dd/mm/yyyy. If BOBs d.o.b is the first of May 2006 his DOB should read 01/03/2006. BUT in the db column it always...

Now that's exactly what I wanted to know. So deployment is just a very quick way of 'installing' the programme for one user on one machine? Whereas making a setup project allows far more control over who and where. As it's New Year and I'm feeling in a good mood, have a star... Have a good new...

Hope you all had a good holiday period and are looking forward to yet another new year. So, I have finished my application apart from a few minor details. It works superbly on my testing machine. I need to have it on another machine and so I have created a deployment package. This deploys what...

earthandfire, here's how I sorted it. Maybe of use to other people who are trying to create a report for a single record using treeview. I created a table called report and created a dataset and table adapter from that table. The table holds one record only. That it used to populate the table...

OK earthandfire you're up... I have managed to get the report viewer working using the site you mentioned. It loads all my data as I suppose it should but...I want only one record showing on the report. I am currently using treeview to populate my textboxes and it works rather nicely. However...

Can you expand on this further? I'm not using a wizard. I copied the code directly from the tutorial I mentioned in my original post, so maybe they did? I definately will have a problem when people have the same first name. I found a tutorial on treeview and quite like the way that works so...

Sorry Earthandfire, didn't realise you had posted again. I read the website and to be honest I'm none the wiser on report printing. Rather than spend too much time trying to figure it out, I moved on through the development and will come back to printing when I'm nearer the end. I may build the...

That could be the problem couldn't it. I haven't told the prog where to insert the data. So now I have this... Private Sub btnSearch_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnSearch.Click sql = "SELECT * FROM tblContacts WHERE Surname = '" &...

I followed this tutorial when I had problems creating update, save, insert etc buttons. If I can follow it then any one can follow it. Talks about connections as well. http://www.homeandlearn.co.uk/NET/nets12p1.html

Thanks for your help. Unfortunately there are no 'errors' or error messages. It simply doesn't populate any of the textboxes on the form. I know the code for the rest of the app works as I can navigate etc but I can't populate from that search button.

I have been building an address book prog for my company. I followed this tutorial http://www.homeandlearn.co.uk/NET/nets12p1.html which I think is excellent. If I can follow it and get it to work, anyone can. It's answered several questions I had as well. I wanted to expand on the basic address...

Sorry to ask such a question but I cannot find the answer anywhere. I have added a report (Report1.rdlc) to my application. All I want to do is be able to press a button and have it print. My problem is that nowhere can I find anything to tell me how to do it. Even MSDN is pretty vague. In VB6...

Johnwm, that's exactly what I want tem to do and what I had in Access. However, all staff aren't allowed access to access so can't run the db. That is why I'm creating it in VB. What I was really after was how would you distinguish between the two unique codes and two SQLs. Incidentally...how...

I gave Jerry a big pink star as it is equal or greater to a bucket of black coffee. I would like to know one other thing from you guys. This project had to be simple. It's used by many staff from different departments, at all hours of night and day (but no multiple connections), so too many...

Ah, yes the rs. That was probably a legacy of copying and pasting from a tutorial that worked for me. I don't quite understand the 129 thing but I'll run with. Any ideas about including [reagname] in the label caption instead of the txtSearch value?

I have this now. Does it look better? Private Sub cmbAdd_Click() Dim conn As ADODB.Connection Dim rs As ADODB.Recordset Set conn = New ADODB.Connection Set rs = New ADODB.Recordset conn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" & "Data Source = c:\stock\db1.mdb"...

No things don't get on my nerves when I'm learning and learning from people who know what they are talking about.:) I didn't want all the IF statements, that's why I asked the question if I could reduce them...and I can, and I have. I do have 2 SQLs that run depending on the value in the text...

My code at the mo loks something like this If txtSearch = "123456" Then Set rs = conn.Execute("UPDATE tblStock SET kitdate = #" & Format(Now(), "dd/mmm/yy") & "#, quantity = quantity + 5 WHERE [reagent] = '" & txtSearch.Text & "'") else If txtSearch = "123457" Then Set rs = conn.Execute("UPDATE...

Sorry, me again. Another one of my projects. This time for organising and controling stock. It uses a VB6 front form and access as the database. There are more than 50 items in the db and I would like to reduce the amount of code in the app. If the user enters 'stockitem1' into the textbox as...