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: *

  1. asmall

    Getting the most recent record

    I have been having a difficult time trying to get the most recent record for a client. Here is the code I am using. The following code give me the results below. SELECT ad.authorization_details_id ,p.last_name + ', ' + p.first_name AS NAME ,av.event_name AS Training ,CAST(av.from_date AS DATE)...
  2. asmall

    Users Not Assigned to a Group

    I have a list of users that are assigned or not assigned to a group. A user can be assigned to multiple groups. I am trying to write a query that would show me the groups they are assigned to as well as the groups they are not. Having trouble with the logic and wondering if anyone could provide...
  3. asmall

    Record counting code

    I'm trying to count the number of records in a recordset, but the code I'm using is causing an error. I have used this code in Access 97 but when I convert to Access 2000 I get a type 'Run-Time Error 13 Type missmatch' error. This is the code. Dim recPosition As Recordset Set...
  4. asmall

    List Boxes

    Is there a way to query a list box? For instance, I have a list box that lists a number of employees. But it's a long list. Can I create a search button that will highlight my search results? If it is possible, can you tell me how I can make it happen?
  5. asmall

    Excel Rounding Issue

    I don't want just the integer part to be shown. For instance, I'm doing accounting spreadsheets and if i have a value of 1,754.987. I don't want Excel to round it to 1,754.99. I want the value to be 1,754.98.
  6. asmall

    Excel Rounding Issue

    How can I stop Excel from rounding decimals up or down?
  7. asmall

    Negative numbers

    I have a textbox that is calculating the value of other textboxes. How can I prevent negative numbers?
  8. asmall

    Suppress action queries

    Does anyone know if there is a way to suppress action queries through code instead of through the menu bar? I'm installing a database on several computers and don't want to have to spend too much time suppressing action queries.
  9. asmall

    Java Virtual Error

    At startup I get a message that says "Could not find the main class. Program will exit." Can someone tell me why I'm getting this and how to fix it?
    • asmall
    • Thread
    • Replies: 2
    • Forum: Java
  10. asmall

    Archiving

    How would I go about deleting old data from one table and inserting it into another table? I know I could use SQL but I don't know the syntax. Please help!
  11. asmall

    System objects

    How can one create a recordset from a hidden table or system object? It is possible?
  12. asmall

    Name of loaded forms

    I'm trying to capture the name of the forms that are loaded. This is the code I'm using: Public Function IsLoaded(ByVal strFormName As String) As Boolean Const conObjStateClosed = 0 Const conDesignView = 0 If SysCmd(acSysCmdGetObjectState, acForm, strFormName) <> conObjStateClosed...
  13. asmall

    IP Addresses

    Does anyone know how I can capture the IP address of a user in VBA code so that I can append it to a table?
  14. asmall

    Radio button

    Does anyone know the code to open an existing word doc when when a radio button is clicked?
  15. asmall

    .Net Installation

    Does anyone know if VB.Net can be installled on WindowsXP Pro operating system? or does it have to be installed on a server? I have problems installing on XP.
  16. asmall

    Duplicate data

    The user is entering new data in unbound textboxes. The textbox I am validating is the &quot;TagID&quot; textbox. I have SQL code behind a Save button, and if the TagID matches what's in the table, I get a message saying the records cannot append. By the way, the TagID is the primary key!
  17. asmall

    Duplicate data

    The user is entering new data in unbound textboxes. The textbox I am validating is the &quot;TagID&quot; textbox. I have SQL code behind a Save button, and if the TagID matches what's in the table, I get a message saying the records cannot append.
  18. asmall

    Duplicate data

    I have a database where if someone types in a number and that number already exist in the database I want code to search the table, find the that same number and show a message box saying that number already exists. Is this possible? I hope I'm making sense
  19. asmall

    Capitalization

    Thanks Dre313. That works perfectly!!!!
  20. asmall

    Capitalization

    I tried the code but I'm not able to type anything! Am I doing it right? This is what I have: Private Sub txtFirstName_Change() Me!txtFirstName = UCase(Me!txtFirstName) End Sub

Part and Inventory Search

Back
Top