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 SkipVought 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. 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.
  16. FrancieFL

    Unbound Field won't allow entry

    I deleted the old text box and created a new one. The form is an unbound form, and the column will be unbound. I will create a whole new form to see if the text box will allow entry for me. Thanks for all of your help.
  17. FrancieFL

    Unbound Field won't allow entry

    Thanks for the help. I think I now know what the problem is, but do not yet have a solution. I have created the column as a text box (ab tool). That must be for display only. I will need to find the one that is used for input boxes. Francie
  18. FrancieFL

    Unbound Field won't allow entry

    I have created an unbound form which has one field. This field is being used as part of the filter when the command button is selected. The problem I am having is that when I run the form, although my cursor is located in the text box. the form won't allow entry. This may be a simple solution...
  19. FrancieFL

    Unbound Input

    The query is: SELECT Max([Customer_Code]) AS ['Last Code Used'], Left(Max([Customer_Code]),2) AS ['Initials'], Right(Max([Customer_Code]),6) AS ['Last Number'] FROM [Customer Master] WHERE (((Left([Customer_Code],2))=Forms!NewCustomerInput!Initials_In)); I have an unbound column which has a...
  20. FrancieFL

    Unbound Input

    I am a newbie to Access, but have used other database products. I am attempting to create a set of forms that will accept 2 chars of input that will be used in my form attached query to filter on the left 2 chars of a column. I created an unbound textbox, but access is not accepting data entry...

Part and Inventory Search

Back
Top