Search results

Doesn't seem to work. Would it be because YourCheckBoxNameHere is a combo box?

I have a form with a subform that displays equipment inventory and loan details. On the main form I have a yes/no combo box indicating if the item is on loan. The subform has a loan date and return date. How can I make it automatically change to yes if the latest detail in the subform has a...

And a copy for me too please: thomas@coleraine.org

Excellent Mark! Thanks very much.

I keep track of church members' weekly giving using a works database and I want to use access but I'm having trouble with sorting the structure. I have one table holding personal details but I'm not sure how to set the giving table. tb_main - name, address etc. tb_offerings - envelope no...

When you get the compile error select DEBUG I think. It should highlight the code that's faulty. Delete it and try again.

This is the way I do it though there may be a better way. Create the button by dropping it from the toolbox. In the button properties event tab click the builder beside on click (...) and choose macro builder. Name the macro and in ACTION navigate to and select open report (or query or...

I have a query with the following sql: SELECT QY_ALL.TB_STAFF_STAFF_ID, QY_ALL.LNAME, QY_ALL.FNAME, QY_ALL.JOB_TITLE, QY_ALL.BASE, QY_ALL.DEPT_WARD, QY_ALL.STATUS, QY_ALL.COURSES_DONE_ID, QY_ALL.COURSE, QY_ALL.START_DATE, QY_ALL.END_DATE FROM QY_ALL WHERE (((QY_ALL.DEPT_WARD)=[Enter Dept/Ward])...

I did use the wizard. Where would I see the counts?

If you put a couple of text boxes in your report header you can show dates retrieved. I use in the control source and Max for the other. Possibly there's a better way but it works OK.

I am trying to count certain records in a report. The detail section shows staff members and details of training done for each one. I want to count number of staff in each group (usually sorted by dept or job title) but only get count of training done.

Figured it out. I hadn't included the primary key.

I've just noticed that it does the same for same last name but differing first names e.g. john smith, fred smith.

I have a report based on a query that is grouped by job title and ordered by surname/name in a staff training database. Problem is if there are 3 john smiths it shows one only but correctly lists training for 3. What have I done wrong? Thanks.

Hello. Is it possible to create a database that will print id cards? I currently use an "off the shelf" piece of software to track and issue plastic id cards. The software was quite expensive initially and over the years, as my pc/os changed it wouldn't work under w2000 so I am using it on a...

I just used the wizard. Drop a command button on to the form and choose print record. It prints the current record as seen on the form though, not from a report.

OK, so how do I do that? Each staff member has a list of training done and I want to look at each record and tell which courses are due an update.

I have a form with 2 date fields, one contains the date a course was attended and the other (onclick) inserts a date 1 or 2 years ahead to show when an update is due. I have just added this second date field and was wondering if it is possible to run the code for existing entries rather than...

Is there any way to keep track of a database structure in access? For instance, which query relates to which report? Sometimes I create queries that are no longer needed but if there are a lot (which there are!) it can be easy to delete one that's needed.

I posted recently about resolving a many to many relationship and wazz kindly did a sample database for me. My current database tracks staff training and has: tb_staff linked to tb_courses_done 1:n and also linked to tb_course 1:n. Wazz suggested tb_staff, tb_staff_course, tb_course_date and...