Search results

I'm not 100% sure some of what you're trying to accomplish. So, here's what I did. Your form "frmStaffReport" isn't bound to anything. I set the record source of the form to tblStaff and then bound the control for the Staff field to StaffID and the control for Start Date to DateEmployed. After...

Thanks for the clarification!

I am much less familiar with SQL than Galaxiom who obviously has a good grasp on it. I would have suggested: DatePart("yyyy",[FieldName])=DatePart("yyyy",Now()) Galaxiom notes that the SQL should be used for best performance. So, while mine will work, you may want to go with the SQL. :)

DatePart("yyyy",[FieldName])=2014

The tables need to be linked together in some sort of relationship and there would need to be something to tie the fields together correctly to apply the appropriate values from one table to the rows from the other table. I think posting an example of your current database setup would probably...

Thanks for the review, CJ_London. I totally understand the naming convention issue. I'm trying to modify a database built by someone else and I didn't want to tweak too many of the table and query names because there are a number of reports in the live database that all depend on the naming...

Nope. I was backwards. Your form is the one that has the checkbox. In the design view of your table, go to the lookup tab at the bottom and change the display control from Text Box to Check Box.

If I understand correctly, your table is working correctly by storing a checkbox value of checked vs. unchecked, but your form doesn't have the checkbox, but rather a text box showing True/False values. Is that an accurate statement? If so, you have the wrong control type. In the design view...

I found that part of the reason I couldn't edit the lender specifically was because it wasn't part of my SELECT statement. However, it appears as though you are correct. Even after I added the Lender field in, which is primarily what we were trying to edit, I still can't choose another lender if...

By their nature, checkboxes store values of 1 for checked and 0 for unchecked. Why would you need to store a null value?

Good afternoon, all. Need some assistance. I have a database with several one-to-many relationships and a nested subform based off of those relationships. Relationships are as follows: One Lender to Many Relationship IDs One Relationship ID to Many Tax IDs One Tax ID to Many DocumentsRequired...

Welcome! I'm relatively new as well, although, like you, a long-time user of all the information contained herein! Cheers!

Apologies on the delinquent reply. I think I have this resolved without needing the loop function at all, thanks to some of the information provided on this page that made me re-think the structure of this database. Most of what I know about Access is self-taught from reviewing existing...

The unique number string doesn't change once it's assigned. So, for instance, loan number 123456 is established today. It will be auto-assigned number string: 031314123456 All of the exceptions entered on this loan record will also contain that same string. User realizes they made a...

Apologies. I edited my second post to include additional information while you were replying. I'm not able to create a zip file at work. If you need to see that, maybe I'll be able to do it from home. Also, I can see I did not include enough information from the start, so hopefully I can clear...

Primarily because of fat-fingering errors. It's not often this happens, but I need something better than what I have happening now. Also, to answer your other question, the loan number is not the primary key in the table. Maybe I was too vague in my description, so let me add a bit more...

I've been searching for an answer to my specific problem, but I've finally conceded defeat and need some assistance (I'm still relatively new to VBA). I have a database that tracks exceptions for different loans. The loan record is in one table and the exceptions are in a different table because...

All - Thank you so much for your assistance. Mike, apparently I still have a way to go with learning about Recordsets. I attempted working with that function initially after your response and was having no success, but I will certainly do further research so I can use it effectively going...

Hello! Just following the instructions I received when I signed up today. I'm an Access lover - I like learning the complexities of how it works. I'm pretty good with most of the basic Access functions, but I'm pretty new to all things VBA. I would LOVE to know more than I do. Thinking...

I'm having some problems with VBA code I'm writing that references a subform. I'm pretty new to VBA and am not sure what the problem could be. The parent form (TrackingForm) tracks dates different tasks were completed. The subform (Child2) tracks exceptions that also need to be marked completed...