|
Using Tab Controls
I have to admit, I have zero experience with using tab controls.
Here is the issue. The main form has the basic detail of the project. Then
there are 3 tabs which provide different details of the project. The main
form feeds a table and the 3 tabs feed tables. Auto number is set up which
is used to link each of these for later reporting.
The problem is that when a new project is add...
|
3 |
19.09.2006 05:20:00 |
|
|
How to Create user and group in Ms Access 2007 Beta version
Hai
i want to know how to create user and group in ms access 2007
so far versions we are creating users by tools\security\create user
but it is not possible in ms access 2007
please any one help me
Thanks a lot for your help
...
|
5 |
19.09.2006 04:50:00 |
|
|
import/export specification
How can I add a column and re-order the column in an existing import/export
specification with access97? Thanks.
...
|
1 |
19.09.2006 03:22:28 |
|
|
Form to show latest Record
I am developing a training database that keeps track of when an employee
completes different training course. I have 2 tables for the records.
tblTrainingTopic
idsTrainingTopicID
chrTrainingTopic
blnTrainingRequired
tblTrainingRecords
idsTrainingRecordID
chrEmpID (FK to Employee Information Table)
chrTrainingTopic (lookup list from tblTrainingTopic)
dtmTr...
|
5 |
19.09.2006 02:49:49 |
|
|
Date/Time input Mask not available
Hi Guys,
First time using Access 2003. Was using 2000 before. In the design of my
database, it was suggested to me to keep start date and time in one field.
I did that but when I created my form, I notied that my field start time
didn't have an input mask. I went back to the table and time and date were
not an option to pick from when I clicked on input mask. I checked and
everyth...
|
4 |
19.09.2006 01:04:03 |
|
|
subform
i have a form with a subform attached. actually the subform does not share
data with the same form, but is another list displayed. The table on which
the subform is based is edited and records added from another dabase with a
linkded table. I would like to have the subform requeried every time the
underlying table is added to. Is there anyway to do this? An alternative
would be to requer...
|
1 |
19.09.2006 00:57:00 |
|
|
Is there any way to create a receipt Form?
I've been trying to work out a form that would serve as a receipt, but it's
not going very well at all. I need my dropdown menu (containing product
names) to place the price in a somehow linked box that the total may be
calculated at the bottom of the reciept. Is it at all possible? If so, can
someone help me out? Thanks in advance....
|
2 |
19.09.2006 00:38:41 |
|
|
ATTENTION EVERYONE!
I FARTED
...
|
1 |
19.09.2006 00:38:13 |
|
|
Form Search - Confirmation dialogue help
Hello all.
I have a form with a "order number" field which i'm basing my searches on. I
successfully created a pop-up form that searches for a specified order number
and pulls the corresponding record (works alot like built in find feature).
The problem i am having, is that if the user searches for a order number that
doesn't exist, there is absolutly no feedback. When something isn't foun...
|
1 |
19.09.2006 00:23:55 |
|
|
Tab control change event
Using the tab control, how can I tell which page I came from when the page
changes? I've tried using the tab control's click and mousedown events
(never fire) and the page's click and mousedown events (never fire).
...
|
2 |
18.09.2006 22:59:02 |
|
|
Function Key - F1 F2 etc
Does anyone know if it is possible to use a function key to open a form in
access?
Thanks in advance!
...
|
3 |
18.09.2006 22:18:09 |
|
|
Problem copying and pasting controls
When I copy and paste controls from one form to another (which is a tabbed
page) all the fields contain #Name?
Wot's going wrong?
Thanks...
|
4 |
18.09.2006 22:05:44 |
|
|
How to Delete a Found Record in a Form
Hi all,
I wanted to delete a record using the following:
Me.FieldToSearch.SetFocus
DoCmd.FindRecord Me.ThingToDelete
DoCmd.RunCommand acCmdDeleteRecord
But, while the "FindRecord" command does find the record, the next line
does not operate on the record that was found... It will either do
nothing, or it will delete whatever record happened to be selected
before the FindRecord...
|
2 |
18.09.2006 21:47:35 |
|
|
combo box sort order
I have a combo box that I would like the pull-down menu to be in alphabetical
order. I originally set the related table up that way, but have since added
items to it. I know how to sort it in the table, but can't seem to find how
to do it, if possible, on the form via the combo box.
--
Patti...
|
3 |
18.09.2006 20:44:02 |
|
|
Mouse advance to next record not repeating
I just installed MS Access 2002 on a new PC. On my old PC when I had a
form up and held the mouse down on the backward and forward arrows to
change the record, the records would fly by due to the repeat from the
mouse. Now I have to click the mouse for each record advance. I
looked through all of the settings in Access and can't find anything.
Any ideas?
thanks,
Alan
...
|
1 |
18.09.2006 19:27:50 |
|
|
Shortcut menu
Can anyone tell me how can I make a button_Click procedure in a macro in
order to include it in a shortcut menu, instead of using buttons in a form?
Thank you.
Acores...
|
1 |
18.09.2006 19:23:02 |
|
|
taking the "click" focus away.
I have 2 option group boxes on a form. they are of the sunken effect with a
darker grey background color. They are used to break up the form. however,
when they are "clicked in" they take the focus and anyting that is "on top"
of it gets greyed out. Now i have the groupboxes with the "send to back"
while all the info boxes are in the "send to front" group. I'm just
wondering if ther...
|
3 |
18.09.2006 19:02:01 |
|
|
Using check boxes to select items in a multi select list box
I am trying to create a multi select list box consisting of keywords.
However, I don't want the user to remember to hold the Ctrl key down, etc.
I'd like to present them with a list box showing the keywords and a check
box next to each to use instead. Eliminates them accidently untagging one.
Thinking ahead I will then need another list box on a filtering form to
filter these records by...
|
5 |
18.09.2006 18:51:14 |
|
|
Vertical alignment
Hi,
XP Home SP2
Access 07 Beta
I want to align the text in the center vertically Currently it aligns at the
top
I cannot seem to figure out how to align text vertically in Access '07
I know I can do it in excel
Any help would be appreciated.
If you know how in earlier versions send that, it can give me a starting
point
Thanks
...
|
4 |
18.09.2006 18:45:02 |
|
|
Bizarre error involving Escape key
Please if someone could help me, I am new to access. Thank You!
No programs were changed and for some bizarre reason, just right out of the
blue we started getting a message. So I tracked it down to this:
Private Sub cbxFY_KeyPress(keyascii As Integer)
On Error GoTo cbxfyKeyError
Dim myrs As Recordset
If keyascii = 27 Then
MsgBox "Escape Key Pressed, Loosing Changes!"
Applicat...
|
3 |
18.09.2006 18:32:02 |
|
|
Scripting
I have a situation where I want to be able to echo a variable to a flag
file to run a for loop over the values. What I want to do is to be able
to SET the variable at the top of the script and allow people to add
more variables then loop the new ones through.
Example
SET FLAGNUMBER=2
SET FLAG1=8
SET FLAG2=26
::Create flag file
SET COUNT=0
::MakeFlagFile
SET /A COUNT=%COUNT%+1
e...
|
2 |
18.09.2006 18:31:32 |
|
|
On_Dirty Form Event
I have a form and I want to place an UPDATE statement in an On_Dirty form
event. I understand that it should fire when the record contained in the form
has been modified, but it doesn't appear that it is. The reason I say this is
that I have constructed an UPDATE statement with a message box that displays
the UPDATE statement in a procedure that should execute when I have modified
the re...
|
1 |
18.09.2006 18:22:02 |
|
|
I cant add certain fields
I have a form that combines data from multiple tables. I have the ability to
edit all fields within existing records but have a problem when it comes to
adding a new record. When I try to do this I can edit all fields except for
those that come from my primary table. I have checked that allow edits and
additions are both set to yes so I don't understand why this is happening.
Any suggest...
|
2 |
18.09.2006 18:21:01 |
|
|
Recordsource Query Runs with Each Change of Record
I have a form with a subform datasheet. When scrolling down in the datasheet,
each time I move to a new record, "Calculating..." appears in the status bar
and there is a delay of 2-3 seconds (10,000 records in the underlying
datasource). There are no OnCurrent events set and I can't find anything in
code that could be triggering the requery.
Access 2003 with SQL 2000 backend.
Any ide...
|
9 |
18.09.2006 18:05:29 |
|
|
Can't recall Photo after generating report
I have a form used for patients that includes the client picture. The
photos are called from a respository folder by the On_Current event. I
also have buttons which generate reports from the same form. The
problem is that once the report is closed the form no longer displays
the photo. The following is the code used in the On_Current even of
the form:
Dim strFile As String
Dim str...
|
2 |
18.09.2006 17:56:02 |