Recent content by batwings

Galaxiom Sorry I misunderstood you, many thanks I will give it a try

Galaxiom I have already tried using a combo box on my form for the 5 options and then passed the Option Names to a text box on my report with the following: =Forms!MyForm!MyCombo.Column(0) And this works well. I'm just rying to do the same but using an option group and 5 buttons instead of...

Hi there, I need some help with referencing controls, I have a Report with a textbox that I am using to show which Option has been selected from an Option Group on a form. The only way I have been able to do what I need is using a hidden text box with the following code...

Thanks for all of the help and suggestions but I'm not sure if they can get me what I am really after...or maybe I just do not fully understand! or didn't explain well enough. Basically I need to find each group that has the same string and find out how many rows are in each group, if I have...

Hi there I have a form and subform with one to many records derived from 2 tables and I'm using this as a source to populate Formfields on a Word document. I am using a VBA script I found and altered linked to a button on my form. Problem is only the records from the Main form window are...

Galaxiom many Thanks for your help You are of course correct my examples were flawed from the start and should have looked like this:- A-B1-1-330-01 would end up like A-B1-1-330-01-001 A-B1-1-330-01 would end up like A-B1-1-330-01-002 A-B1-1-330-01 would end up like A-B1-1-330-01-003...

Hi there I have searched and searched but to no avail, My question is can I use DMax() to add a Sequential Number to the end of groups of Strings. My Field is Datatype String The data looks as below I would like to add -001 -002 -003... to each Group A-B1-1-330-01 would end up like...

Thanks for the suggestions, I have found a way to get what I needed. I just created a query expression EC: Resp([Responsibility]) and then in a module I created a function using the Select Case as follows Function Resp(Responsible As String) As String Select Case True Case...

namliam You dont, if you have information like this that needs to be "translated", this is a perfect sample, you make a "lookup" table ! Not a function... OK all I'm trying to do is use the numeric data from the [Responsibility] field (which originally comes from a lookup table) and create...

Can anyone please tell me how I can place a select case statement in a module and create a function and call it from an expr: field query expression in a select query? I have a select query with an existing field [Responsibility] and I want to use that field to populate another field that will...

Namliam Sounds great but how? The field in my Excel linked spreadsheet is named "Date_Complete" and contains Dates in the form of Text. Example '01/07/2009 for entries with a completed date and just ' in all of the blank excel cells that do not have a date. How do I write an update query...

namlia Thanks again, I've just found out my problem is also compounded by the linked excel spreadsheet. It has hidden apostrophies in it, all tags are pre-fixed with ' but the update query does seem to work for all fields that originally had data regardless off the hidden apostrophies. Do you...

namliam that is my problem I did not think it was possible, how would I do that? In the meantime I will try ajetrumpet's solution thanks to you both.

Hi there, I have an update query that will not update fields that were previously blank. Is it possible to populate these blank fields in the query grid criteria field to "-" and then run my update query?

I meant to say that the attached view of my form is used for filtering a report! The 1st and 2nd options you suggessted return no record at all for "Open" and only the closed records for "Closed" and "All" The 3rd option crashes with a syntax error on "All"