|
using Flash in Access 2003
I am trying to add a .swf file to my Access 2003 database.
The problem is that it works but it is "jerky".
When I use a pop up or right click on the movie it runs fine
and I can not figure out how to fix this problem.
any help would be appreciated.
I did read one article where you renamed the properties
to obj_flashmovie and put this script in the "on active"
but it did not fix the proble...
|
1 |
13.09.2006 11:07:01 |
|
|
ASP script does not update Access Database
I have created a ASP script using Microsoft Visual Web Developer Express
Edition 2005 that will enable users to edit a Access database in a gridview.
The script functions without any errors and allows you to edit the fields but
when you press the update button the page refreshes and the changes are lost.
I have triple checked the perms n(IUSR and IWAM) on the access db, the aspx
page and...
|
2 |
13.09.2006 10:57:36 |
|
|
Creating a form to supply parameters to a report
Hi,
I have posted various messages as the code I have to do this wasnt
working. I am really confused and I think I maybe doing it the wrong
way now, and also I dont have that a great knowledge of programming. I
am using Access 97 and the only way I can find how to do it is for
Access 2000 and XP
(http://office.microsoft.com/en-us/assistance/HA011170771033.aspx?mode=print)
Can someone pl...
|
3 |
13.09.2006 10:53:59 |
|
|
Access Control+Enter
Hello!
How can i add a Control+Enter into a control thru code?
For example, "AAA" & chr(13) & "BBB"
I want the control to show AAA
...
|
2 |
13.09.2006 10:25:01 |
|
|
Dynamic Chart title
I made a graph and the title is:
Private Sub Graph1_Updated(Code As Integer)
Me!Graph1.ChartTitle.Text = [Forms]![frmReports]![Dept] & "-" &
[Forms]![frmReports]![Shift] & " Weekly Report"
End Sub
How would I start a new line in the title between "shift" and the words
"Weekly Report"?
James
...
|
3 |
13.09.2006 10:17:53 |
|
|
To Save or Not to Save, That is the Question
I open a form for a "New Project" and populate the Project Number text box
when the form opens. Can I make it that the form is only saved if I determine
I want to have it save? Reason being if I populate the Project Number but the
user does nothing else, I don't want the form saved to the table.
Thanks...
|
2 |
13.09.2006 08:30:07 |
|
|
Access Control+Enter Revised
Hello!
How can I add a Control+Enter into a control thru code?
For example, "AAA" & chr(13) & "BBB"
I want the control to show AAA
BBB
chr(13) doesn't break the line.
Thanks
Abe
...
|
4 |
13.09.2006 08:01:28 |
|
|
Confirmation with yes/no field
In my servicing monitoring database I have a form (Service Details) with a
subform (Job Details).
The form has the main details eg Job Number Date In, Date Due, "All Jobs
Finished" (yes/no), etc.
The subform has individual jobs that are part of the main service. It has
job details including "Date Finished".
Currently it's possible to close the service by ticking the "All Jobs
Finished" ...
|
10 |
13.09.2006 07:06:01 |
|
|
SubForm
I have a datasheet as a subform and would like to now if it is possible to
have the new record to start at the top of the datasheet as apposed to the
bottom, any ideas?
Thanks in advance.
S
...
|
2 |
13.09.2006 05:40:37 |
|
|
Searching Forms for Data
I am creating a database for our company to use. I have a table and form
created to enter data that is then stored in the table. I would like to
create a main menu form that has the ability to act like a search for records
in the table and then display all results that meet the applicable field
criteria in the data entry form view. Essentially, I want to open the main
menu form and se...
|
2 |
13.09.2006 05:14:53 |
|
|
Fiscal Year and Quarter
This fantastic expression was posted by Duane Hookom. I have no idea how it
works but it displays the fiscal year and quarter for FY starting on October
1.
=Format$(DateAdd("q",1,[Onset Date]),"\Qq yyyy",0,0)
It displays the first quarter for FY 2007 as Q1 2007.
However I would like to display this as 2007 Q1. I couldn't get this to
work.
JohnC
...
|
3 |
13.09.2006 03:49:24 |
|
|
Enable Fields
I have a form where i have made all fields Locked and have set enabled to No.
So that staff can only search clients and view there data, without
mistakenly changing anything. What i want to Do is have a command button at
the botton Name "edit" and if people wish to make a change they click edit.
Upon clicking the button all the fields change to enalbled and Unlocked so
they can be cha...
|
4 |
13.09.2006 00:41:29 |
|
|
Data is being overwritten
Ok, I have a form that has a drop-down menu for account numbers. When
you select one, the customer and address fields populate. Then there
are several fields that the user fills in: Month, Amount of Bill, Type
of Service Completed, and Date Received.
Let's say I select account number 001. The name and address comes up
as John Doe, 123 any street, anytown, HI.
I then type in January, ...
|
4 |
12.09.2006 23:44:18 |
|
|
Buttons on a Switchboard
Our database monitors trainings for over 500 employees. The trainings are
also shared with managers as reports. Our Main switchboard has one main page
and a few secondary pages that may include Management Reports. I was able to
create a button for Refresher reports that was successful however it shows up
on the main switchboard and the Management Report switchboard. I only want
it on...
|
2 |
12.09.2006 23:27:32 |
|
|
Create a form to supply parameters to a report
Hi,
I have followed the instrucation on how to Create a form to supply
parameters to a report from the microsoft website
(http://office.microsoft.com/en-us/assistance/HA011170771033.aspx?mode=print)
.. When you run the report it brings up the dialog box which I select
the critera but when I click on OK there is an error in the module
code. The code I have used is detailed below:
Optio...
|
11 |
12.09.2006 23:08:35 |
|
|
Multiple records on form
I have a report that has a hyperlink on it and I've come to the conclusion
that there's no way that report will allow me to use the hyperlink, so now I
need to create a form that will allow me to do this. The only problem is, the
user would like to query to display multiple records on the form and not have
to scroll through them using the navigation buttons. Is this possible?...
|
2 |
12.09.2006 22:23:05 |
|
|
Bookmark format
Hi.
I have a numeric field which increase with each record ('1', '2', ...).
However, I want '1' to appear as '001'; for that, I went to the field format
and entered '000'. And that worked.
Now I have a bookmark in a Word template that shows that numeric value, but
the value appears as '1' instead of '001' (in the Word document).
Can anybody tell me how can I fix that? Is this a problem for...
|
3 |
12.09.2006 22:22:02 |
|
|
OLE object length in Form
I am linking an Excel worksheet to a form using "Insert Object" from the
toolbar.
Although I set the length in the Unbound Object Frame to 13", only 11" of
the worksheet is displayed. How can I show the entire spreadsheet without
truncating to 11"?
Thanks,
Kathy
...
|
1 |
12.09.2006 21:11:02 |
|
|
Forms Calculations
Hi, I am creating a Form for Returns. It consists of 9 lines of detail that
include a fields (defined in my table) for Quantity and Unit Price (9 each).
On the form I also have 9 Sub-total fields with the Control Source defined as
=[QTY]*[UNIT]. (These fields are NOT defined in my table.)
These 9 lines work fine and the subtotal field (called TOTAL) is filled as
each line is entered...
|
2 |
12.09.2006 21:06:20 |
|
|
object length on form
I am linking an Excel worksheet to a form using "Insert Object" from the
toolbar.
Although I set the length in the Unbound Object Frame to 13", only 11" of
the worksheet is displayed. How can I show the entire spreadsheet without
truncating to 11"?
Thanks,
Kathy...
|
1 |
12.09.2006 21:06:02 |
|
|
OLE object
I am linking an excel spreadsheet to a form utilizing "Insert Object" on the
toolbar. For some reason, the length of the worksheet remains at 11 inches,
even though the length of the OLE Unbound object frame is 13 inches. How do
I get the form to display 13 inches of the worksheet?
Thanks,
Kathy...
|
1 |
12.09.2006 21:00:02 |
|
|
Inserting into multiple tables
I was wondering if it was possible to set up a subform so that when data is
entered in it, the data will be entered into two separate tables. I know
that this may sound like data repitition, but it shouldnt be. I have a
subform that is linked to a table with a MANY-to-MANY relationship. This
table is called ProductSupplyParts and it stores the Product_ID,
SupplyPart_ID, and Supplier_I...
|
1 |
12.09.2006 21:00:02 |
|
|
Create a ViewForm to View GROUP OF Forms
I am working in a database, with forms depending on Date; I am trying to
create a view form where I can choose the form that I want to view by
entering the date.
How can I create that view form?
...
|
2 |
12.09.2006 20:58:37 |
|
|
i am new in access please help me
hello
please someone help me on this question
i have query with date range creteria now i want to make a new field in the
report to use "DLOOKUP" now i need one field data for only start date which
i use in date range
thanks
--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-forms/200609/1
...
|
4 |
12.09.2006 20:23:02 |
|
|
Data on both main form and subform(s)
I have a main page for each record (with a table) and several tabbed
sub-pages (each with their own tables) containing specific details about
particular aspects of the record.
I want each of the sub-pages to contain a couple of fields of data that
reside primarily on the main page.
It doesn't seem possible to create more than one relationship between fields
in the respective tables - is...
|
1 |
12.09.2006 19:28:01 |