Search results

Thanks for the help Loolaa I managed to use this with a bit of other code (see below) to launch the report and bring up an option for the user to export to Word (and be able to chose where they save it and under what file name). Thanks again, Rusty :D Private Sub...

Hey guys, I have a btn on a form which runs the code below to output a report to rtf. Is there any way of specifying a folder I want the .rtf file saved in? At present it just sticks it in the same folder as the database. Also is there any way of using VBA to specify a file name for the .rtf...

This site deals with a controversial subject (don't worry it's 'work safe'). Now that the sun is out here in the UK these people are everywhere!! CLICK HERE Rusty :D

Cheers Rich. I never thought of doing it that way...talk about the answer being right under your nose (and a lot simpler than I thought it would be). Rusty

A woman walks into a pub and asks the barman for a double entendre….. ....so he gives her one!

A man boards an aeroplane and takes his seat. As he settles in, he glances up and sees one of the most beautiful woman he's ever laid eyes on boarding the plane. He soon realises she is heading straight towards his seat. A wave of anticipation and lust washes over him. Lo and behold, she takes...

Hello, I have a button on a form that launches a report. This report is based on a query that asks the user to enter the invoice number. I have used the code below, but I want to get it to do the following: If the user enters a number and there is no data attached I do NOT want the report to...

Hello, I have a form with a field called [email]. When it's double-clicked it launches GroupWise 6.5 (using the code below). Does anyone know how to code it so it will do this and create a new e-mail message using the address in the [email] field? Cheers, Rusty :D Private Sub...

Hello, I am working with an existing database and have a table with a field called "Year". However, the data in it is not in date format, it's just text. The year data is entered in the format of "1997/98" and "1998/99" and so on. Is there a way of changing the data type to Date/Time and...

I already have a validation rule for this field specified in the table as "Is Not Null". I need code for the other date event to specify <=Date() Rusty :(

Hello, I have a date field on a form and I don't want the user to be able to enter a date that's in the future, i.e. not after today. I have tried using the code below and want the field to be blanked out and a message box to appear telling them that they can't do that. Is it something like...

How to automatically fill a textbox Hey Jon, I've had this problem before, and managed to solve it by doing this: Ideally you want the Store Number field to be a combobox – simply click on Format; Change To; ComboBox. This combobox should have 2 columns - the store number first and the store...

Hello, I am trying to get a Command button to toggle the filter "on" and "off" on a form. I have done this by using: DoCmd.RunCommand acCmdToggleFilter How do I get this button to enable only if filter is on? I have tried several different things in the On Current event of the form, but...

Help me!!?? I have a form "frmCommercialTrials" with a field called "cboProjectRef", (the control source of which is [ProjectReference]. I have a button on this form and when I click on it I want it to open a form called "frmFundingDistribution" on the current record of the original form...

Cracked it!!! On the main form enter: Private Sub Form_Current() Me.[subfrmEventPayments]![cboEventDescID].Requery End Sub and just to be on the safe side… On the subform enter: Private Sub Form_GotFocus() Me.cboEventDescID.Requery End Sub Hope that helps other who may see this, Rusty :D

:confused: Help me!! I have a main form, " frmFundingDistribution ", with a combo box "cboProjectRef"; and a sub form "subfrmEventPayments " that has a combo box " cboEventDescID". I need the combo box on the subform to filter based upon combo box on the main form. Now I've tried putting...

Hello, I have a query and I know this is easy but it's Monday morning here and my brain is yet to kick in. I have a query with: [Name of Trial] [Status] I need to add up all patients in [Status] grouped by [Name of Trial] …easy enough I can do that, but I want another field that adds up...

Hello again people, I am trying to code a NotInList event for a combo box on a form. (The form is called "frmPROJECTS2" and the name of the combo box is "cboChiefID". When the user tries to enter a value that is not on the list I want a message box to come up as follows: "The name you have...

How do I get Access 2000 to fill an unbound text field [Activity Name] from values from the 2nd column in a combo box? [cboActivity area] I've tried setting the control source of the text field to: =[cboActivity area].column(2) as advised in a reference book, but when I click away from it it...

It's a subform :D