Search results

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...

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...

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...

I have been trying to do something, and I dont know if can be or not. I have a main form, FormA that has a unbound subform we'll call sfrmA. I also have sfrmB. I would like a command button to change sfrmA to sfrmB. I got this working having the command button on the main form (FormA). Is...

3 years ago I started on a access project. Throughout that time my dB has grown from 3 tables for one job to over 30 for multiple, because I saw the "power" of how I could track anything I wanted and built it to work for my business. I can honestly say that I think it's normilized to the best...

I hate to bring another Audit Trail question to the table, but I am scratching my head for thelast day trying to get to get this work. Link to original post: http://www.access-programmers.co.uk/forums/showthread.php?t=44231&highlight=audit+trail Problem: I have a main form/subform. The...

Add New record using a listbox/ Added Attachment I have a mainform where TaxID is used in a combo box to add new records. The problem is not all of my paperwork will have either a SSN or EIN on it to filter the combo. What I would like to do is use a searchform that has a listbox w/names and...

I am using the following code in a backend updater that's on roger's access library. Testing on two machines mine is running XP Home w/A2K3 and gets a error 3270. The other XP Pro w/A2K and works perfectly. I have verified that the DAO reference is 3.6 on both. Everything seems to update...

I have been developing a database to be sold for the last year and half. I knew from reading here and else where that I would eventually need to buy the developer extensions in order to create a stand-application. This is to allow the use of access runtime for people that do not have access on...

I have recently deployed an application at work [work pcs all running A2K2], built with A2K3 on home computer. I split the database housing the backend on our server, named server, and using frontends on users pcs. I am running a VB script that takes information from another linked db on...

Is it possible to open a new form within a form. Looks like a subform, but isnt there is no parent/child links.

By searching the forum I found a link to the attached sample database where you can explore the drive of the pc from access. I was wanting to use this (or some form of this) for a customer form I have for our archived files where PDFs are stored. What I was wanting is a text box on my form...

Hello, I have a VBScript that when clicked on opens the command prompt and fires code to upload a query to my website. What I would like to do is place a command button on my form that will call the script to run instead of having to go and click on it. I have searched, maybe using wrong...

I have googled and search for this subject and am more confused now... I am running an offline A03 db with XP and have a hosted website. Right now I have a separate db online that is used for the results on the website, and it works correctly. I used frontpage to create the form. Now with...

I am seeking advice on a database with currently over 40,000 records, which was pulled off the internet from NOAA for weather related records. The spreadsheet that they were using looks like this: GridNumber | Year | IntervalNumber | Index Value Each grid has history back to 1948 and each...

I am having trouble wraping my head around this am am seeking help (I have done a search and have made select box print labels and get the general idea) But this is a different format. I have 3 tables running through a query supplying info for the report. The report is filtered using a date...

Credit goes to FoFa for posting this code on this form. Attached you will find code to relink tables. I manage I am doing to wrong, and need help in order for it to execute correctly. I would appreciate direction. What I am doing: Copying the modules over to my unsplit database. Creating a...

I have searched the forums for an answer, either there is not one or I missed keyword somehow. I have a form (frmA) with a combo box to choose company (cboCompanyName). In this form there is a subform (frmA subform) ->Everything works great... Within the subform I have another combobox...

*EDIT* - Mod - sorry for multiple threads, internet froze up, as I was posting. I have a print dialog form with a combo box (cboCompanyName). When a choice is given (i.e Company 1) I would like Company 1's logo and mailing address to be visible, if the choice is Company 2 then Company 1's...