|
new line
Is there a way to get a new line into the Control Source of a form control? I
know I can use vbCrLf in vba code, but I was hoping to code it directly in
the textbox control source.
--
sam...
|
4 |
14.09.2006 19:52:16 |
|
|
dlookup
any idea why i get #name error
=DLookUp("[OpenBal]","Table11","[Date] =" & Format([Forms]![Date3]!
[BeginningDate],"\#mm/dd/yyyy\#"))
Thanks
--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-formscoding/200609/1
...
|
5 |
14.09.2006 23:34:26 |
|
|
Cancelling a Before Update event
I have a form with a subform. A combo box on the form determines the contents
of the subform. If this value is already set and the user attempts to chnage
its value, I display a warning with 'okcancel' options. If the user presses
cancel I want to revert back to the original value in the combo box and not
re-trigger the 'before update' event. How to do this???
Currently, I set Cancel = Tr...
|
3 |
14.09.2006 22:50:02 |
|
|
Button for Adding New Record
I am trying to get a button to work to add a new record. The glitch is that
I want certain fields to be duplicated, since from the point of view of the
user, they are adding a row between two other rows. Since opening a new
record navigates them away from the original data, I want to do two things:
1) Give them the reference data from the row above the place where
they want to i...
|
4 |
14.09.2006 22:37:16 |
|
|
Get TreeVide Selected Item's Parent node name
Hi,
I would like to get the string name of the top parent node of a selected
item in a two-level tree view.
What would be the syntax for that?
Thanks.
Alan
...
|
1 |
14.09.2006 21:47:45 |
|
|
Dropdown List Box is Null
I have a form with several textboxes on it and 1 dropdown listbox.
When I click an "Accept" button the code checks to ensure that all required
fields are completed. Even though the dropdown listbox has been completed it
returns a null value.
The dropdown listbox is unbound.
If IsNull(Me.Branch) Then
Does anyone know how to fix this?
Thanks in advance!
Dwight
...
|
2 |
14.09.2006 21:17:31 |
|
|
Can't Requery Unbound Controls on a Form!!
Got a weird problem ... I have a form in an ADP database and this form
has a "Clear" button that is supposed to reinitialize all the unbound
controls on the form. The code that I put in the OnClick event of the
Clear button is shown below.
The problem is that clicking the button is not clearing the form. I'm
obviously setting all the control values to null but the form doesn't
seem to be...
|
3 |
14.09.2006 21:12:02 |
|
|
in use by another
I get an errormessage saying the table gedrag_rapport can not be locked
because it in in use by another user or process
The message appears when the report should be printed
What am I doing wrong?
Thanks
JP
I use following code
Dim db As Database
Dim TB As RecordsetSet db = CurrentDb()
Set TB = db.OpenRecordset("gedrag_rapport", dbOpenTable)
TB.MoveFirst
Dim a As Inte...
|
5 |
14.09.2006 20:34:52 |
|
|
Resizing a Form
I have an application with a primary form that I want to fill the
available screen space - As if it's maximized - but not.... Because I
have several others that need to float over the primary one.
Any suggestions???...
|
2 |
14.09.2006 20:28:32 |
|
|
Set focus to subform(datasheet) from refresh button
Hello All
I have a refresh button on my main form that will update the current time in
a column(field) on my subform(datasheet). When a user wants to enter a record
into the subform, the user will click the refresh button which will update
the date/time stamp in the last record. When the user clicks the refresh
button, I would like to set the focus to the last record in a particular
column...
|
1 |
14.09.2006 19:34:21 |
|
|
html property vs html field data type
Hi,
I have a field in a table set to the hyperlink data type. The data in the
table contains actual url's in each field.
I have a form that uses the table as its recordsource. I have a text box
control on the form mapped to the url field. I set the textBox's isHyperlink
property to yes -- but when I have the form open I cannot click on the text
box to jump to the web page. So this mu...
|
2 |
14.09.2006 19:11:21 |
|
|
Help with dataentry errors
Form is called New-Edit
I have an option group with three options
Out - Option11 with the value of 1
In - Option13 with the value of 2
Consult - Opiton15with the value of 3
If the Out is input,
then I want a field (combo box) hospital name to default to Memorial
If the In is input,
then I want a field (combo box) Receiving to default to Memorial
How is this best accomplished?
...
|
3 |
14.09.2006 18:56:02 |
|
|
Security
Just FYI - I went in and renamed my workgroup .MDV file from WGName.MDV to
WGName.XXX hoping that system would default to SYSTEM.MDV and it worked I am
at least back to original databases, but with no security. I can now get
into all the databases again. But I still need help with the step and how to
enter.
Thanks, JIM...
|
2 |
14.09.2006 18:47:01 |
|
|
Run-time error 2001
Hey all,
I've been having an issue with a form I'm trying to run a filter on.
I've looked all over this newsgroup and can't seem to find the right
answer to solve my problem, so I've resorted to actually post!
Below is the code I'm having trouble with. The form has four combo
boxes that allow the user to filter the data on the form. Once a combo
box is updated, the appropriate sub belo...
|
8 |
14.09.2006 18:37:29 |
|
|
Access Window won't remain hidden
Hi,
I have a question for you Access/VBA Gurus:
I have been using the readily available code using a function to hide
the MS Access Application so that it appears that the forms are a stand
alone application. The floating forms can be minimized, restored at
will and it works like it should - with no Access background.
This works great until the user either right-click>restores th...
|
1 |
14.09.2006 18:22:36 |
|
|
FSO DateLastModified
I'm trying to get the DateLastModified property of a file, but get an error
saying "User-defined type not defined" on the "Dim fl ..." line in my code
below.
I have the Windows Script Host Object Model selected in my References to
enable the use of the FSO library. What causes this error?
CODE **************
Dim FSO As New FileSystemObject
Dim fl As Scripting.file
Set fl = FSO.g...
|
3 |
14.09.2006 17:31:02 |
|
|
Select 1st Item in Listbox
What would the code be to ensure the first item in a listbox is selected
after a Save button is clicked, the form and the list box are requeried, and
the list box gets focus? Here's what I'm using now, and it's not going to the
first record in the list box.
'Button to save the changes to the current record
Private Sub saveChanges_Click()
On Error GoTo Err_saveChanges_Click
DoCmd....
|
3 |
14.09.2006 17:24:02 |
|
|
Security
Hi, I'm having trouble understanding the steps to secure my data bases. I'm
using access 2000 and following the steps in 'Access 97/2000 Security Step by
Step'
I responded the following:
Step #1 choose a location and name- C:PROGRA`1\MICROS`4\Office\WGName.MDW
Step #2 confirmation - I confirmed
Step #3 open Access - I opened Access
Step #4 go to tool, secrity .... - I went to tools, secu...
|
1 |
14.09.2006 16:22:01 |
|
|
Creating a SEARCH BUTTON
I am having trouble knowing how to and where to start to make a SEARCH BUTTON.
The search button the wizzard gives me is not what I need. I need to search
either Query or Tables for a certian field on the form.
The search field is: frm_txt_Return_Number ("AR"999999) - this field is bound.
Do I need to use and an unbound field?
What I need to be done after the search is to bring up all t...
|
1 |
14.09.2006 14:18:35 |
|
|
Creating a SEARCH BUTTON
I am having trouble knowing how to and where to start to make a SEARCH BUTTON.
The search button the wizzard gives me is not what I need. I need to search
either Query or Tables for a certian field on the form.
The search field is: frm_txt_Return_Number ("AR"999999) - this field is bound.
Do I need to use and an unbound field?
What I need to be done after the search is to bring up all t...
|
1 |
14.09.2006 14:17:44 |
|
|
Access and VB
Are there any Sample programs out there that I can download showing a
Visual Basic 6 Front End and an Access Backend?
Thanks
DS...
|
1 |
14.09.2006 13:33:56 |
|
|
Search String Function
Hello Everyone,
I am new to MS Access and although I have created several different
databases I lack the VB knowledge to code a search function. I am
turning to your expertise for assistance. I am using MS Access 2003.
This is what I am looking for:
A text field for the user to enter the search string or keyword.
Once the user enters the string or a partial string (i.e. *house* or
...
|
3 |
14.09.2006 13:29:47 |
|
|
form/subform-type functionality in datasheet view
I am using Access 2000. I have two tables like this...
art
artid (primary key)
title
description
artist
color
colorid (primary key)
artid (foreign key)
RGB
....where there are always exactly three records in color corresponding
to each record in art.
I am trying to allow the user to print out all of the art records and
their associated colors. If I come at this as a f...
|
9 |
14.09.2006 12:46:50 |
|
|
send an email without bringing up outlook (NEED IMMEDIATE HELP!!!)
How can I send an email without bringing up outlook. I want to send an email
without the user knowing an email was sent.
I.E. a "silent" email.
Can this be done?...
|
1 |
14.09.2006 12:46:01 |
|
|
Any ideas why Recordsource may have stopped working today?
Yesterday, I had a nice bit of code in a form, virtually the same as given by
Access (2002) help, that set a forms recordsource to find a particular record.
Nothing fancy in the code:
strSQL = "Select * from qRefCallHeader where cabreferrals.ubrn = '" &
Me.txtUBRN & "' "
Me.RecordSource = strSQL
(qrefcallheader is a query)
followed by:
a select case statement using me.records...
|
4 |
14.09.2006 12:32:06 |