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 derfloh 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: thefroggy
  • Content: Threads
  • Order by date
  1. thefroggy

    force date entry fom a cmd button

    Hi everyone, Here is my problem. I have created a database to store information on raw material stored in a ware house. Each class of raw material have a given expire date, and some of my user are messing up this vital information when a new raw is introduced. Have a starting form with...
  2. thefroggy

    autofilling option from a cmd button

    Hi everyone. I'm a newby in VBA and I have been trying to do something for sometime without any success. I have 5 command buttons on my “main” form. All on them open the same “page” form only the subforms change depending on the command button clicked. On the “page” form the users manually...
  3. thefroggy

    multiple forms option in one subform

    Hi, I have a common form with only one subform box on it. I have 3 possible forms for this subform space. I would like to know if it is possible to open a given form in my subform depending on the information enter in my main form. E.g: if I select "car" in a combo box from my main form...
  4. thefroggy

    compulsary information in text box

    Hi, I hope that someone can help me with this one. I have a form that people fill up to enter information on suppliers; two text boxes must be filled up with information, supplier name and phone number How can I introduce such obligation? I want to make it a bite smart, with pop up window...
  5. thefroggy

    Query/Table and SLQ link

    Hi, Hope that someone can help me. I currently have a list box with a Table/Query linked with “easy search” application based on SLQ programme, which is working nicely at the moment. Table/Query SELECT DISTINCT [Globaltlb].[ID] AS ID, [Globaltlb].[Product] AS Product WHERE...
  6. thefroggy

    How can I desactivate the "scroller" of the mouse?

    Hi Everyone, I have launched my database on Access 2000 a week ago, and someone noticed something unexpected. My database was developed to enter new materials on site. Everyone can have access to it and a “new record “ variable was used to avoid everyone to modify previous data’s, with...
  7. thefroggy

    txtSearchString display table condition

    Hi, I'm trying to run an SLQ with two conditions in a table form. The first condition is a normal txtSearchString application, but I would like to only display some of the d ata. the (simplified) code I'm currently using is the following: txtSearchString = Me!TxtX.Text strSQL = "SELECT...
  8. thefroggy

    auto calculate date

    I’m using access 2000, here is the prob I’ve got. I’m trying to create a field where a date will be automatically entered. My colleagues need to review the data every five years to check if not out dated. I’m using a =date() expression to set the date, and I’d like to create a field where 5...
  9. thefroggy

    printing report with last entered datas.

    Hi everyone, I'm a newby as Access user and not English, be cool on me ;-). I'm trying to do something quite easy but I can't get it work. I have a form that people will fill up, the form is linked to a table with ~500 different data already stored. I have a cmd button on my form, once all...
  10. thefroggy

    auto fill textbox in form from Cmdbutton

    Hi, Thanks in advance for the help. I'am a newby and I'm using access 2000. Here what I'm trying to do. The users will start with a form with 5 cmdbuttons options, which open the same form. I'm trying to write a code which allow me to autofill un textbox depending on the cmdbuttom chosen...
  11. thefroggy

    Limited space in combo box!!!

    Hi everyone, I'm using access 2000 and I'm currently creating a form to simplify current paper process. I have a form with several combo boxes where all of them are linked with SLQ query. When someone will introduce new material they have to report some safety issue regarding the material and...
  12. thefroggy

    how to create an option box in Access 2000

    Hi everyone, I'm a newby in Access, sorry if the question is a bite dump, and I'm not english so sorry if it is not really clear. I have been trying to create an option box (similar to the YES/NO one) with two different option to choice between two different path. I have manage to do something...
  13. thefroggy

    Need to create an option box in Access97

    Hi everyone, I'm not english and I'm a newby in Access, so I'll try to be as clear as possible. I'm trying to obtain a message box (Like the YES/NO one)but with two other options. The database I'm building start with a form with more or less 10 commande buttons. When people click on one of...

Part and Inventory Search

Back
Top