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 strongm 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: frobo
  • Order by date
  1. frobo

    having semicolon list in table field

    how i can iterate with vba code through a semicolon seperated list saved in a table field? tia
  2. frobo

    open report and set title text

    how i can set a label or textbox in a report when i opened it from vba form code?
  3. frobo

    How to copy data from one subform to another subform

    thanks to this nice KB i found this: Me.subEingabeB.SetFocus DoCmd.GoToRecord , , acNewRec which definitely does the job, hurray! :) thanks alot PH for your fast answers!
  4. frobo

    How to copy data from one subform to another subform

    well... I need to reference one subform of two (they both have the same underlying form) for the following command. I tried lot of styles :P ... : DoCmd.GoToRecord acDataForm, Forms![subEingabeB], acNewRec DoCmd.GoToRecord acDataForm, Forms![Startformular]![subEingabeB], acNewRec ... what is...
  5. frobo

    How to copy data from one subform to another subform

    How to copy data into a new record from one subform to another subform when both subs have the same form? the names I entered for each subform on the main form are different, but they aren't accessible at runtime :(. any ideas?
  6. frobo

    setting default values when going to a new record

    how to set defaults to controls when going to a new record by navigation or code?
  7. frobo

    If, Then - Related tables

    try to have these table fields on the form with the same (this is table field) name and probably hide it from user and color it red to see clearly in design that it's hidden. So Your code should/could possible work then. hope it helped ;)
  8. frobo

    writing file

    Thanks it works very well! Just for the other users here the corrected WORKING version. ---- Line #22 contains an error. Change file.Close To TheFile.Close ---- ;) so here's the corrected full version: <code> Sub ExportSomeData() Dim fso As Object Dim TheFile Dim rstWrite As...
  9. frobo

    writing file

    nice,thanks alot. I'll try that. later
  10. frobo

    writing file

    How I can write out a file which I have to setup in code? I need some records save to a file in an own format. Can I iterate through a resultset, write the text to a string (would be long) and save that string to a file? Or append/save to the file on every record? tia frobo
  11. frobo

    MS Access open selection Form and use Value in prior Form

    thanks alot! problem solved :) especially thanks for the fast replies! love u guys ;P
  12. frobo

    MS Access open selection Form and use Value in prior Form

    i got it to work by having a hidden field in the mainform, but now, when i use the modal form to let the user choose a value, the code still goes on, not waiting for the user input. but I need the value in the ongoing code. any idea? tia
  13. frobo

    MS Access open selection Form and use Value in prior Form

    Well where is this constant used? And my other question is: How I can let the user choose from a dropdown on the modal form and use the value in my vba code on another form? tia frobo
  14. frobo

    MS Access open selection Form and use Value in prior Form

    hello together how it's possible to open a form (popup, bound, so it sticks until the user closes it), let the user choose a value and then OK and have the chosen value used in the prior form? tia frobo

Part and Inventory Search

Back
Top