Search results

D'oh! :o Thanks ;)

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

Thanks. Just what i needed. :)

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

Just noticed that the code was wrong. It didn’t show up in my report because I had data dated as follows: 2/5/2004 2/4/2004 2/2/2004 And when I ran the report it showed me 2/2/2004 and older. 2/2/2004 was more then 5 business days ago so I thought the module was correct. Only after you...

Okay, thanks. It worked. Problem is, I have no idea how it worked. You have a module as follows: Public Function GetDate() As Date Select Case Day(DateAdd("w", -5, Date)) Case Is = 1 GetDate = Date - 7 Case Is = 6 GetDate = Date - 6 Case Else GetDate = Date - 5 End Select End Function I...

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

Found a post by BLeslie88 where he suggested using: Select Top 1… And I was just coming back here to post that I found the answer. Thanks Mile.

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

Of course it’s right in front of my face… :rolleyes: I was afraid that there was no way to call a record from a hyperlink. Thanks

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 figured out what the problem is (was). There were a couple of records in the database that didn’t have any dates. Therefore, when I used the new field you suggested TimeValue([MyField]) there were a couple of records that would contain “Error”. So subsequent filtering would generate a data...

That worked, thanks. But there is a different problem now: When I try a filter the data such as by entering >#3:00:00 PM#, I get the following error: Data Type Mismatch In Criteria Expression Any ideas?

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

If I may continue a line of thought… Currently I have a field in a report that has this as the Control Source: =IIf([Control_Source_A]<>"","Show some text,"") I want to look to see if Control_Source_B has some text. If Control_Source_B has text, then use the above code, if it doesn’t have...

Yes, I did that. Thanks again for the help. ;)

Thanks to Neil, I think I got this figured out. What I did was create 4 queries. The first query contains all the fields of the table plus a NEW field that is formatted like this: Expr1: [DATE] & [number] & [COMMODITY] & [PRICE] & [FIRM] & [VOLUME] & [FIRM 2] It’s concatenates the critical...

Thank you Neil. I will give this a go. :)

Thanks. Yeah, I know this is ugly. It’s not my company that is providing this data. It’s an outside source that, unfortunately, we have little or no control over. Thanks for trying anyway.