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

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

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

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

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

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

I have a query that I want to use for a report and also to load a listbox. This would depend on a value selected from a combo box. The combo box is on two distinct forms. How can i get the value from the form into the query as a parameter. I have an IIF form1!dropdown =...

I have an append query that runs as part of a nightly batch. How can I suppress the prompt that asks if I want to add the records to the table. The setwarnings don't seem to work anymore. Thanks

I am trying to get a DB2 pass thru query to work. I intend to pass two dates to a function and build a pass thru that utilizes the dates. However, how do I substitute the date values for the hard coded values in the following SQL.... thanks ... the following code works until I start playing...

I am trying to get a pass thru query to work. Eventually I intend to pass two dates to a function and build a pass thru that utilizes the dates. However, how do I substitute the date values for the hard coded values in the following SQL.... thanks ... the following code works until I start...

We have been faxing a list to a vendor, this has to change, and I must create a file that is encrypted. How do I encrypt a file. Thx

I have a pass-thru query that contains a field that contains a dollar value. The pass-thru is row source for a list box. How can I make the dollar value format like a currency (db2 sql)?

I have a database which has links to back end DB2 tables that are used to do queries. Over time this db has become large due to tables being imported etc....is there a way to look at the table sizes so I can delete the largest ones...

I would like to create an index programmatically I added 1 fields to a table using the following code... CurrentDb.Execute "ALTER TABLE" [Accts] Add Column Test Text" How can I change an existing field to have an index.

How can I set an app so that the ribbon is always hidden...I dont want the users playing with anything.... I don't want them to get into edit mode.