Forms :: Multiple Instances Where Inactive Names Should Not Show On List

Mar 22, 2013

We have a form that will have one combo box for Associates (like Employee in the OPs DB) which I've got set to show only active Associates for new entry per the tips in the above thread, but we'll also have a combo box for Developer which I need to function the same way. I don't know how to add that part to the On Current event?

Code:
Private Sub Form_Current()
Dim strComboRowSource As String
If Me.NewRecord Then
strComboRowSource = "SELECT T_Associates.AssociateID, T_Associates.Associate, T_Associates.Active " & _
"FROM T_Associates " & _
"WHERE (((T_Associates.Active)=True));"

[Code] .....

View Replies


ADVERTISEMENT

Forms :: How To Close Multiple Form Instances

Mar 28, 2014

After creating multiple instances of a form how should they be closed so as to ensure that all of their assets are disposed of and there are no memory leaks? DoCmd.Close seems not to work because it expects a name string which would be the same for all instances of the form.

Since a form's name is a read only property it cannot be modified when the form is created so it doesn't uniquely identify a particular form instance. I've tried setting the form reference to Nothing which appears to work, but I'm not sure whether this is the correct technique and whether it disposes of everything cleanly.

View 1 Replies View Related

Forms :: Selecting Few Names From A Long List

Mar 22, 2013

I am currently designing an employee personal development and training database.I have 100 employees and the number that would go on a training course might be a handful so selecting four or five names in a subform list from a 100 seems a bit impractical.

I thought of selecting the course in a form from a combo box, selecting the employees using a tickbox in a subform and then running an append query.

View 6 Replies View Related

Multiple Instances Of The Same Report

Jan 18, 2007

I am fixing a database that was previously built. It is use to show listings of items for sale. There is a form that displays all of the information about a particular listing, each with its own id code.

If I want to email a particular item and info to an email address i can, but i can only send one at a time. I click a button which then asks what format to save the report, i choose html, then it opens a new email message from Outlook and sets the file as an attatchment.

The problem is, i want to be able to send more than one listing at a time in the same email. But once the first listing is created and attatched i have to send that one before i can send another listing.

Any help would be greatly appreciated.

Jared

View 2 Replies View Related

Forms :: Drop Down List Linked To Table - Names Not Appearing Alphabetically

Sep 14, 2014

I have drop down list linked to table included "agent names" , the names appeared normally in the form but not Alphabetic (A-Z) although the table was alphabetic .

View 1 Replies View Related

Multiple Instances Of Access On One Machine

May 12, 2005

