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. ScottMusich

    Updating text field / On Change

    Sorry - I am using ASP. I will look at your suggestion closer and try it out thanks Scott Musich Online Editor
  2. ScottMusich

    Updating text field / On Change

    I use MX and i have a form with a list (first Name). When I selec the list I want the other text field to put in the corresponding last name from the database in the field on the form... I know I need to use an OnChange function but not sure exactly how to grab the second field from the...
  3. ScottMusich

    Delimited list

    See Text Manipulation post under Microsoft: Access other Topics. the last post was 4/10/2002. If you need further explanation let me know. Scott Musich Database Analyst/Programmer
  4. ScottMusich

    Multiple Records in the same Form

    Set the default view to datasheet instead, see if that works how you want. Scott Musich Database Analyst/Programmer
  5. ScottMusich

    Viewing, editing records without the full version of Access

    Do you have licenses for excel? If so you could export/link the tables to an excel spreedsheet. Depending on the size of the database this could get messy though. Other solution you get the solution pack/runtime version - not sure if they still have this for access or if this is exactly what...
  6. ScottMusich

    Form not visible--what is up???

    Is there and error? Is it attached to a query/table? Is it based of search critera? Is the form opening but there is not data? A couple thing I can think of since it is not the properties. I have a form that displays blank when it does not find any subsequent data from some sort of...
  7. ScottMusich

    Passing year parameter to subreport

    It sound like you have it right - just to make sure, the [Enter Year: ] must be typed in exactly the same in all subreport queries/sql and textbox! Does it ask you for year for EVERY subreport or just some of them - if it is just some of them then the above is probably true. Scott Musich...
  8. ScottMusich

    Text Manipulation?

    Try something like the following - I know it looks like a mess but here it goes - I did this in a query and used the Mid and InStr functions. Mid([IP],InStr(InStr(1,[IP],".")+1,[IP],".")+1,3) Breaking it apart: What this does is searches for the 1st position where there is...
  9. ScottMusich

    Pipe delimited problem

    When you start the import click on Advanced (in the Import Text Wizard). Then change the field delimiter to the pipe. This should do it! Scott Musich Database Analyst/Programmer
  10. ScottMusich

    Opening Forms quickly over a slow data link.

    I have a few questions: Are the remote users changing data frequently or just viewing the data? How important is it to have "Live" data? I ask these questions becuase you could create a download process that will run and import/export new data each day (week, etc..) - you may have...
  11. ScottMusich

    How to Suppress an Access information message

    No problem! You can also acheive this by using Macros - However, I find it cleaner to use the code approach. Scott Musich Database Analyst/Programmer
  12. ScottMusich

    How to Suppress an Access information message

    Before the main part of your code add the following (Access 97 syntax): DoCmd.SetWarnings False Make sure after the code to set it back to True otherwise nothing will pop up from that point forward until Access is closed down. Scott Musich Database Analyst/Programmer
  13. ScottMusich

    Adding New Record in SubForm from another subform

    Thanks, This is what I ended up doing: DoCmd.SetWarnings False DoCmd.OpenQuery ("appendQry") DoCmd.Requery [Forms]![mainform]![subform2].Form.Requery DoCmd.SetWarnings True The first requery refreshes subform1 and the second one does subform2 - for some reason refresh...
  14. ScottMusich

    Adding New Record in SubForm from another subform

    Great idea - it works great - can't beleive I didn't do that in the first place! However, how do I requery subform2 properly after clicking on subform1. Scott Musich Database Analyst/Programmer
  15. ScottMusich

    Adding New Record in SubForm from another subform

    1) Yes, The selection in subform1 should be entered in subform2 2)They are related by the field that is being selected (LicenseID) 3) No - only one of them are - the Subform1 is actually a listing of possible data to be entered in (needs to be seperate - not combo box) - I am starting to...
  16. ScottMusich

    Adding New Record in SubForm from another subform

    I will try and explain as best as I can! I have a form (MainFrm) with two subforms (subform1 and subform2). When I click on a record in subform1 I want a record to be added to subform2. (not actual names!) I can get the needed data over to subform2 (to whatever record is selected). However I...
  17. ScottMusich

    I would like to import Paradox tabl

    It't been a while since I used Paradox but doesn't paradox have an export feature? If so, export it out in text format and then import it into Access with the text format. If you work at a place I use to, sometimes getting the necessary disk to do this from your tech dept. takes longer than...
  18. ScottMusich

    Enter date criteria once for report and subreport

    I hope I understand fully your issue. When you are asking for date (or anything else) - if it is named the exact same way in a report as the query it will display correctly and only ask you once! Example In query your criteris is "Between [Start Date] and [End Date]" Then in the...
  19. ScottMusich

    Popping up database window

    Depending what the security is on the database you can have the user just hit F11 to popup a hidden database window. Or hold Shift as the database open in Access. Not sure how you have it setup, but these are the simple solutions. Scott Musich Database Analyst/Programmer
  20. ScottMusich

    Question on subforms

    in the design/properties of the sub forms make sure Record Selectors is set to NO, Same as Navigation buttons! Scott Musich Database Analyst/Programmer

Part and Inventory Search

Back
Top