Recent content by sho ryu ken

Man, I've finally nailed it. It was the 'oncurrent' thing that I was overlooking (I always wondered how to run instructions when you change record). Thanks very much JRJR for your time and patience.

I ran that example and have messed about with it and understood it thoroughly, thanks, but it has exactly the same problem as I have: All these options, visible, locked, etc. ... they affect every record throughout the whole table/form. e.g. If I lock field2 of record 1, then field2 of record...

what I mean is, say I lock (or disable) the customer surname on record 2 to stop employees screwing it up, then it will lock the surname field in every record for the whole database.

thanks jr jr... maybe theres something I missed, but this system locks the fields throughout the whole table. I need to lock fields in specific records :confused:

ok, thanks, good idea. Do you know how to make it so only the admin can view the check box?

Hello, I have just spent ages doing searches and reading everything I can on locking. But, I have yet to find an answer as to how I can lock a specific field in a specific record. e.g. Staff enter customer details, then at the end of the day the admin (me) checks it over and presses a big old...

man, I'm THICK.... I just figured it out, never mind!

Hi, can someone tell me if there is a way to save several different datasheet views? I have a large database with many fields. I use forms for data entry, but to view the data I use the table datasheet (so I can see multiple records at a glance). But every time I have to manually move...

Scotty too hotty, you are a man among men.

Thanks scotty, I have bound column to 1 (which I believe is appropriate). I wonder if anyone could have a quick look at it for me :( (this is a simplified version) http://www.sdkjewellers.co.uk/temp.mdb

Hello, thanks. I have most of it working now, but when I hit the button I get a blank report, I think it's my query criteria which is wrong? [forms]![form1]![cmb1] I have that as the critera (form1 is the name of my form, cmb1 is the name of the combo box where they select the report number)...

Hi, I have set up my form so that there is a print button, looking a little like this : http://www.sdkjewellers.co.uk/printreport.JPG But how do I get it so the print button prints the report for only the currently selected record? Code for the print button is simply: Private Sub...

Guys, ignore that last question. I only just realised that reports are automatically updated when you enter more info into the database! :eek: So one more question, how to I tell it to print the current entry of the report and not the whole thing?

Hello, thanks very much, I just tried that and it works. That leaves just one issue : I need to automatically generate the two report labels based on the information the staff member types in at the time. i.e. customer comes into the shop, staff member takes details, then presses a button on...

Hello, this is my first post here. I am a novice to Access. I hope someone can help me. I have created a database for my business. It contains customer info (name address etc) as well as jewellery repair info (what the item is and what needs to be fixed). It is all entered into the same...