|
How to Delete the Current Record via VB in a Form
Hi all,
I have tried several other things that were not directly an answer to
this from other posts, but have not had success. I have code that finds
the record I want to delete, but I can't figure out the delete part:
Me.AllowDeletions = True
Me.iTheKeyField.SetFocus
DoCmd.FindRecord Me.SearchForDeletion
' Make sure FindRecord didn't fail and leave us ...
|
3 |
15.09.2006 21:11:15 |
|
|
update a field in a record with a query , parameter under a save b
Hi,
I have a access 2000 form which is linked to a table.
This form has calculated text fields. So far, when a user hits the save
button on the form it saves all the control source textboxes for the current
record.
I created a query that has a forms![formname]![txt1] parameter.
It updates a field for the record by performing a calculation on 2 other
fields.
I put docmd.openquery...
|
2 |
15.09.2006 21:10:02 |
|
|
Problem linking together subforms
I am having trouble linking subforms together. I use the technique with the
invisible text box. So i have it so that the textbox reads the value from
the first subform. then i set the properties of the second subform so that
the master link filed is equal to the name of the textbox, and the child link
field is set to the corresponding field in that subform. however when i got
to view...
|
1 |
15.09.2006 20:10:02 |
|
|
Access Date in Report...PLEASE HELP!!!!!!!!!!
I have a Letter Date of 01/01/2006 that is input on the FLY for each letter
when I print it.
I want to put a paragraph in with a ResponseDate file that displays a date
that is always 30 days later than the Letter Date.
I went to the Report Format property and coded the following that did not
work.
Dim ResponseDate as date
ResponseDate = dateadd([LetterDate],dd,+30)
Either get er...
|
3 |
15.09.2006 19:29:03 |
|
|
'database close' event
How can i execute code when the access database application closes. is
there a way to hook into a 'database_close' event, or the like? thanks!
...
|
5 |
15.09.2006 19:22:54 |
|
|
Date in unbound textbox
I want to set the date in an unbound textbox to 01/01/1970
Properties format : mm/dd/yyyy
Properties data - default value: 01/01/1970 turns to 1/1/1970 or if I build
=01/01/1070 turns to =1/1/1970
Anyway, when I click the form, I get 12/30/1899 for some reason. How do I
set this default?
Form is to work with a query to determine beginning and ending range of
dates.
Ending date wo...
|
4 |
15.09.2006 19:15:01 |
|
|
Access Date in Report
--
Hansford D. Cornett...
|
1 |
15.09.2006 19:03:01 |
|
|
Set a variable
Hi.
Is it possible to define a variable = value of the field on focus?
E.g.: in a field called «Var» I enter the value «1», and if I have the mouse
cursor there, a click on a specified button would make appear a Msgbox with
the sentence "The value in field 'Var' is 1".
Is possible to do it?
Thank you.
Acores...
|
4 |
15.09.2006 17:38:01 |
|
|
Select all button issues
I have a button on my form that selects all clients in a list box. It
works in the sense that when I click it, it does select all clients.
The problem I'm running into is that when I first open the form the
button defaults to 'Unselect All Clients' when it should default to
'Select All Clients.' Those are the two states of the button. Ideally
I want to open the form and the button reads 'S...
|
4 |
15.09.2006 17:30:23 |
|
|
Hide/display part of form
I have a continuous form that has multiple entry fields, making the
continuous form rather long. I would like to be able to hide all but the
first line (containing two of the controls) for all the records that aren't
active (currently being updated).
So, when a user clicks on an entry (first line) to update it, either the
rest of the fields automatically appear (ideal), or the user wil...
|
3 |
15.09.2006 17:29:01 |
|
|
set value to blank in a macro
I would like to change a field to a null value if a condition exists. If a
checkbox = no or is not checked i would like to create a macro that would
change the adjacent field to blank. I tried using setvalue in a macro and
creating spaces but the spaces are viewed as data. Please help
Rob...
|
2 |
15.09.2006 16:58:01 |
|
|
Active Window Title
Is there a way to change the Active Window Title of a form? I had named the
form one thing and then renamed it, but the active window title is still the
old name. Any suggestions?...
|
3 |
15.09.2006 16:33:02 |
|
|
updating fields
I would like to dblclick on a field in a subform and send the field data to a
field in a different form. I've been researching it but I don't really know
what to look under.
eloy...
|
4 |
15.09.2006 16:09:02 |
|
|
Forcing a save of bound form
If I set Me.Dirty = False will it still fire off either the BeforeInsert or
BeforeUpdate events? I just want to make sure that this happens so I can
still validate the data before it saves it.
TIA,
Jayyde
...
|
4 |
15.09.2006 16:03:47 |
|
|
% format
Hello.
I have a field which I want to enter e.g. '20' and I want to show '20,00%'.
I already tried to format it to Percentage, but everytime I enter '20'
apears '2000,00%'. How can I do this?
Thank you.
Acores...
|
2 |
15.09.2006 15:34:26 |
|
|
Toolbar disabled
Hello.
I have a form with the property popup defined as 'yes'.
However, after I did that, my toolbar attached to the form (where I have the
navigation buttons), appears disabled.
Can anyone tell me if it's possible to enable the toolbar keeping the form
in popup mode?
Thank you.
Acores...
|
1 |
15.09.2006 14:55:01 |
|
|
Trying something but not working, please help!
Hey all,
As opposed to typing...
If Not IsNull(txt1Label) Then
.txt1Label.Locked = True
Else
.txt1Label.Locked = False
End If
9 times I tried to have it loop thru the text fields and lock the ones
containing text but it's not working. It only locks the first one and
forgets about the other 8. Do I have to do it the long way and forget about
my idea?
Thanks to all wh...
|
4 |
15.09.2006 14:31:01 |
|
|
selecting data from a table and displaying it in a subform (in datasheet format)
Hi All,
I have a small problem which i am unable to fix! I am able to do
relatively simple operations in MS Access 2003, but i think that i am
trying to achieve something which comes into the catagory of advanced!!
I have a form (frmEvent) with a subform in it (frmEventMusic) and what
i want to be able to do is to click a button which opens a table
(tblMusic) i then select the records th...
|
1 |
15.09.2006 14:12:42 |
|
|
dlookup
Hi!
Please help me
i need data from my query for beginning date which i use in date form range
and i use below but show me #error
=DLookUp("[Balance]","Table1 Query",[Forms]![Date3]!Format([BeginningDate],
"#"))
thanks
--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-forms/200609/1
...
|
6 |
15.09.2006 14:04:31 |
|
|
Text box misplaced
Hello to all... I was creating a new form from an existing table link in
which I removed one of the text boxes and saved the form.... I would like to
use the original text box from that table link so the data will transfer
properly how can I create it in the form I have set up.... Thanks
Ermest M....
|
3 |
15.09.2006 13:51:02 |
|
|
HELP
Right what I have done is...
set up a form (frmKerbside) with 2 combo boxes
- Route Number (comb20)
- Collection Type (comb21)
OK button:
Private Sub cmdOk_Click()
Me.Visible = False
End Sub
Cancel button:
Private Sub cmdCancel_Click()
DoCmd.Close acForm, Me.Name
End Sub
On from Open;
Private Sub Form_Open(Cancel As Integer)
If Not bInReportOpenEvent ...
|
7 |
15.09.2006 13:02:01 |
|
|
Llinking subforms
I have looked through the discussion groups and was unable to find an answer
to this question. Can i link 2 subforms together? I have seen examples
where you can link 2 together and the second one depends on the which record
is selected in the first. What i need is that the information in the second
subform depends on all the data in the first subform. That is all the
records from th...
|
1 |
15.09.2006 12:54:02 |
|
|
Tab back style set to transparent
It seems that when the back style of a tab is set to transparent, it acts the
same as normal, not permitting the colours or picture of the form below it to
appear through the tab...
|
2 |
15.09.2006 11:28:36 |
|
|
Showing decimals
I have a table with fields in it defined as numeric single. I also have two
forms that both show this field. However one form shows the correct value
i.e. 17.5 but the other form shows the value as 18. Why is this. Both forms
have the fields decimal value set to Auto and I have tried setting it to 1 on
the form that is showing the wrong value but it didn’t make any difference.
If I...
|
2 |
15.09.2006 11:05:02 |
|
|
Subform ?
I need to know how I would after entering data into the last field in my
subform for it to go directly to the first field in the form and to the next
record?
Thanks ...
|
5 |
15.09.2006 10:55:02 |