Search results for query: *

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

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

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

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

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

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

I have the following code. To open a specfic file in excel from Access. Dim stAppName As String stAppName = &quot;Excel.exe T:\GlobalRisks\MI\Clientmi\600 Group\600Grp_Latest_Report.xls&quot; Call Shell(stAppName, 1) It works fine as long as there is no spaces in the folder names. So...

I have a table called &quot;Data&quot; there are fields in &quot;Data&quot; called &quot;Client&quot; and &quot;Result&quot; I want to return a value into the field called &quot;Result&quot; based on what the &quot;Client&quot; field holds it is easy enough to do with a query but what is the VBA...