Search results for query: *

Hi Is there anyway to make a 256 Color pallete for a windows form? The reason I ask is that I am reading and writing data to an epos terminal. When I read the data back from the terminal it tells me the color of the button is an integer for a 256 color palette number. I also need to know how...

I have been asked to look at a pc which was having some problems logging on. When you switched it on it came up with a message (even in safe mode) System error lsass.exe: When trying to update a password the return status indicates that the value provided as the current password is not...

Thank you all for your comments and I will have a look into all options.

Thanks for the quick response and the comments. Is MSDE limited to the number of users or records that it can hold as I have just tried to import my access database into it and it only seems to hold 10000 records and some of the table in access are bigger than that. What I might do for the...

We have a Front/back End Access Database that we use at the moment which supports about 15 users and it runs very slow. When we had about 7 users it worked ok. If I was to convert the front end to VB.net but keep the back end as it is would this speed things up? Would it cope with 15 users or...

I have a combobox on a form and when the form loads the style is simple as I am just navigating through records. When I hit the add to add a new record I change the style to Dropdownlist which works fine so I can only select what is in the list. The problem comes when I want to edit a record...

I am using the follwoing code to read data from a dataset For i = 0 To myPaymentDataset.Tables("tblMembershipPayments").Rows.Count - 1 With myPaymentDataset.Tables("tblMembershipPayments").Rows(i) If myPaymentDataset.Tables("tblMembershipPayments").Rows(i)...

Solved the problem I had to change my SQL command to myDataAdaptor.UpdateCommand = New OleDbCommand("UPDATE tblMembers SET dteJoinDate = @dteJoinDate,txtMemberTitle = @txtMemberTitle,txtMemberFirstName =@txtMemberFirstName,txtMemberMiddleName = @txtMemberMiddleName,txtMemberLastName =...

Thanks for the reply but it still stops in the same place

I ma using the following code to try and update my database myDataAdaptor.UpdateCommand = New OleDbCommand("UPDATE tblMembers SET...

I have a dataset with 2 tables in it. I have a combobox that changes various text boxes to the seleted record. My dataset also have a datarelation to the second table which when loaded puts the related child field in to the datagrid. The problem I have is that when I change the record in the...

could you point me in the right dirrection of how to achieve this

I am trying to find a way to watch a directory on an ftp site so I can download files once they have been uploaded. Am I able to do this with FileSystemWatcher if so how do I do it I can manage to watch the files on a local machine but not a remote one. If I cant use FileSystemWatcher is there...

Thanks for all your help. I will go away and try all the ideas and see which one I like the best.

The problem I have is that each day is going to have to be split into hours as well as everything is booked by the hour so I was thinking I could have fileds for the hours and just have the data grid show 7 records at a time represting a week of bookings.

Thanks again, I will look into that. Thinking about this a bit more could I not use a data grid each line representing 1 day. I could then set some code that when it got to a certain date it would automatically add the next set of dates to the database.

Thanks for the help RiverGuy. Just as a thought could I use an Excel spreadsheet and have it on the form rather than excel open as a seperate program?

I have been asked to design a program for the local sports club to schedule the clubs facilities ie tennis courts, sports hall etc. I am just not sure of the best way to achieve this. I will be holding the information in a database and just need some help with the scheduling part. I would be...

Thanks for all your help RoyVider. I have managed to sort this. I had to take the words DISTINCT out of the code and it works fine.

I promise this will be the last question on this. I have got my code working as follows so thanks for all your help. Dim wh As Date Dim da As Date wh = DateAdd("d", -3, Date) Me.List39.RowSource = _ "SELECT DISTINCT Account, Name, dt, ti, amount, mon, comm FROM Customers " & _ "WHERE onstop =...