Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: Nickaroo
  • Order by date
  1. Nickaroo

    Form will not Sort

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

    FTP

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

    Multiple Items Selection Problem

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

    Listview select error

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

    Processor Speed Command

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

    form key press event

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

    List View Sort

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

    List View Sort

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

    How not import duplicates

    ...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 &...
  10. Nickaroo

    How not import duplicates

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

    How not import duplicates

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

    How not import duplicates

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

    finding which control is active

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

    finding which control is active

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

    Grand totals from grouping totals

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

    Opening and closing record sets

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

    opening and Closing recordsets

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

    User name

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

    Creating a Report based of form query

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

    Calculating from one form to another

    That worked...Thanks

Part and Inventory Search

Back
Top