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

    Renaming Column Headers in Excel using VBA

    I'm manipulating tables in Excel using Visual basic and as part of the code I would like to remove all text enclosed in parentheses from column headers - see below From To Ive been attempting to use the example formula using VBA but cannot make it work =LEFT(D1,FIND(" (",D1)-1) and...
  2. fishtek

    Enumerate Grouped Records in a Query

    Im trying to enumerate grouped records in a query. Please see table below. The query is grouped and sorted by ID then depth. When I run the query I would like Depth_Enum to enumerate the depth values based on the grouping. Any suggestion would be appreciated. Thank You
  3. fishtek

    Dates in Consecutive Quarters

    I'm trying to figure out a query statement that would identify when 2 dates occur within consecutive quarters (but not the same quarter). I've been messing around with DatePart and DateAdd but not getting very far. Thanks for any help.
  4. fishtek

    Prevent Duplicate Child Records?

    I have a station ID table connected to another data (species code) table via one to many relationship using the station ID. Users enter species codes for a station using a form. How can I prevent a user from entering duplicate species codes for a particular station ID. In other words its ok to...
  5. fishtek

    strWhere when field is Boolean

    I would like to use strWhere to search a boolean field. Can someone provide me with the proper syntax? See similar code below. Dim strWhere As String strWhere = "1=1" If Not IsNull(Me.chkPaid) Then strWhere = strWhere & " AND [Paid] Like """ & Me.chkPaid & """ " End If Dim stDocName As String...
  6. fishtek

    Condense rows in a query

    I have a query that returns the following with each row representing a different date in 2008: Facility Year Jan Feb Mar Apr Dare County 2008 Pass * * * Dare County 2008 * * * Pass Dare County 2008 * Pass * * Dare County 2008 * * Fail * Is it possible in the query to condense the rows like...
  7. fishtek

    Extracting whole numbers and decimals from text field

    I have a query with a text field similar to the following: Fail <24 >24.6 Fail >100 <45 >100 Fail 77 59.9 I am using the following code to extract numbers from the text but the decimals are removed. Problem is I would like to keep all decimals in the numbers. Public Function getNum(myField)...
  8. fishtek

    Date stamp in table for when record was last exported

    I am pulling data from a table via a query to be exported to excel. I have created a field in the table to display a date when the record was last exported. How do I date stamp the field to show when I queried/exported the record? Any help would be appreciated. Thank You
  9. fishtek

    Date stamp record in table without using a form

    Is it possible to place a date stamp for a modified record in a table without using a form? Some records are being changed by a user without a form and need to be stamped when edited directly. Thanks
  10. fishtek

    Open Continuous form to edit datasheet subform record

    Hello: I have a subform in datasheet view that displays some (but not all) data in a table. I would like to have the user browse the records in the subform and then click on the date field in the subform to have a continuous form open for editing all data for that record. Thanks for any help.
  11. fishtek

    Pass values in unbound control to a table

    Is there a method to pass values in unbound controls on a form to a table? Because of the table structure and for other reasons having to do with the users I would like to have the form act as a template with unbound controls and then pass those control values to a table at a later time. Thanks...
  12. fishtek

    Counter on form

    I have a form that I want serve as a count sheet for organisms. On the form I have text boxes that hold counts for various critters. I would like to place a button on the form that increases the count in the active text box by 1 for each click. (Initially the text box would be null) I have made...
  13. fishtek

    Average for multiple fields in a query

    I have a query with multiple fields containing weight data - Weight1, Weight2, Weight3, etc.. I would like to average the fields (not rows) and ignore fields with null values in the average calculation. I'm sure its obvious but I can't make it work in the query. Thanks for any help.....
  14. fishtek

    Force negative sign with input mask

    I'm looking for a method to force the user to insert a negative sign in front of a number. I've tried various input masks but none seem to work and still allow a positive number to be entered. Thanks for any help.
  15. fishtek

    Disable command button if any textboxes are not null

    I have a search form that i want to disable a command button on if any unbound text boxes contain text. I've tried various code with various events but none work. Thanks for any help.
  16. fishtek

    Need to quickly clear yes/no field

    I have a boolean field in a table that users check yes or no to filter unrelated records in a query. Is there a quick way with code or other to allow users to quickly clear out all checks in the field before starting a new filter? I suppose they could sort to bring all checks to the top and...
  17. fishtek

    Multiselect Listbox to filter a form

    Hello: I have limited experience with VBA. I have a form that displays data in datasheet view that I am trying to let the user filter with a multi select listbox. The form runs off a query. The user selects multiple records from the listbox, then clicks a button to open the form to show only...
  18. fishtek

    Output form in datasheet view to excel workbook

    I have created a user interface that display search results on a form in the datasheet view. I am trying to output this form to an excel workbook with multiple worksheets using DoCmd.OutputTo acOutputForm, "frmBCTable", acFormatXLS, "S:\MikeW_DB\TransferXL.xls" The form outputs fine but...
  19. fishtek

    Scroll wheel accidentally adds new records

    I have a form for entering and viewing records in a table. (the data entry property is set to "No"). If the user accidentally turns the mouse scroll wheel while the form is active, new blank records are added to the table. Is there a way to disable this? It has caused problems because some...
  20. fishtek

    Force User to Save Record on Master Form

    Hello: I have a master form with several buttons that open child forms. The master form passes certain record info to the child forms provided the record has been saved. Problem is if a user forgets to save a record on the master form, they get an error message when attempting to save the...

Part and Inventory Search

Back
Top