Recent content by stimpy

  1. S

    create file for output + name it current date

    I need to create a text file and name it the current date. I then need to have the results of a query exported to that file. If a file with the same name already exists then it has to overwrite it. I have attempted this by using the Open, Freefile, Print and Close commands. Unfortunately I am...
  2. S

    random number generator

    Thanks Jack I just realised that the help files were not installed properly which is why I couldn't find the Rnd function That is exactly what I was looking for
  3. S

    random number generator

    I need a textbox on a form to contain a random number which refreshes(changes) everytime I click a particular button on the form. I have searched the help files etc and all I can find is the RANDBETWEEN function which is ideal, but it only seems to work in Excel worksheets. Is there are function...
  4. S

    Message boxes

    This cant be done can it
  5. S

    replicate form design

    Maybe Im misunderstanding your question, but it sounds like you could save the form design as a style and this would be helpful for the form design aspects
  6. S

    Help with Subform

    Im not all that sure how to set it up, But there is an example of this in the Northwind database that might be helpful to look at.
  7. S

    Button command

    Im no expert but here is how I did it: The notes can be entered into a field in the table that the form is linked to. Add a new field in the table for the notes to go in and make its data type memo if the notes will be longer than 255 chars. Then make a form that contains a text box bound to...
  8. S

    Display combo box value in a text box

    My form contains a text box and a combo box. When a value is selected from the combo box I want it to be displayed in the text box. The combo box contains a list of 4 digit postcodes(zipcodes. I have linked my text box to this combo box using the source property of the text box, but when I try...
Top Bottom