|
Change format of other fields based on combo selection
Hi, I have this urgent question Any help would be appreciated.
I have two field on the form, A and B. Field A is Comb Box with options 1, 2
What I want is if a user selects option 1 I want field B format to be changed
to 0000-0000-0000-0000#;0;_
and if user selects 2 then Format of Field would be 0000-0000-0000-00000#;0;_
( The difference is only last set of zeros have 5 zeros)
...
|
4 |
08.09.2006 17:41:21 |
|
|
subform/subform expand details button
I have a subform embedded within a subform. When viewed, the user sees the
details in the primary subform, and there is a "+" button in the far left
column. When the user clicks the "+" button, the details in the secondary
subform are displayed and the button image changes to a "-". What I would
like to do is trap the event that occurs when the user clicks the "+" or "-"
button. Doe...
|
1 |
08.09.2006 17:19:02 |
|
|
using DLookup via a subform
Hi,
access2002, xp
I've tried in about every variation I can compose -- so I must not be able
to refer to a subform using this function. Can anyone verify that that is
the case -- and if not, tell me where my syntax is kaflooey. Below are a
couple examples of my attempts.
=DLookUp("lastName","qryEvents_HPersons","eventID=Forms!frmEvents!zsfrmHPersonEvents!Controls!cboEvents(0)")
...
|
2 |
08.09.2006 16:52:47 |
|
|
Help with check box selection
Hi
I have a check box on a form and I am trying to make it that when it is
selected (ticked) it will display a text box. It is kind of workin,
like when it is selected the text box isn't showing, and when it isn't
selected the text box IS showing!
Can anyone help with this?
Private Sub Prof_Click()
If Me.Prof.Value = Yes Then
Organisation.Visible = True
Design...
|
5 |
08.09.2006 15:23:00 |
|
|
Can't NAVIGATE Records
I've created a fairly basic form for entering data into a table.
It is pretty staight-forward.
Most of the text boxes are simply drag-n-drops from the field list....But....
a few perform calculations and display the results (a few averages, etc).....
and there are also...a few combo boxes used to make data entry easier (e.g.
one is for MONTH and has all the months listed in the pull-down)...
|
7 |
08.09.2006 15:12:51 |
|
|
Create Table
Also is there a way to use input from fields in a form, to create a
table name in runtime.
ie:
CREATE TABLE [Inv#]+Line.........
//Where Inv#=
Input from Invoice# Field in Main Form
//and Where Line =
Input from Item# Field in subform
So that from one form, there may b...
|
5 |
08.09.2006 14:40:38 |
|
|
combos in continous form - varying the rowsource between records - text dissappearing
I have a continous form used for entering data. On each row there are 2
combos with no. 2 being dependant on no. 1
The rowsource for combo2 is derived from "table1" but only some of the
records from this table (depending on combo1).
On the next row combo2's rowsource is changed again (OnEnter).
So the datasource for combo2 is always the same but the rowsource changes.
This however causes t...
|
4 |
08.09.2006 14:30:54 |
|
|
How do i Show/Hide Combo based on the answers of another combobox?
Hi All,
I'm trying to write code that will so and hide a combo box depending on the
answer you select in another combo box.
Here's what i have so far:
Private Sub Item_AfterUpdate()
On Error Resume Next
Select Case Item.Visible
Case "Computer"
Computer_Name.Visible = True
Case "Projector"
Computer_Name.Visible = False
Case "Monitor"
Computer_Name.V...
|
7 |
08.09.2006 13:20:01 |
|
|
UK Post Code Checking
Is there any code that will make sure the letter in the post code are
automaticlay turned into Upercase.
Also is there any code to verify its a corect Post code format
Thanks
simon
...
|
3 |
08.09.2006 11:38:17 |
|
|
Refresh Linked Tables - ADO
I'm trying to "refresh" or "change" the database path of all linked tables
in my access file that are linked to "myFileA.mdb" so the tables become
linked to "myFileB.mdb". This code came from the Office 2000 Developer
CD-ROM and can be viewed the MSDN page
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odeopg/html/deovrcreatinglinkedtable.asp.
When I try to run the sub...
|
11 |
08.09.2006 10:47:43 |
|
|
Requery a table in a combo box query
I'm sort of new to access and vba, and therefore I have a little trouble
finding the answers to some basic problems. Any help will be mostappreciated.
My problem is this- I have a continuous form with a combo box that has a two
table query as a record source, one table is a table containing inventory and
the other table contains the number of items being taken. In the query, I
subtract ...
|
2 |
08.09.2006 08:51:21 |
|
|
How to display all record in subform?
Hi,
I have a main form that contain only 1 combobox for listing character from A
to Z. I have a subform to display to display the Glossary base on the
selection of the combobox on main form (because I set Master/child key for
master and child form). This technique work fine
Now I want to display all records, how do I do that?
SF
...
|
1 |
08.09.2006 08:17:25 |
|
|
RunReportAsPDF
Hi all,
I have come across some brilliant code that prints Access Reports as
PDFs. Using the registry, it changes your default printer and then
resets the original when done.
My understanding is that it is a little old and thus I have a problem
where the old registry keys are different to the new (i think). My
problem is the 'Save As' dialogue that opens when using this function;
I don'...
|
7 |
08.09.2006 03:06:14 |
|
|
Subform question
One of the databases I work in each day has two tables which are
related to one another. The SWL Table is made from data in the SAR
table. A query is run on the primary table (SAR) to select the records
which need to be appended to the SWL table. There is a field in each
table which I must update (LOB). Rather than doing it one table and
then the other, I built a form with a subform. The SAR...
|
1 |
08.09.2006 02:15:20 |
|
|
Relational Delete Query
Hello Everyone!
Here is the scenerio....I have table "A" and table "B" , they share the same
structure.
If field 'f1" in table "A" is not null then delete like record from table "B".
(Table "A" and "B" share a one to one relationship based on "id").
Just to explain in greater detail, I have daily import table and a holding
table. The holding table is a list of records appended daily a...
|
3 |
08.09.2006 01:21:42 |
|
|
Tree View and Images
Can anyone help to show me how to insert an image into a tree view node in
Access 2003?
I cant figure the correct method or property..........
I had code in Visual Studio 2005 that worked but the same properties
are not available in Access 2003......
|
3 |
08.09.2006 01:16:04 |
|
|
Variables
If you are using an application across many computers and declare a
Global Varaiblethat is application wide does that mean that the value of
the Global variable is only for that machine or can everyone using the
application on the other machines grab that value as well, or will their
machine have its own value?
Thanks
DS...
|
3 |
08.09.2006 00:41:01 |
|
|
Combo Box - not able to select option?
Hi everyone,
I have a combo box in an unbound form that is controlled by table1. I do
not have a control source as I do not wish to populate with this data, but
need it to hold the data in order to determine what other fields may be
available on the form. I currently have the following code in my row source:
SELECT Item_Type.Item_Type_Description FROM Item_Type GROUP BY
Item_Type.Item_...
|
7 |
08.09.2006 00:30:01 |
|
|
New record remembers button state of prev record
Hello,
I have a form which is used to add records. I have a 4 button option group.
I would like the state of the option group's buttons remembered as we move
from record 1 to record 2. E.G. if record 1 has option group buttin 2
pressed I would like record 2 to come up with option group button 2 pressed.
In essesnce, I would like the option group to work like a caps lock key.
Than...
|
5 |
07.09.2006 23:41:31 |
|
|
'Save as' to export a report to word needed
Hello all,
I have a report that I can easily enough export through a macro to a
word document to a specific location. That works fine.
It is alos easy enough to create the wizard export report button which
then gives the user the choice of format and desired location of where
to save the report. (Word is not an option here)
Question:
Is there a way to combine the functionality of th...
|
2 |
07.09.2006 23:31:33 |
|
|
Change Input Mask
Is there a way to change the Input Mask property of text box? Depending on
what a user selects I want a text box's input mask to change to one on the
following:
000000\-00;;_
or
000\-00\-0000;;_
Thank you....
|
2 |
07.09.2006 23:26:38 |
|
|
Linked Image
Good morning,
I have a linked image on a form. However, I am not working on my work
network and as such keep getting error about the db not being able to open
'Image path'. is there a way to trap this error? i have tried using the
Load event of the form but it didn't catch this error?!
Thank you for your help,
Daniel...
|
5 |
07.09.2006 21:45:53 |
|
|
Delete Table Query
Hello Everyone!
In the query design window I have table "A" & table "B". Table "A" and table
"B" share the same structure. I would like records from table "A" to be
deleted where table "A" has like records from table "B".
Presently I created the one to one relationship between the contingent fields
in the two tables, and pulled the "*" from the table where I want to delete
the record. W...
|
5 |
07.09.2006 21:31:42 |
|
|
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...
|
5 |
07.09.2006 20:59:51 |
|
|
combine events to create a condition
I am trying to change the properties in a text box in my form. If changes (On
Change) are made to the text box and you move (On LostFocus) to a different
field, then I want to run a macro. I can’t figure out how to code this or
combine these two events as a condition....
|
8 |
07.09.2006 19:59:34 |