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 TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by Callreluctance

  1. Callreluctance

    Automatic send mail from outlook

    I asked a similiar question. The answer I received was to have the Exchange manager change my permissions in the Exchange Security Manager. My exchange guy gave me a funny look, and said "I'll have to talk to the big boss about that" and of course, it won't be done. So I am anxious...
  2. Callreluctance

    Using Form As User/Password Validation?

    Thanks, that did it.
  3. Callreluctance

    Using Form As User/Password Validation?

    How do you hide the database window?
  4. Callreluctance

    If Record Source is Null then what??

    I set up a query to do a basic sort. It uses "or" statements for 3 fields: LastName, Company, ProjDev. I then use a button to instigate the query and search, and set my recordsource=ContactsQuery2 (the query). Works great when there is data in the Query. When the query cannot find...
  5. Callreluctance

    Any way to covert a form to Data Access Page in Access 2000

    That is a possibility. My understanding is that it is hard to run multiple users on a database, but that using DAPs and an intranet it will work. Any help would be great!
  6. Callreluctance

    Any way to covert a form to Data Access Page in Access 2000

    This is a very powerful (free) tool. If you like the way your form is laid out, it will copy it over to a Data Access Page. You then have to rewrite your code for buttons, actions, etc, into VBScript. But still, it will save a lot of time
  7. Callreluctance

    Set Filter in Calling Form....HELP!!!

    Not exactly what I am trying to do. I want to make this very user friendly. The users who are working with the forms will have no concept of Access, in fact a right click might be stretching it. I need buttons, and buttons that would not normally appear in access, as I will be disabling most...
  8. Callreluctance

    Set Filter in Calling Form....HELP!!!

    I am really having a devil of a time finding a FAQ or post that will set a filter on the current record to restrict it to a set of records that match a criteria. I want the user to be able to type in text to basically search or limit the records to that text, ie LastName, Company, or SalesID...
  9. Callreluctance

    How to pass a filter to a form that I am opening with Cmd Button

    No, I still get the same problem. I then moved the Open Command to the end, and added the StrFilter to the command like this. I now get a type mismatch message. I thought it might be the lookupfield versus a text with ProjectDev, but I commended it out, and I still get a type mismatch...
  10. Callreluctance

    How to pass a filter to a form that I am opening with Cmd Button

    I wrote up some code to pass a filter onto a form that I am opening. Basically I want the user to be able to specify in one or all of three text boxes (LastName, Company, and ProjDev) requirements or a letter to start with from a form (MainPage), and restrict the form they are opening...
  11. Callreluctance

    Any way to covert a form to Data Access Page in Access 2000

    Wow, that looks powerfull. I will check it out this evening. Thanks.
  12. Callreluctance

    Data Access Page - Filter Function

    How about if I wanted to restrict the records viewable in the Data Access Page to a certain field, ie CompanyName.
  13. Callreluctance

    Any way to covert a form to Data Access Page in Access 2000

    I am trying to create an intranet accessible database. I have created the database in Access using forms, but now need to publish them to the web (everyone in the office has Office 2k, but not Access). Other than learning VBScript and creating Data Access Pages from scap, can I use what I have...
  14. Callreluctance

    Import Outlook contacts into Access

    I am still working on this process, but if anyone else is interested the Contacts sample database from MS Access, has scipt within it to download the contacts from Outlook. I haven't tried it yet, but it shows you how to link the field so you can populate the existing table directly from Outlook.
  15. Callreluctance

    How to set a property of a subform from the main form

    I apologize for the use of a name you don't have (to my knowledge). At one time I was responding to two posts in rapid succession, and both you and the responder to my other posts, handle started with S, and the other poster signed it Sharon, my brain did not do the switch. My apologies, and...

Part and Inventory Search

Back
Top