Recent content by g28dman

arnelgp, Thank you for your reply. Sadly though I have no real working knowledge of VBA. I can sometimes piece things together to get what I am looking for but this isn't the case here. I will see what I can do. Thanks again for the help.

I currently have records in a table (tblMPCIPolicyDetail) that need to be updated every year. I have a field called CropYear that I need to change from 2015 to 2016 while still keeping the 2015 records. When trying to add these new records I get an error that multi value fields can not be...

pr2- I think this is what I am looking for as well, but wanted to ask a couple questions... I have an unbound form (like RAWDATA) with a combobox that queries for counties. Once I choose the county I would like for the county image to appear. tblCounty CountyID-PK StateID CountyName Is it...

Bada-Bing / Bada-Boom, there she is!! I wanted to add a Close Me on pop-up but it kept closing the main form, so I made a seperate close button which enables once code is ran. Thanks alot for your continued help.

The popup contains a form generated from all counties and includes a tickbox that filters only those counties that they want to work with. I would like once a user selects a new county to add to their personal filter, the combo box on the main form is to be requeried to include the added...

I still do not understand I already have all the counties entered, the user shouldnt need to edit the description that they entered. I am saying if the county name was incorrectly entered on the mainform or new county was being added the pop up box shows a listing of counties by state which...

Not quite sure I follow you on this. Say a user doesnt spell a county name correctly in county selection, the edit button on the on the pop-up is used to correct it? Why would a user need to check the correct county spelling, then edit(if need be) when it's already there? 2) I can get what...

Well, I am having a harder time with this and it'll probably be some simple fix, that if I kept going I could have figured out. This is a stripped Db, frmMain chose county..Not in list open nice little wizard to add. But can't 1) Remove what I had initially typed (say wrong spelling) and get...

Thanks - I'll see what I can come up with.

I modified it to reflect what I am trying to do.

I understand not giving users the ability to add more states or counties and I have them all in the system. To clarify, maybe Not In List was the correct terminology I should have used. For example I have a user on the East coast that does business in just one county in one state - I wanted to...

That was my original thought...But I came across several counties where the name was duplicated in another state, and I need additional data to fall in under the crop table that is unique for that county/crop. Yes multiple states and counties can be chosen. They state option would only be used...

Need a little direction on this. I have three tables as such: tblState StateID [PK] StateAbb StateName Select (Y or N) tblCounty CountyID [PK] StateID [FK] CountyCode CountyName (Y or N) Select (Y or N) tblCrop CropID [PK] CountyID [FK] CropCode CropName There are over 3000 counties in the...

2 questions: 1. Is it possible to export an unbound form field value to a field on an existing PDF file? 2. If the PDF locations are stored into a table and brought using a query...Is it possible to print those queried PDFs from access form? I have searched for some type of answer to these...

If you study form 2 (the reference of the combo box) of Larson's example I think you will find what you are looking for.