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 | 47 | 11/11/2009 7:07:26 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 | | 1 | 48 | 11/11/2009 5:13:03 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 | | 1 | 55 | 11/11/2009 3:59:17 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 | | 4 | 50 | 11/11/2009 3:33:02 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 | 45 | 11/11/2009 3:29:30 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 | 53 | 11/11/2009 3:25:37 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 | | 3 | 55 | 11/11/2009 1:01:10 AM |
Create subform default values based on value set in main form Hello,
I have a form into which summary data is entered, on which there is a datasheet-style subform for entering related records. In many cases, one of the fields in the main form m | | 14 | 57 | 11/11/2009 12:26:53 AM |
how to cause checked yes/no items to appear in a list in another part of th e form... I have a form with many yes/no checkboxes on it. if the user has had an issue with a particular item, he checkes the box under that item. I'd then like to have a list box on another part
| | 8 | 33 | 11/10/2009 9:58:37 PM |
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 | 54 | 11/10/2009 9:27:44 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.
| | 1 | 46 | 11/10/2009 8:09:53 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 | 46 | 11/10/2009 7:56:06 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 | | 2 | 42 | 11/10/2009 7:39:48 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 | | 2 | 48 | 11/10/2009 7:35:01 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 | | 1 | 46 | 11/10/2009 6:00:28 PM |
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 | | 3 | 51 | 11/10/2009 5:59:02 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 | | 3 | 48 | 11/10/2009 5:51:56 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 | | 1 | 44 | 11/10/2009 4:55:01 PM |
Radio Button Problem Hi again guys,
I've got a form which, among other controls, has two radio buttons
beside each other with the labels 'Active' and 'Inactive'. This relates to
whether a member of | | 12 | 36 | 11/10/2009 2:11:24 PM |
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 | | 1 | 48 | 11/10/2009 1:54:52 PM |
Want a Parameter for date range driving a cross tab query Hi, I have a form with two text boxes called txtStartDate and txtEndDate. I have a query called qryCuffsShipped1 with a date field called DateShipped. In the criteria area in design vie | | 2 | 50 | 11/10/2009 12:53:02 PM |
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 | | 2 | 39 | 11/10/2009 9:28:01 AM |
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 | 41 | 11/10/2009 8:48: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 | | 3 | 47 | 11/10/2009 6:28: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 | | 1 | 50 | 11/10/2009 5:11:14 AM |
populating field Hello,
i would like to be able to automatically populate a field in a table from a
form
the fields are as follow:
FirstName
LastName
E-mail
i am able t | | 3 | 55 | 11/9/2009 9:57:02 PM |
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 | 46 | 11/9/2009 9:35:02 PM |
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 | | 3 | 61 | 11/9/2009 9:34:01 PM |
Using form for searching, and then for changing records Hello,
I need to make form, which I will use first to search from tables, and when
I find it, I need to change some paramethers about it. How to do this?
I already made form, but when | | 2 | 50 | 11/9/2009 9:31:02 PM |
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: | | 5 | 48 | 11/9/2009 9:23:43 PM |
Textbox in an Update Form I have 2 text boxes in my updatable form that I want ask about.
1st one is "Register Date" and the other is "Actual Date".
How can I create the "Actual Date&qu | | 1 | 46 | 11/9/2009 9:23:02 PM |
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 | 47 | 11/9/2009 8:42:08 PM |
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 | | 2 | 43 | 11/9/2009 4:07:01 PM |
Combo Box Compile Error See code below
Private Sub Combo30_AfterUpdate()
Me.Child32.RowSource = "SELECT Form FROM" & _
" tableComplaintTypes WHERE Com | | 3 | 53 | 11/9/2009 2:55:04 PM |
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 | | 3 | 44 | 11/9/2009 2:26:02 PM |
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 | | 1 | 47 | 11/9/2009 1:51:02 PM |
Still struggling with DCount I am still strugling with understanding DCount. I don't know why I can't get
it.
Does DCount work in forms and subforms? If so, what is wrong with this:
DCount("[Amout | | 10 | 36 | 11/9/2009 12:32:00 PM |
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 | | 1 | 50 | 11/9/2009 5:50:08 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
( | | 1 | 40 | 11/8/2009 11:05:13 PM |
Create form using query doesn't fill fields Hi, I have question, I want to create form using query. I made a form in which I choose from one table field, and then the other fields on my form should be filled in with appropriate ro | | 9 | 36 | 11/8/2009 8:47:02 PM |
Right and Left Arrow Keys I have a form with two command buttons:
cmdNextRecord cmdPreviousRecord
Is there coding out there that will allow the user to control the command button "cmdNextRecord&q | | 4 | 60 | 11/8/2009 4:29:32 PM |
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 | | 1 | 51 | 11/8/2009 6:06:17 AM |
Yearly Forecast Query Hi I wonder whether someone can help me please.
I would like to create a query, which will in turn feed a report, that shows spend forecasts across the year.
The table called tbl | | 1 | 52 | 11/7/2009 7:58:34 PM |
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 | | 2 | 50 | 11/7/2009 3:39:01 PM |
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 | | 1 | 49 | 11/7/2009 1:55:04 PM |
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 | | 2 | 50 | 11/7/2009 4:38:01 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 | | 1 | 48 | 11/7/2009 1:35:47 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 | 51 | 11/7/2009 1:03:01 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
| | 1 | 46 | 11/6/2009 10:26:26 PM |
Required data on subforms Hi group,
I have an Access parent form with two subforms. I'm wondering whether
there's a way to "force" people to enter data on one field in each
subform, or else not | | 2 | 44 | 11/6/2009 9:06:10 PM |
change label format based on control it is attached to I hve a form that has checkboxes for all 50 states. Because individual
checks are hard for the user to see, I color the label of the field
when the box is checked. When the form is open and | | 2 | 53 | 11/6/2009 8:16:25 PM |
FormBased On A Query Hi all,
I have posted this question before, but I might not have posted in the right
group.
I hope I get an answer from this group.
I have two tables, tblCusto | | 1 | 51 | 11/6/2009 7:56:01 PM |
Help with Update Query I have a imported table from a SQL DB that I need to remove part of the data
from a field and leave the rest.
The data in the field is SERVICE CONTRACT NUMBER 5035764A09, I just need the
| | 8 | 47 | 11/6/2009 7:14:08 PM |
One Combo Box won't work?? Hi, I have a form with 12 Combo Boxes and the last one won't work. Well it works but won't update the table/list if a new entry is added. All the others are the same using the same code in the | | 8 | 40 | 11/6/2009 5:56:12 PM |
not able to save/added text box or label in design view of some fo I have inherited a database and want to modify some forms - I looked in the user groups and permissions and everything show editable- nothing set up in here - prev. user not adv. enough to | | 6 | 34 | 11/6/2009 5:26:02 PM |
parameter to populate 2nd combo help please :(
i have a form (clerkdataentry) with a combo box (cboCDSinitials) that asks for an autior's initials.(cdsinitials)...works great but.... i want the second combo box to | | 2 | 48 | 11/6/2009 5:24:02 PM |
Delete record when form control becomes invisible Greetings,
I have 2 forms (frmContibutors & frmEnterNewContrib) that each allow data to
be entered into a table (tblContributors). This table has a relationship with
another | | 2 | 44 | 11/6/2009 2:57:01 PM |
how do i get listbox selected data into table I have a form with an unbound listbox (0) set to simple for multi select, that I populate it from a table that contains boardmembers. the query has 2 fields the boardmemberid and a concatena | | 3 | 36 | 11/6/2009 2:45:17 PM |
Problem with filling form using query? Hi, I have form based on query. I want to choose value in one field on form, and then the other fields on form to fill with appropriate values (one row from table). I made query, I tried | | 1 | 49 | 11/6/2009 2:28:02 PM |
Conditional Formatting of a subform within a subform Hi,
am pulling hair out trying to get this to work!
I hvae a nested form as below:
frmMainBrowse
frmMainComboBox
frmData
frmManu | | 0 | 60 | 11/6/2009 12:31:01 PM |
Fill in form using query Hi, I have form based on query. I want to choose value in one field on form, and then the other fields on form to fill with appropriate values (one row from table). I made query, I tried | | 2 | 53 | 11/6/2009 10:52:01 AM |
Modifying subform's underlying SQL statement aI am trying to make modifications to the the SQL statement underlying a subform. I make changes using the query builder. However, after I make the changes and save the updates my changes j | | 2 | 59 | 11/6/2009 4:30:01 AM |
option button to control form query Hello all-
I have two identical forms. They only differ by the select statement in their queries. I would like eliminate one of the forms and use a radio button in the footer to c | | 3 | 44 | 11/6/2009 4:02:02 AM |
Programmatically change combo box sorting I am looking for a way in Acc2003 to change the sorting of a combo box, depending if the user holds down the Shift key when clicking the combo box (i.e. no shift key = sort order (A), shift ke | | 4 | 66 | 11/6/2009 3:00:31 AM |
Form to Multiple Tables Issues I have three tables and I want to use one form to enter data into all tables. First table is actually going to be imported from a template excel file Second table is going to be entered from t | | 1 | 44 | 11/6/2009 1:22:33 AM |
Use listbox selection for query criteria
I have a listbox that shows a list of regions, I am trying to create
a query that will use the listbox selection to only show records that
are in that region. I want to use this quer | | 3 | 69 | 11/5/2009 10:51:27 PM |
Is my query at fault for a slow form? It never fails, I build my database to the best of my abilities, and once I split things move terribly slow. So I once again come for assistance. I've going through the steps of things to | | 8 | 32 | 11/5/2009 10:25:02 PM |
Show all records I have a form that has drop lists. Users will use a list to choose an item, then the associated query will filter by that item.
Two things:
1) How do I get the list to make | | 12 | 38 | 11/5/2009 10:19:00 PM |
If, Then, Else Hi,
I'm a bit confused and hope someone can help. I'm just learning code and can't figure out why I keep getting an compile error; Else Without If on the following code. Thanks in | | 3 | 41 | 11/5/2009 9:36:04 PM |
Can update one form but not another I am using Access 2003. I have two nearly identical (as far as I can tell) forms, but one will allow updates and one will not. They seem the same in every important particular:
both f | | 3 | 53 | 11/5/2009 9:27:52 PM |
combo box and saving to table I can select 1 value from a 2 column combo box and save it....no problem. I can even display the 2nd value of the combo box in a text field. But, is there a way to select 2 values from the | | 3 | 62 | 11/5/2009 9:18:29 PM |
Unique Value not Showing Up, Repeating Information I am creating a form based upon three related tables.
The first table lists students with their 2 primary department interests. The second table contains grade information. The third t | | 1 | 44 | 11/5/2009 8:52:04 PM |
Automatically populate a field based on 2 others I have a form on which we log employees' time spent on a certain part. In a separate table I have the following fields: Number sono lineno
The field "Number" is an Auto | | 9 | 40 | 11/5/2009 8:44:25 PM |
Choose rcd using cursor position I have a form with multiple transactions displayed. The user enters an expense category for each of the transactions. At times, a transaction needs to be split out to multiple expense cate | | 0 | 54 | 11/5/2009 6:53:02 PM |
Creating a Form from a Table 2003 I am new to Access. I created a table with the appropriate fields which include a couple of drop down menus. I then created a form for data inupt. I realized that I had left a couple of opti | | 3 | 58 | 11/5/2009 5:50:43 PM |
Can't pull all the I have a form to search the studentId and then display in listbox or combobox for order# and orderDate but it only display one record. I would like it to display all the order# by the studen | | 2 | 51 | 11/5/2009 5:26:01 PM |
Require Field if another field is not blank I am having some troble with my code within a form. What I am trying to do is diplay a message box and require entry for a field when another field has an amount greater than zero.
| | 2 | 51 | 11/5/2009 5:23:55 PM |
List Box Right Alignment - is it possible? Hi, I am using a sub to create a list in a form. There are a few columns with numbers and I need them right aligned. Is it possible? Thanks Mitja
Code: Me.ListN.ColumnCou | | 3 | 64 | 11/5/2009 4:13:01 AM |
Limit decimal places without format statement I wish for my query to display two decimal places without truncating the original data. I've accomplished this goal by using the format function in the query, but this function converts the nu | | 5 | 46 | 11/4/2009 9:29:48 PM |
cant add new records to a form Hi
Please forgive me as I am a access newbie. I just moved an access 2003 database onto a SQL server. I am now using the database as a access project with access 2007 with a sql bac | | 3 | 52 | 11/4/2009 9:29:01 PM |
Cascading? Hi,
I have a form that has subform with it. I would like the CLN on the main form is cascade to the CLN on the subfrom. Somehow the subform don't show the ClinicNumber that shows on | | 1 | 54 | 11/4/2009 9:26:01 PM |
User Sets Control Default Value I would like my user to be able to set and lock default values for controls in a data entry form so that repeated information is entered automatically. I have a form that asks the user to e | | 1 | 49 | 11/4/2009 7:48:27 PM |
default values in combo box with multiple colimns Hi, I have a combo box (cmbSEG_ETY_ID) that is filled with values from a table SELECT RPT_EMPLOYEE_TYPES.ETY_ID, RPT_EMPLOYEE_TYPES.ETY_NAME FROM RPT_EMPLOYEE_TYPES; (employee ID and emp | | 1 | 71 | 11/4/2009 7:30:02 PM |
Form Detail disappeared Hello,
I have created a form that has been working just fine. I went to do a print preview and the only items I can see are the page header and the page footer. Can anyone tell me i | | 2 | 55 | 11/4/2009 6:15:48 PM |
Sum() I have a fairly simple form with a query as a control source. The query includes two calculated columns. They work perfectly. When I change one of the fields in the row that's part of the ca | | 5 | 49 | 11/4/2009 5:21:01 PM |
Continuous Forms I have a form that is based on a query.
The Fields involved are: ClassID (Class Query) Class Name (Class Query) Assignment (Assignment Table) Max points(Assignment tale)
| | 2 | 50 | 11/4/2009 4:49:02 PM |
93 Hosting Web www.ivys.es Hosting Web www.Ivys.es Hosting Web www.Ivys.es Hosting Web www.Ivys.es Hosting Web www.Ivys.es Hosting Web www.Ivys.es Hosting Web www.Ivys.es Hosting Web www.Ivys.es Host | | 0 | 100 | 11/4/2009 11:50:16 AM |
Preventing Form from moving I have a master form with tabs, most of which have subforms on them. One of them has no subfrom, but a control that isn't linked to the master table. When I use the keyboard shortcut to go | | 1 | 48 | 11/3/2009 9:23:50 PM |
combobox display item when not in list Hi all,
I have an application where combo boxes are filtered by groups (I have a
Group table and also a Level table). I also have a check box (yes/no field)
for Shared Project. For | | 1 | 50 | 11/3/2009 9:18:34 PM |
Form that Runs a Query. I have set up a Form that has a combo box. When something in selected in the combo box it automatically runs a query. The problem that I am having is that I don't believe that the query is | | 8 | 49 | 11/3/2009 8:08:05 PM |
Print all Forms Is is possible to print all forms in my database using a command button?
--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-forms/200911/ | | 1 | 97 | 11/3/2009 8:03:06 PM |
Conditional formatting with SQL Select from another table Hi,
I trying to set the font color in a textbox using this "Expression is":
[txtProdAvailableDate]<=Date() And [ProdAvailableChk]=-1 And
[txtProdAvailableDate]<(S | | 2 | 73 | 11/3/2009 6:54:04 PM |
Combo Box, Unbound Text Boxes I have a form that has a Combo Box for Contractor. The form works alright
filling in the unbound text boxes with the first name, address, city, state,
etc... after the last name is chosen | | 3 | 45 | 11/3/2009 6:22:57 PM |
Update a field for all records in a form I have a form that has a textbox in the header that I populate with a value.
I'd like to have a command button that then updates a specific field for each
record displayed on the form with t | | 1 | 73 | 11/3/2009 5:42:58 PM |
DCount problem redux Greetings, a week or so ago I tagged a question onto another thread about a
DCount problem and I got an answer that I am having a problem with. I had to
go out of town and so I have left t | | 4 | 41 | 11/3/2009 2:19:23 PM |
DDE function works in A2003 but not in A2007 I am having trouble converting a database that uses the DDE function from A2003 to A2007. After much frustration, I eliminated as many variables as I could by creating a new database with n | | 2 | 55 | 11/3/2009 4:52:01 AM |
Access Database size limits linking to SQL server I have a database that was 1.8 Gig in size, I moved all the larger tables to
SQL Server and linked them to my Access Database. Now when I run the Access
Database to append my table on SQL se | | 6 | 47 | 11/3/2009 3:49:34 AM |
buttons do not show I have a form that has a subform that is in datasheet view. there are three
buttons on bottom of parent form and in design view they show but in run mode
they do not. I have moved them t | | 1 | 52 | 11/3/2009 3:37:41 AM |
TEST TEST
| | 0 | 44 | 11/3/2009 3:30:08 AM |
Cascading Combo Boxes - How to deal with one being empty? Hi again,
I have a set of three cascading combo boxes for the following;
Supplier Code, Doc Number, Revision
all is working great, but what I'd like to do is allow the Doc N | | 5 | 40 | 11/2/2009 10:43:50 PM |