|
Acces 2007:Splitting database
I have been playing around with different aspects/tools in Access 2007
with an old database and decided to split it. Then I wanted to unsplit
it, so following a reply to one of my posts on how to do this a week or
so back, I imported the tables. These were then named as item name
Table1 , so my question here is, are these table1 imported back into the
database so that they are no longer ...
|
3 |
11/11/2008 9:54:29 PM |
|
|
Split form page
My form created in autoform is split into two windows, my form only shows in
the top window-I have to scroll to see it. This is not the footer as I moved
that way down in design view. How can I make my form full size?
--
Julie
New Access User...
|
1 |
11/11/2008 8:02:05 PM |
|
|
Instructions for use of Position Request Form.
I am designing a form that I want the user to interface with. Functionally I
want it to do the following.
1. The form to open up when the user opens the program .
2. The user can only interact with that form. So there is only a minimize
button and a close button.
3. there is now toolbars so all the user sees it the form and the only
choise they have are to input on the form or close...
|
7 |
11/11/2008 7:54:08 PM |
|
|
2007 Tab Control appearance
Is it true, even in Access 2007, that the Tab Control in a form still cannot
be configured to show a brighter background color for the page and bold font
for the label for whichever tab is selected? It's bad enough this doesn't
happen automatically; even worse not being able to force it....
|
1 |
11/11/2008 7:26:02 PM |
|
|
test
gvfv
...
|
1 |
11/11/2008 5:57:30 PM |
|
|
QBF Form: Disabling Toggles based on Report or Criteria
I am using Duane Hookom’s QBF form and it is just terrific. I’ve
looked at many posts and it is just remarkable how many people it
helps (and how many people Duane and the other moderators themselves
help -- I am sincerely grateful, and I say that especially if no one
answers this post: I know how busy every one is, so I hope you all at
least accept my gratitude).
My question is probab...
|
1 |
11/11/2008 4:10:06 PM |
|
|
Can I pass OpenArgs to multiple instances of the same form?
Hi All,
I've got a form I want to open multiple copies of. It will have a
subform like a checkbook register that displays different accounts' entries
from a general ledger. For example, the general ledger may have entries for
two accounts: Bank1 and Bank2. I want to be able to open a Bank1 register
form and a Bank2 register form at the same time, using the same base form.
...
|
6 |
11/11/2008 3:07:02 PM |
|
|
Copying and pasteing records within subform
I have a subform within a subform using Link Master and Child fields. In
Datasheet view I can expand the selection a record to display the subform
records associated with the main form. The problem is when I select the
group of records from the expanded view to copy and then try to paste them in
another record on the main form. The records appear there, but will not
save. I can close...
|
1 |
11/11/2008 2:26:09 PM |
|
|
Telephone Number Problem
I have a Field for "Telephone" using the standard Input Mask in my Form.
The DB is for Europe and the area codes often begin with a zero -- (01) or
(044)
I want the zero to be visible but after I insert it, and save, the zero
disappears and leaves a blank space. Any suggestions?
Thanks in advance for any help....
|
3 |
11/11/2008 1:45:01 PM |
|
|
Request help with the yes/no toggles
I'm very new using Access, having just "discovered" it about 3 weeks ago.
This is the second time I've tried to create this particular form. I'm
trying to use the yes/no toggle box, for three fields, however the boxes
themselves are too small and don't look right in the form. Is there any way
to make them larger in the form, but carry over to the data sheet as a text
yes/no?
I kn...
|
4 |
11/11/2008 1:34:43 PM |
|
|
Searching in forms
Hi there
I have a created a query and a subsequent form for other users to use to
recall data. One of my fields in the form is a name box, does anyone know
the best method of setting up a search facility for this field that will
bring back all relevant records?
Thanks...
|
2 |
11/11/2008 11:33:14 AM |
|
|
Disable Form Delete
Hi there
Does anyone know how to disable the ability to delete records from forms?
Thanks
...
|
2 |
11/11/2008 9:42:43 AM |
|
|
My Pivot Table Option are not working all icons are disabled
When I am running my pivot table option in access, after that my all
pivot option are disabled so I want to know how i can enable those
option in my access(like, Export to excel, pivot properties..etc)
Please tell me as soon as possible.
Thanks,
Vikram...
|
1 |
11/11/2008 6:04:05 AM |
|
|
Dynamic Form Control
I have a form that I want to create with a combobox for WorkOrder. When a
work order is selected, I would like for a textbox to display the product
number revision and description for that work order. I am creating a work
schedule that will automatically populate the remaining fields based upon the
selection of WorkOrder. The form will look like this:
Joe
cboWO txtProductNo t...
|
4 |
11/11/2008 3:26:03 AM |
|
|
~TMP showing up in my value list
Hi All,
In my reports menu, I am getting a report that shows up ~TMPCP...
I have no idea why this ~TMPcp... is showing up in my value list.
When I try deleting it from the value list, it pops up again after I
save my changes.
Has anyone seen this before?...
|
4 |
11/11/2008 1:10:22 AM |
|
|
linking form and subform
i had it working once but i have no clue what i did and can't duplicate it.
i have a form and subform and i want to lik them together. i guess i have
two questions here.
1-how do i link the forms together so when i select the data on one it
automaticly fills in the other subform data. two of the fields are the same
unique numbers.
2- can i get the data that is automaticly displaye...
|
2 |
11/10/2008 10:49:00 PM |
|
|
datasheet form and not able to add new records.
I have a datasheet form and the recordsource is set to
"SELECT tblProjectBudgets.ProjectID, tblProjectBudgets.CIP_ID,
tblProjectBudgets.CIPBudgetItemID, tblProjectBudgets.ProjectBudget,
tblProjectBudgets.ProjectBudgetComments FROM (tblProjects INNER JOIN
tjunCIPProjects ON tblProjects.ProjectID = tjunCIPProjects.ProjectID) INNER
JOIN tblProjectBudgets ON (tjunCIPProjects.CIP_ID = tblP...
|
7 |
11/10/2008 10:05:02 PM |
|
|
Get Windows Group info in code?
How can I retrieve a users Windows group info from vba?
I have seen lots of samples out there but they all seem to only grab the
Access groups.
--
Message posted via http://www.accessmonster.com
...
|
3 |
11/10/2008 9:42:58 PM |
|
|
Query criteria from datasheet.
I set up a subform with the Default View set to datasheet. I need to set up
a combox box on the subform/datasheet which is based on information in an
earlier field n the datasheet for the same record. I saw a posting which
shows the statement to use, but it didn't work and I am now unable to find
that posting. The statement that I used is:
[Forms]![ViewProCustMgr]![ProjectTechResour...
|
3 |
11/10/2008 9:08:02 PM |
|
|
Defalut Form View
I am using Access 2003. I have restircted my db to only show a form when it
is opened and the user is only able to input into the form an then exit.
IF I wanted to make updates to the DB or form how can I get all my options
to appear. LIke I said there are no menu bars or tool bars only the form
that allows data entry and the user to exit.
Thanks...
|
2 |
11/10/2008 8:59:03 PM |
|
|
Running an UPDATE query in code to update a subform that reflects an underlying Table
Hi,
I'm have a subform that displays records in a table. In this table,
there is a boolean field called 'SelectTicket'. I have attached the
following code to the subform that should only allow the user to ever
select one record as being true. It doesn't work though. Any ideas
what I am doing wrong? I'm not very good with access coding yet.
Thanks
Private Sub SelectTicket_Click()
...
|
1 |
11/10/2008 7:40:10 PM |
|
|
Hide column in datasheetview
I want to hide a control in the subform which is a datasheet and can't find
where this setting is. Can somebody help? I am using ACCESS 2007.
I tried selecting the control and then right click. The right click popup
menu doesn't have it. Where is the "hide column" setting hidden?
Thanks much...
|
5 |
11/10/2008 7:03:01 PM |
|
|
Access 2007: Combo box text is not aligned with down arrow. Why?
I wrote an application in Access 2003, but the company for which I wrote it
has migrated over to 2007. In 2007, even though in Design View the combo box
and its text are correctly aligned and the same size, in Form View they are
not the same size and therefore not aligned. Does anyone know why and a fix
for this? It looks very unprofessional.
...
|
2 |
11/10/2008 5:56:18 PM |
|
|
Strange Behavior with text block left and width
I use two text boxes to establish the left position and widht of another text
box in a report. However if the left position + width equals the exact width
of the report, I get a message that the control is too big to fit in the
section.
Code is as follows:
me.RightText.left = Me.RightPos
Me.RightText.width = me.rightwidth
I get an error when the rightpos is 10054 and the right wi...
|
2 |
11/10/2008 3:30:30 PM |
|
|
Operation not supported
I have a tabular form with a tabular sub-form that is giving me an error I
have never gotten before. It only happens when I delete a record from the
subform and then move to another record in the main form. The error reads:
operation not supported in transactions. I typically get it twice. Ideas
about where to look? Thanks in advance....
|
3 |
11/10/2008 2:46:02 PM |