Search results for query: *

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...

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...

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...

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...

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...

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.

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...

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...

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 -...

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...

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...

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...

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...

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...

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...

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...

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]...

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...

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...

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