Search results

This is going to be an easy/dumb question for someone smarter than me to answer, I hope. I only work on Access occasionally, and I always forget what I've done before, and feel like I have to re-learn everything every time. I want to print some name badges for events. I have a table and...

Hi, I have a form that allows for data entry only. I'm a little concerned that some of the db users won't realise that if they enter information incorrectly, or navigate away from the form, that the information will be saved, and they can't then alter it. What I'd like to do, is have the...

I really hope someone can help me, because I feel like I'm going crazy! I have a button on my 'customer' form that opens a pop-up subform to input information into my 'invoices' (or 'orders') sub-table. I want the sub-form to be for new information only, so in the property sheet I set it to...

Hi all, I have a quick question, I'm going to make this sound more complicated than it is I think - I have a subform that, with the extremely kind help of members of this forum, I have managed to filter to show 'pending' invoices from my table. What I want to do is have a 'navigation form'...

I have an already existing database of 500 odd contacts, and I need to set up 2 competency/skills matrices that can be completed for them. For either matrix, there are 38 categories/skills, and there are 4 possible options that they can select (red, amber, green, and specialist). I'm new to...

Hi all, is it possible to create an action query that locks records? I have a subform that users will need to update, but I don't want them to be able to edit 'already processed' information. Ideally what I'd like to do, is have a control button that brings up a dialogue box requesting what...

Hi all, I'm hoping that this question will have a simple answer, I've searched the forum but can't find what I'm looking for (or maybe I have and don't know it). I have a subform from which I want to calculate values into a text box on the main form, to keep a running total of weeks for...

Apologies, I think this is one of those irritating newbie questions. I'm running a query from two related tables in the database I'm setting up, and it's not giving me the result I'm hoping for, and I'm a little concerned that it's not just the query but that my fundamental architecture might...

I apologise in advance for any poor forum etiquette or any general or specific database newbie dumbass-ery. I am involved in centrally managing a project , a part of which involves employees of certain companies being given a weekly subsidy for study on academic courses. Despite my...

Hi all, Typical newbie, I stumbled across Access recently, and I am in that terrifying/exhilarating early stage where I realise that Access can do SO many things I desperately need it to do, I'm just not sure how I make it do them! I have two projects at work (actually two and a half...