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 Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by FrancieFL

  1. FrancieFL

    Maximizining Website Window

    Is there a way that I can force my website to be opened in a maximized window. The site uses a picture background and does not look correct if the window opens minimized. Thanks, Francie
  2. FrancieFL

    Maximizing Website Window

    Is there a way that I can force my website to be opened as maximize? My site uses a background picture and doesn't display correctly if the site is not in a maximized window. Thanks, Francie
  3. FrancieFL

    Passing VB variable to Form Where

    I tried both methods and don't seem to be able to get it to work. I'm sure it is something I am doing, or failed to mention in the above note. The process is that I have form one (GetInitials) with a button that calls my VB Public Sub. Public Sub GetNumber_Click() NewClientCode = Chr$(39) &...
  4. FrancieFL

    Creating a date range prompt

    You may want to try and set the usage to "A8MDYY" for your column, then create the below define. Define MyDate/MDYY = InDate ;$ The way I do this is I give the master "FIELD" name a temporary name and the Define field is the one that is used on reports and in the WHERE...
  5. FrancieFL

    Passing VB variable to Form Where

    I have a form that runs a VB function then calls a subform. I need to use the computed VB variable for my filtering in the subform. Is there a way to do this? Here is the VB code I have. NewClientCode = Chr$(39) & rst.Fields(0).Value & Num & Chr$(39) ' Go to the New Client form...
  6. FrancieFL

    Dynamically setting screen size

    I have installed a website that displays correctly when viewed in 1024, which is how I developed it. When someone access the site with a workstation set at 640 the pages wraparound. Is there a way to determine the screen size and set it corretly? Thanks, Francie
  7. FrancieFL

    Display scrolling

    I have created a website that displays correctly when viewed in 1024. Several users are using 640 and are not receiving the horizontal scroll bar. This is causing the page to wrap around. Is there a way to put a control in FrontPage that will determine the screen size and adjust correctly, or...
  8. FrancieFL

    Referencing a form variable in VB code

    Thanks for the help. Francie
  9. FrancieFL

    Referencing a form variable in VB code

    I have an unbound field called "[Initials In]" which I am trying to us in a SELECT and SET statement. I have tried "ME![Initials IN]" but VB doesn't seem to get the value of the field. My sub statement is: Public Sub GetNumber_Click() and the WHERE statement is...
  10. FrancieFL

    Invalid Qualifier Error

    Thank you both so very much. That got me past that problem. Francie
  11. FrancieFL

    Invalid Qualifier Error

    I am creating an unbound form that receives initials and uses them to determine what the next available key should be for given initials. When I run my test and select the add button I receive an "Invalid Qualifier" error on the "Set rst" line. VSBasic highlights the...
  12. FrancieFL

    User Defined Type not Defined Error

    That did it. Thanks so much. Francie
  13. FrancieFL

    User Defined Type not Defined Error

    I am receiving the User Deined Type error on the "Dim dbs" statement. What I am trying to do is select the next value of "Last Code Used" so I can generate the next key. Am I working with DAO incorrectly? Thanks, Francie Here's the code: Public Sub GetNumber_Click() Dim...
  14. FrancieFL

    Making Unbound column Public

    I have an unbound form which calls a bound form. I want to pass the value received in the unbound form to the select/filter in the bound form. Can the unbound column be made Public by using the text box properties form. Thanks, Francie
  15. FrancieFL

    Unbound Field won't allow entry

    Recreating the form allows me to enter data. I will add my command buttons and see how that goes. Thanks for helping me out.

Part and Inventory Search

Back
Top