Search results

Samon, Whilst the below would need a lot of modification, is the logic the sort of thing your after? Dim rst As Recordset Dim dt As Date Dim intAmnt As Integer Dim db As Database Set db = CurrentDb Set rst = db.OpenRecordset(Qry Or Table, dbOpenDynaset) dt = Date 'choose a start date...

Do you want to update all the records for the year as apart form the one you are editing, they will all have the same start and end qty. I'd go more along the lines of picking up the last end amount (do you store this or calc it on the fly, in which case this won't work) when the input form...

Hi Pat, How do you convert an A2k db back to A97? The only way I've found is to import everything, so am interested in finding a short cut. Cheers,

Hi Merdok, Jsut a couple of point that come to mind from this. 1) Aviod spaces in field names , ie Client Name should be ClientName. This also applies to tables ie tblClientName 2) I dont know what you're storing in clients old, but you might be better keeping all data in clients and having...

Merdok, use my stuff as an example, but you need to apply the questions that AncientOne asks in order to build the structure. In my example, I have assumed that each client will only have one region, and that a region can be for many clients. Also, that a buyer will only have one region, but a...

Hi Merdok, The first thing that I would do, and it will help you later on, is to normalise your tables as per AncientOne's advice. You will probably end up with a client table (naming conventions such as tblClient etc will benefit you later on) Client Id client Name RegionID Then a Region...

Merdok, Not sure what your exact question is but it sounds like you need a form with a combo box. Have a not in list command (plenty of examples on here) on the box to allow you to add buyers etc. To delete a record, would advise having a button that picked up the record in the combo box and...

I expect it might be a problem wit the type of link that you have. In design view, right click on hte join and amend it from 1 to 2 or 3 as relevant. If you are unsure, set up a new query and use the unmatched query wizard. THis will step you through and should clarify things. HTH

Have a look at email from table list Also, have a searc has there are quite a few postings on this.

Try pasting this into the format of the control #,##0;(#,##0)[Red];;"Null" Set your own comma, decimal formats etc. The order is positive numbers, negative numbers, zeros and nulls. HTH

Have a look under DateDiff Will go something like datediff("d",date(),date2)

Try putting the following on the On_change for the control(s) you want to assess. Static intLetter As Integer intLetter = intLetter + 1 If intLetter = 2 Then ' Check to see how many letters have been entered. Me.tb2.SetFocus End If

Do you do your data entry through a form? If so (and if you don't you ought to) you should be able to populate the required field on the form with the previous records data

I'm afraid I've never done it but I'm sure I've read that there is a way to do this using briefcase. Have a search on here and in help under synchronize. Sorry not to be any more help.

FoFa, Many thanks for your help. I've just come out of the meeting (I love quickies) and the business have decided to only record their own deals on the system as otherwise there are so many ifs and buts that I'd have to build in. Back to a good old fashioned parent/child relationship...

It can indeed. I had originally modelled it with Agreements in the middle and the two other tables on the side; ie Everything would have an agreement and could have many of either/both of the other tables. Sadly, the business has changed their spec to require the option to have a trade and a...

yes you can

I am now not sure if I am approaching this issue in the correct way. I have 3 tables, Swaps, Loans and Agreements To model the relationships, each table has a many to many relationship with the next (have no problems setting up the intermediary tables) but is not required, so no referential...

How about importing it to a new table and then appending it into the required table?

Hi, I had my web developers put a link to your site on my links page (www.wtsltd.com) but they've used the access-programmers URL and the old logo, so not sure how much good it will do. Apologies (obviously a legitimate excuse to not pay them). I’ll get this amended when I next get some...