Search results

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.

Are you converting to 07 first before running the packaging wizard or can you package an 03 db and use the 07 runtime? Thanks -

I might be corrected here, but I think you need A2K7 in order to package your db up.

Attached please find my updated version of this calendar posted on AWF. I needed to put into a mainform - so the calendar is a subform. Searched for an answer and couldn't find exactly what I was looking for (i did see where another member posted the question), so here it is. I think I got all...

Thanks Peter I was making it out to be harder than it was, and was confusing myself along the way.

I don't think you can, if I remember correctly. But I could be wrong, age is taking a toll on my mind.