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!

  • 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. mdaniele

    Need to display elapsed time in several fields

    Sounds simple enough, but currently my ReceiveDate/CompleteDate fields only contain the date (sans time)and I use =DateDiff("d",[DateIssueReceived],[DateCompleted]) to capture the days. The minutes are captured in the [ReceivedTime] and [CompleteTime] fields, which contain the time (sans...
  2. mdaniele

    Need to display elapsed time in several fields

    I'm trying to display the elapsed time in days and minutes for the response to a call. On my form, I have a date received field and a time received field (they're not combined into one field because the data is entered from hardcopy at a later time), and a DateCompleted field and a...
  3. mdaniele

    Return a value from a field

    To clarify - I work with tables of raw data (these are project estimates)that are later used in reports. As new data comes in or is developed I'm required to update the old data. Currently the easiest way for me to locate a old record is to query the data using a "like" statement in...
  4. mdaniele

    Query Criteria Statement?

    Problem is that I'm not using a form, am just working with raw data in data tables. I already use a query that displays a subset of all the records based on the LIKE parameter in the DESCRIPTION field, and want to be able to add a criteria expression into the SUB field that will auto filter...
  5. mdaniele

    Return a value from a field

    I'm using the query to retrieve records that need to be updated, the data is never used in a form, it's presented in a report. All I need to do is: get the row, get the field, and use the value from the field in the query criteria. Would I first have to bookmark the record? ...and when Satan...
  6. mdaniele

    Return a value from a field

    Can someone help me with an expression, for a query criteria, that will return the value of a field called AREA from the active record, (not the active field) in a table called ESTIMATE. I don't know the correct syntax to specify the value of a field in the current record I would be working in...
  7. mdaniele

    Programming Custom or Existing Toolbar Buttons

    As this is true for the custom toolbar buttons that can be created from the customize menu, I'm really seeking info on creating custom conmand buttons similar to the "stock" buttons like GoTOField or FontSize, i.e. buttons where the user inputs a value and the program responds to the...
  8. mdaniele

    Query Criteria Statement?

    Sorry that I did not make the question clear enough. I don't want the query SUB criteria to be a specific value, but rather to reference whatever value is in the SUB field in the active record when I run the query. So, if I happen to be on a record that has "180" in the SUB field, I...
  9. mdaniele

    Query Criteria Statement?

    That was kinda freaky, I'll repost. I have a query with a LIKE "*" & [ ] & "*" statement in the DESC criteria field. Could someone help me with syntax for another criteria for the query's "SUB" field that will retrieve records based on the value in the table's...
  10. mdaniele

    Programming a really custom toolbar button?

    My query is a simple one, a criteria search that filters all the records in my table based on the [Description] field. I have attached it to a button on my toolbar which allows me to; while I'm looking at my table, hit the button, the parameter request dialog appears, I type in my string, and...
  11. mdaniele

    Programming Custom or Existing Toolbar Buttons

    The query is simple, a criteria search that filters all the records in my table based on the [Description] field. I have a query that I've attached to a button on my toolbar which allows me to; while I'm looking at my table, hit the button, the parameter request dialog appears, I type in my...
  12. mdaniele

    Clear Text from bound textboxes?

    Thanks for all the help, I've given you a star for each post, well deserved! I'd like to make this a small executable program, but the database will be changing so I'm going to now dabble with making this a webpage app. Once again, thanks
  13. mdaniele

    Clear Text from bound textboxes?

    WHOA, IT WORKS, IT WORKS! After renaming the table, it actually does work using the OPN option. The reason that I didn't think so was that there are so many null records in that column compared to the NPN's(appx 3500 blank entries before the OPNs begin), that I didn't realize the OPN's were...
  14. mdaniele

    Clear Text from bound textboxes?

    I should have remembered that seasoned programmers preface their items with a descriptor like tbl or qry, I mistook it as part of the code and not as part of the item name. So, ok...oops...minor glitch, sometimes you just need those extra pair of eyes...it is now called tblMyProjects, which...
  15. mdaniele

    Clear Text from bound textboxes?

    May thanks once again, After you first posted code, in frustration, I changed names and created a new form bassed on the code you provided. Since then I've looked at it over and over and can't see a discrepency. Here's what I've got: Form ("ProjDataRef" has: Option group...
  16. mdaniele

    Clear Text from bound textboxes?

    Thanks for the input, I have: 1 option group, 2 selections 1 combobox 1 textbox (npn) 1 textbox (opn) 6 textboxes (various project details) All Existing Code is: ******************************************* Option Compare Database 'Automatically generated by the Combo wizard Private Sub...
  17. mdaniele

    Clear Text from bound textboxes?

    Thanks for the help, since 1st posting, re-created the form, here's what's going on: It's a pretty simple form, _______________________________________________________ | | [NPN btn] [NPN combobox] [OPN textbox] |...
  18. mdaniele

    Clear Text from bound textboxes?

    I need to automatically clear?/reset? text fields whenever I either select one of my combo boxes. I don't want to delete any the values in the text fields. Row 1 of my data table is a blank row, can someone tell me the correct syntax to use in the "ON Focus" event of my combo box...
  19. mdaniele

    Need small form to cross ref data

    Thanks for the help, since 1st posting, re-created the form, here's what's going on: It's a pretty simple form, _______________________________________________________ | | [NPN btn] [NPN combobox] [OPN textbox] |...
  20. mdaniele

    Need small form to cross ref data

    I have a table with 5 fields of static data: NewProjNum, OldProjnum, Desc, Client, Mgr. I need a simple form that will allow me to type in the New Project Number to Retrieve the old Project Number and related info. Conversely, Id like to also be able to type in the old Project number to...

Part and Inventory Search

Back
Top