Hi, I would like to recreate a record locking problem (error # 3218) our users are experiencing on an application we have developed. I currently do not have access to a network, so I would like to run multiple instances of Access on one machine. How do I do that?

Thanks,
Bill

View 1 Replies View Related

Multiple Instances Of Access To Allow For VPN Useage

Feb 22, 2007

I have a very elaborate Access 2000 application that uses three different SQL databases as the back end. Mostly the data is modified or selected via ADO connections.

The problem I am having is that recently users on Terminal Server are not able to open the application because for some reason the application is not allowing more than one copy of it to be opened at once. I checked everywhere and couldn't find anything that would not allow multiple instances but couldn't find anything.

Any ideas on what could be causing this? Any help is greatly appreciated

View 11 Replies View Related

Open Multiple Instances Of Form

Aug 4, 2005

Is there a way to allow Access to open a second (or thrid...) copy of a form? We need this so we can visually compare the contents for record one with the contents of record two.

Thanks,
David

View 11 Replies View Related

Queries :: Possible To Have Multiple Instances Of Same Provider ID

Feb 9, 2015

I have a table called providers with the following 3 fields:

Provider ID
Cancellation Reason
Visit ID
Date

It is possible to have multiple instances of the same provider ID, cancellation reason and visit ID on the same date. I'm trying to count just 1 instance based on visit ID if there are multiple instances of the visit ID and reason on the same date. Select distinct doesn't seem to do the trick.

View 1 Replies View Related

General :: Avoid Multiple Instances Of ACCDE

Jun 14, 2013

I have an Access 2007 mydb.accdb file. If I click on it, it starts up fine. If I click on it again, then focus goes to the already open db.

If I do the same but with the .accde of the same db, for each click a new instance opens. This is not good, in that a single user then can have multiple instances running without noticing it, and that might mess things up. What Windows setting to use, to convince Win XP that only one instance of mydb.accde should run, similar to the .accdb?

View 2 Replies View Related

Forms :: Search Combo Box With Multiple Last Names

Jan 19, 2014

I have a combo box that brings up records for an individual. I have people with the same last names and have their first names showing on the combo box list, but when i choose one of them, it will always go to the name of the person who was entered first, so matter who i pick(that has the same last name).

View 1 Replies View Related

Unable To Open Multiple Instances Of Access 2003

Dec 20, 2005

Not sure if this is the correct forum but its worth a shot.

When I try to open any database, MS Access will hang if there is already another instance msaccess.exe running. I even tried opening two newly created blank dbs with the same result. Has anyone ever come accross this behavior?

I have tried repairinging/reinstalling/checking and unchecking "Windows in Taskbar option"

Thanks for any help!

View 1 Replies View Related

Forms :: Delete Inactive Members?

Jan 9, 2015

I have created a database containing customer records and i wanted to somehow add a part where an individuals records will automatically be deleted if they are not active for 3 years+

View 6 Replies View Related

Forms :: Add Multiple Checkbox Names Into Single Table Field

Aug 15, 2013

Im constructing a form with check boxes next to names. Id like to have the checked names input serially into a single table field like:

IssuedTo
Name1, Name2, Name3

There are 8 possible Names. Is there way to do this without a long complicated If-Else-Then function?

View 5 Replies View Related

Forms :: Form Active And Inactive Field

Aug 18, 2015

Field "A" is the drop list to select data like (Yes, No)

Field "B" is inactive but turn it to active when the field "A" is select to "Yes".

View 1 Replies View Related

Forms :: Query Does Not Show Selections From List Box

Jun 19, 2014

I have a list box (SUB CATEGORY) on my form where I can select multiple items. I have a query (Final) that has this field in it.

Problem - I cannot seem to get the list box selections to appear in the query results. What the "Criteria" should look like or maybe some code that I can try.

View 1 Replies View Related

Forms :: Combo Box Wants To Show Records Not In List

Apr 4, 2013

I'm sure there is an easy way to do this but I have not clue.

I have three tables:
Students
STUDID (pk)
txtFname
txtLname
etc.

Classes
CLASSID (pk)
txtClassName
txtClassRoom
etc.

Student_Class (join table)
STUD_CLASSID (pk)
fk_StudID
fk_ClassID

On my Class form when assigning students there is a combo box which shows the students names. Once a student is picked in the combo box their name shows up in the subform.

What I would like is a way to NOT show a student in the combo box after they have been selected. Is this possible? Or should I be looking at another way of doing this?

View 13 Replies View Related

Forms :: Open Form And Show First Record In A List

Oct 20, 2013

On a form I have a listbox that allows me to navigate around my records. The listbox is filtered and I get the redords that I waqnt from the table.My problem is that when I open the form the record that is showing is one from the table but not one that is in my listbox. I want it to show the first record in the listbox...This is the command I have on open:

Code:
DoCmd.GoToRecord , "", acFirst

which is where the fault lies, but I dont know what I should put in its place. The list is List273 and the form is frm_Profile

View 1 Replies View Related

Forms :: Check Box List - Show Data Vertically?

Jul 11, 2013

I have a check box list on my form for all 50 states, so the user can choose any number and any combination of possible states, which I need the user to be able to do, but when it displays the data it does so horzontally and delineated by a comma. The problem with this is that if enough states are selected, it eventually gets cut off at the end and doesn't display the last states. Is there any way to make it instead show vertically, since at least with that I can format around it and not have a horizontal bar going all the way across the form?

View 14 Replies View Related

Forms :: Show In A List Box A Query Filtered By 2 Or More Text Boxes

Dec 15, 2014

I've created a form with two textboxes and a listbox. What I want to do is to show in the listbox the registers filtered by the 2 textboxes. But I would like that the listbox refreshes while typping in the textboxes.It was no problem to do filtering with only one textbox. The rowsource of the listbox is a query in which I set in the criteria Like [Forms]![Form1]![Textbox1].[Text] & "*"Then I write the code for the change event of the Textbox1:

Private Sub Textbox1_Change()
Listbox1.Requery
End Sub

With this I have no problem. The problem is when using the 2 textboxes. I write the same in the criteria, Like [Forms]![Form1]![Textbox2].[Text] & "*", on another field but it doesn't work. I also write the code for the second textbox:

Private Sub Textbox2_Change()
Listbox1.Requery
End Sub

The listbox doesn't filter with both textboxes. When you type in one of them, the listbox filters from it, but when you type in the other textbox, the listbox shows the whole table filtered with the characters of the second textbox.

View 10 Replies View Related

Totals From Instances (not Of Instances)

Jul 21, 2006

I've come across an interesting problem a colleague has been trying to solve and even though I can 'see' what needs to be done and could probably program it on our mainframe, I'm really stuck on how to achieve the same results in MS Access

I'll do my best to explain the problem by showing an example of how the data exists in the DB and also how it 'should' be output on a report.

DATE OPERATOR COUNT

29/06/06 - Oper A - 32
29/06/06 - Oper B - 12
29/06/06 - Oper A - 10
29/06/06 - Oper C - 13
29/06/06 - Oper B - 10

The output needed however should read as follows

29/06/06 - Oper A - 42
29/06/06 - Oper B - 22
29/06/06 - Oper C - 13

Setting up a date selection shouldn't be a problem, its just adding the totals on each instance of each operator into one figure without ending up with a total of the number of times an operator appears on a date.

Any help and guidance about how best to approach this problem (macro/query/script) would be appreciated.

View 2 Replies View Related

Forms :: Variable Number Of Instances Of A Subform

Dec 8, 2014

I have a subform that formats the data in a record in a particular 2D way. I want to use it a variable number of times on a single form. Is there any way to do that? I've tried using CreateControl, but access just says it can't add the controls I've requested -- with no reason given, of course.

View 2 Replies View Related

Forms :: Filter Between Two Instances To Work Without Values?

Mar 25, 2013

The thing I've been trying to do is make it so that my form filters my records, and I'm trying to make a between function for it. My form is shown below in the attachment.

What I need to do is make it so that my form filters my records Between the two year boxes AND between the two Length boxes. But I need it so that if nothing is in the boxes, it shows all records, and if something is in only the Year boxes, it only filters the years and not the lengths.

Code:
Field: Length
Criteria: Between [Forms]![SearchForm]![Length1] And [Forms]![SearchForm]![Length2]

Then in a separate column I had

Code:
Field: [Forms]![SearchForm]![Length1]
Or: Is Null

This works fine if it's only for Length, but if I try to do the same for the MovieYear boxes, it screws up and just shows me no records...?

View 9 Replies View Related

Show Field Names In Combo Box

Dec 30, 2005

Hi,

How do you display the names of field for a table in a combo box. I know how to do it in mySQL "DESCRIBE employee_data", is there a SQL command in access to do this?

thanks

Sean

View 6 Replies View Related

Modules & VBA :: Show Captions Instead Of Names?

Sep 25, 2014

I used the code below to check the empty fields in the form and populate it in a message

Code:
Private Sub Form_BeforeUpdate(Cancel As Integer)
Dim ctr As Control
Dim strMsg As String
'Loop through every control on the form
For Each ctr In Me.Controls

[code].....

I want the message to show the captions of controls instead of its names

View 8 Replies View Related

Forms :: Show Multiple Records On One Form

May 3, 2015

I need to show 10 records on one form (10 customers info), and for now I have 10 subforms to do that.

Is this the way to do it?

View 3 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved