Search results

It's not good looking code I'm afraid. SORTED! I am an idiot, please accept my apologies for time spent.

Hi all, Strange one this. I've a simple module that does some calculations based on a record and when a field hits a certain value a date is added to the record and a new record created. If I simply run the code it loops through and once finished there's an extra record in the table. If I set...

Thanks Ken Just finished! Works fine, cheers...

All, I shall try and explain this problem in a far less vague way than the title suggests! 1 table with 3 fields. MemberNo/date/paid e.g. 4000,01/01/2004,True 4000,08/01/2004,True etc... What I'm trying to do is sort firstly by [MemberNo], then by [paid]. If ALL and ONLY ALL of a persons...

Got it folks! Many thanks for that. You've probably turned about 2 days of error prone querying into 3 hours or so of productive work. Kind regards indeed :)

Ah, now there's a thing. They are all identical in structure but the table names are not all of the same format as you mentioned. (Hindsight!)

Now don't laugh too loudly but I really do have an access database with 648 tables in it - all with identical structure and different table names (obviously) The story so far: I had 200 or so old xls files with multiple sheets and wanted to get these in to access. Had the code to get single...

Thanks guys, I should have gone in to more detail with respect to this being part of a much larger project. However! I'm in no position to argue and so will take your advice and try to accomplish at least this bit via the query route. Thank you again Grunners

Hi there, This can't be too difficult but it's taken me a day to realise that I'd just have to post. I have a table: ID (PK) member (Integer) Hours (Integer) eg: 1 - 200 - 12 2 - 201 - 24 3 - 202 - 26 4 - 202 - 2 I'd now like a table in the same format but with the rows where the member...

using: Private Sub Form_Load() Recordset.MoveLast Recordset.MoveFirst End Sub seems to work, however >>>Moving from one record to another is saving the current record if it was dirty<<< Something else I had overlooked. Any how, thank you very much indeed. I'll do it your way! Cheers...

Hi all, There is no doubt a very simple answer to this problem. This having been said I haven't a clue what it is! I have a form that shows invoice details for clients. Most of the form is populated using a dynaset and this works just fine. All the boxes etc on the form are filled in and the...

Thanks neileg! It worked a treat. String manipulation actually scares me... I'll have to practice more... Hmmmmph Best Regards Grunners :rolleyes:

Hiya all, I had this brilliant idea to cut down on the spam in our office - it works but if I don't put an 'allow' list in to our firewall I get all the spam by default! We have hundreds of trusted email addresses on a database. Thing is I don't want the whole email address - just the domain...

Cheers Pat I thought that I'd have to go down the query road. Think this was just me trying to make things a bit too flash! I have resolved the problem and I'll read up on what you said about putting calculated totals in a table. Thanks all - very much appreciated. Grunners :)

Thanks guys, For a fleeting moment there i thought i had it licked! I should have mentioned in my first post that i need to 'combine' the entries in to one as they then go in to a payroll system. A member can only be paid once in a week so if he has say 3 entries they all need to be added up...

Hi all, I have a table as follows: InvoiceID (PK) - Autonumber MemberNo - text AgencyName - text Hours1 - number Rate1 - currency Hours2 - number Rate2 - currency TotalHours - number GrossPay - currency The InvoiceID is the only unique field. This is because the Members may be input a number...

Hi all, I have searched for answers to this question in the forum but to no avail. It can't just be me can it?!? I have one large Access 2000 database stored on a server (W2k) and two types of client database consisting of various forms and linked tables. Everybody on the LAN has the employee...

MANY THANKS! I managed to work it out, must have been just before you posted. Useful though - i've learn't quite a bit today. I'll be using your code though as it's a lot more 'streamlined' than mine... :p

Hi there I've got to calculate the mileage expenses for guys driving X number of miles in a week. The code below I got from an earlier post allows me to set the cost per mile (here £0.40) and just put in the miles covered - it then calculates their expenses in the 'travelcost' box. (I've also...