Search results for query: *

I have a nightly process that creates a file from accounts that reside in two different databases. There can be the occasion where an item is contained in both databases. First they are written to a table that is "indexed with no dupes". Wouldn't the same account from the second process be...

No, there wont be multiples on the same day.

I got it to work by doing MAX on the date and first on the comment. I think when it runs, it does the Max date first which places that record first in the result set, then the comment is first. Does that make sense. I will use the sub query method instead....looks cleaner. Thanks

I have a table that holds comments. There can be multiple comments for the account. They are dated. I want to query the table and get the latest comment -- I am using MAX on the date and LATEST on the comment....I have checked several records and I am getting the MAX date but sometimes not the...

I am trying to store a file in the attachment field with VBA. Does anyone have a sample code snipped that I can model after, I don't see any good examples on this site or others. Thx

I have an add record routine and I want to add a file (excel sheet) to an attachment field programmatically. Is there any sample code around...

I need to process an Outlook group mailbox. I easily get my own inbox, but I want the inbox of a group mailbox. Does anyone know how to do that. thanks...

I am building a routine to deal with attachments in a particular group mailbox. It works except its working in my inbox not the particular group mailbox... How would I code for the group mailbox. Set oOutlook = New Outlook.application Set oNs = oOutlook.GetNamespace("MAPI") Set oFldr =...

Looking at the attached Outlook table, there is a field has attachments...but how can I get to the attachment? It seems that it has to be stored someplace. Right?

I have an app that monitors a group email box. It is used to assign and track items being worked on.... this is a linked outlook Essentially items are added to a table based on the last received date. The manager assigns the items by double clicking the item in the listbox and filling in...

unfortunately i still get the error.

ok I will give it a try.

I was working on a textbox...I wanted to write some code in the On Keypress event when suddenly I got the hourglass and am now unable to get to any code. I get the message that Access encountered a problem and needs to close. I cant get past this. Any other tricks that I can do, I tried to...

I am linking to an Outlook mailbox. Specifically the inbox. Every 30 minutes a routine runs that loads the new emails into a table. I use this in two different outlook mailboxes...One mailbox has an INBOX but it has several sub folders....when the update routine runs it is failing with the...

it is a date/time field. Thanks for the response.

ok very interesting

Wierd happening. I have a date field in a query and a form with two text boxes for date from and date to that are parameters to the query. For instance, if I want all records for December up to today, I I have to add 1 to the end date or go 12/1/2009 and 12/22/2009 as the date params. I have...

One wrinkle here is that I use the value in a parameter query. So, I have something like [Forms]![frmTest]![txtAssigned_To] in the query grid...How would I pass the SQL from the <ALL>. Thanks for the help.

Thanks I'll give it a try..

How can I build in an "ALL" for a combo box. I want the users to be able to select "ALL", is there an example around....Thx