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 TouchToneTommy 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. vickvickvi

    VBA Array Function

    hello, in my opinion, it may be best to use a speadsheet for the controls on the program that will be needed to do the job. have a Row number and a column number in the extra spread sheet to indicate the row count and the column count if the speadsheet grows. then refence the fields and...
  2. vickvickvi

    Controls

    Hello Here is my solution to this problem. 1- Create 1 combo box and 1 list box and a option button that says to the user that this is the last name search or this is the First Name search. 2- Type in the First or Last name in the combo and select the option box to indicate that this is a...
  3. vickvickvi

    how do you "showmodal" a form and get a response

    your solution seems to be the idea that I would choose. You white a VB box and insert the DLL into the access database. that is a lot more trouble than your first solution. sorry I do not have a solution for you. Good luck and post your solution when you figue it out. vickvickvi michael Vick
  4. vickvickvi

    Drop Connection to SQL Server

    hello , I did add one line to this code to delete the connection. Here you will find the code to add a ODBC table connection to DSN. DSN connects to SQL Server, Oracle, etc. As long as the DSN is setup correctly, it will work. You can cut and pasted the below code into your code good luck...
  5. vickvickvi

    different initial form in MS-ACCESS according to the username

    I have a class module that will help you get the job done. why don't email me and I will forward the access modules to you? vickvickvi@hotmail.com what you are asking for is the code that will get you the user name from the log in information so you do not have to use the access security...
  6. vickvickvi

    Object doesn't support this property or method

    I have tested the code and it done not have any errors with the code ABOVE the DoMenuItems. If I were you. I would use the docmd.runsql Delete from table where Id = [id] and then requery the table. good luck. vickvickvi
  7. vickvickvi

    Filtering 2 forms at once

    hello, this is Vickvickvi, the best thing I can tell you is : 1: Set the Subform as a datasheet Only using the form property's on the subform. 2: in the main form, change the parent/child to the link or links. Ex: link child fields: subfield1,subfield2 link master fields...
  8. vickvickvi

    Selection criteria

    Hello, I will do my best to explain. The input box that you see that pops up is asking for a value and it is looking for a value in the Child form(Subform). Your script is not correct so it can not find the value. The correct script is forms![parentform]![subformName].form![Field Name in...

Part and Inventory Search

Back
Top