Computer Support Forum

Access 2000 - Not displaying all records on Form

Question: Access 2000 - Not displaying all records on Form

Hi Guys
First timer - so please tread gently! I'm sure this is a similar situation, but wasn't sure whether it warranted another separate conversation.
I have a situation on an unbound list box in Access 2000 and haven't yet got to the bottom of it. I have a box which displays incorrect records for the user to correct. When they first go into the box, they see all 500 records (for example) and use a dble click event to edit the one they want, when they return to the box it will only display the first visible amount of records. They can use the scroll bar but the records do not scroll!

The Code behind ( and here's where I get lost - I don't do VB!) opens another form, allows you to edit the record, saves the changes, closes the form and returns you to the original form. We have tried keeping the original form open, as it was closed and reopened, but no change.

The DB has been inherited, so I have no idea why a List box has been used an not a combo.
Forms data is taken from a query.

I'll work out how to post a copy of the empty DB to you!

Relevance 100%
Preferred Solution: Access 2000 - Not displaying all records on Form

I recommend downloading and running Reimage. It's a computer repair tool that has been proven to identify and fix many Windows problems with a high level of success.

I've used it in the past to identify and fix everything from blue screens (BSOD's), ActiveX errors, corrupt files and processes, dll/exe/sys errors, recover lost memory, Windows update problems, defragging, malware removal etc.

You can download it direct from this link (This link will automatically start a download of Reimage that you can save to your computer.)

Answer: Access 2000 - Not displaying all records on Form

6 more replies
Relevance 88.15%

Hi All,

Noob first-time poster I'm afraid!

I'm new to Access 2007 (but have used 2003 & 2000 reasonably extensively).

I'm building an App and have created all the necessary tables, as well as creating the relationships in the Database Tools area (which I know are correct - I'm a SQL Server DBA in my day job)!

Anyway, it's an almost text book example of an employers and employees database; one employer having many employees (employerID is the foreign key on the employee table).

I have created an employer form (using the wizard) which is fine, but then when I add a button to open the employee form (selecting 'Open the form and find specific records', matching employerID on the Employer table with EmployerID on the Employee table) it doesnt work. Instead, I get a popup box asking me for the EmployerID! Even if I manually enter the correct employerID when the popup box appears it actually displays all records, so I'm sure that the problem is more fundamental (and therefore, probably my fault)!

I'm hoping that I've just overlooked something REALLY stupid, but would apprecaite any suggestions!


Answer:Access 2007 Form Button Wizard - Form does not open with the correct records

I have seen this kind of problem with Access 2007 VBA code which does not work when it dod in 2000-2003.
It can be a Syntax problem which you may be able to get around, if not you can get around the problem bby using a Criteria in the Query that supplies the Employee Form.
Although I would have thought it would be better design wise to have the Employees as a Subform or Tabbed Subform on your Employer Mainform.
I do not have Access 2007, only 2003 so I can't help with the VBA, but you could post the code anyway.

Did you use a Wizard to create the Employee Form, if so check the Record Source SQL it may be preventing your EmployerID from working.

1 more replies
Relevance 87.74%

My multi item form isn't letting me add new records, only update and delete current ones.

My guess it that this is because the form is based on a multi-table query. That's fine, I can make a new form specifically for adding new records, but I'd like to be able to salvage this form if possible. Is there any way to either force this form to accept new records in the bottom row, or is there any way to get rid of the "add record" bottom row completely so it's not misleading users into thinking they can add records here?

Thanks in advance.

Answer:Solved: Access 2007 - multi item form (continuous form) trouble adding records

16 more replies
Relevance 80.77%

I’m creating a website that will handle tons of data, using MS SQL Server for the active content, basically dropping records into a variety of webpage templates for the end-user. But, my back-office first has to sort through tons of raw data and whip it into shape, drafting and editing text, cropping/resizing photos, assigning links, etc. I’m using Access 2003 for that process, to handle everything that is not yet ready to be imported into the SQL Server for publication to the live website.

I understand that I can display data from an Access db on a webpage, somehow (just a facsimile of the real webpages in which it will be displayed, later, one record at a time). It would be very helpful for the back-office staff to have an in-house, interactive way to see how the data they’re editing will eventually appear on the website, giving them insights into how they need to adjust it further.

My head is reeling from all of the different stuff I’ve read about how I might do this. Can you all give some general advice on how I should get started, which direction I should take?

Thank you.

Answer:Displaying Access data records on a webpage

Access 2000-2003 uses Data access Pages to display data on the Web. They are an html version of a Form and can be created by saving a Form as an access Page.

1 more replies
Relevance 80.36%

Hi All,

I am trying to put a combo box on a form that will allow the user to both scroll through the list and start typing the first name of the employee to find the desired name. Clicking on the desired name would open the appropriate record.
So far, I have successfully created:

A 'multi column' combo box, that shows the information that I want, called "cboSelectBEP"
The combo box lives on a form called "Basic Employee Profile"
The combo box is fed from a query called "Basic Employee Profile Query"
All the main data is kept on a table called "Employee Information"
What I seem to be missing is the following functionality:

The combo box shows the test record (ie the list) when you click on the arrow but does not allow you to type the employee's name in to search
When you do click on the test record, it doesn't actually go to any record - other than the default record - btw - how can I change that so the form comes up blank?
I think part of the issue lies in the fact that my query takes the First & Last names from the "Employee Information" table and puts them together in a 'full name' format. I know the topic of comboboxes with 'search while type' functionality has been covered many times before but I've been searching the internet for 3 days and can't seem to find where I'm going wrong! Any help is appreciated!

To make it easier envision the situation with the... Read more

Answer:MS Access searchable combo box on form to access records

It is a property setting on the form that is causing the problem.
I have added a find combo to my form in your original database that works fine.

1 more replies
Relevance 80.36%

Hi there,
I'm working in Access 2003. I'm running XP Pro, SP-2. My problem is this:
I have a form that is set up to drop data into 4 tables. As I was entering the data, the number of records increased. I also made sure to save frequently. When I finished for the time being, I could scroll through and see all 16 records that I had entered through the form. Then I closed the program. When I opened it up again and went back to the form to continue inputting data, I noticed that it said only 4 records were there. When I checked the tables I saw the data for all 16 records. How come I'm not seeing that in the form? I've tried looking everywhere and I feel like the answer is right under my nose. Any ideas?

Answer:Access Form not showing all records

8 more replies
Relevance 79.54%

I am relatively new to access 2007, so forgive me if this is simple.

I created a database to store Overtime hours for our employees(50 or so)

