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 strongm 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. 3699wat

    deleting record opens new one

    As far as I know those codes are standard with a delete record command button. Removing one of these lines just disable the delete action. Any other suggestions
  2. 3699wat

    deleting record opens new one

    I am trying to help out someone with a problem The person has a form with a listbox. Clicking on an option in the listbox opens a second form with info on that item. The second form has a delete button to allow user to delete that same record and requery the list. Everything goes fine but for...
  3. 3699wat

    Pop up calendar

    I would like to stay away from using the ActiveX Calendar control in my applications. Does anyone have a calendar form that can be opened with a button on the main form and than populates a textbox on the main form after clicking on a date on the calendar form. I did found a sample somewhere but...
  4. 3699wat

    Powerpoint slide disappeared

    When opening my powerpoint presentation I found out that all my slides were gone, except 5 that have an unknown content. One slide only has [shell] in it and another one [IE]. Any idea what went wrong????
  5. 3699wat

    Package and Deployment Wizard

    I am intrigued about your question myself and see what could be done with VB6. I did not want to copy your post without your consent. I suggest to post this on another site of this forum Visual Basic (Microsoft): Version 5 & 6 Maybe they have an answer to your question.
  6. 3699wat

    stop form from opening if listbox empty

    Need help with the code on the on click event of a command button on formA to stop formB from opening if the listbox on formB is empty
  7. 3699wat

    Code to look for empty fields

    I am using the following code to set a label to invisible if the textbox is empty. It works great for each textbox / label on the report, but the problem is that I have to set it for each one. If Me.Textbox = “ “ or IsNull (Me.Textbox) Then Me.Label.Visible = False Else Me.Label.Visible = True...
  8. 3699wat

    Need help with code to hide label

    Steve The code works fine and I don't mind setting it for each field. What I'm also looking for is for the next textbox to move into the space of the previous empty one. I did set the properties to Can Shrink and Can Grow, but it doesn't work. Any suggestions Marcel
  9. 3699wat

    MS Access can't start

    Hi Maerts Yes that problem can be solved, but I have a question first. Did you do the step by step or install the AcLicn97.exe file. Only the second will help, but I'm think I remember (it's been a long time ago) you need to install a second file. I have those on my home PC and look them up...
  10. 3699wat

    Open new form with new record for option picked from other form

    You did understand the problem allright. Here's are the specifics you asked for. Both forms are full screen. Form B is opened by using a command button on form A after selecting a person in the listbox. As already explained it is supposed to open with a new record for the person choosen and the...
  11. 3699wat

    Need help with code to hide label

    I usually do not post the same problem at multiple sites, but I am desperate for help. I am looking for the code that will set all labels in the section of one report to not visible when the corresponding fields are empty. The report is bound to a query populated by a form. Each form receives...
  12. 3699wat

    Pulling records between today and 1 year from today.

    Try this Set up a query and use the following criteria Between [now()] and [now()-365]
  13. 3699wat

    Hide empty fields on report

    Ken I tried your code, but get a runtime error 424 - Object required. Any ideas? Do I need to declare anything? Marcel
  14. 3699wat

    Hide empty fields on report

    I have a report with multiple fields (textboxes and corresponding labels). They are all lined up horizontally one under the other. The form is bound to a table populated through a form. Not all fields will be populated on that form for each record. I would like to set a procedure on the OnOpen...
  15. 3699wat

    Open new form with new record for option picked from other form

    I kinda posted this earlier but I’m still stuck. Form A has listbox and button. I chose a name on the listbox and click on the command button to open a new form (filter is NameID). Like to open this new form with a new record for that name and with the name already displayed. This form is bound...
  16. 3699wat

    Open form with empty fields

    Have a form with a listbox. Clicking on an option in the listbox populates the fields related to that person on the form. How do I set the property of a form so it opens with all fields empty, but still shows the options in the listbox and allowing me to call the appropriate record. If I set the...
  17. 3699wat

    What about those stars

    I can't find out how this "star thing" works, but like to give some to those that are helpful. Hint please!!
  18. 3699wat

    Open form with empty fields

    Have a form with a listbox. Clicking on an option in the listbox populates the fields related to that person on the form. How do I set the property of a form so it opens with all fields empty, but still shows the options in the listbox and allowing me to call the appropriate record. If I set...
  19. 3699wat

    Highlighted option in Listbox on form

    Have a form with a textbox and listbox. The textbox has an on key function to search for a corresponding item (sorted alphabetically) in the listbox. When the textbox is empty, the first item is highlighted. When I key in a choice in the textbox the search scrolls down as expected, but the...
  20. 3699wat

    Update list on form

    Sorry But were exactly do you put that code?

Part and Inventory Search

Back
Top