Search results for query: *

MajP, can you give me the names or locations of the utilities you referenced?

I had that working, but I wanted a concise name rather than a long url.

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 am sorry for not explaining this up front. But also, some Persons have more than 1 Job as well. Here is the work around I did. I started with your first crosstab but modified the data in my table such that I have Jobs like Lights1 Lights2 Camera1 Camera2 Camera3 This works. Thanks for your help.

that almost did what I needed. The problem is that many times more than 1 Person are assigned the same Job. It only chooses the first record in Person. I need it to return all of them. I may need a nested query or something.

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?

that did the trick thank you.

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

mintjulep, I am aware of that. What I meant was that the message itself no longer has the category I set on the original email when someone replies to me...whether the category was user defined or master.

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

awesome. Thank You!

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

Got myself. I just added a www and a mail A record. Before when I added them, I added the entire www.company.com as the A record and it was trying www.company.com.company.com