Search results

I'm sure this is really easy - the database I am writing is for sales enquires with an anticipated completion date (month), but I also need to show which year. I would then want to concatenate these two fields and be able to produce a report that would list by date in ascending order. Can...

I have a databse which tracks a franchisee recruitment process, with something like 12 stages in the process. At each stage the date is recorded and (sometimes) a text comment. I want to produce a report that shows how many potential delegates we have at each stage of the process. How do I do...

I have created an invoice. There may be several lines on an invoice. Each line item generates a log number in the underlying table, but obviously I want only one invoice number and I want Access to generate that number consecutively. I feel this should be (relatively) simple, yet I just...

Well, I've been playing about this for ages, and I think I have finally cracked it. It seems to be working as I want. I've learned quite a bit from this little episode, so thank you all very much

This isn't working! I have done as you suggested, but this allows me to make an update to one record, but then will not allow me to create a new record (presumably because it is locked after an update). There must surely be a way??

I still don't have this quite right. Attached is screen shot of the code I have put in After Update. It has locked the field as I wanted (ClientID) but when I try to enter a new record, I get a message that Access can't find the macro. The ClientID is entered, but it doesn't automatically...

I'm probably going to make myself sound dumb, but I assume I have to replace myTextBox with the field name; but what is represented by Me? I would appreciate your help.

I have a form which, once certain data is entered, should not change, I therefore want to be able to lock these fields (one of which is the primary key) in order to prevent the user changing in error. If I set the Locked text box property to Yes, it does not allow me to enter a new record. If...

DateAdd Excellent! It worked. So simple when you know how eh? Many thanks.

I am producing a form where I want ot use the DateAdd function to calculate a maturity date for a mortgaged property. I have the fields Term and StartDate in the table, where the Term is the number of years of the mortgage and is therefore variable. I am entering...

I think my problem is similar to that posted by southernbell, so here it is (again?) I have a series of forms which are accessed via command buttons on a customer data entry form. I want to be able to carry forward a file reference from the (primary) customer data entry to the linked form. I...

I have a database that is being used for sales orders. A form is used to enter customer info, then a subform for order lines, which has a product number, description, qty and unit price. Am I right in thinking that a discounted prices needs to be calculated in a query, another calculation then...

As I understand it, you can put unbound check boxes in forms. I want to add a number of check boxes to a form (which incidentally, is accessed via a command button from another form). These are merely for the user to indicated that a project is completed. As there are a number of projects I...