Search results for query: *

Thanks that is the function I need to use.

I am having trouble converting a simple expression in excel to access. The formula in excel is =(LEFT(J25,FIND("|",J25)-1)) in access do you know what the equivalent FIND function is? Thanks Greg

Cheers phv, very clever, it works perfectly.

Does anyone know if it is possible to create a random sample from a query in access? I need 4 samples from a table that will change each month. Any help would be great Thanks

Okay I have figured it out needed speech marks around the "Yes" to make it work. However still don't know how to output to word with out losing the formatting the code has changed. Any ideas? Thanks

lameid: your answer dosen't seem to work the report runs but none of the formatting changes to Italics. I have used the same code with Me![ToChange].ForeColor = vbRed which changes the correct figures to red. dhookom: I am using 97. Yes to both of your other questions. The code works for when...

How do I use the vb code in a report to change a text box to italic based on what's in the text box I have tried the code below. But it dosen't change the Font to Italics Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) If Me![ToChange] <= -200000 And Me![ccycheck] = "GBP"...

How do I use the vb code in a report to change a text box to italic based on what's in the text box I have tried the code below. But it dosen't change the Font to Italics Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) If Me![ToChange] <= -200000 And Me![ccycheck] = "GBP"...

I have a make table query. I would like the user to be given an option to call the table what they like when the query is run. Is this possible without having to change the table name via the query each time? Thanks

Rob thanks for trying to help imagine if you will I have a list box with 3 selections available here is the simplified macro attached (with your extra bits of code) Sub ModifyS() Static oldchoice As String Replace = Application.InputBox(&quot;Warning you will replace the data entered...

These ideas will not work as the way a macro runs on a list box is it only activates when you have changed the selection.

List Box Macro I have a list box that has a macro attached to it so that when a selection is made from the list box the macro runs. However one of the options I have is when the selection is changed the user is asked if they are sure they want to change to the new selection. If they input Yes...

Rudy & Bob thank you both. The two methods do work perfectly although I think Rudy's is slighty faster thanks for your efforts.

I create my queries in design mode. I am not flash using sql. How would I go about merging two tables &quot;T1&quot; and &quot;T2&quot; to create a table called &quot;Combined&quot; as set out below. T1 claim amt1 1 10 2 20 3 30 T2 claim amt2 2 15 5 25 7...

I create my queries in design mode. I am not flash using sql. How would I go about displaying one record for each claim and then one other field for each table so basically T1 claim amt1 1 10 2 20 3 30 T2 claim amt2 2 15 5 25 7 35 Combined (what I want)...

I am using access 97 and I have two tables T1 & T2 I am joining these using a claim number field. In the join property I can select claims from T1 that match T2 or all claim in T1 plus matched one from T2 or all from T2 and matched from T1. Ideally I want all claims from both tables (but zero...

Thanks very much

I am using Access 97 and it dosen't regonise the function formatDateTime

I have a field in Access which is formated as Date/Time I would like to make a field from this that is formated Just date &quot;dd/mm/yyyy&quot; is there an easy fomula in access for this? Thanks very much

That works fine, And such a simple answer. Thanks.