Search results

Yes it is. In fact the entire purpose of this code is to requery the combo box row source when the form is opened FROM the ZooMobile Education Update Form. Yesterday that part of the code was working fine--the row source in a subform in the Update Form was being required, but the New...

I know this is kind of basic, but I don't know what you refer to as "call". What does that mean? I see a lot of instructions on how to do it--hell I may have done it myself without knowing the term--but I can't find a simple answer to "what does it mean when you call a code?". Are you...

Yeah, I know that acSaveNo doesn't negate saving record changes and to use Me.Dirty code instead. I can't remember why I included the acSaveNo at first. I did it for some reason and then forgot. I suppose I could remove it, lol. Please let me know if you have any other suggestions regarding...

Thank you for the suggestions. I have never used the With commands and I have no idea how they work or what they do. I did experiment and copy/paste your suggested code, replacing the DoCmd lines and that worked fine, just the same as the DoCmd technique. It didn't solve the close command...

I have a form that is meant to add a new facilitator to the FacilitatorTable. It can be opened directly from a menu page. However, sometimes it will be opened from a form that is used to link facilitators to events that they facilitate. The combo box's row source is based on a query that is...

Sneuberg, Your second suggestion worked perfectly. I had used "" originally because I've used that in the past to indicate an empty text field. I guess it doesn't work in this case, however. Thanks!

I have a continuous subform that just has one combo box as a control (named docentTxt). It is designed to select facilitators who have went on the given event (which is in the main form). Here is the current table/relationship structure: The Event Information table has Event_ID as the primary...

I think I got it! After reading more into subqueries, I started to get at least a basic understanding of what I'm dealing with and started playing around with code. This is what I created and it works: SELECT [Event Information].Event_ID FROM [Event Information] INNER JOIN FacilitationTable ON...

I tried using the code you suggested and it resulted in the following error message: "You have written a subquery that can return more than one field without using the EXISTS reserved word in the main query's FROM clause. Revise the SELECT statement of the subquery to request only one field."...

Thanks for the suggestion, but I'm not really following what you are getting at by using a *, or including a count function in the where statement. Maybe it would help if I posted a simple query with what I have: SELECT [Event Information].Event_ID FROM [Event Information] INNER JOIN...

I have an Event Information table with a key field Event_ID, a Facilitators table with a key field Facilitator_ID, and a Facilitation table that records which facilitators went on which events with the following fields: Facilitation_ID, Event_ID and Facilitator_ID. There's a One to Many...

I agree it is future proof, but not under my circumstances. We're a small non-profit zoo and this system is for just the education department. We don't even have an IT department; I am an environmental educator but I also know computers so I'm also the defacto IT guy. If we had a large...

I see your point about normalizing the table but there will never be more than 3 or 4 staff members using this system. If it was a large number of staff who would use it, I would agree with you, but in this case I think it's easier to just have one table. Less confusing and it's not difficult...

I'm thinking of having the path and image names as part of the staff table. Why bother separating the two when each signature is directly related to a staff member and wouldn't be associated with anything else?

Cool! I didn't know you could use pathways in Access fields like that. I'll look into that more when I have time. I'm assuming that this technique works with a shared server as well. My database is a split database with a front end and a back end. To clarify, the table would need three...

I'm using Access 2010.

From what I understand an OLE field would be able to hold a picture instead of text, correct? Can I use an image in an OLE field as the image in a report? Here's my situation: I have a report that we use to print an invoice that we send to clients. I want to include a scanned copy of a staff...

Perfect! Thanks!

I suppose not, but it seems the most direct option. The only places that the field is used is on certain forms. No queries or reports. Are you suggesting that I use a property for the relevant textboxes within the forms to force the "0" to be visible? Which property would I use?

I have a field to record the last 4 digits of a credit card number in regards to tracking payment information. The field is currently formatted as a Number field. When I try to enter a set of 4 numbers that start with "0" (e.g. 0123), Access removes the 0 from the start automatically (so 0123...