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

    process keeps running after .Quit method

    I'm working on an Access 2k3 database that sends calendar appointments to Outlook 2k3. At the moment, the database consists of only one table and one form. On the form is a command button that creates the appointment and sends it to Outlook. But even though I'm using the .Quit method to close...
  2. Eupher

    invoke Outlook menu item from code

    I'm working on an Access 2K3 database that writes calendar appointments to an e-mail/groupware app called Mirapoint. But I can't write directly to the Mirapoint server (long story, but bottom line, it's a web-based appliance with no API) - so I have to write the appointments to Outlook, then...
  3. Eupher

    find unmatched and append in one query?

    Ack! My SQL is weak... Two tables, TableA and TableB, identical structure. The help files for an append query say to first create a query that contains the records you want to append - in this case, a "find unmatched records" query (TableB contains records I want to append to TableA). My...
  4. Eupher

    Crosstab query subreport in report footer problem

    I have a report that lists items like so: Unit Name 1 Weekend ----------------------------------- Event Description 1 X Event Description 2 Event Description 3 X Unit Name 2 Weekend ----------------------------------- Event...
  5. Eupher

    test for object = nothing

    I'm trying to use an optional textbox object as an argument in a function but had some problems: Public Sub OpenCalendarDateOnly(FormObj As Form, DateBox As TextBox, Optional DateBox2 As TextBox) I got around them by declaring the argument as a Variant instead: Public Sub...
  6. Eupher

    dim vs. private?

    I feel like I should know this, but haven't pinned it down yet. Is there any functional difference between declaring a variable with a Private statement vs. a Dim statement? Looking at the help files, it appears the scope of each is the same. What am I missing? Thanks! Ken S.
  7. Eupher

    programmatically refer to label control

    I'm building a form that has a large number of label controls that have the same code in the OnClick and OnDblClick events. The generic form of the code is like this: Private Sub lbl1_Click() Call SomeFunction(Me!lbl1) End Sub I would like to not hard-code the control name in the function...
  8. Eupher

    windowtop & windowleft to position form

    Not being completely satisfied with the many ActiveX-less date picker solutions out there (though many are quite good), I decided to build my own. I'm setting it up so that when the user clicks a button the calendar pops up immediately beneath the associated date field, sorta like an ActiveX...
  9. Eupher

    OnDirty event not firing

    I'm working on a database that sends calendar appointments and notes to Groupwise. I'm trying to use the OnDirty event to set a flag which would pop a MsgBox to remind the user to send the event to the calendar if the data has changed. Everything works great except on one particular form -...
  10. Eupher

    deleted Network Places keep coming back

    I manage one little corner of our university network - about 30 workstations in one department. The environment is Active Directory, a mix of 2K and 2K3 servers. We use roaming user profiles and redirected My Documents, Application Data, and Desktop folders. I have a number of Network Places...
  11. Eupher

    assign ownership

    We've been gradually implementing roaming profiles and folder redirection in our Win2k3 AD domain. I initially had accepted the default "give users exclusive rights" in the My Documents folder redirection group policy, then changed it so Admins would have rights to the folders also. So we have...
  12. Eupher

    all users' My Documents folders = Administrator's Documents?

    I have several XP workstations with multiple user accounts. Right now they are in a workgroup, but we will soon be migrating to an Active Directory domain, with roaming profiles and folder redirection. In preparing for this transition, I've noticed that the My Documents folders under Documents...
  13. Eupher

    column data disappears

    Okay, just got a brand new computer on my desk at work, a 2.4 gHz Intel processor, an nVidia GeForce 5200 video card, a Philips flat panel LCD, etc. So now I'm getting some strange form behavior in my databases. If I open a form that contains a listbox, then open a table from the database...
  14. Eupher

    password protect 4050N connected via jetdirect?

    I just installed a 4050N on my office network. All the workstations that need to use it are configured just fine. But I'm concerned that other users and other departments that I DON'T want to have access could connect. Is there a way to password protect a JetDirect TCP/IP connected printer...
  15. Eupher

    sync to proxy OR import from proxy?

    I have a calendar resource in GW 6.5 (used as a master calendar) to which I've given read-only proxy access to everyone in my office. I'm dumping appointments into the calendar from an Access XP database. Works great so far. However, I want my users to be able to sync their PDAs to the master...
  16. Eupher

    early/late binding confusion

    I'm working on some code to send calendar items to Groupwise from my Access XP database. According to the Groupwise API, early binding is preferable in almost all cases. As nearly as I can tell, here's how the API says to declare a Groupwise application object using early binding: Dim...
  17. Eupher

    complex(?) sorting/grouping question

    I have report, based on a query, that displays a list of all people not available for work during a given time frame. The report lists the employee's name, the reason, and the time frame of their non-availability. The underlying query has 5 fields: [Name], [StartDate], [Description]...
  18. Eupher

    Odd VBE behavior, some properties lowercase

    I have a form with several fields which are disabled by default. Depending on the user's selection in a combo box, some of the forms are enabled in the combo's After Update event. Everything works, there's no problem. However, I noticed today that in the code window for the form that the...
  19. Eupher

    number the rows in a report

    I've gone brain dead. There must be an easy answer to this question, but it escapes me at the moment. How do I number the rows/records in the detail section of a report? The rows are just concatenated string values. In the output, I want it to appear as... 1. My string value #1 2. My...
  20. Eupher

    literal ampersand character

    What's the syntax for using a literal ampersand character in a string or in a command button caption? Thanks! Ken S.

Part and Inventory Search

Back
Top