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: *

  1. Rustaferd

    Help Desk database

    Paul, Thanks for the explanation. The more I work through these problems...the more I am understanding how the software works and with your kind and generous help I have gained a lot! I did create a new macro and put only that code which is what I need and pointed to the new test macro and...
  2. Rustaferd

    Date in field on control button click

    This is interesting. Is it possible to do the same thing, but instead of a command button, could this date stamp be done by selecting from a combobox? If in the combobox I had the option of Closed, Opened, ReOpened, whichever is selected, a date stamp would be entered into that field? I can...
  3. Rustaferd

    Populate 3 text boxes with a 3 column combo box.

    I have a database with a form called Main. In the Main form there is a status field (combobox). In the status field are 3 selections - Open, Closed, ReOpened. Also in the Main form there are 3 text fields: Opened, Closed, ReOpened What I would like to do is select Open or Closed or ReOpened...
  4. Rustaferd

    Control Button

    This sounds like a great idea! If anyone figures this out, I'd like to know the answer as well. Russ
  5. Rustaferd

    Help Desk database

    I checked and couldn't find this in the status properties. It may be an issue with the macro, but not sure. SetCallDateOpened IsNull([CallDateOpened]) SetValue ... Requery ... SetValue SetCallDateClosedReopened ([CallStatusID]=2)...
  6. Rustaferd

    Help Desk database

    Paul, Just so I understand, when you say go to the Form module, are you talking about selecting the Form Object where all the forms reside? If so, are you suggesting I open each form and look for fields that may have EditCaller_Click? I don't suppose Access has any type of search tool? I...
  7. Rustaferd

    Help Desk database

    When I enter a new record, the Opened Date is populated with the current date. But if I select Closed from the Status list I get this message: Ambiguous name detected: EditCaller_Click There is no EditCaller_Click that I can find. In the Status properties I have a link pointing to the macro...
  8. Rustaferd

    Help Desk database

    Paul, Thanks for your response. I will see if I can put together some screen grabs and post it up on my website. A picture speaks more... I'll let you know when this is ready. Thanks,
  9. Rustaferd

    Help Desk database

    I have made some progress with my HelpDesk database. However, I have noticed when testing the Open, Closed, ReOpen Dates do not work when I select the Status. In my Main Form I have a Status field with Open, Closed, ReOpen - when I make a selection the date fields should change, but they do...
  10. Rustaferd

    help with understanding a small piece of code

    ...- the subform is suppose to display the data for whichever caller was selected from the list, but this doesn't occur. The subform disappears...of course because I've been playing with teh above sql code other things are not working... It is indeed a learning process *whew* Thanks for your...
  11. Rustaferd

    help with understanding a small piece of code

    Zemp, Thanks so much for helping me understand a little better about sql. I know very little but am trying to learn,thus the reason for pulling some code and disecting it. The one thing I forgot to mention was there there is also no company type. So would the above sql statement be written...
  12. Rustaferd

    help with understanding a small piece of code

    I am working on a database issue and need to resolve this piece of code. Can you or anyone else understand what is happening here? I need to take out certian parts, but if I do, I get syntax errors. How can I remove anything to do with Facility, or department? I don't need these,but the code...
  13. Rustaferd

    Help Desk database

    Visual Basic for Application Microsoft Access 9.0 Object Library Microsoft ActiveX Data Objects 2.1 Library That is all, Talk again on Monday. Thanks, Russ
  14. Rustaferd

    Help Desk database

    Okay - I am still working on this Help Desk Access database. The problem I am running into is when I am creating a command button. This button when selected is suppose to open the person form so that I can add a new caller. Name - Command247 Caption - A Status Bar Text - Add a Company...
  15. Rustaferd

    Help Desk database

    I am continuing to work on this Access Database and have found a road block with the Visual Basic Modules I want to create. I know nothing about Visual Basic with Access. When I select New (to create a new module), I can enter my text for the code I want to create, but when I select save it...
  16. Rustaferd

    Help Desk database

    Will do.
  17. Rustaferd

    Help Desk database

    Paul, You are absolutely correct. I figured this out late friday. Thanks for your help and feedback. Russ
  18. Rustaferd

    Help Desk database

    I've listed links to my form in Design Mode and some errors I get when entering Last Name or selecting from list. I've listed what my goal form should look like and what I currently have. Anyidea about the error messages? http://home.comcast.net/~rustaferd/wsb/index.html
  19. Rustaferd

    Help Desk database

    Thanks Paul, as you can see I am a newbie at this, but enjoying the challenge. Your help is much appreciated! Russ Have a great new year!
  20. Rustaferd

    Help Desk database

    Paul, My website has some additional images to help you better understand my issue. http://home.comcast.net/~rustaferd/wsb/index.html When I open the Main Form I now get this message: Enter Parameter Value valPerson.Person.Name (see image). Some of the changes I made was to add a...

Part and Inventory Search

Back
Top