|
Resizing forms
What is the best way to fit more data per page on an access report? I
have tried to resize it, and there's more than enough room on the page
as the data gets smaller and smaller, yet the same mount of rows show.
Is there another way to do this aside from the typical manual resizing
in design view that I have been doing?
Thanks
-Jimmy
...
|
1 |
29.09.2006 19:48:15 |
|
|
Add New Record in Datasheet subform
Hi All,
I have an event on my main form that when you press enter it moves the cursor
to the first record on the subform. However I want it to place the cursor on
the add new record portion of the subform if there is data already found.
I hope I am saying this correct.
--
Matt Campbell
mattc (at) saunatec [dot] com
Message posted via http://www.accessmonster.com
...
|
3 |
29.09.2006 19:31:06 |
|
|
duplicate record error
I would like my users to get an error message when they put in a duplicate
name in my database. I have the database set up so it will not accept
duplicates but I'd still like them to get a message. This is my code that is
attached to an on click:
If Not IsNull(DLookup("Employee", "Census", "employee")) Then
MsgBox "This user has previously been added, please click Existing User on
th...
|
5 |
29.09.2006 18:52:01 |
|
|
Checking for opened form
Hi
How can I check in code if a form is currently open i.e. running?
Thanks
Regards
...
|
5 |
29.09.2006 18:51:01 |
|
|
group box / radio buttons
I have a groupbox with 4 radio buttons. I've set the default value of the
groupbox to zero. None of the radio buttons are enabled however the groupbox
still holds a value of 1. Any ideas on this wonderful Friday?
Thank you
--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-forms/200609/1
...
|
4 |
29.09.2006 18:42:22 |
|
|
vbSunday
I would like to have each new record start with the first day of the week
(vbSunday) e.g. first record date would be 03-Sep-06 next record date
10-Sep-06 etc. Each time I start a new record I would like the Date to appear
in the Date field. This is for scheduling purposes. Each record equals a
scheduled event on the coming week. Each new date would have to be vbSunday
and continually ...
|
2 |
29.09.2006 18:35:01 |
|
|
Path definition
Hi.
I need to ask the user in a customised menu something like: 'Settings >
Documents folder location', where the user would define a [path] to a folder.
Then I would use that path in the following code:
Private Sub ID_Ordem_DblClick(Cancel As Integer)
Dim nome As String
nome = Forms!frm_Obras!Doc_nome
Application.FollowHyperlink path & nome & ".doc"
End Sub
How can I do this?
T...
|
4 |
29.09.2006 18:15:06 |
|
|
Give an automatic .doc name
Hi.
I have a button in a form that exports some data to a .doc document.
My question is:
How can I assure that the user saves the .doc name with a specified name
(the idea is to use some form fields), and is a specified folder?
My idea is that the user selects only once the folder where the .doc
documents will be saved (using a customised menu, such as 'Word documents
location...')
Than...
|
1 |
29.09.2006 17:49:02 |
|
|
Auto fill text boxes from combo box *or* print report of one recor
Hi!
I know similar questions have been asked before but I'm obviously not
proficient enough in Access to make teh answers work for me.
First my database structure. (I think it's a bit messy, but it's the only I
found to make it work so far)
-> I have a WORKSHOPS form/table that lists details about upcoming workshops
we offer.
-> This has a subform/table PARTICIPANTS where I ...
|
3 |
29.09.2006 17:36:02 |
|
|
Combo box help
I have a combo box on a form in which i enter information that occasionally
repeats. A query i have lists the information have entered previously. When
i enter the first letter for a new entry the combo box automatically
displays the first entry in the list with that particular letter and the
cursor moves to the end of the box. What i need it to do is allow me to
enter a 2nd and possibly...
|
5 |
29.09.2006 17:11:46 |
|
|
Date Control which allow to select different days and month in one shot
Hi: Can any one please help me in date control. I want a control which allow
me to select dates from like 1 to 3, 6 to 9, 11 to 13 for each employee in
different month in one shot.
Thanks.
--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-forms/200609/1
...
|
2 |
29.09.2006 17:06:01 |
|
|
import object into a Word Doc using a Command Button.
I'M ON A DEADLINE!!
I've an Excel sheet that is saved.
I want to use a Command Button in my Word form to trigger Word to find the
Excel sheet and import it into my Word document.
I inserted the file as an object in my word document and looked fine but I
don't know how to use a Command Button to do the same.
Thank you very much....
|
3 |
29.09.2006 16:43:02 |
|
|
Record search.
In Access 2003 I have designed a form with a search field for Request ID.
This field is unbound but when typed in to this field it brings up the
relevant record if typed in correctly.
However, should a entry be typed in that does no exist, this automatically
brings up the first record within the dataset. The users will most likely not
realise that this has happened and will assume that ...
|
8 |
29.09.2006 16:43:01 |
|
|
Tab Order : 2 Subforms
Hello,
I am using MS-Access 97.
I have created a form with 2 subforms (Calls and Personal)
I can tab through the main form to a subform, but when I try to tab to the
2nd subform from the 1st subform, nothing happens.
Can someone point me to some examples or samples???
Thank you,
Charles L. Phillips
...
|
8 |
29.09.2006 16:39:11 |
|
|
sum([TakesTooLong])
Adding a textbox to the footer of my continuous form in order to provide a
total dollar figure for one of the columns has become problematic. Even
when the form is filtered to show only a few records, access takes a very
long time to calculate the total. A sql trace (the back-end db is on sql
server 2000) reveals that the database is being hit once for every record in
order to come up ...
|
2 |
29.09.2006 16:09:07 |
|
|
Please Help, Access DB, forms problems saving
Hi folks
I'm getting both confused and mad.
Lets say I have 4 records in a table.When I then save a new record in
a form I still have4 recored in the table. The first one dissapears
and the latest is added.
I have a PK which I can see in the form changes, so that is correct.
The code in my save button looks like ths:
RunCommand acCmdSaveRecord
DoCmd.GoToRecord , , acNew...
|
3 |
29.09.2006 16:02:45 |
|
|
Form design wizard won't separate fields from form and subform
I have two tables that have a 1-to-many relationship. When I went through the
form wizard to design my main form, I got to the step that shows the fields
from the "one" side in the main box and the fields from the "many" side in
the subform box.
I am doing the same again but this time I have inserted the fields I want
from each table into a query and filtered the records that I would li...
|
12 |
29.09.2006 15:38:02 |
|
|
Sub form fields do not sync
I have a sub form that links to an account number field in the main form.
The account number is a 10 digit number. The main form will display all of
the account numbers properly, but the sub form will only show the accounts
that start with 1. Once it hits an account number that starts with a 2 or
anything other that 1 #Error appears in the account number field of the sub
form.
Any ...
|
3 |
29.09.2006 15:30:02 |
|
|
How to stop Access 2003 crashing with fatal errors during form des
Access 2003 crashes with a fatal error (very apologetic) and asks me if I
want to repair and reopen. Once this starts happening it keeps happening
every 5 minutes. It seems to me mainly as I am doing a copy/paste in design
mode on a form or just when moving controls. I thought it was just my
Notebook but am having the same problem on my new Notebook. It also happens
with different databa...
|
4 |
29.09.2006 15:16:20 |
|
|
Detect user idle time
Hi,
I have lately used the microsoft detect user idle time coding in the
access database I'm having and it works excellent if you just log in
without moving through forms or adding any data because as soon as you
do that and you walk away from the computer and the code detects that
you are idling, instead of closing the database - I have a form where
you can cancel if you want to continue ...
|
5 |
29.09.2006 15:16:00 |
|
|
List Box / Combo Box
Hello,
I have an unbound combo box on a form that also has a list box. I want the
list box to populate with only those records that match selection from combo
box (a text field). I've done this before in another db and have copied and
pasted the code to this db, but can't get it to work. I've gotten errors and
have changed it around so much that I'm not sure where to go with it now. ...
|
8 |
29.09.2006 14:48:02 |
|
|
Resetting Background colour
Is there any way of setting the background colour of a form back to the
original grey colour after you have set the forms colour.
The grey's on the list don't match up.
I don't have anything in the picture box on the forms properties. It
displays (none)
Thanks
Nicola...
|
3 |
29.09.2006 14:42:02 |
|
|
MS Access, forms. problems saving
Hi folks
I'm getting both confused and mad.
Lets say I have 4 records in a table.When I then save a new record in
a form I still have4 recored in the table. The first one dissapears
and the latest is added.
I have a PK which I can see in the form changes, so that is correct.
The code in my save button looks like ths:
RunCommand acCmdSaveRecord
DoCmd.GoToRecord , , acNewRec
...
|
1 |
29.09.2006 13:44:26 |
|
|
Disable text box via Combo box
Hey,
Can any one see if that can help?
I want to disable certain fields when a certain value is selected in a
combo box.
I have a form called "Expenses" and within that a subform
"GeneralExpenses_subform". On the subform form when you select a value
other than "Mileage" from the combo box "ExpenseType" i want
"VisitMileage","VehicleMileage" and "MileageRate" to be disabled so
that no dat...
|
8 |
29.09.2006 13:31:08 |
|
|
Form - open blank
Working in Access 2003.
When I open a form, it automatically opens with the first record. Is there
anyway of making the form open with a blank record so that users cannot see
this!
Thanks,
Matt...
|
5 |
29.09.2006 12:56:01 |