Search results

Hi I have inherited a massive excel spreadsheet which i have taken into access. one field called category, has text in it e.g. "Sussex; Shropshire; Promoter;". I have created three tick boxes called sussex and shropshire and promoter. I have been playing with an update query but havn't has...

Hi All I wondered if anyone has any experience in or can giveme pointers for my development. I have a dvd database with 500 dvd's, with 5-6 new ones coming in a week. Instead of typing in all the details I want to scan the barcode (have got this far - the barcode number gets put into the...

Hi Wayne Thanks very much for replying. Mixed success with using the dmax. The record is chooses to go to is the last in the database! when trying to find out why i put a watch on it, and on the Dim command the dtmbestdate= to last date in the database. any ideas? i have tried to play around...

Hi, I have an events database with 500 different events in it. I have built it from scratch but very slowly over the years. On a continuous form I have a GO TO TODAY button which goes to the record for today. If there is one. [datefield].SetFocus RunCommand acCmdSortAscending...

Thanks very much - I'll do some research. One of the downloads proved really interesting in showing me hows things work. great site. Ian

Have found enough info on the site to keep me going - searched on Fixture and found some good posts. thanks.

Hi All I have been reading up on access and have done a little programming though it was a while ago. I need to manage a small tennis league, 3 divisions, men women mixed, etc. When results come in from a tennis match i want to type them in and for the database to produce league tables. I...

i seem to get a compile error "method or datamember not found" and it highlights the name of the field promopaidreconciled - which is the checkbox name Me.Actual_Promoter_Fee.Enabled = Not (promopaidreconciled) Any ideas? Also given that my field does have spaces in can I not just put [ ]...

Hi Thanks very much for replying. 1. There are so many fields in the database with spaces in that I haven't dared change them all, as it will also affect reports and queries etc. I don't think that this is causeing my problem anyhow, as both fields have spaces in them, and one works and the...

hi hope someone can help! i have two currency fields "inc due" and "inc due less VAT". when another field (called "locked") is ticked I want to not enable these fileds so folk can see them but not change them. So I use this: If Me.locked = -1 Then [Inc Due].Enabled = False This works...