Thanks in advance for your help!
4 users, Microsoft Access 2000 App shared on LAN, Split into front end and back end
Front end copied onto each users local hard drive,
Back end on LAN in...
I am creating a form
I want to input sales information into a form along with contact info.
I can create a form to input this one by one, but I want to be able to input many purchases kee...
Hi,
I'm designing a Patient Medication Database and I have a portion of a form that lists a Patients medications within a List Box. I'd like to be able to highlight certain items within th...
Is is possible to copy a piece of annimated clip art to a Access form and have the animation work? I have a training form that I have designed and would like to add some clipart I found on th...
I'm currently using MS Access 2000 and created a form with a subform. The subform contains a combo box (cmbTestingTypes) and a text box (txtDuration). When I choose a test type in the combo ...
Hello: I have a form that brings up records of a table based on a search criteria. If the user enters "spider" then any records with spider will come up along with the ID number from the table...
Within an Access form, I need to copy a portion of a textbox (txtPartNumber) and paste that value into a new textbox (txtPartCost) on the same form.
Here is an example of information that I...
I have combo box that uses two columns from table, master key and text column. The user selects an entry in combox and it store master key in a record with other data keyed in the form in a d...
I have a Access 2003 database. One of the forms has 7 sub forms. When this form closes in Access 2003 (on a slower computer) it closes and opens very quickly. When in Access 2007 on a fast ...
Hi Experts,
Thank you for your time and patience.
I am setting up a form with cascading combos to act as a filter for queries / reports.
On there form there are a number of cascading co...
I have a form in access that has about 80 fields on it. When I open the form as a datasheet I have about 80 collumns and 25 rows. If I click in field 30 on row 5 I need to retrieve the text ...
Experts,
I'm having trouble doing something that I know should be simple. I want to take whatever information the user selects and transfer it to a query. Usually when I'm doing this I us...
Experts, I cant seem to get this one right. I can barely explain it so apolgies if confusing. I need to open a form based on the ID of the subform. The button this goes under is on frmLetterO...
I want to have it so once the choice is selected from the dropdown menu that the 2 phone number fields and the email address autopopulate with the correct info.
This info is static and shou...
Experts,
Apparently if you are trying to open a form to a "company name" of the form you are on the syntax is different than opening a form to an ID you are on. In the below, the [CoName]...
Hi experts,
I have a form that is in continuous format. I have 24 records that are displayed. If I want to make one of the fields (txtname) for records 20 and 22 have a forecolor of red, ...
I am trying to create a basic search in MS Access.
A query, qrySearch, is based on information in tblMembers.
frmSearch has an unbound textbox, txtSearch, in which a search criteria is to be...
I am using Access 2007 and need to use VBA code to change the back color on a label to "System Menu Highlight".
This fails: Me.lblBondNum.BackColor = "System Menu Highlight" if I use the ...
I am trying to develop an Access 2007 (.adp) "project" as a front-end to tables held in a SQL Server 2005 Express database, but am encountering problems when working through records in a Form....
I have a form that includes a date txtDate. I would like the next field txtDay to be the three letter name for txtDate. So, if txtDate is 11/11/2008 I would like txtDay to autopopulate with ...
I have an ACCESS 2K3 database with only one table. The table contains 7 columns: ID/Name/Name2/ticket/mgr/date of employment/phone number.
The Name and Name2 column are formatted by both ...
What I would like to know in access 2007 is there a way to connect a date field to microsoft outlook calendar?
i am using ms access 2002 and have customized some of my own toolbars. I can't find the ability to add "filter for" command under the records section when doing the customize. I see every oth...
I have an event on load:
Private Sub Form_Load()
If CheckScanAcctSubAuto.Form![Acct #] = Me.Deposit_Account Then Me.ClientKey = CheckScanAcctSubAuto.Form!ClientKey
End Sub
It is poss...
The form has a recordSource of a table, and the first page of the tab control has the correct fields. It worked, except I noticed that some of the fields were on the form, and some on the page...
