Recent content by natesternberg

Thanks for the pointers! I didn't know about the ItemsSelected property. So now I have the code below, addressing #1 in your suggestions. I don't entirely understand your second suggestion, though. Do you mean, change my SQL query so that, rather than saying "WHERE F=A AND F=B", etc., I...

Thanks to everyone who replied! Yes, a volunteer can have multiple skills. This will sound dumb of me, but I didn't realize you could just write VBA to perform a SQL query when an update event is fired from one UI element, and in that event, add the query results to another element on the form...

I'm looking for some high-level guidance here. I have two tables, tblVolunteers and tblSkills. tblVolunteers contains a lookup column listing every skill for each volunteer. I'm writing a form that has a listbox with all skills; I want the user to highlight whatever skills she's interested...

You're right, placing the calculation in AfterUpdate worked. I didn't understand the mechanics of the form processing, which you clarified for me. Thanks very much for the assistance.

I have a form with a combo box whose row source is a query: SELECT [Lname]+", "+[tblVolunteers].[Fname] AS Name, tblVolunteers.ID FROM tblVolunteers WHERE (((tblVolunteers.Lname)<>"")) ORDER BY tblVolunteers.Lname; When you open the form, the combo starts out blank: the values are all...

Ah, that works for me too! And it updates correctly when I update records in the form. Thanks!

This is probably simple, but I seem to be stuck... I have a form that displays data like this (based on a query): Description VehicleType Cost F150 TRUCK $100 Miata CAR $80 Taurus CAR $70 VehicleType is a combo box, so the user can select one of...

Ack! Due to an error in the source data, some of my dates were coming up as 2009 when they should have been 2010, and I glossed over that when I was eyeballing the sort results. So Access was sorting like this (correctly): 1/1/2009 2/1/2009 1/2/2010 and my brain saw: 1/1/2010 2/1/2010...

Hi guys -- I imported a TSV into an Access table. One of the columns was dates, and I set the corresponding table column to "Date/Time." However, Access seems to be treating the column as a string. For instance, in a query, it sorts the column like: 1/1/2001, 2/1/2001, 1/2/2001, etc. So I...

Wow, that was fast. Thanks! It took me a sec to figure out how your example works, but I think I get it now. I've applied the idea to my database, and it now works! Just to summarize: 1) Set the combo's "control source" to be the workerID column in the tblVolunteer table 2) Make sure the ID...

Ok, I have a simple question. I have a database containing volunteers and the hours they worked. There's two tables: tblVolunteers: ID AutoNumber FName Text LName Text tblHours: workID AutoNumber workerID Number (foreign key) StartTime Date/Time EndTime Date/Time I want a...