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 Rhinorhino 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: kismet
  • Content: Threads
  • Order by date
  1. kismet

    How to sort times

    How can I sort time records chronologically? Given that a file contains: 10:30a ... 08:30a ... 11:00p ... 09:15a ... 01:30p ... ... how do I make them into the ff. (arranged chronologically)? I've tried the sort -n command, but obviously it just looks at the time itself and...
  2. kismet

    checking format of date and time inputs

    Hi! How can I check the format of an entered date and time in the command line? For example, I want the date format to be dd-mon-yyyy while the time, hh:mmT (with T as either a or p). Is there a command I can use that does these? Thank you!
  3. kismet

    How to determine number of rows returned by a filter

    How do I determine the number of rows returned after using an AutoFilter?
  4. kismet

    get value of specific cell in datagrid

    Hi! I want to get the value of a specific cell and display it in a textbox (separate from the datagrid). For example, my datagrid has the fields Name, Birthday, and Address. When I click on a particular record/row, I want the textboxes txtName, txtBirthday and txtAddress to get the respective...
  5. kismet

    get last 10 records from a table

    Hi! What sql command can I use in order to get the last 10 records of a table? One of the fields of the table is an AutoNumber. Other fields are dates, version numbers, etc. Thank you in advance! =)
  6. kismet

    getting the latest version (MAX) of multiple distinct documents

    I am working on this document library and I want to display only the latest versions of the available document titles. For example, under the Analysis document type, there are the Hardware document title (Analysis_Hardware) and the Software document title (Analysis_Software). These document...
  7. kismet

    Problem with Error:Object Required

    I can't figure out why this error keeps popping out when I run my code. It always says that frmImmunizationRecord cannot be "found" by VB. Function decreaseStockOnHand() Dim stock As Integer Dim computedStock As Integer Dim strSQL As String Dim vaccineCode As String...
  8. kismet

    Assign Value to a Specific Field of a Record in a Table

    Sorry, it is me again! =) I am making an inventory database, and this concerns two tables- the tblVaccine (stores info about a Vaccine including its stock on hand) and the tblImmunization (records that contain the patient, vaccine, and date of vaccination). I want to automatically deduct 1...
  9. kismet

    Get Specific Value from a Table and Copy it to a Textfield of a Report

    Hi. I am a fairly new Access user so I am still pretty much in the dark. How can I get the value in a specific cell from a table(Table A) and copy it to a text field in my report(Report 1)? I have some knowledge of SQL- can I use this in my problem? (SELECT tblImmunization.dateAdministered...
  10. kismet

    Get Specific Value from a Table and Copy to a Text field of a Report

    Hi. I am a fairly new Access user so I am still pretty much in the dark. How can I get the value in a specific cell from a table(Table A) and copy it to a text field in my report(Report 1)? I have some knowledge of SQL- can I use this in my problem? (SELECT tblImmunization.dateAdministered...
  11. kismet

    Get specific record given the 2 primary keys

    Hello! How can one program an access database in such a way that it takes in the chosen values of the 2 primary keys and displays the record (in form view) pertained to by those 2 primary keys? I hope this question made sense... thanks!

Part and Inventory Search

Back
Top