Search results for query: *

I use access to add appointments to outlook. I have constructed a working hyperlink to google maps for the location of the appointment. I have added Body = "<a href=" & stGoogMap & "> Google Map</a>" when I display the appointment, it just gives me text, not a hyperlink. However if I use the...

I have data in a table like the following fldClass fldPerson fldJob Class1 John Lights Class1 Sue Camera Class1 Jack Sound Class2 Fred Lights Class2 Amy Camera Class2 Arnold Sound Class3 Henry Lights Class3 Todd Camera Class3 Sally Sound What I wnat is something of...

I know I can hide and show the preview (Reading Pane) pane with the following code application.ActiveExplorer.ShowPane olPreview, true but I cannot figure out how to move it to the right or bottom. anyone know?

The following line works Set rst = db.OpenRecordset("visitorreportrecipients", , dbSeeChanges) the following line gives me an error stating that I need to use the dbSeeChanges option for a table on SQL server that has an identity. Set rst = db.OpenRecordset("select * from...

When I assign a category to a new email send and to someone, their reply does not have the category. Is this by design? Do user-defined fields stay or get stripped? If they stay, could I make a workaround with a VBA macro that copies the categories over to a user defined field before send...

I get an error when running the following code in outlook 2003. When I comment out the .OnAction line all works as intended. With it in, I get runtime error 438. object doesn;t support this property or method. Can someone help me with this one? Public Sub EnumButtons() Dim i As Integer Dim...

I have a batch file that is scheduled to run each day. it opens and Access database and print out some reports. I really want to learn how to do this in a vbs file. Everything I find in searching seems much more complex than what I need. Can someone point in the write direction? Maybe a little...

I have a database file, database.gdb, that when I look at it with a text editor has lines like the following. RDB$RELATIONS? RDB$VIEW_BLR? Ç RDB$FIELDS? RDB$DIMENSIONS I need to identify the format and hope to get an ODBC driver or some way to get it into microsoft access or excel. can...

I have searched andjust cannot find the info I need. I want click a button and have access move/resize to a certian part of the screen. I tried the movesize command, but that only works for forms. Does anyone know how to do this? thanks in advance.

I have 2 tables FAMILIES FamilyID, Mom, Dad CHILDREN FamilyID, FirstName, Birthday I have a query on the children table that selects children under age 11 qry_Kids_Under_11 returns the following columns FamilyID, FirstName, Birthday I want to list the families that have kids under age 11 so...

I have an rtf file created by using the docmd.output method and I want to send it as the body and not as an attachement. Is there a way to do this?

I have a table called tbl_sales with fields saledate, department, amount, etc I want a query that will show me results something like the following Department Sales_YTD Sales_LastYearTD Sales_MTD Sales_LastYearMTD Sales_ThisWeek Sales_Today Dept1 $100 $100...

my win2k3 domain is company.local and I installed live communications server which had my add a forward dns zone company.com now, my internal machines cannot reach www.company.com nor mail.company.com, both of which are isp hosted. Is there a dns entry or route that will fix my problem?

I am setting up an offline backup server with identical hardware as the primary. I want be able to mirror the disk to removable disk weekly and use it the offline server in case of catastrophic failure. I prefer not to spend the $800 on Symantec LiveState Server and Ghost 9.0 will not install...

Can I install a fresh copy of xp, then browse the network for my asr.bkf file and double click on it and restore it? Will this give me a complete restore hte same as using the boot floppy and setup cd?

I need to write a batch or script to do something like the following. I can do it in Access, but I need a .bat or .vbs file that I can just copy over to a vpn client machine. Thanks in advance for your help. dim i dim strCustomer, strSourcePath, strDestDrive, strDestPath strCustomer = Input...

I call a macro from and access mdb file form a batch file. The macro runs various code that emails reports to my people. I want the program to automatically exit when done and close access. However, every method I have tried from the macro and vba returns an error. Can I do this successfully? I...

Is there a way to track when a users edits/moves an appointment on his calendar in ex2k?

I have a few users who I want have only read/create access for their calendars and not allow editing of appointments put on by scheduling agents. I know I can do this if I make them use a public folder calendar, but can I do it with their personal mailbox calendar on ex2k?

How can I give a few users permission to restart the spooler service. I have it restart at night and sometimes it does not start back up and I have to manually do it but I am often away.