Search results

Thanks Guys, Managed to get it working by using numbers rather than lookup, so - [Install]*7 + [SC] + [SCCB] Slight problem that the fields had to have a number or it wouldn't work, so made the default 0. Thank for your help :)

Hey, I should have said. I mean a Calculated column in the same table. So the Calculated column would be - [install] *7 + [SC] *1 + [SCCB]*1 Am i going about this all wrong?

Thank you. How about if i just used numbers in one table? =Sum([RA] [Install] * 7) , ([RA] [SC] * 1) , ([RA] [SCCB] * 1) Could do that in a Calculated field?

Please help. I come from an Excel background so am probably doing this wrong, however . . . I have a Table [RA], in the table i have a fields [Install], [SC], [SCCB] This is in date order and totals what an engineer has accomplished each day. for example [Install] 1, [SC] 6, [SCCB] 2 I have...

Hi Plog, Good call, but for me Week 52 is the end of December, so if there is a week 53, the company would always be closed for Christmas/New Year. For anyone else trying something siomilar, I managed to get the dsum working by using the following...

Hmmm, I ran into a slight problem. Because the financial year is 1 April, it starts in week 14. So if i Dsum <= week 8 (i.e. end Feb) it only shows me figures from this year, not last years (week 14-52) I created a table [WeekNos] for weeks 1 to 52 and a second column with week commencing...

Excellent !!! thank you, now working perfectly :)

Yes, SC and Week in the table RA are numerical I want to add the SC (in RA table) where the Week (in RA table) is less that the form [combo6] box on a form.

this is probably a basic questions but i've been struggling for hours. I have a table RA in this table i have columns - VisitDate, Week (week number) and SC (services done) In a Form i have a subform and use a drop down menu ([combo6]) using the Week. i.e. Week 26 lists the SC's done that...

Solved it :) Button on my form which opens another form [HNumber] in [HNumber] I have a Combobox with the following macro -Search for form -Form -Heatersmaster -First -="[ACCOUNT] = " & Str(Nz([Screen].[ActiveControl],0)) Close Window Sweet ;)

Thanks theDBguy & Gasman. I am looking at a ComboBox which does do the job, just need to make it 'pretty' on my form. I will also investigate the SearchFor Record, but this is a new one for me. I think the answer (as always) is for me to learn VBA! Thank guys, you have been a great help.

I have one main form [Heatermaster]. All I want is to be able to jump to a selected record without users having to go to a tiny Record box at the bottom of the form. I thought text box may be the answer, but there may be a better way. I'm surprised this isn't a standard feature in Access (2010)

Thanks theDBguy. I tried the OpenForm path but it filtered my database. So record say 164 of 3000 became record 1 of 1

Please help. I have set a button to open a form [HNumber] with a text box - [Text8] I want to type a record number [Account] in this box and make my form [Heatersmaster] go directly to that record. (unfiltered) I have a Macro GoToRecord; Form Heatersmaster Go To...

Thanks Minty, I know it's not good to reuse enquiry numbers and have tried to get this amended., but unfortunately met resistance. Before my method below of keeping the data it was simply deleted, so at least we're moving forward. :)

Can anyone help? I have a Customer Table with up to 999 customer enquires on it. When an enquiry is 'dead' I have an append query that moves the 'enquiry number' from the Customer Table to a Dead Quotes table. This is actioned by a macro button which refreshes the form, runs the append...

Minty, You are an Access Wizard !! Hugh thanks to you.

Option Compare Database Private Sub Mobile_GotFocus() Mobile.SelStart = 0 Mobile.SelLength = Len(Me.Mobile) End Sub Private Sub Mobile_Click() If Len(Me.Mobile & "") > 0 Then Mobile.SelStart = 0 Mobile.SelLength = Len(Me.Mobile) DoCmd.RunCommand acCmdCopy End If End Sub...

Minty, I'm using your code which works great. As well as Telephone, I have a Mobile field in the same subform. Is it possible to do the same function (copy to MS clipboard) for Mobile? I have tried the following which works, but when I change the record I get "runtime error 94 invalid use of...

Minty, Worked perfectly !!! You are a star, thank you. Arnelgp. I didn't try your suggestion as Minty's worked great. Thank you for your suggestion though.