Help Linking Subform and Form
Below is a sample of my coding in my program. What happens is when I make a
selection in a field in my subform..it opens a form that reveals only the
information needed for that particular | | 0 | 16 | 11/11/2009 3:39:34 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 | 13 | 11/11/2009 3:39:33 AM |
Images in MSFlexGrid
I'm looking for a simple way to resize images to fit in cells in MSFlexGrid.
Currently I have no trouble loading the images, but they are cropped because
they exceed the size of the cells | | 0 | 15 | 11/11/2009 3:28:09 AM |
Access 2000
I must be daft. On Google and Access help I've found everything there is to
know about the AllowShortcutMenus property except how to use it. What is it
a property of? Application? CurrentP | | 0 | 12 | 11/11/2009 2:20:22 AM |
Add Record from Event Procedure
I am trying to modify an existing database. There is a form with a subform.
I have added a combo box at the bottom of the main form called
txt_add_employee. I want the user to be able to m | | 0 | 20 | 11/10/2009 10:28:35 PM |
suppress 12:00 time
I use a single column for both date and time of events. I have two fields
(one for date, one for time) and the formats of the fields are set to just
show a date or a time, not both.
| | 0 | 12 | 11/10/2009 6:24:41 PM |
Dcount type of function on a form
What can I use on a continuous form to tell me when there are no records on
the form? I can't dcount the underlying query of the form, because the user
might further filter records on the | | 0 | 15 | 11/10/2009 5:56:47 PM |
multiple subforms linking
I've had a wee look around all the posts on here but I seem to be going round
in circles so I'm sorry if the answer is already out there! I'm also a bit of
a (pretty much self-taught) acce | | 0 | 16 | 11/10/2009 5:10:42 PM |
Three state bool
I thought I've seen some sort of tree state bool field type,
electronics speaking hi, low, hiZ..
Just my imagination? If it exists, can it be bound to a checkbox (yes,
no, grey?). | | 0 | 12 | 11/10/2009 12:52:28 PM |
Syntax error
Hi,
Could someone help me to correct the following line. Thank you.
intYounger3Y = DCount("[Name]", "tbRegVacc", "[Birthdate]< DateAdd("y" - | | 0 | 12 | 11/10/2009 9:26:33 AM |
Form and Subforms link Problems..
Good day to everyone!
Ok, before I start, please take a look at my table...
tbl_Operating_Units
Unit_ID
Operating_Unit
Acronym ==== (ex. BAS, ATI | | 0 | 15 | 11/10/2009 7:48:20 AM |
Return "No Matching Records"
I have a form based on a query. When it opens, if the underlying query has no
records, I have a macro that conditionally uses DCount("*","frmCalendar1")=0
to successful | | 0 | 14 | 11/10/2009 7:48:20 AM |
Populating Combo Box With DB Objects
Access 2007 sp2.
I want to populate a combo box with Database objects and have that object
open when
selected in the combo box. I'm not sure where to begin.
For instance, I | | 0 | 15 | 11/10/2009 7:48:16 AM |
acSaveRecord issue and required fields
i have a button for exporting a single record into a report and e-mail... the
problem is that when the record needs to be saved first, but i don't want
this to be allowed without all the req | | 0 | 11 | 11/10/2009 7:48:15 AM |
Transfer Spreadsheet Issue
Hi All,
I am having trouble with the transfer spreadsheet function. It was working
fine when i had it pointing to my C:/ drive but when i tried to switch it to
my shared M driv | | 0 | 14 | 11/10/2009 7:48:12 AM |
set reference with VBA
Hi,
Could someone tell me how i could set references with VBA code in the
starting procedure of an application so that it will run on computers where
the users have not set the | | 0 | 11 | 11/10/2009 7:48:12 AM |
Force Update of Subform Data
I have a form with the following contents:
* "Start" and "Stop" time fields
* frmNavButtons subform with custom navigation buttons that include record
validation
| | 0 | 13 | 11/10/2009 7:48:09 AM |
Combo Question
I have a 3 colum combobox and have the first column set to 0 to hide it, and
it is bound to column 1. Works just as I want it to.
However, when he dropdown list is visible, I have it | | 0 | 12 | 11/10/2009 7:48:08 AM |
Calendar 12 AfterUpdate Function Missing
Hi,
I'm trying to use the Calendar function to requery a subform but there
doesn't appear to be an AfterUpdate function to carryout and tasks when the
date changes. The only eve | | 0 | 15 | 11/10/2009 7:48:07 AM |
How do I select hidden fields
I'm in Access 2007. I have a form I'm designing and I've got several fields
hidden behind other fields. How do I select them so I can do something to
them without having to minimize the ot | | 0 | 12 | 11/10/2009 7:48:05 AM |
loop thru records to create a union query
Thanks in advance for any help on this.
I have a form with a combo box which has a list of customers. When a
customer is picked from the list, a subform lists price books which
ap | | 0 | 14 | 11/10/2009 7:48:04 AM |
Automatically update a text field when any entry changed
Hi,
I have 2 fields, 'Record Type' and 'Record Status' that I would like to
automatically update to 'Pending' (in the Record Type field) and 'A' (in the
Record Status field), wh | | 0 | 14 | 11/10/2009 7:48:03 AM |
Insert Into 2 tables from a form & subform
Any help would be appreciated:
I'm trying to add lines to two different tables in two steps. One line to the
first table and multiple lines to the second. The number of lines equals th | | 0 | 12 | 11/10/2009 7:48:00 AM |
Hiding a Form when a Report Runs
Hi
I thought I had posted this before, but it didnt appear, anyway :-
I have a Popup Form "FRM_HEAD" which has a command button "BTN_PRINT" which
runs a | | 0 | 12 | 11/10/2009 7:47:55 AM |
Tab out of subform
I have a from with several controls and a subform that may have from 0 to 15
detail lines. These detail lines appear like a list of labels and associated
text boxes for the user to fill i | | 0 | 11 | 11/10/2009 7:47:53 AM |
Can I hide the line between columns in a list box
I have a 3 column list box. Is it possible to hide the vertical line between
the colums? If so, how and can it be done on a column by column basis or is
it all or nothing.
Thank | | 0 | 12 | 11/10/2009 7:47:47 AM |
Continuous form set focus
Hi Group,
Win xp Access 2007
This is my first effort at working with continuous subforms.
I've read through the posts I can find about continuous forms but nothing
see | | 0 | 12 | 11/10/2009 7:47:42 AM |
Run time question
I have a simple database that I'm giving to a couple people.
I went through the packaging, etc. but somewhere in my reading I remember
getting the idea that all I need to do is supply the f | | 0 | 14 | 11/10/2009 7:47:39 AM |
setting form's recordset property
I am having problems with setting form's recordset property.
My subform's form_load event sub includes the following code:
Private WithEvents rstA As ADODB.Recordset
Dim SQL | | 0 | 17 | 11/10/2009 7:47:34 AM |
Continuous form refresh/requery
I have a continuous form, with the fields locked. In order to edit, the user
clicks on a cmdButton in the left margin of the record they wish to edit.
This opens a form in "single rec | | 0 | 15 | 11/10/2009 7:47:31 AM |
Docmd.SendObject
I have a form that uses Docmd.SendObject to create an e-mail attachment with
a snp file.
It runs fine on XP, Vista, Windows 2000 but when open the database on a
Window 2003 se | | 0 | 13 | 11/10/2009 7:47:29 AM |
Date Calculator
Can someone point me to some Visual Basic or Access functions that would do
calculations on dates? Given as input the date and some number of days
before that date, I want as output the corr | | 2 | 79 | 2/6/2008 8:19:28 PM |
running text on status
I want to have running text on the status bar.
Any example to do this?
Your information is great appreciated,
| | 6 | 125 | 2/6/2008 8:05:12 PM |
Program error
I am trying to append the data to an excel file . It worked while running
access 2000 but now that it is
running in access 2003 it no longer works. rsExcel.AddNew is where it
continues t | | 4 | 78 | 2/6/2008 7:57:12 PM |
Capturing the old value of a field
I have a status text box field that I want to maintain with check boxes. One
of the check boxes is "Void". If it's clicked, the status field should
change to "Void". My problem is that if | | 1 | 79 | 2/6/2008 7:49:01 PM |
Filter Issue
Hello, everyone,
I'm wondering if anyone has any suggestions for this...
I want this data entry form to allow access to only a subset of
records in the underlying table, based on | | 3 | 68 | 2/6/2008 7:42:02 PM |
Navigation Bar Problem
When I filter records in a split form using a lookup field in a combo box
nothing is displayed in the Record # of #. I've had this problem
since installing Access 2007 and I was hoping iyt had | | 0 | 73 | 2/6/2008 7:27:58 PM |
How can I get "CONSTANT" behavior from a variable (Constant magic )?
running access 2k;
And before anything else is said - "Yes, Virginia, I know you can NOT
use a variable to set a constant (that's why it's constant)".
BUT - my problem is - I want a c | | 17 | 58 | 2/6/2008 7:23:28 PM |
Open report in Filter asks for Parameter Value
I am trying to open a report filtered to a particular RM (text field) from a
"dashboard" which is a continous form. PEPRM is the PKey field. I have the
following code in the 'on double cli | | 2 | 73 | 2/6/2008 6:46:04 PM |
Navigation Bar Question
When I first started using AC2007 I was having issues with the
Navigation Bar not showing the number of records. Either the
record number wasn't displayed or the number of records wasn't
b | | 2 | 73 | 2/6/2008 6:32:45 PM |
remote sever connection
I have the following code that runs from a form. It works in the original
database but when I make a new database and copy the statement to a new form
and run the form an error message appea | | 0 | 70 | 2/6/2008 5:51:00 PM |
"Tab" help
I have a main form with 2 subforms. I want the user to be able to tab to the
second subform when they are finished entering data onto the first subform.
I have been able to get it working | | 1 | 78 | 2/6/2008 5:22:53 PM |
Do something until conditon is met (loop?)
Hello -Using Access 2003 I have the following code in the click event of a
command button.
If Forms!frmlease!TotalDue + Me.txtLicenseFee < Forms!frmlease!SalePrice -
Me.txtSalePri | | 14 | 67 | 2/6/2008 5:10:00 PM |
Setting the Focus to a Control if it is empty
Hey guys,
I have a Form where if the user exits a Control without selecting an
Employee Name, I would like to display a error box and then set the Focus
back to the same Contro | | 10 | 77 | 2/6/2008 3:39:07 PM |
is this possible, read contents of directory file and populate a t
Just seeing if this is at all possible
say i have a table called cust_docs with fields doc_id, doc_name, doc_path.
can i put some code to a button to read the contents of a folder (e | | 1 | 82 | 2/6/2008 3:31:16 PM |
Trouble recalculating field in sub-form
I have eight fields in a continuous sub-form. When any of them changes, I
need to recalculate a 9th field (Average Rating). In addition, I want the
Average Rating to be calculated when the | | 5 | 74 | 2/6/2008 3:25:00 PM |
The Data has Been Changed
My database includes forms to allow the user to correct entries, for example,
if the user misspelled a company name, he would select the incorrect name
from the list and enter the correct na | | 2 | 108 | 2/6/2008 3:09:00 PM |
Command button to populate field automatically
Hi,
I would like a command button on my switchboard to open a form and
automatically populate a field with the next available number.
The field is called "Client_Number" and th | | 1 | 105 | 2/6/2008 1:37:57 PM |
Cascading Combo boxes
I am creating a form with bound combo boxes. The Plant filters to the
corresponding Process which filters to the corresponding Equipment.
Plant-Process-Equipment
I have all the c | | 18 | 72 | 2/6/2008 1:29:46 PM |
FormatCondition
Hi,
Is it possible to have a conditional format to set, for example, the
..Visible property of a control? Or is it only possible to use the
FormatCondition members such as .For | | 1 | 98 | 2/6/2008 12:43:59 PM |