Search results

It took a little bit of faffing around, but that did work, thank you very much!

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...

I'm still having problems with this - I have managed to set the form so pushing a button opens a filtered subform that shows 'complete' invoices that relate to that account (and is read only), which is exactly what I want, and another form that opens up for new or 'pending' invoices for data...

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'...

Thank you very much, that is a great suggestion, but, um, how do I do that? (sorry, I am very new to this). Do I need to make an append query that creates a new table of 'complete' records?

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...

Thank you very much for your help, I added a field to the sub-table that designates the record as either 'pending' or 'complete', I created an update query with a parameter value that, I was quite surprised and gratified to realise, works exactly the way I intended it to. My next challenge is...

Thanks very much for the response, that’s a brilliant idea! Is there a way of automating that for many records in the sub-table, without using VBA (or even using VBA)? The ‘invoices’ in my database (they aren’t actually invoices, but the principle applies) will relate to hundreds of records in...

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...

Hmmm, that doesn't work either, if I use an expression to DSum just one of the fields (as attached) I still get a message saying 'expression has a function containing the wrong number of arguments'. If I try and type it 'manually', Access tells me I have invalid syntax. I thought it might even...

Thanks very much for responses, a hidden sum on the sub-form might be a great solution if I can make it work. Screengrabs of relationship (the mainform is the 'Apprentices' table and the subform is the 'Line Claim' table, I'm looking to sum 'NoOfYr1Weeks' and 'NoOfYr2Weeks' on the main form)...

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...

Q: What's Whitney Houston's favourite type of co-ordination? A: Haaaannnnnd eyyyeeeeee………...

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...

Thank you very much for the reply, I'm sorry my lingo was wrong - I did mean that the table could only grow vertically - 'horizontally' it would be 53 columns (the field names being Student ID, then Week 1, Week 2, Week 3….Week 52), then against each student ID the data checker would input a...

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...