Recent content by MarkWright

Hello MarkVII, Thanks, I'll look into it. Mark

Hello, am not sure if this is the right Forum but, We log into our net using Novell. We are using a SQL 2000 Server to access an Access 2000 ADP DB. The problem I am having is, everytime we change our password in Novell I have to change the given password on the SQL Server otherwise no one has...

Hello, does anyone know the animadversion for the ole connection`? Thanks Mark

Thanks PHV, I've already read the things there Mark

Hi, I decided to kill the List and made an under Form instead. Saved me time. I am still interested if anyone has an Idea. I looked in the posting that were given. Some good things but not what I was looking for. Have a nice weekend all Mark

Hello, Info: Access 2000, SQL 2000 Server. I am trying to Delete a record from a list field. Is this possible or do I have to call the date direct from the table to delete the entry ? Thanks for your time Mark

Hello Ashlious, I would build a query and set this in a Form. Set a text field where you enter the reg ID and then after klicking enter information will be shown in a under Form. This is one of the easiest ways to get the information you want. regards Mark

Hello Pizarro, I have access 2000 with SQL server 2000 and I use: Dim cnn As ADODB.Connection Dim rst As ADODB.Recordset Dim tbl As New ADODB.Recordset Dim dbcmd As ADODB.Command Set cnn = New ADODB.Connection Set rst = New ADODB.Recordset cnn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data...

Hello awinnn, I would try a query if there is more than one record given. Another way is a Dlookup. but this is useally for looking for 1 record. Just a thought Mark

Hello Martin you can use = Environ("UserName") for NT --> = Environ("NWUSERNAME") just set this in the standard setting in the text field. Have a nice day Mark

Hello, Question: how are or do you want to sort the Information. I don't understand how you sorted on the second click. Have you thought about first click(get information) second click (Sort info...Fild visable = False) Just a thought Mark

Hello, I am trying to set a search field in my contex menu. I have a list form and I want to get a search field where with a click on the right mouse tab I get my contex menu with a search field, enter a name and then that searches for given name in all of the entries in the marked field. This...

Hello Denis, check your table def and see if your using "nvarchar" (4000chr) if so this is one problem. You need to use "ntext"(2^30 more that 1mil.chr) This should help you out. Have a nice weekend Mark

Hello Jurgen, the last step in Access is the Private Sub Form_Unload(Cancel As Integer). set your coding here to check if something is not answered . Use an exit sub to exit if the user has to finish giving any information in the formular. For example -> If IsNull(Produkt.Value) Then...

Hello, if I unsderstand you right, you are trying to give the employee ID as a standard to other forms that you are opening with a cmdbutton. You can use -> employee_ID = Forms("formname")![employee ID] Hope this is what you were looking for Mark