Search results for query: *

First make the table into a query and sort the query by txtservername. Second use the query instead of the table in the form. Besides, queries run much faster.

I have already written a FTP program. What I am wanting to know, how can I give certain people access to different levels inside of the program. There are over 100 people signing on the FTP program and on 30 laptop computers(CDPD wireless) Police Patrol cars. I do not want to add and change...

Try putting these checked boxes or radio buttons in a group and use the group as the selection process.

I have a listview box with Multiselect turned on. When I select only the last entry in the listview and remove it from the listview box I get an error: An unhandled exception of type 'System.ArgumentOutOfRangeException' occurred in system.windows.forms.dll Additional information: Specified...

I am trying to get the processor speed...Is there a command i can run... AIX 4.3.3 Thanks Nick

Look in the drop down and select (form1 Events) and now you should see the events the belong to the "FORM1

Thanks, That works great...One other quick question though...How can i get a date(column) field sorted...

I am trying to sort Columns in Listview. I have used Comparer in my code. I don't understand how to sort a Numerical column....(file.length, third column) Any help is greatly appreciated. Here is my code. Thanks Nick Class ListViewItemComparer Implements IComparer...

...String, Offcode As String) As Boolean Dim CheckDup As ADODB.Recordset Dim StrSql As String Set CheckDup = New ADODB.Recordset StrSql = "select * from [master case] " & _ "where [master case].caseno = '" & Caseno & "' and [master case].offensetype = '" & Offcode &...

How would i keep "Mastercase.caseno" from importing the same "importmapdata.caseno" IE Duplicate record

...ImportMapData.Open strSQL, CurrentProject.Connection, adOpenKeyset, adLockPessimistic MasterCase.Open "select * from [master case]", CurrentProject.Connection, adOpenKeyset, adLockPessimistic With ImportMapData 'Move first moves the Pointer to the "First Record" in the...

How not import duplicates from one table to another…. I have two tables one is the Main table and the other is a Temp table which is imported via ODBC. The Temp table could possibly have a record in it that is already in the Main table. There is not and can not have an UNIQUE field in the Main...

I want to know what type of control is active when is recieves focus?

Hi, I want to know which control is active on the current form regardless of control..... I have started some code, but don't seem to have the hang of it..Help With ctl Select Case .ctl Case acComboBox Response = MsgBox("Combo Box", vbInformation...

How can I get Grand totals for 2 of 3 grouping levels at the report footer? Grouping levels as follows: Grouping Header Section Date Division Activity Group Footer Section Date =sum([total rate]) Division =sum([total rate]) Activity =sum([total rate]) Report Footer...

...UpdateHistoryRecord(Pf As String) Dim rst As ADODB.Recordset, countrecords As Integer Set rst = New ADODB.Recordset selectionrecords = "select * from history where dispos in('HE','EM')" _ & " and permit = '" & Pf & "'" & " order by...

...UpdateHistoryRecord(Pf As String) Dim rst As ADODB.Recordset, countrecords As Integer Set rst = New ADODB.Recordset selectionrecords = "select * from history where dispos in('HE','EM')" _ & " and permit = '" & Pf & "'" & " order by...

If a user logs into the database with his/her Username and password. How can I get the username to be put into the data entry form? Thanks

I have a form and a report that uses a query from 2 tables...I want the report to reflect the filter(filter by form) a put into the fields of the form.

That worked...Thanks