Experts Exchange - Top Solutions

December 1, 2008 06:14am pst

1. capricorn1 1,036,187
2. boag2000 743,311
3. LSMCons... 594,627
4. DatabaseMX 463,807
5. peter57r 388,978
6. harfang 196,202
7. jimhorn 171,662
8. wiswalld 158,988
9. hnasr 109,444
10. ldunscombe 100,086
11. GRayL 99,497
12. eghtebas 91,713
13. koutny 89,650
14. MikeToole 88,218
15. irudyk 81,230
16. mbizup 79,834
17. JDettman 77,570
18. frankytee 77,464
19. TextReport 76,173
20. matthews... 75,462
21. LennyGray 74,748
22. omgang 74,746
23. jefftwilley 69,538
24. dqmq 60,875
25. Rick_Ric... 60,265

1. capricorn1 1,524,429
2. DatabaseMX 815,020
3. boag2000 792,401
4. LSMCons... 771,995
5. peter57r 605,947
6. jefftwilley 354,605
7. harfang 338,723
8. mbizup 282,451
9. jimhorn 275,209
10. wiswalld 199,202
11. frankytee 185,705
12. GRayL 177,565
13. MikeToole 153,036
14. stevbe 146,536
15. matthews... 139,812
16. LPurvis 130,795
17. JDettman 129,770
18. ldunscombe 121,545
19. eghtebas 113,958
20. dqmq 113,747
21. hnasr 109,444
22. koutny 100,675
23. omgang 100,081
24. puppydog... 98,189
25. LennyGray 84,328

635 organizations, including eBay, Ericsson and Lockheed Martin, now work smarter with Corporate Accounts. Save up to 42%

TechSoEasy

Welcome! If you have any general questions about Experts Exchange, feel free to ask me.

Top Access Forms Solutions: 201 - 225 of 583

I need to change back colour property on a form depending on value on a combo box

I have a simple SQL Database in SQL Server 2000. Two tables, one lisitng detials of an IT system and the other for Risks, they are linked on the SystemID column. The forms work with the system...

Validation of entered data before opening next form

Hi Experts, I have a form where the user should choose a value in a combobox field and then after clicking the add button another form will open up. I want this field to be mandatory, the ...

Form doesn't execute query

I've created an Access 2003 update form that has its Control Source set to a query. However, the form is coming up blank (empty fields) because the query is not getting executed because there...

creating a pop-up subform in access

Hello Experts! I'm looking for a way to create a linked subform (actually that will be set to continuous forms) that can be opened from the main form as a modal pop-up form when a button is cl...

In an Access 2003 db "Input Box", Format a Field view as Money

I have a "Input Box" in a command button Event Proceedure that I need the view of a Field value to be in money format. My "Input Box is: QuestC = InputBox("You have Entered " & Forms("Clien...

MS Access: Remove Scrolling Records

I am currently creating an intake system. The intake system consists of 4 forms: 1st form is a new form where the user will fill out the information and submit the info into the database, the...

Insert into table code error

Experts, I have this nagging issue of if after I successfully implement an "insert into" I try to amend it by including other items I want to include in the "insert into" and I continually ...

Can you automatically update a report title based on a a form using lists to filter?

I know how to get a combo box to automatically populate a report title. (can you get it to automatically populate a pages header?) But how can i get the selections made from a list to popula...

Importing excel into access revisited

I have set up a database to record data that comes in Excel format. The excel workbook consists of 3 sheets: Technical,Scan, Email. each containing two rows ( approx 20 cells of data) : row...

Filter an Access Form/Subform on the One-Side PriceAgreement Code and Get the Subforms Many Side Data.....

Just created a form/subform combination in Access using the Form Wizard. The primary form is a PriceAgreement (like a contract) with three subforms all tied to the PriceAgreement in a one-to-...

General Tab Control - Part 3

So, confused and I don't know why, other than I am doing this form a little different. The question on your website for General Tab Control - Part 2 is almost what I am wanting to do. This ...

Changing a number format on an access form

Hello Experts, I am running a form that takes its input from an access query. i have three fields that consists of numbers with decimal places 3653.9837 i would like to change the why the...

Remove little 'x' to disable closing of form

hi there, i'm sure there's an easy solution out there. I just don't know what it's called so i couldn't google or search for it! :(. Can anyone please tell me how to remove or disable the li...

Difference between Enable and Visible in Access 2003 Form

Hi all. What is the difference between the following properties in access 2003 forms: Enable and Visible I'm working on a form that when the user chooses one radio button it will make th...

Calculate avg of two bound text boxes on access form with possible null value in one or both text boxes

I have a form with TxtBox1 and TxtBox2 and TxtBox3. I am trying to have TxtBox3 be the average of TxtBox1 and TxtBox2. I want to use and AfterUpdate event to put the TxtBox3 value in the o...

Need help with Syntax error on microsoft access form txtbox

Hi Experts, I keep getting a syntax error wtih this code: If Not IsNull(txtFromAge.Value) And Not IsNull(txtToAge.Value) Then strCriteria = strCriteria & "and(ChildAge BETWEEN "...

Storing Data calculated via VBA code

I am developing a system that will generate an annual schedule based on a series of dates that are entered. I have a form (frmDates) in which the user will select a type of date and then en...

List Box on Tab Control imported from Access 97 to Access 2003 not displaying results

A form that I imported from Access 97 to 2003 that contains a two page tab control, each with several list boxes functions perfectly in Access 97. In 2003 the data populates perfectly into th...

How do you add filter buttons so a form can have records filtered per a users selection, either in combo box, parameters, etc.

I am almost home with this db, but need a little more help. I have a form that when open shows all the records and fields, etc. I would like to add, combo boxes, or pop-up windows so a use...

Multiple combo boxes to filter a subform.

Hello, I have a subform with a query recordsource that I am now trying to allow the user to select multiple choices from combo boxes. Currently, it filters on only one combo box and disable...

Can I force a query to return a count of 0 when no data is returned from query?

I have a query whichs count the number of records whose DateofBirth is null. The only value returned from the query is the count, NumDateofBirthNull. When all records have a value for DateofBi...

Scrolling issues with a subform

I have a 3 continuous subforms on separate tab pages. My problem is that whenever I click a new tab the focus sets to the first field of the first record and it makes my main form scroll down ...

Add a MS Access Form to existing WEB Page

All I would like to do is insert/add a pre existing MS Access Form and insert it into my web page. Very simple ???

assign a value in a subform in microsoft access

Hi Experts, I have a subform on a form and I want the value of a field on the form to autopopulate in a field on the subform. Specifically, if not null, I want the value of cboCounty to au...

Cmd Close Question

In what way can I utilize the attached code in the btnClose command to reset the three major forms namely: frmS, frmW and frmT: FrmS, FrmW and FrmT are designed as follows: Allow...