Search results

Need some help badly! Have been struggling with trying to resolve this issue for awhile with various solutions. The code is a mix of someone else's and mine. Essentially the form is like a document library, based on the parameters in the form, it takes the original document that is selected by...

Hello! Have been struggling trying to find an answer on why an update query isn't working when trying to update an multivalued field. In this table, there are 647 records and only 9 of which already have a value set in the "AssociatedProject" field. More than one AssociatedProject is associated...

Have a form that contains fields AssociatedProject, AssociatedRelease and then the user hits a button to create a new record and a new form opens to display this newly created record which sets the fields and also sets a field called Type. There is no issue with setting the field values and the...

Solved: Checking for a filtered duplicate value on a form before closing Below is some code that I'm struggling with and I get an error message "Type Mismatch". Have tried several different ways but had other issues, so I'm posting to see if anyone can help. Perhaps I'm missing something or...

Looking for coding help (and perhaps an example) that would help solve the following. Any help is greatly appreciated. The user will be creating a new project that contains a bunch of releases. The releases have standard names which are stored in a table tbl_ReleaseNames It should be noted that...

I have never seen this error before nor can I recreate it on my computer. We currently use Access 2007. Basically, I have forms that when the user finishes entering information, another form will open and then close the current one. It's pretty simple, but on one users computer it's causing...

Have a generic dashboard report with multiple charts in it. One in particular is a bar chart, but depending on what the dashboard is produced for, the bar chart may have too many bars in it to make it legible. Therefore I'd like to conditionally determine the number of bars (basically the number...

Have a database with a back end that I have been working on. The database resides on a USB at the moment. I was ready to deploy and now when I try to re-link the back end tables, I repeatedly have the following error: "Your network was interrupted. To continue, close the database, and then open...

Have one form that contains values AssociatedProject and AssociatedRelease that need to be passed onto another form that opens with a new record. Have tried different variations based on what I read here and couldn't get them to work. Here's what I have at the moment and any help would be...

I have several different sub-forms that have a button that opens a new form which creates a new record. Each of the different sub-forms have a field value that needs to be passed to the new record when the other form is opened. I've tried a few solutions, but to no avail. Right now I'm using the...

In my database, the user can select certain fields to search the records. Everything works fine, except the list is not sorted. I've tried placing the sort within the associated query, but this causes an error when I try to run it. How do I sort the results of the requery? I should note, that...

Have a database that produces documents for public distribution, and the use of memo fields are extensively used. Most of the time we can get buy using the standard rich text that is provided with MS Access, but I'm trying to find a solution to include a table that is produced in MS Word and...

Currently creating an MS Access database that will reside on a shared drive, and looking for a simple solution that will control access to 2 different forms based on the userid. I could use the user's windows login or create a unique userid and password that is managed by the database. I'm...

This forum is incredibly useful! Particularly for individuals who are not experts in MS Access or programming. Any assistance would be GREATLY appreciated! Have another problem with a training scheduling database, with the auto generation of emails to participants. They use MS Office 2003...

Have developed a database for our training team to manage their training schedules. The one course schedule form (see attached), enables the user to add a course schedule, and then the associated participants. The main form is linked to a table called "tbl_schedule" and the sub-form is...

Have a database built in MS Access 2000/2003, and utilized Lebans RTF2 Active Control (http://www.lebans.com/richtext.htm) which I found reference to in dozens of sites, which enables doing rich text and graphics within a memo field. It works wonderfully, and solves a great deal of problems. Two...

We have a need to display a date field which is stored in English, to be displayed in long date format but in French. It's only necessary for the report, so I don't want to make a global change, only temporary for when the user produces the report. I have done some research, but all I can find...

Have found some code that originated from this forum, and have modified it to suit my needs. There's one form with all the information, that has multiple buttons and subsequently multiple functions to generate emails, with each button/email to generate a different format and content. The first...