There are only two tables:
Employees(Employee #, Last Name, First Name, Active(yes/no))
Overtime Hours(Employee #, DateWorked, Hours Accepted, Hours Rejected)

The tables are linked with a one to many relationship on Employee#

I was able to import the data from the excel sheet we use, and generate the reports we need from that without a problem. However, I am stuck on the hour entry form.

What I would like is to have the form to have a date entry text box on the top, then display the list of active employees(gotten from query), and next to each employee have a place to enter the hours accepted and hours rejected. Everything I have tried so far has failed.

I tried making a multiple item form bound to the active employee query, with 3 text boxes(HoursAcc, HoursRej, DateWorked) that has sql that executes from a command button using the following code

INSERT INTO OvertimeHours (EmployeeNumber, DateWorked, HoursAccepted, HoursRejected) VALUES ('" & EmployeeNumber.Value & "', #" & Format(DateWorked.Value,"mm/dd/yyyy" ) & "# ," & HoursAcc.Value & ", " & HoursRej.Value & " )

This has three issues,
1. Filling the Hours Accepted, or Hours Rejected text box next to any employee causes the text boxes for all the employees to be filled.
2. It only ... Read more

Answer:Access New Records from Non-bound table in a Form

WolfRoolz, welcome to the Forum.
I think that you have 3 problems with your current setup.
1. You are you using Unbound Text boxes for some reason?
2. The form for Hours should be based on the Overtime Hours table.
You are using an Insert into SQL Query when you don't need to.
Ideally you would have an Employee mainform which also has the date selection/entry on it, the Employee selctable from a Combobox.
The Subform would have the Employee # as it's Master/Child link to the Mainform and the date would be transferred by some simple VBA (or you could have it entered on the subform)

1 more replies
Relevance 79.54%

originally had 1 big table with 190 records. i had to split it to 2 tables with a relationship set on a specific field. i modified my form to combine the contents of both tables via my relationship. as i went back and added 10 more records, these records can be found/seen directly on my first (original) table but they were not inserted in the second table.
on my form, i can only see up to the original 190 records, and NOT the last ten records added after the table split.
is there something that i need to do to my form to go beyond 190 records?

Answer:Access Form is not showing all records in my tables

EVM welcome to the forum. You will get a quicker response to Access questions on the Business Programs Forum.
You sound a little confused over the use of the second table, it's data will not be automatically updated when the first table is updated on your Form. You need to have form, usually a Subform on your mainform to update the second table.

1 more replies
Relevance 79.54%

I have a bound form that is not registering new records that I added in the corresponding table, any ideas on what the issue could be? I am still learning the in's and out's of access 2010 but have never had this issue.

Many Thanks!

Answer:Form in Access is not registering new records in table

tookiemouse, welcome to the forum.
I do not have Access 2007/2010 but I can ask some general questions.
Is the Form's Data Entry Property set to "Yes", as it is does not allow displaying of olod records, only the entry of new ones?
Can you enter Records in the Form?
Do they appear in the Table?

1 more replies
Relevance 78.72%

I have an Access 2007 database with two tables. Table1 has a form to add and edit records. I would like to add a button on the form that would generate a list of records from Table2 that match fields from the form in descending importance.

Example: The Make field on the form sourced from Table1 has “Ford” entered, the Model field has “F150” and the Time available field has “7:00”. I would like to match these fields with identical information in Table2 in order from best match (all three) to second best (just Make and Time matching) to least best (just Make matching).

I also need to limit the number of results as the tables are quite large and anything past about 20 matching results is too much information.

Any help such as descriptions of how you would do it, keywords, or links are much appreciated.

Thank you

Answer:Access 2007 Finding Matching Records From A Form

InquisitiveIdiot, welcome to the Forum.

Finding matching records is not too difficult, however to do what you want to do changing the match from 3 to 2 to 1 field is definitely not. I think it may be possible to do so with a query that has 3 criteria rows, but it would need an extra column that calculates how many fields match the search record and it may take more than one query.
Can you provide a database with some dummy data in it so that I can try creating the query?

3 more replies
Relevance 77.9%


I've searched on the forums and google but I've been unable to pin down a solution that would help with this issue.

I have a form (see attachment), bound to a table (called tbl_samp). There are 4 fields in the table: X (Yes/No field), Plan, Year, and Type.

In the example, I have the first 4 records highlighted, and I would like a way to have the X checkbox checked for those 4 records (using either VBA or keyboard shortcut if it exists). So for example, perhaps a subroutine where I:
1) Select the desired rows (like in the attached image)
2) Press "Spacebar" (or command button or something) that takes the selected records, and marks "Yes" for each record.

Answer:Solved: Access 2003 Form - checking select records

10 more replies
Relevance 77.9%

I am still trying to get to grips with Access 2007 - there's a lot more than cosmetic changes!!Here's my conundrum....I have a form with a subform in it and that subform has a subform in it (nested subform).Main form Name: frmEngineerSubform 1 Name: joinTasksEmployeeSubform (joined to Main form by EmpID)Subform 2 Name: joinTaskServersSubform (joined to Subform 1 by TaskID)I would like to create a command button (or an event procedure) to open up another form called frmServer (which also has a subform called frmNote joined by ServerID).I would like frmServer to open and show the record (will be singular) for the selected server (and in turn display all the notes associated with it in the subform) I've tried a number of things and can't seem to get it right - have started climbing the walls! Any ideas? Will be much appreciated - have wasted almost a week on this!

Answer:Access 2007 - Open a form from a subform (filter records)

8 more replies
Relevance 77.9%

I have some tricky forms that I am working with and need some direction. I have a data entry form for partial detail and then a button on that form to open another form for more detail on a related record. I need the pop up form to display only the record related to the first data entry form. I have the button control set to open and display only the record that has an index equal to the index on the data entry form the button is on, but it doesn't work that way. The form is opening to show all records. I do not want to put a parameter on it. Want it just to show the record related to the open record on the first form.

Is there another place I should be looking in the properties to ensure it opens at the record I need?

Answer:Solved: Access Form Settings - display specific records

10 more replies
Relevance 77.9%

Is it possible for an access form to filter specific fields in the record source table so the user can deal with them only a part form the rest of the table fields.
The table contains many fields and the user needs to enter data in all fields for the different records in the table. To make it easy, I need to filter the records which have similar or are common in a specific character to enter their data, then remove the filter and put another filter for another character.
Please advice,
Thanks in advance.
M Hegazy

Answer:Building a form in Access can filter specific records in a table

9 more replies
Relevance 77.08%

Semi beginner in Access 2003. My problem is I think a little complicated so here goes. On a specific week, our department will get a list mail renewal packets with 5 different expiration months. So I have to find a way to create a form (which I have done) with a week ending date that will allow the user to enter multiple expiration month dates. I figured how to do one at a time and get the form to update but can't figure out how to update all of them at the same time. The problem I think has to do with the control source but not sure. so here's a sample of the info:

For week ending 9/20/2008,
August September October November December
Opening Balance 1000 1200 1300 1500 1600
Received in Unit 200 100 50
Deferred Closed
Deferred Pilot
Deferrals Return
Closing Balance
Mail Room Count

So I set up a form similar to the look above but can't figure out how to update it to a single table that has all the left handed information on it. Please help!!!!!

Thanks a million... You know bosses they want it particular way.

Answer:Access 2003 - Updating multiple records from a form to table simutaneously

16 more replies
Relevance 77.08%

If I wish to append the current record on a form there seems to be only two ways. One is in the append query for the table to leave all criteria blank in which case all records are appended not just the current record. The second is to enter a parameter value in the append query for the table which just deletes one specific record.
For each record on a form I can have a number of different records and I want to be able to append those.
Would appreciate some help here. Thanks

Answer:Solved: Append all data from records returned on form Access 2003/7

See my response to your other Thread.

1 more replies
Relevance 77.08%

I have a form that I'm using to enter orders for inventory. I just ordered 2 phones I'd like to have listed as 2 separate records (they will be physically tagged individually, so they need to be separated in the table).

I'd like to have a Quantity field that when I type a number and save the record from the form, the number in the Quantity field adds that number of identical records (aside from the Autonumber field for the primary key).

Is this possible? If not, how should I go about it?

We have larger orders, sometimes 10-20 items, all with the same everything in the record except for the physical tag number that will be applied to each item when it comes in.

Thanks in advance.

Answer:Access 2010: Form quantity field that adds records to table

If the form is for entering the actual order details then you shouldn't have a record in the order table for each item in the quantity field.
What you could do is is to add a record for each item in the quantity field in the Inventory table using the Item's ID to identify it.

1 more replies
Relevance 77.08%

I am a Access newbie with very little VB coding experience and would greatly appreciate any help in sorting out my problem. One which I have been trying to solve in vain for many days.

I have a customer table one of the fields is FirstName. I have managed to design a form named Customer Search which searches the CustomerDetails table and shows the results in a form.

I have a command button on this form which when clicked should open the selected record for viewing/editing. However this does not happen and I get an error window which shows the FirstName chosen and error message "Enter Parameter Value' if I then type the name it opens the record. I want the record to be opened automatically without any further user input.

FirstName is a Text field.

My Code is as follows:

Option Compare Database

Private Sub Search_Click()

Dim sSearch As String

'read the seach string from the form

'note: NZ() ensures that nulls are converted to empty strings

sSearch = Nz(Me.SearchString, "")

'Check if the search string is empty or not and set the filter accordingly

If sSearch = "" Then

Me.Filter = ""


Me.Filter = "[FirstName] LIKE '*" & sSearch & "*'"

End If

'turn on the forms filter

Me.FilterOn = True

End Sub

Private Sub Command11_Click()

DoCmd.OpenForm "Add Customer", , , "[First... Read more

More replies
Relevance 75.03%

I basically have a Main Menu form, on which I have a variety of tabs. On one of the tabs I want to have a series of combo boxes from which users can enter/select the value they require. In the After Update I need some sort of code as below, that will allow me to display the record/s matching the value provided/selected by the user.

-this command is expecting an =

So a user has a combo box called ID, they may enter or select a value from a drop down list, a form is then displayed from tblImprovements in frmImprovements. What am I missing? Any ideas?

Answer:Filtering in Access and displaying in a form

I think you have the order of the filter wrong. Also you should not need the .AfterUpdate piece of the combo box. Try

1 more replies
Relevance 75.03%


I am trying to create a data entry form for a large database. There is a parent form with 6 forms linked with a one-to-one relationship (due to a large number of fields) and several tables linked with a one-to-many. All have auto update/delete checked. The date entry form uses tab control (across 11 tabs) and subforms for some of the tables. I have two problems...

Firstly, if I enter part of the data for a new record in the form (eg fill in tabs 1-3) and then close it, the data appears in the tables, but when I re-open the form the record does not appear, so it is impossible to complete the data entry.

Secondly, when using the tab key to move through the fields in the table, when I get to the end of a tab control, instead of moving to the next tab control for the same record, it moves to a new record on the same tab.

I am fairly new to access and not familiar with all the code etc behind it, so I would be grateful for any advice!


Answer:Access form not displaying all data

9 more replies
Relevance 74.62%

Lengthly, I know. My apologies.....

I know that there has got to be an easier way to do this than what I'm doing.... Here's the situation. We want to be able to get our questionnaire information into our Access DB.

The way the questionnaire program dumps the data, it puts about 5 fields of identifier info first and then "question number", "answer", "question number", "answer" all onto one row of a flat .csv file. We can import that to a table in Access fine. But, as different questionnaires have different numbers of questions, if we put everything into one big table, we have wasted space (and energy) since we would have to have the table big enough to support the biggest questionnaire.

We want to get it to where our Access table has each question in it's own record instead of all combined together. The way I've done it (which does work) is to import the csv file into a table, and generate more queries than necessary, all hooked up through a macro, to append each question's info into the "broke out" table. But, this gets cumbersome as I have to have 50 queries to cover a questionnaire that has all of the questions in it and then each one will have to be changed if anything is ever added to the identifier info (each one basically says to pull x and y columns, which would change if an extra field is added to the identification fields).

I know that there has got to be a way to either handle this befor... Read more

Answer:Access 2000 - Breakup Records

Open a Module window and then bring up Help. Search for the READ and WRITE methods. This will allow you to read and write to a streaming text file. If you can control your format in such a way that you have a header record that has your identifier fields and then some way of distinguishing between questions and answers, this may be the way to go.

Hope that helps.

3 more replies
Relevance 74.21%

Hello OBP and others,

I have 3 Access XP survey forms that are not displaying the uploaded data in the tables, though they are restricting the number of records to the number of surveys in entered into the tables (as they should be doing). The "Data Entry" settings are set to NO for all forms and subforms. Do you have any suggestions as to how this can be fixed?

Thank you,

Answer:Access XP Form Not displaying Table data

16 more replies
Relevance 74.21%

Hi all,

I am a beginner to MS Access. I was trying to create a form in Access which has 3 combo boxes on it, with each of them having the data on accountname, report type and date respectively. This data comes from 3 tables which are two column tables with one filed being the primary key one and the other fiield having the say accountname as type Text and so on. The form has the functionality that as a user chooses a particular combination of accountname, report type and date from the 3 combo boxes and clicks on a button titled 'Display report' the respective pdf file opens up. These pdf files are stored in a particular folder and are named as a concatenation of 'accountname+reporttype+date'. The form also needs to have a button clicking on which the user can close the form.
Any directions members !

Also could anyone explain me what actually a query is and what relationship does it have with a form. I have some idea about this but i am still not fully clear about these concepts.


Answer:Creating a form in MS Access for displaying reports

i posted a similar question about 2-3 weeks ago... I hope someone has the answer...

2 more replies
Relevance 73.8%

I have a 3 PCs peer-to-peer network sharing to use a Access DB file which resides in say PC-A. Most of the time PC-B and PC-C would open file to do data entry.

PC-B never has any problem.
PC-C the person has been complaining records missing... say she puts in new records 2 days ago, now when she opens the file she cannot find those records. This case does not happen all the time, just hit & miss!
All PCs are WIN98 running Office 2000.

1. Do I need to apply any fixes (SR1?)
2. Is there any sharing issue that I missed?

Currently all I am doing is making PC-A with a shared folder to house the Access data file.

Pls advise.


Answer:Access 2000 database records not updated

6 more replies
Relevance 73.8%

I have Access 2000. I have gotten one of my databases imported into it and created a query and report.

Now when I go try to change a record, I am getting "updating data in a linked table is not supported by this isam"

Help tells me that i need "installable isam". What do I need to do? I've never run into this before.

It's a simple subscriber database I use to print mailing labels. I had it in MS Works, but the new works is too complicated and I can't figure out how to print my labels in it. :S

Answer:Editing Records in Access 2000 table

I don't know about the "installable isam", but I did just import an Excel spreadsheet into my new DB and noted the option to "link tables" rather than actually import the data. It sounds like you may have accidentally done this. Unless you've drastically changed the data in your table, I would change the name slightly and import the data again to test this. Save the new table as the name referenced by your query and report and see if you get the same error.

1 more replies
Relevance 73.8%

How do I filter information from records that contain year -2003 from date format 01/17/03 (Do not want to filter by day or month)?? What is the correct criteria information??

Answer:filtering records/access 2000/criteria

Create a query with desired fields.

Put this in the criteria for the date column:

Between #1/1/2003# And #12/31/2003#
There's another way to do it by using just the year, but I'm not sure of it.

2 more replies
Relevance 73.39%

I'm sure this is an easy fix but I can't seem to find it. I just have a form, that will be a subform of another, that needs to display the results of a query.
The query is simple enough, just displays all fields of records that fall between specified dates. The query works great, but when I attach it to the form as its record source it doesn't display the data. I can see the correct amount of record selectors so I know its understanding the query but its as if all fields are hidden!

I have also tried building a query to the forms record source that was simply Select query.* From query. Oddly I have had this working before but I had to specify every field. What I mean is:

Select title From query
Select type From query
Select date From query ...

And so on for all the fields but this seems foolish, can anyone think of what I may be doing wrong?
Thanks in advance!
Edit, forgot to mention I also tried the foolish solution that I mentioned above and it didn't work so its definitely some issue that I'm not seeing, some property that's probably not appropriately set

Answer:Solved: Access 2010 form not displaying query

8 more replies
Relevance 72.16%

I have a table with a Date/Time field called Date Created, it is in the General Date format, and it is a time stamp (EX: 12/3/2004 3:00 AM). I know that if you have a date field that is formatted as a Short Date you can easily pull records in a query based off of a current date (EX: Date() as the criteria). I have tried using the Date() criteria as a parameter for a query, but I am unable to pull the current date's records. The query will work if I test the "Between #12/1/2004# and #12/4/2004#" parameter range, but I would like to be able to pull records for the current date without having to change the date range or even the date field to a short date in the main table. I've even tried converting the date within a query to display the date as a short date, by adjusting the field properties in the query, but the Date() criteria still doesn't work. Is there any other type of syntax that I could use within the query to make this work? Your help would be greatly appreciated.

Answer:MS Access 2000-Pulling Current Day's Records From Time Stamp

6 more replies
Relevance 72.16%

We're having difficulty with a large data file of 4 million records in Access 2000. We can't delete records after it has been linked. Also, when opening an unlinked database, it automatically links it.

error: operation not supported by this ISAM.

Answer:Access 2000: Can't Delete Records in Large Data File

6 more replies
Relevance 71.75%

This ought to be pretty simple to do. I have a small table that contains contact information for a number of businesses: name, address, etc. I have an “ID” field that is an auto number and is the PK. I have created another table that contains the business name, date of a donation and a memo field to hold the donation info (since it’s stuff instead of money.) In the second table, “ID” field is also an auto number and is PK. I have related the tables with a one to many: theoretically one business with many possible dates/donations which is the basic premise. I created a main form to input the business data and created a sub-form for the donation data based on their respective tables. Each business will be unique but a business may give multiple donations, say one each month or more – whatever.

I can’t get it to work. I’ve got that big, honkin’ Access 2000 Developer’s Handbook but am still getting up to speed using it…. but I’ll keep looking until I hear from someone!


Answer:Access 2000 Form/Sub-form

9 more replies
Relevance 71.34%


I have linked my calendar 11.0 to my text boxes, and then to my query criteria. Everything works, except after I click on the Calendar to choose my end date and it shows up on the text box thats linked to the query, the information from the query doesn't automatically show up on my Form in other text box I have linked for results (d*count funtion, etc).

BUT, when I go into design view, and then back to form view, the Data is Updated!

So I am very confused as to how to set it up after I input the end date to automatically update instead of hitting the design view and back to form view for it to update.

Not sure if a "refresh" or "after update" function needs to be in place? I hope I explained it correctly! Thank you!

More replies
Relevance 68.47%
Question: Access 2000 form


I have a form for entering medical studies and have another for patient information. I would like to have them both on different tabs of the same form, but if I use a query showing all data (tied by StudyID) I get, say, if there are 3 studies with 10 people each, I see 30 listings. This is fine for the tab where I want to enter patient information, but I can't get the studies tab limited to just one instance. Is there a way to import an existing form into a tab so I can get around this? In the attached files, you can see what the three tabs are showing. Note that they all show 5 records, when there are actually only 3 studies. (Alas, the database is too large to upload, even stripped down and zipped).
Thanks in advance, everyone.

Answer:Access 2000 form

slurpee, you can just put an existing form on to a Tab using the Subform icon on the Form Toolbox.

Have you compacted and repaired the Database, that will dramatically reduce it's size.

2 more replies
Relevance 67.65%

I created a new form in a new database and the recordset it pulls from is a ADODB type recordset. Does anyone know how to change it to a DAO type recordset (like all my other forms) ?


Answer:Access 2000 -> Form Recordsets

What is the data source of the form? As a general rule, when a form's data is coming from an Access table the recordset it returns would be DAO. If it is linked to an ODBC source it would return an ADO recordset. BTW, how do you know that the form's recordset is ADO?

I don't really have good tools to experiment with here but even if you are linking to an ODBC source, you might be able to create a DAO recordset in code against the link and then set that recordset as the source of your table. I'm 100% sure of that though so don't quote me on that unless you test it and see that it works.

[Edited by YSB on 07-06-2001 at 06:19 PM]

2 more replies
Relevance 67.65%

Hi Everyone,

I am try to get this form to work without any luck. I have a text field that the text is going to go to a table where the field on the table is defined as a MEMO. But when keying the text and clicking the button that will move this data into the table. It gives me a error "invalid Argument" HUH??? I can't figure out what I did wrong here.
If anyone have any ideas I would appreciated.



Answer:Problem with a form Access 2000

There is nothing intrinsically wrong or tricky about using a text box to input text destined for a Memo field in a table. (By this I mean this is a standard sort of a thing to do that usually doesn't necessitate special tricks or work-arounds.) Please give moreinformation concerning how you have been attempting to do this. What is the "button that will move this data into the table" that you are clicking? How are you trying to accomplish the move?

3 more replies
Relevance 67.65%

Through the use of the wizard, I added a command button to my form to print only the current form (see code at end of message), and that works perfectly. I have now included my form on a tab form, each tab having a different form based on a different table. Only problem is that when I click the command button, instead of printing just the single form selected, it prints all the records in the table!! Help - what do I have to change so that it will work the same way it does when I open it as a stand alone form instead of part of the larger tab form.
Code generated by wizard to print single form:
DoCmd.DoMenuItem acFormBar, acEditMenu, 8, , acMenuVer70
DoCmd.PrintOut acSelection, 1, 1, 0

Any suggestions will be greatly appreciated!

Answer:Print Form from Access 2000

9 more replies
Relevance 67.65%

My question has to do with making sure certain text boxes get filled out.

I use check boxes that show or hide different text boxes. If we are to call back, then the phone number text boxes are visible. If we need to send a letter, then the address boxes are visible and the text boxes are hidden.

The logic for gettting the text boxes visible for the different check boxes was a pain.. I would hate to have to do that again to check to see if all of the text boxes are filled out.

Is there a way, when I save the file, to check and see if only the visible text boxes have information in them? Any body have an VBA code for that?

Thanks much.. have a great weekend

Answer:Access 2000 Form question

Does VBA have the .visible property? I forget.

But anyway, If it does...

Public sub cmdSubmit() <---- That's the button that saves your data
If txtAdress.visible = true and TxtAdress.text = "" Then
Msgbox "Please fill out the Address field."
Exit Sub
end if

If txtPhoneNumber.visible = true and txtPhoneNumber.text = "" then
Msgbox "Please fill out the Phone number field."
Exit Sub
end if

etc, etc, etc.

at least that's the way you'd do it in Visual Basic. If that doesn't work in VBA, tell me.

1 more replies
Relevance 67.65%


I have created a hyperlink from a text box in a form to field in a subform that enters information in a table. The hyperlink works and puts the data in the field on the subform but when I add the record it does not appear in the table.

How do I get that information to be bound to that field?

Answer:Access 2000 Form Question

I have responded to your email, as I don't know why you are using a Hyperlink for this application. It is normal to use Master Child Links on the subform.

1 more replies
Relevance 67.65%


I was wondering if someone could help with an Access 2000 problem. The database was created by another colleague who has since left the company. When opening the database for the first time it tells you it is created for read-only access. The main form then opens and data can only be entered from here. There are also buttons that you can press which takes you to reports that have been created.

The problem is that the design of these reports requires to be changed and I can't switch the form to design view in order to make changes to certain fields.

Can you offer any advice?



Answer:Access 2000 - Form set to read only

Is this an mdb file or an mde file?

Have you tried holding your left shift key down while double-clicking the file to open it?

2 more replies
Relevance 67.65%

I am creating a form and would like to put some controls on it.

There are 3 Fields involved. [Reg Hours], [OT Hours] and [Task].

I would like the [Task] field to be required if there is an entry for [Reg Hours] or [OT Hours]. I have tried IIF statements and If Then statements. I am not certain I have used the proper syntax or formula.

Can anyone give me a suggestion on how to write the statement or if there is another way to do this?


Answer:Access 2000 - Form Question

I would setup a macro that will check the fields to see if they are not null or blank and then have it display a messagebox and take them back to the task field. I would have this macro load in the before update event for the form.

2 more replies
Relevance 67.65%

Hi All.

I am flying off to Florida tomorrow morning, but wanted to leave some of you Access guru's access to a database I worked on, and now have to figure out how to add something.

You can download the database here.

What I am trying to do is create an interactive Product Listing.

From Switchboard, access"Enter/ View Orders by Customer"

and on the screen that pops up, at the bottom there are several buttons. One is for Product Order. First thing I would like to get rid of, or have automatically found, is the Shipping fields that pop up wanting to be filled. You can leave them blank.

Now we have a Report that lists the Client information, and then a Product listing. What we would like to do is to make this into a Form, that can be interactive with the rest of the database. Basically, we would like to enter the order information through this Form, and have it capable of filling in the appropriate tables, etc. Orders would be placed within the Color columns, and tallied to the left of the Product Name. That total would then carry over into the Orders by customer, etc.

Any assistance by y'all is not expected, but would be most appreciated. This is not my job, and I haven't the necessary knowledge, or time to sort this out. I'm positive I could tack something together at some point, but I'm hoping one of y'all will be a little bored, and feeling extra helpful.
When I get back on the 23rd of October, I'll check to see if anyo... Read more

Answer:Access 2000: Input on Form

8 more replies
Relevance 67.65%

There are several questions in the area of mine, but not quite. I have developed an application for archiving contract documents. This will many network users and I would like them to be able to work completely from within the user form. I have created three buttons for them to locate specific documents:

1. Search - with the action command of Filter by Form
2. Apply Search - with the Apply Filter command
3. RESET - with the Remove Filter command

Search and RESET work fine. However, but I click Search button the form properly goes into the Filter by Form mode and disables all the buttons on the form so that after selection the filter parameters I cannot use the Apply Search button and must use the Funnel button in the toolbar to complete the search sequence. Any suggestions? Thanks.

More replies
Relevance 67.65%

It is set up to open the form in the add mode. However, there is a button to do a find which gives an error because it is in add mode. How do you cancel the add record, so that I can do a find and edit?


More replies
Relevance 67.65%

Hi everyone,
Is it possible to relate 2 combo boxes on an access form so that what you select in the 1st one, controls what you can select from the 2nd? In other words, the 1st changes the control source of the 2nd.
Im my case and I want to be able to select 'office' or classroom' in one box and then the room number for whether it is an office or a classroom in the next. I don't want to bundle all the rooms into one drop down box as there are lots (as you can imagine)!

Thanks in advance

Answer:Access 2000 Form Building

Yes, it is possible.
It's called "conditional" or "cascading", depending who you ask.

1 more replies
Relevance 67.65%


I am trying to create a job entry form where dailiy time slips are entered each week for a group of disabled adults.

Job codes are used to enter the different types of work done as well as non-work items that are still recorded.

Different types of jobs can be done on the same day, so this is done in a subform that will allow as many entries as needed for a single employee.

Some jobs are "Piece Jobs" where everyone gets the same pay for the same work. So infromtion about those jobs is in a PieceJob Table which includes the code, description and pay rate for that work.

The problem is that some jobs are Hourly Jobs. Pay varies by not only the kind of work, but also by the individual doing it. So a lookup there has to include both the JobCode AND the EmployeeID.

Now my form has a code box and when a user enters the code, it will fill in a JobType box with the type of job (General, Piece or Hourly) [and as General has no pay rate, I am not worried about it]

If it is a Piece Code, then I need to form to go to the piece table and get the payrate appropriate to that code.

If it is an Hourly Code, then I need the form to go to the Hourly table and get the rate for the Code based on who the employee is. (See two things to look up here - Employee AND Code)

I have been working on this for a week - have a deadline now and still can not get this part done!

Any suggestions would be extremly appreciated.


Answer:Desperate for Help with a Form - Access 2000

8 more replies
Relevance 67.24%

I created a MS Access form for data entry. As the user enters in the address information, I want to check the table to see if the name and address is a duplicate record. Does anybody know a way or have some code to help me out?

Answer:MS Access 2000 Data Entry Form

6 more replies
Relevance 67.24%

Hi all! Haven't been here in a while, but I find myself stuck!

I have an Access 2000 database that tracks people (like members of a given club).

I have a form created that brings up each members profile, with all their info (birth date, name, etc.).

What I need to do is bring up each member's picture on their form page, (and later, connect the reports to the same pictures).

From my somewhat-fruitless research, I discovered that it's best to link to images stored in an external folder rather than put the images themselves in the database...and that's fine. (This is a stand-alone Db, and is only intended to work off a single PC -it's not on the web, and not feeding any applications).

The only way I could come up with this, is to add a field to my table called "headshot", then insert the patch to the image. But when I put that in my form, it display's a hyperlink to the image, not the image itself.

Can anybody provide a quick walk-thru on what I need to do to get this thing working?

Many thanks in advance!

Answer:Access 2000: Display images in a form.

6 more replies
Relevance 67.24%

In a continuous form I have 4 fields. If any one field is filled in the other 3 fields must be filled in. The fields are:

[Type] [Hours] [Task] [Hours Worked]

Can I put that in a validation statement on the form and if so can you give me an idea of how the formula would read? If a validation rule is not the way to force an entry once one of the fields is filled in how else can I do that?

Also, the [Hours Worked] field needs to be limited to whole numbers with the only decimal places being .25 or .50 or .75 in them. Is there a way to limit that field or force decimals to only be those entries?

Thanks. I am very frustrated with these problems.

Answer:Solved: Access 2000 Form Question

16 more replies
Relevance 67.24%

I have a form that has a subform in it.

The form is linked by date only, because there is another subform in it that needs to be linked this way.

On one of the tabbed subforms I would like to link another field by itself to the master form.

Can this be done and how?

The Master form has [Date] and [EMP RICC ID]

On the subform in question I want to link the [EMP RICC ID] so that it will auto fill that information.

Any tips?

Answer:Solved: Access 2000 Form Question

Gene, why not send me the current version to look at?

1 more replies
Relevance 67.24%

How am i able to modify data in a form that is loading data from a query? I only seem to be able to retrieve data, but not upload. More specificly I use a query to filter some data from my table. With a form, i then want to be able to update some of the values (in my table ŕnd query). I have to use the query since not all colums/rows from the table may be displayed.
Any help is welcome!

Answer:Access 2000: Data entry in a form

What application are you using?

2 more replies
Relevance 67.24%

I have a form that is linked by date and person. On the form I have a field called [Hours] and a Field called [Hours Worked].

I want to add a field onto the form that totals the [Hours Worked] based on certain criteria in the [Hours] field.

I added a text box and and an iff statement the went like this:

iff([Hours]=1,true,SUM[Hours Worked])

I cannot seem to figure out the correct code. Can anyone help me?

I put a subform in with a totals query if I could get that to update each time a new entry was put in that would work as well.

Any direction would be helpful.


Answer:Solved: Access 2000 Form Question

10 more replies
Relevance 67.24%

Maybe it is just late in the day and the brain has quit. But I need help. I have a form that I have to base on two tables. So I wrote a query to pull the fields needed from each table, since visually trying to use sub-forms could get very messy. Now the problem is how to I save any of the data the user enters/changes in the form. In other words, I want to be able to update the appropriate table, but can't remember how to do that.

Thanks in advance for any help.

Answer:Access 2000 Form based on 2 Tables

For Access to update changes using information in both tables, there needs to be a relationship between them. Although you have created a query using fields from both tables, unless they are linked Access won't know how to treat the information

2 more replies
Relevance 67.24%

I have a little database I’m trying to set up. Here’s the scenario: We want to keep track of people who call our office anonymously and ask for services we don’t provide. The only things I want to track is gender of caller, county of residence, date of call, where that caller was referred and the reason for the referral. I want to make this as easy as possible for the receptionists so they will accurately track these calls.

I currently have 4 tables: the Main Table contains fields for date, gender of caller (lookup), county of origin (lookup), where referred (lookup) and reason. (I have an additional table for gender so I can create a combo box on my form as a lookup. Same goes for county and referral source. I want control over what is entered specifically and in what format.)

On my form I have created an option group for the referral sources. It’s possible one caller could be referred to one or several sources. I’d like the receptionist to simply check a box for each referral source but with the Option Group I can only select one of the group, not several. How can I allow the selection of more than one value if necessary?

Thanks in advance. Maybe I’m trying to make this harder than it should be.

Answer:Access 2000 - Option Group on Form

Yes, I know this scenario. It's a fairly common one, actually. You can't do it with an option group, though. If you can use code, you can do it with a multi-select list box (I think there's an example or two in the Access Developer's Handbook). But it's not the easiest code writing out there; I can give you some stuff, but if you're not familiar with VBA, I'm not sure how much sense it will make.

Which leads to the next possibility, which is clunky, but works: You use a datasheet subform, which contains a combo box from which the user can pick the various referral source(s). Each time a source is selected, the user must add a new record, but that's fairly easy to see and understand. And you can do it without code, or almost--just something on the Before Update property which sets the Caller_ID field to match the parent form.

Let us know what you think.

2 more replies
Relevance 67.24%

I have a form the consists of a subform with tabs.

When you open the form it opens to the first tab and jumps down making the tabs disappear, and making it necessary to scroll back up to tab to the next form.

When you tab to the next tab, it does the same thing.

How do I stop that from happening so that the tabs show when the form is openned and when you tab back and forth?


Answer:Solved: Access 2000 Form Question

10 more replies
Relevance 67.24%

I have a toggle button group that can have a value of yes or no.

One is [Regular Time]
The other is [Over Time]

I would like the [Regular Time] Default value set at 'no' but show the button selected and the [Over Time] set at 'no' and show the button not selected unless it is actually selected.

Then if someone clicks on the [Over Time] button, I would like the [Regular Time] button to show it is not selected.

I have them grouped but cannot figure out how to get the toggle to work correctly.

Any guidance would be appreciated.

Answer:Solved: Access 2000 Form Question

8 more replies
Relevance 66.42%

A while back you (I don't remember the exact members) helped me create a query by form in Access 2000... Thank you. Now I need to know how to create a QBF using a date range as part of the criteria.

I know how to use the date range in "Design View" of a query (ex: Between #07/01/2004# and #07/06/2004#) but I don't know how to implement that into the Form.

As an example, I would want to pull all records of "Apples" (criteria one) sold between "07/01/2004" and "07/06/2004" (criteria two).

Please help!!!

Answer:Access 2000: Query By Form Using A Date Range

7 more replies
Relevance 66.42%

I know this can be done because I did it years ago in Access 2. However, I don’t remember how. I have a database set up where I want a user to be able to open a specific Word document (already set up to merge with a query) from a command button on a form. I’ve tried creating a RunApp macro with the path to the particular document. The macro fails. Optimally, the user will click the button, Word will open the merge document, the user enters a date range based on a parameter query and is good to go.

I assume I will have to include the path to the Word executable located on the user’s hard drive. However, this is a database on the network so the path to the executable will be different for each user since all of our Word installs are local, right?

I remember this isn't a tough thing to do but have been unable to find the process in my documentation.


Answer:RunApp From Command Button on Form - Access 2000

11 more replies
Relevance 66.42%

Hi all,

I have problem with query a date range... I know how to use in "Design View" of a query (ex: Between #01/01/2004# and #05/07/2004#) but I don't know how to implement that into the Form, for eg: In Criteria: Between (Forms!FormName!From_textbox) And (Forms!FormName!To_textbox) but it just returns nothing...

Please help!


More replies
Relevance 66.42%

I have a form with entries that I would like to protect but allow users to update the form with more entries. How can I protect past entries yet allow a user to add new entires? I know you can lock the form, but how could you do this and allow new entries?


Answer:Access 2000 protecting past form entries

Use two forms, one for entering and one for viewing.

1 more replies
Relevance 66.42%

My background:

I have 5 years experience as a programmer, mainly dealing with java and higher end database systems. I have dealt with MS Access for a few years now. Most of my work has been modification stuff. I go into previously written code and update it with changes here and there.

My Problem:

I am working with a client on a major upgrade of their db. It started as an Access 2.0 database. I upgraded it to Access 2000 (among other changes). Now the users are telling me that where they used to be able to use the enter key to switch data entry fields, they now have to use the tab key.

All users are using Access 2000 or 2002 (XP) and are running on Windows XP machines.

Any advice and what things to look at?



Answer:MS Access 2000:Enter key does not switch form fields

Look at the "enter key behavior" (properties of form in design view) on the form and/or text boxes affected. Make sure it is set to default for those items that do not need to have a new line (i.e. Text Area's) when enter is pressed.

2 more replies
Relevance 65.6%


I am trying to validate users input in my recipe database, there is a main entry form called Recipes and a subform called RecipeCourseMeal that is a combo box (CourseID - is the control name)- dropdown list of meal course choices such as: appetizer, snack, breakfast, lunch, dinner, desert. I need to limit user to select only up to 3 of the courses for a given recipe. I was looking for simple ValidationRule for table such as comparing fields or so, but I could not get that right. Then somebody told me to try the "for" loop:
Private Sub Form_AfterUpdate()
Dim totalcount AS Intseger
Dim rowcounter As Integer
Dim x As Integer

totalcount = CourseID.ListCount

For x = 0 To rowcounter + 1
If CoureID.Selected(x) Then totalcoint = totalcount + 1
MsgBox "You cannot select more then 3 courses"

End Sub
But it still does not work the way I need it to work, how can I modify it to make it useful in my database? I would appreciate any help, maybe there is simpler way to do it.


Answer:VBA, Access 2000 - how to limit selections from drop down list on a form

Please stick to one thread for an issue, continue here:

1 more replies
Relevance 65.6%

I would like to create a Form (if that is what is used) that will allow an end-user to query data from a table (or query). In other words, the form will allow the person to enter or select more than one set of criteria...

I have seen this done in other databases... Usually, there are "and" and "or" options that allow the end-user to select more filtering options.

Since my next question is a simple one (I hope), I'll add it here instead of a new thread:

In a user-level security database (Access 200), is there a way for me to be able to see which users are currently using the system? Sometime I want to perform maintenance on my database, but I have to call all of the users to make sure they are not using the system so I can open it exclusively.

Answer:Microsoft Access 2000: Create A Form That Queries Data

13 more replies
Relevance 65.6%


I have used access for some time, but for some reason cannot get VBA to mark a list box row as selected (yes I know about list.selected(n) = True). Below is my code - it is now on the Form Current event, but I have tried it in Form Open/Actrivate/Load with the same results. Basically I am passing a string from one form to another and have checked strPenId is correct and matches a list item. However, if I have the code below in place, the list is not populated. Without it the list appears ok. If I run a test using a button after the form is presented, the relevant list box row is highlighted. The list box is populated as a value list as part of the Form Load event.

' See if we have been supplied with search criteria and expected result
If fDoFind And strPenId <> "" Then

' Check the Pen Availability list - criteria will be the same as originally used
With lstAvailablePens
' Run down the results
For intI = 0 To .ListCount - 1
If .Column(1, intI) = strPenId Then
' We have found the selected pen on the availability form
' .Selected(intI) = True == This is commented out as it stops the list being populated???
' Set the count to exit the loop
intI = .ListCount - 1
​End If
​End With
​End If

More replies
Relevance 65.6%

I have a form that has 3 blank entries that are from the same employees table. The name of that table is employees and it has 2 other codes (cost and company) in that table that each have an employee code (my primary key). The question is, if a user is filling out an invoice record and adds the employee code, how can I have my form automatically update my other two fields (cost and company) and save this fields on my main invoice table called invoices?

More replies
Relevance 65.6%


I am trying to validate users input in my recipe database, there is a main entry form called Recipes and a subform called RecipeCourseMeal that is a combo box (CourseID - is the control name)- dropdown list of meal course choices such as: appetizer, snack, breakfast, lunch, dinner, desert. I need to limit user to select only up to 3 of the courses for a given recipe. I was looking for simple ValidationRule for table such as comparing fields or so, but I could not get that right. Then somebody told me to try the "for" loop:
Private Sub Form_AfterUpdate()
Dim totalcount AS Intseger
Dim rowcounter As Integer
Dim x As Integer

totalcount = CourseID.ListCount

For x = 0 To rowcounter + 1
If CoureID.Selected(x) Then totalcoint = totalcount + 1
MsgBox "You cannot select more then 3 courses"

End Sub
But it still does not work the way I need it to work, how can I modify it to make it useful in my database? I would appreciate any help, maybe there is simpler way to do it.


Edit | Quote | Quick Reply
View Public Profile
Send a private message to emilia
Find all posts by emilia
Add emilia to Your Buddy List

Answer:VBA, Access 2000 - how to limit selections from drop down list on a form

7 more replies
Relevance 65.19%

how can i add a new record between two existing recorfs in access 2003 ?

thank you in advance

Answer:add a new records between two existing records in Access 2003

Sorry I do not understand your question, in what way will the record be "Between" 2 other records?

2 more replies
Relevance 63.55%

Is it possible to group records on a form like you can group it on a data access page? If I group it on the data access page the records can not be edited!

Answer:Group Records on a Form

Hiya and welcome

Is this Access that you're having problems with, or another program?



1 more replies
Relevance 63.55%

I want to make it so that when the user looks at records in the form, the form highlights or adds a new field only when certain records are viewed.

Example: A recipe book that when you get to homemade recipes the form adds a text line saying something like
"This is my special homemade recipe!" highlighted in green.

What's the easiest way to do that?

If it has to involve programming code or something like that I don't mind...


Answer:Special records in a form

are you talking about the web or an application?

do you have any programming experience and if so what language(s)?

1 more replies
Relevance 63.55%

I'm creating a database to capture contact history to my customers.

I have the customers loaded into one table and that is the souce for my main form. I have an additional table for call history, and have created a subform based on this table. I have linked the subform via the common key, which is my customer id.

The problem is that the subform will not allow me to create new records in the history table. It will only display _existing_ customer history records. In fact, if there are no linked records in the history table for a particular customer, the subform doesn't even display.

I know that it's probably some silly setting, and I've encounterd this before, but can't remember how I fixed it.
Help would be greatly appreciated!


Answer:creating records with a sub form

6 more replies
Relevance 63.55%

Howdy folks,

I am trying to get three rows from a mysql query result to print in three seperate columns in one row of an html table.

I used a tutorial and came up with:


$result = mysql_query("
A.ID >0");
if($r = mysql_fetch_array($result))
$num = @mysql_num_rows($result);
$thumbcols = 3;
$thumbrows = 1+ round($num / $thumbcols);
function display_table() {
global $num, $result, $thumbrows, $thumbcols;
for($r=1;$r<=$thumbrows;$r++) {
print '<tr>';
for($c=1;$c<=$thumbcols;$c++) {
print '<td bgcolor="#999999" align="center" valign="top">';

printf("<a href=\"%s?ids=%s\"><img src=></a><br>\n", $PHP_SELF, $r["ID"], $r["tn"]);
printf("<a href=\"%s?ids=%s\">%s</a><br>\n", $PHP_SELF, $r["ID"], $r["style"]);

else {
print '&nbsp;';
} ?>

Problem is, this prints a very long list of imageless tn's.

Any ideas??? Suggestions much appreciated.


More replies
Relevance 62.73%

I have an issue with counting [COLOR=blue !important][COLOR=blue !important]records[/COLOR][/COLOR]. In one report all records and the one filtered by Director, I need to total up the records in the employee info table and have the count available for a calculation in the reports, Takes the total hours and divides by the number of employees. In the filtered form, Director Report Date I would like it to go and tally the records of all the employees for the director chosen in the form each time the report is run so if they add employees the calculation will always be current. The same thing needs to happen for the ALL employee report... count all records and store. Should this be controlled by the form? I have included a copy of the mdb.

Thanks again for your support.

Answer:Counting Records using form criteria

10 more replies
Relevance 62.32%

Not sure how to do this, I have a form (frmIntro) that displays project number, title and PM (Project Manager)

Control source is tblProjects, I want to filter on "PM" to just show records by project manager by using a combo box and I need to have "All" as one of the options also.

How do configure the combo box properties and make this work? this is not to add data, just to filter.
Thanks, Joe

Answer:Solved: Filter records on form with combo box

10 more replies
Relevance 62.32%

Basicly I have been given the task of building a system to manage accounts and log calls and I have most of what to do already mapped out and having done similar things in parts with Access before I thought it would be a doddle but a few steps in and I have already come up against a brick wall. I have a form with several search fields and that works fine, no hitches at all and when you click on a button next to the top record it opens the customers details in a new form for editing, that works fine also. The problem I am having occurs when I get more than one result from the search and I try to click the button next to any record except the first and the problem is that the form I want to load is not loading anything, its just a blank form. No text boxes, no labels, nothing but the colours and the picture in the corner. I have put the code on the form to show me what data is going through and when following through with the first record it is showing me the correct data was transfered but when clicking any other record I am getting nothing. I have tried hunting for a solution for this but find it hard to know what to type to get the right information for my problem so I am sorry if this has been resolved before. Also forgive me for my patchy knowledge but I have taught myself everything I have done so far so it is probably just a step I have missed somewhere along the line.

Any Ideas?
'In Search Form on button click
Dim strWhere As String
If IsNull(Me.OrderRe... Read more

Answer:Search form not opening records properly...

16 more replies
Relevance 62.32%

I have a form (NewItemForm) that lets you create records by typing in Name, Description, PIN # and select Can Size, Upcharge and Price.

I want to be insert a feature that lets the user search the records created (specifically by PIN #) and pull up all information on that PIN # (form query "Form"-because that also includes the total and discounted prices).

Any help, or clear step by step directions would be great (I'm kinda new) thank you!

Answer:Solved: How to create a search of records in a form

Use the Combo Wizard to create a "Find Combo".

1 more replies
Relevance 61.5%

How do I disable paging through records as is the case in the “Orders” form of NorthWind?

I want to be able to control what data goes into the “Orders Subform” strictly thru what I pick in the “Bill To:” combo_box.

And the next question is: How do I control what goes into the subform using the “Bill To:” combo_box.. Some code out there?
Using Link Child and LinkMaster are not working for me.

Answer:How do I disable paging through records? See “Orders” form (NorthWind)

Why disable the forward and back buttons when this is what the form was designed to do - page through all orders and customers. The way you are thinking won't work with the current db design because the relationships aren't set up that way. There is a relationship of one to many (one customer can have many orders). Not to mention that they are differentiated by an OrderID

3 more replies
Relevance 61.5%

Hello, I am trying to accomplish the following with Access 2010: 1. Filter records within a table by typing characters that are contained in a text field. The text filter on the shortcut menu searches and returns records to suit me but I need it to make several selections. Combo box does similarly, but returns only those records that begin with the characters you type. 2. Select the desired record from those displayed and add that record to a current list. 3. Repeat filtering and adding until all desired records from the table have been added to the current list. 4. Displ the current list in a report or form for printing or saving as a text file. I will be grateful for any tips on the best way to do this.

Answer:Solved: Form to search & select records from a table

16 more replies
Relevance 60.27%

My database is used to complete reviews (evaluations) typically done monthly. My parent form hosts info such as the who's being evaluated, the Review ID, the reviewer's name etc.
The 5 child forms each have the same fields but capture the questions we answer during our evaluation.
Since there are about 50 questions total, it's rare that a reviewer will start and complete a review in one sitting. I have my database working now so that my 5 child forms have drop down menus to select their corresponding questions, and allow the reviewer to enter the score and comments. Everything then cascades up to the info on the parent form and all is good.
My problem is that when I close and re-open my parent form - the child records are no longer visible for that given parent record. They are saved in the correct table, however there's no way for the reviewer to know which questions have been answered and which remain. I would like all the records to be visible every time the form is opened.
I've set my Indexed field to Yes-No Duplicates, so I do get a pop up message if a duplicate is created, but it leaves the reviewer guessing what's been done and what hasn't.
How can I make the existing records visible when the form is opened?
And better yet, can I write a macro or code to automatically create the record for each of the questions I have to answer, leaving just the score and comment fields to be filled? (all other fields already auto-fill when the quest... Read more

More replies
Relevance 60.27%

I have built a form on table which will navigate showing data stored in each record in the table.

I need to restrict the edition of data while navigating records from the form. Edition can be permitted by clicking a command button for example (Edit) to change the stroed data.

Can this happen?

If so, please advise.

Answer:Controlling data edit of form objects while navigating the saved records

Unless you are going to use some kind of Password control I don't see much point in having the Command Button.
It can however be done.
You set the Form's "Allow Edits" to No and then use the Command Button's On Click Event Procedure to set it to "Yes".
me.AllowEdits = Yes

3 more replies
Relevance 60.27%

Hi all,

I have a continuous form in Access 2007 that's based on a query. My users want me to add 5 or more check boxes that will filter the records on the form when clicked. The check boxes should be able to filter independently and also have the ability to filter the records specified when say 2 out of the 5 are checked. The checkboxes are filtering one field of the query called CompanyArea which is the areas each company is in which is a number from 1 to 9.

So far my code is as listed below and doesn't work. I also have a text box named txtQuery that shows the SQL being run but so far it only shows that I've selected all records and not the query. Right now the code is stored in the on click event of a command button. What I would really like to happen is that when a user clicks the check box, the code runs. I know that would be the after update event of the check box but I figure it's best to get the code working on the whole and then worry about the after update of each check box.

Also I want Check112 to be a show all or remove all sorts and show all the records again. I also need check112 if checked to remove the checks from the other check boxes. Does that mean I should run the code for check 112 separately?

Any help is greatly appreciated. Thanks.


Option Compare Database
Option Explicit
Const strSQL = "SELECT * FROM qryCompArea"

Private Sub btnfilter_Click()
Dim strFilterSQL As String
strFilterSQL = strSQL

If Check106 ... Read more

Answer:Solved: VBA multiple check boxs filter records on a continuous form

13 more replies
Relevance 57.4%

I am a true beginner in access programming, so excuse if my methods isn't the best, and any advice would be much appreciated.

My main problem is displaying a Query I did on an attachment field in my main table on a form.
This is what i am working with:
Access 2007
My main table name : Table2
Attachment column name in Table2 : Target_photo
Query name: QuerySpecGraph (Query on the attachment field)

The query works perfectly fine when I run it and gives me the correct result. Now to display the query on the form I added an new attachment under controls and edited the control source to display the query results.

I used the function dlookup:


I tried similar code on a text box, with a text Query and that worked fine. However it does not want to work for the attachment.

Then I tried to analyze the situation to see if the query is the problem, so changed the attachments control source to:


this was to see if even a basic dlookup function works in the attachments control source, but yet again the attachments box stays empty (Again I tested the simple dlookup function with a text box to see if my table is the problem, but the textbox's dlookup works fine)

I do not know what I am doing wrong, or if it is even possible to do what im trying to do! Any advice would be much appreciated, and if there is away around this I will gladly explain in more detail ... Read more

Answer:Displaying an Attachment Query in a Form

12 more replies
Relevance 57.4%

Hi all

I have a simple Access (2003) db which has a single form view with a subform. The main form is a record based upon a physical case file the subform only details actions past and future, a sort of event log.

I also have a continuous form which displays all upcoming actions sorted by date on all cases for a particular user so they can see just how busy they are likely to be for a particular period. What I would like to do is have an on click() property for the detail of the continuous form so that it opens the main form filtered by the record in the continuous form that was clicked. User can then update or add new events for that case before closing form and returning to the continuous form

Hope this makes sense

Answer:MS access open single form filtered by selected record in continuous form

coasterman, welcome to the Forum.
It makes perfect sense.
If you add a Command Button to the Continuous Form and after selecting the mainform select the "Open the Form and find specific data to display". This will give you the code that you need to add to your On Click or On Double Click property or of course leave the button and use that.

2 more replies
Relevance 57.4%

thanks for taking a look at this thread, any help will be greatly appreciated by a complete Noob.

I've been given a LOT of help by members of this Forum (especially OBP) with a DB I'm making as a first look at any type of IT product, and I'm very grateful, so thank you all.

Recently, I was advised to take a look at the "Tabbed" style of "MainForm" instead of the "Switchboard" style I originally used. I must say, I really like the tabbed style much more than the switchboard but I've hit one hurdle that I can't seem to overcome.

In the Switchboard style, I was able to set a form to load in either DATA ENTRY = YES or DATA ENTRY = NO mode depending on which sub-switchboard the user selected. For example, I had a ENTER NEW sub-switchboard that all forms would open in DATA ENTRY = YES mode & I had another EDIT EXISTING sub-switchboard that all forms would open in DATA ENTRY = NO mode.

However, with the new tabbed style, I cannot set the form load type for separate tabbs, it will only accept the LAST type as the GLOBAL type. Example, on the ENTER NEW tab, I set the form to load as DATA ENTRY = YES & sets the form to open in DATA ENTRY = YES on both tabs, then I go to the EDIT EXISTING tab & set the same form to DATA ENTRY = NO & it sets the form to open in both tabs in DATA ENTRY = NO mode.

So, my question is:
Can I set the same form to load differently on different tabs on the same MainForm?
If so, w... Read more

Answer:Solved: MS Access - Tabbed MainForm - How to make a form open a form in multiple mode

I would just copy the Subform, so you have version 1 for data entry with the Data Entry set to "Yes" and version 2 set to "No".
The only thing you need to do then is to Requery the Editing form each time you make an entry in the data entry form.
Although I prefer to just have an Edit form with a "New Record" button for the data entry.

2 more replies
Relevance 56.99%


I have a subform which on its own - works beautifully but fails under the mainform. I use a main form to select the record that the end user wants to update. Upon update event on main form, the sub form opens, presenting fields for possible updating. The Sub Form also present 2 buttons - Save & Close or Cancel and Close (Undo). When the main form opens, the code set AllowClose as False. When the sub form is opened as a result of the update on the mainform, the issue is the Close command /code gets canceled. (Error 2501). I have tried: 1. setting AllowClose (true and False) on both forms, 2. only the main form and 3. only the subform. None of these 3 configurations resolves the issue. Also, I tried moving the buttons to the mainform instead of the sub form but that failed as well.

The application has a dozen forms and all of them utilize AllowClose functionality so the end user MUST use the buttons on the forms to force background queries (updates, deletes, perform calculations, recalc control totals etc). This is the first time I have tried to use Allow Close on a subform with buttons.

XP and Access 2007


Private AllowClose As Boolean

Private Sub Form_Load()
AllowClose = False
End Sub

Private Sub Form_Unload(Cancel As Integer)
Cancel = Not AllowClose
End Sub

Private Sub SaveChangeandCloseForm_Click()
AllowClose = True

Private Sub CancelAddingNewRecord_Click()
If Me.Dirty Then
End If
If Not Me.NewRecord Then
En... Read more

Answer:Action Canceled - Using AllowClose on Form and Sub Form - Access 2007

Why not just use a listbox to display the records based on the selection on the main form? I don't think you can actually close a sub-form on a main form since it is tied to the main form.

2 more replies
Relevance 56.99%

Morning Guys.

I am having a problem with Access 2007. I am not good with code, so would like to resolve this without using code if possible?

I have a form "A" that I have created. I want to be able to select a row on form "A" press a button and it will open a form "B" based on the selected record in form "A".

I have had a look at the button wizard, and it lets you have the option, but when you go through the wizard, it gives you an empty box on the left and a box on the right showing all the fields in the form "A". Nothing to relate to?

Any ideas?


More replies
Relevance 56.99%

I have a database which ultimately will have a couple of thousand records. The primary table has 30+ fields. I have lots of queries and connected reports to show various subsets of the data needed from the table. However, there are times when what is needed is all fields for a specific subset. Because the records sought often need to be filtered by several criteria, I've found the "Filter by Form" option to work well. I have a button on the main dashboard marked "Find Record" that automatically opens a search form in the "Filter by Form" mode. This allows me to enter information into as many controls as necessary, and returns exactly the right records after clicking on "Toggle Filters" on the ribbon. The problem is that ultimately I need to make this "Access-free". The goal is to create an application from the database without ribbons. I've created a button to run the filter, and another one to print the results, but when the search form is open in the "Filter by Form" mode, it greys out the buttons. I understand that there is a GotFocus command or something similar. Can anyone help with specifics, both the syntax of the command and where the command needs to be typed? Thanks a bunch...I look forward to your reply.

More replies
Relevance 56.99%

Hi all.

I am using WebEasy Professional 6 to design my website. I have inserted a form on my 'contact us' where clients can submit comments, however these comments display in html format when I view it in my inbox (Microsoft Outlook). Does anyone have any suggestions to correct this? Thanks!

Answer:Form on website displaying comments in html

Greetings, BexBomb.

Sounds like you've got something missing, most likely a bracket. Look for code similar to this:

<form>yada yada</form

Notice the missing > after the second "form".

If you can't find the culprit, post the address and I'll take a look at it, or you can validate the page at which should show any HTML mistakes on the page.

3 more replies
Relevance 56.58%

Here is what I'm trying to do.

For lists Equipment in drop down box.
Whatever equipment that is select, the equipment type field needs to be updated from a table.

Is there a way to get a value from SQL statement?

SQL = "SELECT [Equipment Type] FROM OrderDetails Where " _
& " Equipment = '" & Me.Equipment & "'"
[Forms]![OrderDetails]![Equipment Type] = SQL

Answer:Help with access form (insert table value into form field)

Mhouser, if you are trying to "display" a value related to the Combo selection you can have thta value as an extra column in the combo and refer to it with simple VBA.
You should not populate a Field's actual value with that from the combo as that is duplication.
Can you tell me which one you are trying to do?

3 more replies
Relevance 56.58%

I am a new user to Access 2010. My operation system is Window 7.
I have created a data base with two tables. The first table contains a list of students and their personal information. The second table contains student subjects and has many subject records with a relationship to the student record. The relationship key is the student id.

I have created a form that populates with the student information and contains a subform that populates with that students subjects. All of this works great for existing students. I can edit the student information and and new subject records.

Now here is my problem. I would like to create a form that preceeds my current form. The user would input a student number and click search button. If that student number exists on the student data base then the form that I created should open populated with the student data and their subjects and allow the user to update it. If the student number does not exist, then I would like that same form (or a form with the same layout) to open and the only data populated is the student number that was input on the search form. The user should be able to input all of the student data and course information and hit a save button that would insert the records into the correct database tables.

I have tried many methods to create the intitial search form that would open the correct version of the student form without any progress. Could someone provide me with the macro that would open that correct form, or set t... Read more

Answer:Access query to open Add form or Edit Form

needaccesshelp, welcome to the Forum.
First a couple of points, you do not need to "save" the record, access does so automatically. Also when creating a New record the subform should be automatically populated with the Student Number, this is controlled by the master child links.

The combo you need is a Find combo which can be created using the combo wizard, that combo can have it's Not In List Property set to yes, which can then be used to trigger adding the student that to the table and then to the form (and combo).

1 more replies
Relevance 56.17%


I wonder if you can help me with something. I have created a Form where there are 4 drop down boxes that collect data from 3 tables. How can I use that form to search for all the records matching one or more criteria chosen from those drop down boxes and display other fields on a report or a table?

The case is:

Table_Candidates (number of candidate, name, date of birth, address,…)
Table_Professional_Habilities (professional experience, years on the job…)
Table_College_Observations (College attended, degree, years, field of expertise…)

Form – Drop Down Boxes

Professional experience
College attended
Result Expected (How do I get this? In a table or a report, it doesn’t make a difference)

Number of candidate
Professional Experience
College Attended
Field of expertise
Age (how can I calculate this from date of birth?)

I've been advised to use Expression Builder. But the query isn't working because itreturns blank. Should I only select the fields on the Expression Builder (as an example, this is what it appears " [Forms]![New_Frm_Parameters_Selection]![Combobox17] "? Or should I make another expression?

Thank you very much.

More replies
Relevance 56.17%

Hi folks, I have a multipage form as part of an Excel development that requires checking the completion of fields on page 1 when a user enters page 2. All very straightforward I thought having done it many times before in word macros

eg If Multipage1(0).<variablename> = "" then
msgbox(<error message>)
multipage1.value = 0
End if

but no. The tab of page one is activated but the form controls displayed remain stubbornly those of page 2 and vb sicks up because it can't see <variablename>. The only reference I've found to this is that it was driving people mad and 'appeared to be a bug in XL2003'(sic) I'm using Office 2010.

Has anyone else had this problem, and more importantly found a cause/solution?


More replies
Relevance 56.17%

Computer:Del Vostro 430 runing Windows XP Pro Service Pack 3, Comodo Firewall, AVG Free.Following a malware infection (now cured, see,134485.0/all.html) I have a strange problem with Windows Files Search.  These two images show the Windows Files Search launched from Start > Search > For Files and Folders, and from Windows Explorer > SearchAs shown, the search form at the left is not displaying properly.  Somehow it is scrunched up vertically so that only a tiny part of the actual form can be seen.  The scroll bar of the form still works and I can get to all parts of the form but to use it is like doing keyhole surgery.  Also, the link for the alternative Search Assistant (the ?cute? puppy) is missing.What in the world could be causing this behaviour?  Any ideas are welcome.Keith

Answer:Windows Files Search form not displaying properly

Do you have your XP CD ? ?If so...from a command prompt type in sfc /scannow and hit Enter...let it finish and re-boot...The cute Puppy may even come back...

2 more replies
Relevance 55.76%

I am using an Excel worksheet with several thousand records listed. On a daily basis, I get an updated list, but I need to keep hold of some of the 'old' records.
At present I'm copying the new list, adding it to the end of my existing list and then filtering it so that only unique records are visible.
Obviously, this means the list is ever-increasing with many duplicated records (hidden or otherwise).
Is there a way to simply delete the duplicate records (so I can just keep one record of each) rather than hide them?


Answer:Solved. Excel 2000 - delete duplicate records?

15 more replies