Search results

you could try requerying the list box on the onclick event of the Add record Button listboxname.Requery

The grouping and sorting have been set so that the Group header is Ascending, the Forename is also set to Ascending. The problem seems to occur when the data for the first group has two or more people to be printed. It always prints the first page with only one person and the second page with...

I have a report based on a qury. The query contains four field, pretty simple stuff and shows the correct data when run. However, my report is basically a letter going out to particular groups, the groups are in the query. Its only one page long. Each report lists one or more members...

Hi grnzbra I spent the last few hours working on the querydef process and after searching the net, finally worked out how to do it. Thanks for pointing me in the right direction.

Mmmm seems a little too complicated really. The sql of the query I am using is this SELECT * FROM tblMembers WHERE (((tblMembers.Complete1) Is Null)); Is there not a way that I can substitute the WHERE clause to change the field name from Complete1 to Complete2 etc using the textbox from...

Im not, basically 26 text boxes display the number of people that have to complete that particular module. see frmNoOfModules. Curently that data comes from tblCompleteModules, the query shows the number of people that need to complete a particular module. My client is still insiting on using...

Grnzbr There are 26 fields on the form, that is not a problem. I have used the doubleclick event to input the name of the field into an unbound textbox located on the form. How would I change the query def of the query. What code would I need to put into the query?

I have a form with several textboxes on it. If i double click on a textbox it sets the value of another textbox to what I have asked it to in code. This works fine. I need to use the value from the text box in a query to extract data. The value that is put into the textbox is a particular field...

i am slowly finishingthis training module database. My client already has a members form where he displays his non normalised data, this wroks well but not for what he requires now. He wants to keep the form as it is. I have now added a normalized table for MemberID, ModuleID and...

Thanks Pbaldy. Works a treat

OK, so i have finally got round to re-building my client's database as suggested several times by RV. I have three main tables that I need to extract data from - tblMembers, tblModules, tblCompleteModules. Basically its a database containing the training details of Scout Association leaders...

Thanks for your advice RV. Im more than happy to work with messy vba so if anyone has any idea, i'm more than willing to take them

Is the a way of changing the fields selected in a query by a form. I have a form showing how many people need to do each module. Each textbox is populuted by a count from the table. The idea is simply to avoid having 26 queries based on each module. Is there a way to have the field name...

Thanks RV. I am fully aware that if the DB had been set up properly I would only have need one query. However, the DB is an inherited one and not one that I have built. I am looking to produce a list of people who need to complete each module and not the number of people who need to complete...

I have a table containing among other things, dates where training modules have been completed. There are 26 modules to be completed and 180 users. Not everyone has completed all the modules. I am hoping to create a report showing what modules people need to complete. Any ideas how this can be...

Sorry for the delay in getting back to the forum. Have tried your solution and it works a treat. Many thanks for that

Hi Been taking abreak from Access for a few years now and cant get my head round my problem. I have been asked to manipulate data from a Training Recods database. Basically, training consists of 26 modules, there are currently 180 people who need training. Each person has been assigned a...

What sort of documents are you scanning? and what purpose is this for. It can be done im sure, but its a bit like re-inventing the wheel. There are far better software applications for the purpose of scanning document, storing the tif file and searching the database for a particular scanned...

Try this one, I have used this a few times. Its not perfect but will help you get started!

Hi all, not been here for a year or two, hence i have forgotton a lot of Access stuff. I have an unbound Data Entry form which when populated, adds the record to the table. Simple enough. I have some code on the form which basically stops the user entering a new record without having a First...