Search results

Hello Everyone, Been a while since I needed to post on this forum, but I found something rather disturbing today; either that or I have missed something obvious. I have a large query of financial data, and I filter out certain codes which I don't want to include. The filter is; <>"BL01" And...

Well no one here is dumb enough to be on the side of "Intelligent Design", so I'll try another one here. I reckon I'll have to fight this one myself though ;-) Not a question of which is better, although that's bound to crop up. The question is, can they co-exist? Or is one doomed to...

Pretty simple, as the title states. Is Intelligent Design scientific theory? Discuss.

Not as uncommon as you might think... http://mosnews.com/news/2006/01/16/brother.shtml

I am sure that everyone who wants a gmail account (or Googlemail as its now known in the UK) has one, but if there is anyone who wants an invite, just send me your email (in PM if you like, but the GMail spam filter is awesome, so I use my gmail address all over) and I will send you an invite...

I've created the following to act as an audit trail. All the values seem to be fine in the SQL; however, rather than writing the correct field name into the AllocationAuditField, I get the Value of the field. Can anyone spot where I've gone wrong? tblAllocationsAudit has AllocationsAuditID -...

Hello All, Is there an "Events Map" anywhere on the net anyone knows about? If not I think I will make a start on one today. By that I mean something like; Form Events: On Opening Form Open --> Load --> Resize --> Activate --> Current On Closing Form Unload --> Deactivate --> Close Of course...

After watching Space Cadets last night, it seems that the contestants have either been fooled or are at least conforming to groupthink. However there are many rumours around saying that the show is a double bluff; all the contestants are in the know, and the joke is really on the viewers. The...

Just going through a DB today and I was struck by an idea... I was writing code to check fields for data, and if they were empty I was prompting the user. Now I usually try to fill in the status bar text and control tip text with some like "Please select a month" or whatever. So, I came up with...

I have created a custom function in Access. I used the Class Module method as I wanted it to be accessible to Excel. I have this in a class module in access; Option Compare Database Public Property Get strFinancialYear() As String myDate = Date - 1 myYear = Year(myDate) - myYearModifier...

I am trying (unsuccessfully) to get Class Modules clear in my feeble brain. I've got plenty text books, I've read up on support.microsoft.com, googled and read all the forums I can find. The most useful thing I've found so far is the post here...

Hello Everyone, I've created a custom function to get a value for a query which feeds a DAP. The function is as follows (in a Standard Module, not a Class Module); Public Function IntDepDate(ByVal MinusDays As Integer) As Date ' Get the date for the interdepartmentals ' This is normally...

Hello, I have written some VBA which sends a report exported in RTF to a person I select from a combo box. When the 'EditMessage' property of SendObject is set to True, the email is inserted no problem and it will send fine. However, when the 'EditMessage' property is set to False, the email...

Hello Everyone, I am new here so please forgive any faux pas. I would like to create a module that exports a report in RTF format, renames it and then sends the report to a specified email. The problem I am having is that I want to send this exported report (it has a custom name depending on...