|
Find Combo Box Almost Works All the Time
We have a students table [tblStudents] with approximately 4,500 records. On
frmStudents, we have a "Find" Combo Box that works 99% of the time. the Combo
Box uses the value of StudentID to find the student.
When two people have the same last name and a different first name, it will
only find the first person with that last name. For example, if there are 2
people with the following nam...
|
6 |
08.09.2006 18:25:01 |
|
|
Cannot Enter Data in a Field
Hello:
I have a simple flat file db that tracks Time & Attendance for me at work.
All of the fields have default values so I wrote a short "dirty record'
script that saves the new record. Without that script, the record won't be
saved.
Everything works perfectly except for the Note field [text]. I can no longer
enter a new note or edit an old note. I checked the form and the field is...
|
4 |
08.09.2006 18:20:01 |
|
|
Need Form and TextBox Help
I am new to the Access game and run across issues that I just do not
have a clue how to do...
On my form I have a Combo Box where the user selects a store number and
all the pertinent information in the textboxes fill in...this is for
viewing purposes only. I have 4 text boxes where the user will input
information for new data storage. This is running very smoothly. My
problem is this; I...
|
16 |
08.09.2006 17:58:37 |
|
|
Text Button Colour on Value
Hello All
Looking for a quick bit of advice ... I have a Form which currently contains
numerous buttons. I change the colour of the Font on each button using and If
loop ... ie if 0 then Green if greater than 0 red
If Startup.btn1.Caption = 0 Then
Startup.btn1.ForeColor = 32768
Else: Startup.btn1.ForeColor = vbRed
End If
Given the number of buttons on the form, I am seeking a way t...
|
5 |
08.09.2006 17:57:01 |
|
|
forms load slowly.
Hi,
I am an MS Access newbie.
I have a form with two subforms. Main form and subform both quries the
SQL db though ODBC link. When I run main form and subforms
independently, they are very fast but as soon as I put them together in
a single form (main form + subforms), it takes 3-4 seconds to load.
There are not any complex calculation involved.
Is there anyway I make this load fast or atle...
|
1 |
08.09.2006 17:42:11 |
|
|
forms loads slowly.
Hi,
I am an MS Access newbie.
I have a form with two subforms. Main form and subform both quries the
SQL db though ODBC link. When I run main form and subforms
independently, they are very fast but as soon as I put them together in
a single form (main form + subforms), it takes 3-4 seconds to load.
There are not any complex calculation involved.
Is there anyway I make this load fast or atle...
|
1 |
08.09.2006 17:42:03 |
|
|
Command Button color
Although Access provides many options to customize the look and format of a
Form, the "Command Button" is defaulted to grey with no optons to change its
color. It would be great it the user had the ability to change the command
button color/design in order to coordinate the look of a form.
----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
sugge...
|
4 |
08.09.2006 16:50:00 |
|
|
Form field problems
I have a table HYInReg which uses three forms, one for data entry, one for
data edit and one for data delete. I am also using the audit log function by
Alan Browne. By using this function I can create a log of inserts, edits and
deletions. The entry and edit forms work okay however I cannot get the
functionality of the delete form to work correctly.
I have an unbound combo box from wh...
|
4 |
08.09.2006 16:31:01 |
|
|
"Find" Function in Form or Datasheet
Help! I've got users who look up and print forms from a db I built some time
ago.
Users pull up records by a specific part number and print the form. This
form contains all necessary information for setting their machine up
properly. The only use for this DB is so they can look up and print the
records as needed.
I initially taught users how to use "Find" to locate a particular pa...
|
3 |
08.09.2006 16:27:02 |
|
|
Execute a query from a Form and output to Excel
Hi
I was wondering if it is possible to run a query and output it to Excel?
Kind Regards
Ricky
...
|
3 |
08.09.2006 14:29:21 |
|
|
Unwanted Deletion
I have a form for a timesheet application based on the following query:
SELECT Timesheet.StaffID, Timesheet.PeriodStartDate, Staff.UserName,
Staff.FName & " " & [LName] AS FirstLast
FROM Timesheet INNER JOIN Staff ON Timesheet.StaffID = Staff.StaffID;
In testing today, I deleted a record and was surprised that not only the
Timesheet record was deleted but also the corresponding record i...
|
3 |
08.09.2006 14:26:02 |
|
|
sorting records on a subform with a control in Access
I would like to be able to sort the records on a subform (in continuous form
view) using a control. For example, clicking on the label for the Date field
will sort the records by date ascending, and clicking on the Date label
again will sort the records descending. Clicking on the lablel for another
column will sort a different way. ...
|
1 |
08.09.2006 14:04:01 |
|
|
Form Structure Question
Here's what I've got:
tblEmployeeInfo (contains all employee info, name, ID #, company phone, etc)
tblTrainingRecords
chrEmpID (FK to EMP ID in tblEmployeeInfo)
chrTrainingTopic (lookup field to tblTrainingTopic)
chrTrainingDate
chrTrainingFrequency (New hire, annual, etc)
tblTrainingTopic
idsTrainingTopicID
chrTrainingTopic
I set the training record table up th...
|
2 |
08.09.2006 13:46:02 |
|
|
Data not visible in Text Box
I have a form that displays employee information that is linked to a table.
The problem is that when I open the form, I have to press the sort button to
get the first record to show. I have the underlying table sorted. It
appears there is a blank row at the top of the table & only goes to the
bottom when the sort button is pressed. What is the best method to prevent
this?...
|
2 |
08.09.2006 13:30:02 |
|
|
Compact & Repair: Now my forms add and delete buttons are greyed out
I have been running compact and repair for a long time, at least once a week.
I recently created a set of new forms, reports, and queries. Very simple ones
just did a save as and changed one set of criteria in each query.
Now when I run compact and repair all of my forms have the "add new record"
button greyed out and also the delete button. This is the case unless the
form doesn't call up...
|
3 |
08.09.2006 13:24:42 |
|
|
Triple State not working for check box.
Check box on tab, Triple State = Yes, break inside onclick event, click check
box and it's value is ALWAYS = 0.
Um... is there a bug here or is it me.
--
Regards
Tom...
|
5 |
08.09.2006 13:04:02 |
|
|
Dynamic forms..?
Hi all,
I've encountered a problem with an application I am developing in
Access. I have a series of tables that appear in a listbox on the left
hand side of my form. In the right hand side I have a subform showing
the contents of each table in a datasheet when the user clicks on a
table from the left hand side listbox. The user is then free to make
changes to the data in each table, wh...
|
4 |
08.09.2006 12:54:16 |
|
|
Show Combo Box Vertically
I was wondering if there's a way to show the fields of a combo box vertically
as opposed to horizontally.
I'd like people to select an address and it's more traditional to see the
address above the city....
|
5 |
08.09.2006 12:35:02 |
|
|
Data entry base on Listboxes
Hi,
I have an entry form consist of two listboxes, one for districts and another
one for communes. Both listboxes is set to allow multiple selection. Based
on the selected communes, I want to add these record to a table, my table
consist of 4 fields, \
ID AutoNumber
P_ObjectID Number Foreign key
P_DistrictID Number
P_CommuneID Number Foreigh Key link to Commune Tab...
|
2 |
08.09.2006 10:38:12 |
|
|
Capturing a form close
I have a form that starts in a listbox that has an onexit procedure defined
to ensure an item in the list is selected before continuing. If an item
isn't selected, a msgbox appears and the exit is canceled. But, when the
form is just opened and then closed (via clicking the 'X' or double-clicking
the forms icon), I don't want the procedure to run or want to put an if
statement in the p...
|
8 |
08.09.2006 10:35:30 |
|
|
Forms
I have a Bus Timetable Database in which i have 526 records relating to each
timepoint, day & time. I looks like this
Timpeoint Timepoint Name Day Service No Time On Off
1 Melbourne Sunday 27 9:00
2 Bendigo Sunday 27 10:30
3 Mildura Sunday ...
|
2 |
08.09.2006 09:36:13 |
|
|
Form and sub form last modified stamp
Hi All,
I have a main form and a sub form that my staff use for order entry. The
main form records the order header info and the sub form records the order
lines. I have added a last modifed date and time stamp to the header form
which works perfectly when i modify the header info but when i make changes
to the order lines in the sub form the stamp is not updated.
Can anyone sugges...
|
2 |
08.09.2006 08:47:13 |
|
|
Subform Combo box values filtered by form ontrol
I want to be able to display list values in a combo box within a subform that
are filtered by a control field in the main form. No matter how I reference
the control filed in the main form, I either get no data displayed in the
combo box or all the items available in the combo box with no filtering. I've
also tried setting up the same control in the subform and that doesn't work
either. ...
|
8 |
08.09.2006 07:30:03 |
|
|
Attendance database
Hi
I'm somewhat new to this so please advise what more you need.
I have a database set up with a form that has the following fields from a
lookup query based on staff code, staffname;
Staff code (shows staffname)(combo box)
Teacher (T or F)
Absence reason (value list)(combo box)-data entry
Absence start date-data entry
Absence end date-data entry
AMPMFull Day (value list)(combo b...
|
5 |
08.09.2006 07:07:01 |
|
|
Summing a calculated field
I have a problem I badly need help with. I'm using the Order Entry template
for Access an d have modified it like this. I have an Orders form with an
order details subform. The subform is like this
ProductName UnitPrice CostPrice Quantity LineTotal CostLineTotal
I'm reading CostPrice into this subform from a Products table like so
=[ProductID].column(3)
CostLineTotal is calculated li...
|
2 |
08.09.2006 01:19:50 |