Recent content by jarra_mackem

Select tblOne.Value1 as [01 - Total outstanding], tblOne.Value1 as [02 - Total at take on], tblOne.Value1 as [03 - Total payments] From tblOne; Changes to Select tblOne.Value1 as [1-Total outstanding], tblOne.Value1 as [2-Total at take on], tblOne.Value1 as [3-Total payments] From tblOne...

I have built an SQL query which sums up various totals and that's working just fine. As this output links to an outside system it requires the fields to be named exactly as they are in the other system Using the AS functionality I have 01 - Total outstanding 02 - Total at take on 03 - Total...

I have created a database which is used for risk assessments, What im hoping to accomplish is the auto-opening of a pre-set mail merge document, And either merge the results straight to the printer or leave the file open so the user can specify a save point. Basically i dont want any...

Basically im builidng a databse which needs to produce a report which may incmlude pictures. Im looking for code and or any tips for selecting a file, i dont want to open it or attach it, i simply want the pathway so i can then get the correct picture into the report Any help greatly appreciated

hmmm there will be a way around it. I will have access to more of my files tomorrow and can keep you updated if i find what your looking for I beleive i set a string variable to equal the active control name strCallingControl = activecontrol.name you do this on whatever triggers your requery...

The thing is when you refresh Access loses the information it held, howver i think this may work, without access to my other databases Private Sub Premium_AfterUpdate() Dim recordnum As Integer recordnum = Me.CurrentRecord DoCmd.OpenQuery "AddPremSumQRY", acViewNormal, acEdit DoCmd.Close...

For some reason my computer wont let me open the mdb after ive downloaded it? Anyone else had this problem??

Sorry i didnt have time to put syntax in. The Mrs was shouting for me so had to be brief. Glad you got it sorted

I think i have a fix, but to be honest its bit messy Basically creating blank boxes based on the number of charcters allowed in each box. Filling it with one character and enough carriage returns to pad it out to the correct height

I think i had something similair I used the solution of storing my current record number (me.recordcount) in either integer or even in a control. Then here i would put Forms![CaseOverview]![AddPremSumQRY subform].Form.Requery Forms![CaseOverview]![AddPremSumQRY subform]![PolicySubTable...

So you are wanting to get back to the second record in your subform? or indeed wherever you were?

Unfortunatley ive never use the draw line method before and cant really find any helpful examples. Do you have any idea where i could find some?

Sorry should have said that you can set the focus to any box you want. You could also set the focus to any control

YourFieldName.setfocus should do it

Yeah i want them to dynamically grow. Like you say im not sure if this is possible. I have had the line at the bottom and the top but would like to split each of them into columns as well