To check all items in a subform
Hi,
I am currently using microsoft access 2003. The problem senario is
this: I am using a form with a subform. In the main form, I have a
checkbox. The subform also has checkboxes | | 0 | 11 | 11/11/2009 7:23:47 AM |
Where is the next control identified?
Screen.PreviousControl.Name provides the name of the control that last had
the focus. That's nice if you need to know where control came from, but
there doesn't seem to be a Screen.NextCo | | 0 | 17 | 11/11/2009 4:55:32 AM |
Data Entry form and show old records
Hi;
I have a form for data entry which displays blanks for new data to be
entered which is fine, however it would be nice if it also showed the most
recently entered record, but grey | | 0 | 15 | 11/11/2009 3:39:37 AM |
Can't get debug to break
I asked a similar question recently, got no answers. I rebuilt the form
(Header/detail) using the wizard, this time with the final form name I wanted.
I added three buttons, and a cou | | 0 | 9 | 11/11/2009 3:39:36 AM |
Creating "key" fields when met, unlock the next step...
I am researching how to create veritable "gates" in a database so that when
someone initilializes the process filling out a form, they cannot progress
beyond a certain point in t | | 0 | 12 | 11/11/2009 3:28:10 AM |
Is there a way to center (horizontally) items in a list box?
I want each individual item in the list box to be centered horizontally. I don't see any properties that allow me to do this, nor any VBA code I can apply. When I tried adding leading blanks and usi | | 0 | 16 | 11/10/2009 9:30:36 PM |
scroll to click on the tab page in the subform/subreport
dear
I am new in access, i am having a minor problem, i dont know if i can
discribe it well,
i have created a subform with many pages and in each page a form is
added.
o | | 0 | 15 | 11/10/2009 8:00:53 PM |
Search for records
I am an Access novice. How do I create a simple form to search for specific
records in a table without the risk of updating existing records? Thank you.
| | 0 | 16 | 11/10/2009 7:12:35 PM |
Incomprehensible OpenArgs behavior
Incomplrehensible to me, at least. I'm hoping wiser heads will offer
advice.
I have a form (frmCirculars) that displays individual records of
correspondence (circulars) in single | | 0 | 12 | 11/10/2009 6:10:50 PM |
Text Box populate
I would like to know how to get a text box to populate the field from the
previous text box. Example: I have a text box call Store ID so the first
record I put in a Store ID number and I | | 0 | 14 | 11/10/2009 3:58:32 PM |
Filtering on more than one field
I need help filtering more than one field on my form.
Table Names and Info:
Data (has all the patient info. including type of device and country)
Countries (list all 81 countries | | 0 | 14 | 11/10/2009 3:24:17 PM |
Tab Control
I'm attempting to have two tabs on a form and I've cut and paste a form from
a separate database into my page1 form. My problem is the data shows on
both pages, almost transparent to the | | 0 | 16 | 11/10/2009 3:12:21 PM |
If duplicate value apply conditional format
Hi
I'm really struggling with a project at the moment. The database I'm
working with has a concatenated Primary key of Registration Date and Customer
ID Number. It MUST stay t | | 0 | 17 | 11/10/2009 12:42:09 PM |
Expiry dates sql problems
dear all,
I am doing something wrong but i dont know what is it :( i am new in
access .
i am trying to get the expiry dates list of today in order to renew
it
in t | | 0 | 16 | 11/10/2009 8:50:31 AM |
Add data range
I have been searching for ages, and have not been able to find anything
exactly like I want, any suggestions would be greatly appreciated!
I have a data entry form based on table: Lo | | 0 | 10 | 11/10/2009 7:49:17 AM |
2003 Multiple sub forms 2 update perfectly the 3rd does not
I have a database which has a form which should update 2 sub forms on the
same screen one works perfectly the other works but not correctly
Is there any reason for this?
They are | | 0 | 14 | 11/10/2009 7:49:15 AM |
Before Update vs OnExit
I have a form where all of the fields must be completed before 1. going back
to the Find dialog box (to find a new record to update) or 2. closing the
form. In reviewing the threads for the | | 0 | 15 | 11/10/2009 7:49:13 AM |
Form wizard not showing both tables - Access 2007
I am working on a client's database and want to have a button on one form
open another form and relate it to a specific field. I have the code working
correctly. However, the client mentio | | 0 | 11 | 11/10/2009 7:49:11 AM |
Calculating "Workdays" in an Access 2007 Form?
How do I calculate the number of work days between two dates using the
"Workdays" function in an Access 2007 Form? Right now, I'm getting the
"#Name?" error when I use | | 0 | 19 | 11/10/2009 7:49:10 AM |
Problem with Expression
Good afternoon,
I have a parent form with 2 list boxes and 2 text boxes that supply
information to an expression located within a calculated control in a
subform.
Li | | 0 | 15 | 11/10/2009 7:49:09 AM |
How to get each item, Last date it was sold
Hello All,
I need a list from All the Items in the Inventory, the Last Date each item
was sold, and the qty sold on that date.
Doug Steele told me to use a subquery, it works fine | | 0 | 16 | 11/10/2009 7:49:05 AM |
If subform dirty, field in main form visible
On my main form (frmBenefits), I have a subform (subActions) that is
continuous. Either when the the subform receives focus or if the
subform is dirty (I don't care which), I would like a f | | 0 | 14 | 11/10/2009 7:49:01 AM |
Refresh data on form
Hi,
I have DB, and I made form for searching specific data. It's form where I
choose value from Unbound field, and then other fields have been filled. But
I want then to change value | | 0 | 12 | 11/10/2009 7:49:00 AM |
checking a field in a form before update
In an existing form that shows teacher details, there is a field for the
teacher id number (similar to a social security number). This field is shown
in a text box but until now has never b | | 0 | 11 | 11/10/2009 7:48:56 AM |
How can you set tabs between subforms so they will tab to next for
I have created a form and added 4 subforms to it. How can you get the tabs
from one form to land in the next form without clicking the next form to
activate it?
Hope I'm explai | | 0 | 15 | 11/10/2009 7:48:49 AM |
TOTAL package PER DAY AND PER HOUR
Hello,
i have a list a list of employees along with salaries, in the query i
have calculated the total of package using:
nz([Basic Salary])+nz([Overtime])+nz([Transportation])+nz
( | | 0 | 16 | 11/10/2009 7:48:48 AM |
Conditional Formatting
Hi All,
here's the current problem:
I have a form with a tab control which itself shows four instances of the
same subform (with different recordsets).
I've curr | | 0 | 14 | 11/10/2009 7:48:46 AM |
bookmark bug access 2003
Hi,
I am using Access 2003 11.8166.8221 SP3. Can anyone confirm or deny if the
bookmark bug has been fixed in this version? I am using the bookmark in a
form to locate records and | | 0 | 10 | 11/10/2009 7:48:44 AM |
Textbox: Max Column Value, Except...
I need a textbox to show the highest value of a column within a table, but
exclude the values: 000, 994, 995, 996, 997, 998, and 999
Thanks
--
Message posted via http: | | 0 | 13 | 11/10/2009 7:48:43 AM |
Combo Box Compile Error
See code below
Private Sub Combo30_AfterUpdate()
Me.Child32.RowSource = "SELECT Form FROM" & _
" tableComplaintTypes WHERE Com | | 0 | 17 | 11/10/2009 7:48:42 AM |
Is it an Ms Access bug?
Hello Forum users,
Any advise on the following will be much appreciated:
I have a customer who has created a form in Access which contains two combo
boxes. Then 2nd combo m | | 0 | 12 | 11/10/2009 7:48:36 AM |
Expiry dates query
Dear all,
I have a list of employees along with a list of expiry days
example
ID Passport expiry date Driving License expiry Date
Insurance Expiry Date
5001 | | 0 | 16 | 11/10/2009 7:48:35 AM |
Forms & subforms
I have created a master form and a subform. The subform displays the correct
information for the first record in the master form. In the master form I
can not move to a new record. Any | | 0 | 16 | 11/10/2009 7:48:30 AM |
After Update Event
is this possible?
I have a Main form with a tab cntl with two subforms frmInvoiceDetail and
frmPayments.
Both Subforms are continous forms.
on frmPayments I have | | 0 | 11 | 11/10/2009 7:48:29 AM |
importing text files into access and generating queries and reports
I have 50 word documents in Word 2007 format. The data in the word
files is in a table of two columns and 10 rows consisting of
paragraphs which is basically a report how a unit in our compa | | 0 | 10 | 11/10/2009 7:48:27 AM |
How To Move To Last Record in Form
I have a form which is bounded to a table. I have a button on the form
which will add 7 addition records to the table and update the table of the
form. After clicking on the button to a | | 0 | 12 | 11/10/2009 7:48:26 AM |
Adding value of ComboA and ComboB then dividing by 2
Hello, I have a problem with a database I'm working on. Okay, I'll try to
explain it:
I created a form and it has a drop down with default values of 0,1,2, or 3.
Depending on that v | | 0 | 14 | 11/10/2009 7:48:25 AM |
Add up all the values in one column on a form
In an event handler, how do I add up the value of a column for all the rows
in a (filtered) form?
--
Jim
| | 0 | 15 | 11/10/2009 7:48:24 AM |
Event won't fire
I have a very simple form. It's a header/detail structure with PO Header and
PO Lines. PO Lines is presented on a subform in continuous forms. Whenever I
change a line, I want to add up th | | 0 | 18 | 11/10/2009 7:48:23 AM |
Color of the backgroud
Hi,
I'm using Access XP and I notice that I have limited selection of
color.
Is there a list of many code or box to pick any colour "light to
dark" ?
Can you help wh | | 1 | 79 | 2/6/2008 8:06:11 PM |
How do I turn on Autocomplete in Access 2003 Forms?
How do I turn on Autocomplete in Access 2003 Forms?
| | 3 | 114 | 2/6/2008 7:59:01 PM |
Update Command Button Caption
I am having troubles getting the caption on a command button to automatically
update.
I have a sub form with checkboxes that need to update the command button's
caption on the main | | 1 | 75 | 2/6/2008 7:55:04 PM |
Open selected records via listbox
Hi,
I don't have a lot of experience with Access. I would like to open records
based on a selection in a list box and then make a report. This can also
happen in one step.
| | 9 | 62 | 2/6/2008 6:38:49 PM |
Looking for lost free shortcut icons
Some time ago I had found a collection of icons that could be used for
shortcut menus and other uses. They were a very nice set for free and not
the usually cutsey crap that seems to be out | | 0 | 80 | 2/6/2008 6:21:07 PM |
Access 2002 Runtime Spellcheck w/Office 2007
I posted this previously and get no response. Not sure if my question is
worded poorly or if this is the wrong forum, but I'll ask again:
I have the Access 2002 runtime installed on my | | 9 | 82 | 2/6/2008 5:30:02 PM |
Add Records Sequentially with DMAX
Where is the proper place in my form to add the following
Area Table CostCodeLast3 CostCode
1000 001 10-001
1100 001 11-001 | | 2 | 75 | 2/6/2008 5:05:12 PM |
Can I add to a drop down list like a new status that is not shown.
I am using Time and Billing form. I would like to be able to add to the drop
down status menu which already gives me some options but I need some to cover
warranties. How can I add an ite | | 1 | 95 | 2/6/2008 5:00:02 PM |
Query Row number don't wotk with duplicate name
Hi there,
How do I get query rows numbers?
I follow the Qry Sample that Microsoft provided
Rank: (Select Count (*) from qryNewWarehousechart Where [WK0] <
[WarehouseChart].[ | | 1 | 80 | 2/6/2008 4:52:26 PM |
ole field corrupt
When I try to add an image to the ole field, I get an error message: "Cannot
open database. It may be not be a database that your application recognizes,
or the file may be corrupt"
| | 0 | 96 | 2/6/2008 4:06:00 PM |
Prevent maximizing
If Form A has been opened and the user has maximized it, how can I prevent
Form B from opening in a maximized state?
| | 4 | 64 | 2/6/2008 2:05:05 PM |