Search results

I am creating a database to hold information pertaining to research articles. Ultimately I want to create a search form to find the article I want by certain categories. Now to the point ... I have 2 tables. 1 is a referential table of keywords, the other is the main table, holding the...

I have a form to enter information of people training in a gym for invoiceing purposes. A number of groups receive a percentage discount. However, I need the figures rounded to the nearest penny. I thought I had it, but when the totals are calculated, the rounded value is not reflected e.g...

I want to create an unbound text box control that has a default value of the last date of the current month. Does anyone know the formatting for this?

Is it possible to get your report to be automatically produced as a Word document for e-mailing to another individual who does not have access?

I was being an ass! I just realised that if I made the customer an athlete as well then it solved all the problems. Talk about making life difficult for yourself (and others - sorry!) Thanks for the help and patience :D :D :rolleyes:

never thought of doing it that way. The decision as to who is charged depends on the booking. The gym is used either as a group booking (Customer charged), or athletes come in on their own, which means that they are sometimes liable for certain elements of the charge - confusing and overly...

yes it makes sense. But the as I do not always want the charge reflected on an athlete, I kinda need the extra CustomerID - I think! i.e. the information may look like this: Day 1 Group 1 charged £20 Day 2 Athlete 2 charged £40 As such there would be no athlete information in Day 1 to get...

I have a report that lists the charges to one of two fields - customer or athlete. Therefore, one or other field in any given row in the dataset will be blank I want the list to be continuous as this is to be sent as an invoice. If I place the customer field on top of the athlete field on the...

I have a report with three subreports. It's a happy camp, except that I want to display a grand total in the main report based on the sub totals in each report. Not a problem normally, however, there will be numerous occasions where one or more of the sub reports will be blank and as such, the...

I am using a query to build a report, but can't get it to select the records I want!! In the query I have 3 tables: tblCustomers tblAthletes tblSessionDetails tblCustomers has a 1-many relationship with tblAthletes on a CustomerID field tblAthletes has a 1-many relationship with...

Tim Got it together - it's all working great now. Thanks a million

Hmmm, still not working. I've combed through everything in your example and mine. They're identical - yours works, mine doesn't. don't quite understand it. Anyhoo, in testing the two, I did notice that your example only updates one record at a time. I need to be able to update many records...

OK, I've done what you said, but am getting a run-time error '3114': Syntax error in UPDATE statement and when I go to debug it opens up on the line DoCmd.RunSQL strSQL Any ideas??

An example would be great - I don't understand Rich's example; which fields/tables are referred to where. I'm lost in the world of computer talk!!!!

I've posted this one a couple of times, but have yet to get it answered!! I'm trying to run an update query with an on_click event in a form. I've got the query running alright - that's not a big problem - but I want the query to only update records I select in a multi-select list box. As I'm...

Ok I've got the update query working - sort've!!! It updates all the records in the underlying table, not just the ones I've highlighted in the listbox. I've just added the DoCmd.OpenQuery line onto the end of the code that operates the selection of reports to print from the listbox..... is...

complete frustration I just can't get this to work. I've tried the RunSQL method, the RunMacro method, the Update method, and a method from a book I got working in ADO. I'm sure this is something I'm doing wrong, but I just can't see what. All I want to do is update selected records from no...

hope someone can help - I've been trying to get this to work for a while with no success. I have a listbox bound to a query. I then have a command button that prints reports from the records selected in the list box. All this works fine. The problem is that I need to update one of the fields...

I've got this to work now - thanks - but I now have another issue. Well, issue or two!! 1. Is it possible to insert some code that will print all the records in the listbox? 2. Can you update a yes/no field contained in the underlying table on which the form is built, based on the records...

Thanks Pat. I'll just have to find another way round the problem.