Search results

I got this code for this web site. When I run it, I get User-defined type not defined. And objOutlook As Outlook.Application is highlighted. I am using Access 2003. Any help would be appreciated. Private Sub Command0_Click() On Error GoTo Add_Err DoCmd.RunCommand acCmdSaveRecord Dim...

I am trying to query a table that has two fields; Company and Date. The table is populated by companies we have audited and the date we did the audit. Companies get audited at least yearly and sometimes more often. So the table will have the same company listed many times with a different...

Okay, forgive me if this is a stupid question but sometimes the obvious escapes me… I want to use code to produce the same effect as when you right click on a text box (formatted as hyperlink) and select Edit Hyperlink. So that when a person left clicks on the field the Insert Hyperlink...

I have a small query. One of the fields is a date field. I wan this query to give me only dates that are older then 5 days ago from now. So in the Date criteria cell I put: <Now()-5 What I would like to do is exclude weekends. That is to say, <Now() – 5 working days. I have seen code on...

I have a query that I use to pull the dates from a table and then I set the Unique Value field to Yes to remove all the duplicate dates. So now I have a list of unique dates. What I would like to do is filter this list so that only the most current date is displayed. The most current date...

Although I have found (via the search function) several references to hyper-linking to a record, I have not found any answers to this question. Is there a way to reference a specific record in an Access database? I have an automated mailing system that alerts the appropriate persons of...

I have a table that contains a field type Date/Time. This field contains the Date and Time a record was submitted. I want to query this table for all records submitted after 3:00 PM regardless of the date. When I build a query, I enter >#3:00:00 PM# as the criteria. It returns every record...

I have a table with the following fields: Date Commodity Price Buyer Seller In the first record, the data looks like this: Date: 8/20/2003 Commodity: Banana Price: 1.1500 Buyer: Fred Seller In the second record, the data looks like this: Date: 8/20/2003 Commodity: Banana Price: 1.1500...

I am trying to open a form (and a specific record) in one database from another. Example: In database One, I want to click on a button on a form and open a specific form in database Two and filter for a record that corresponds to a field in the form in database One. That is to say, if I...