|
Å׸ª
Å׸ª
...
|
1 |
19.09.2006 14:15:03 |
|
|
System policy prevents loading manifests. please contact your administrator.
Hello All,
The strange of this issue is that this error occurred only the first
time the code "ran".
I wrote these lines of code to get the sheet names of an excel file:
Dim filename as string
Dim xlApp As Excel.Application
Dim xlWorkBook As Excel.Workbook
Dim xlWorkSheet As Excel.Worksheet
filename = "C:\Excel.xls"
Set xlApp = New Excel.Application
Set xlWorkBook = xlApp.Workb...
|
1 |
19.09.2006 14:07:14 |
|
|
Conditional Format On Crosstab
I have a crosstab query sourcing a report. The dynamic columns are
date based. I want to add a conditionally formatted texbox so that the
color changes based on the relation of the most recent data to the last
ie: if Value wk 37 < Value wk 36 then the color would be red.
I have pre-set the column names in the query and placed them on the
report. How do I reference the most recent dat...
|
1 |
19.09.2006 14:00:01 |
|
|
Message box to appear twice!
I already have one message to appear but if yes is selected i want this new
message box to show ....Thanks Bob
Private Sub cmdDistributeAllInvoices_Click()
Dim nRtnValue As Integer
nRtnValue = MsgBox("Are you sure you want to Distrubte All Invoices ?",
vbCritical + vbYesNo + vbDefaultButton2, "Distribute all Invoices")
If nRtnValue = vbYes Then
DoCmd.Hourglass True
****MsgBox...
|
11 |
19.09.2006 13:16:20 |
|
|
How can i import scans of a purchase order into access database?
I want to modify an access 2003 database which tracks purchase orders whilst
entering order details from paper orders i want to scan a copy of the
purchase order into the database for future reference. can anyone help?...
|
3 |
19.09.2006 12:16:01 |
|
|
Can't find MSysaccounts file
When working on an Access database yesterday, I clicked on the security
options by accident, and just closed down the pop-up windows that appeared.
Now I can't open my database - I just get the message 'Could not open table
MySysAccounts in the workgroupi nformation file'.
I have never set up any workgroups, any user level security etc. - I'm the
only person who uses this database.
...
|
2 |
19.09.2006 11:21:58 |
|
|
How can i import scans of a purchase order into access database?
I want to modify an access 2003 database which tracks purchase orders whilst
entering order details from paper orders i want to scan a copy of the
purchase order into the database for future reference. can anyone help?...
|
1 |
19.09.2006 10:57:02 |
|
|
Where can I find a template for a Membership List for Access2002?
Any help would be greatly appreciated.
Thank you,
Rick....
|
3 |
19.09.2006 10:47:05 |
|
|
Any easy way to make database / external form more portable?
I have a database that I use to contain data, and another that has a
data entry form in it. I'm building it a my office and deploying it out
to the client. Problem is when I move the databases and open the entry
formit tells me that it can't find \\myserver\database\datafile.mdb . I
can correct this, but I expect to continue to do updates and etc to it
as time goes on, and don't want to have ...
|
4 |
19.09.2006 10:43:02 |
|
|
HOW CAN I ADD A "N/A TO A DATE FIELD
IN ACCESS CAN I USE "N/A" IN A DATE FIELD?...
|
4 |
19.09.2006 08:53:32 |
|
|
Update Date in a table.
Hello everyone,
I have a database with a table with about 500 records in it. Every day I add
another 3 to 4. I also update some of the old records in the same table. I
want to add a field in the table that will track the dates I make changes in
the rows in the table. I dont want to manually enter this information, but
each time I make a change in one row in the field, the date field
cor...
|
4 |
19.09.2006 08:39:33 |
|
|
Error when Using the SendTo object
When I run a report from Access 2000 sr-3. Then I try to use File, Send To,
Mail recepient as an attachment. Then I select Microsoft Excel, I get the
following message
Microsoft Access
Object variable or with block Variable not set.
This just started today. I tried to do the same thing on two different
computers and the results were the same.
Can someone shed some light as to wh...
|
2 |
19.09.2006 08:19:03 |
|
|
Update Report to print to designated printer using a form combo field
I am trying to create a method in which an end user can select a report
and printer from a form. I was able to populate a combo field with the
available printers using the code below. However I can not figure out
how to assign the selected print to the selected report. I assume that
I need to add code to the report so that ON OPEN, the printer name can
be updated from the form field. Any help...
|
2 |
19.09.2006 08:13:01 |
|
|
How do I prevent #deleted appearing before I update a query?
A database is open by 2 users. The 1 inputs data and the other is used to
display the data in form view. As soon as data is updated by user 1(owner)
all fields on the form of user 2 displays #deleted until shift+f9 is pressed.
How do I prevent #deleted appearing?...
|
7 |
19.09.2006 07:48:02 |
|
|
Error 'Error evaluating CHECK constraint' in the validation rule.
I am working on Access and I am having problems with my table... I have never
seen the error message before, and I have try different ways to fix the
error, but I still get the same message.
Error 'Error evaluating CHECK constraint.' in the validation rule.
I really apreciate your help. Thanks for all your time in advance....
|
3 |
19.09.2006 07:47:58 |
|
|
RunSQL UPDATE Doesn't Work with Time Field
Greetings:
I am trying to update Places and Times of runners in a
database that keeps information on foot races.
But I can't get my UPDATE statement to work correctly
from VBA. Whenever I attempt to update the runner's data
I get the following message:
Run-time error '3144'
Syntax error in UPDATE statement.
Here's the code in question:
Private Sub Submit_Click()
DoCmd.RunSQL...
|
2 |
19.09.2006 04:30:30 |
|
|
WorkDay Function from Excel
In Excel, I often use the workday() function to calculate dates
for example
=WORKDAY(1/1/06,5)
gives the date for the next work day (or week day) 5 days after the date
1/1/06. It will exclude weekends (and holidays entered) in returning the
date.
I cannot seem to find this function in Access. Seems odd that two products
so similar would not share the same function libraries.
Is t...
|
6 |
19.09.2006 03:29:11 |
|
|
OneNote 2003 - Auto screen orientation w/Tablet???
My OneNote screen orientation used to automatically change from landscape to
port. when I switched to tablet mode simply by swivling my screen and closing
it. How can I reset this option. I am having to manually change screen
orientations every time I use my notebook....
|
2 |
19.09.2006 03:06:03 |
|
|
Access 2003 / Adobe Toolbar Removal
How do I permanently prevent the Adobe Professional toolbar from loading when
I start up Access 2003?
I know I read something recently how to do this, but I cannot remember how,
nor where I read it.
Thank you.
...
|
2 |
19.09.2006 01:14:01 |
|
|
Input of data into a report
I am in charge of a Dodgeball League for more than 150 kids. I have all the
information put into tables in access 2003.
The Tables are organized by division (3rd & 4th Grade, 5th & 6th Grade,
etc...) so that on one table are all the 3-4 grade players. I have 4 total
tables for 4 divisions.
Each column on the tables are: Last Name, First Name, Team
For each game every week, I have to...
|
3 |
19.09.2006 01:08:02 |
|
|
Hyperlink to PDF fles
I have a database with a field that we want to hyperlink to image files. If
the images are jpegs then the hyperlink is fine, but when they are PDF's it
does not seem to want to open the file.
We have both Reader 7 and Acrobat installed, so that should not be a problem.
Many of these PDF's are not suitable to be saved as jpegs.
Suggestions appreciated....
|
4 |
19.09.2006 01:04:00 |
|
|
Finding a feild
My fields are set up by Section, Township and Range. When I press the find
button I am only allowed to search in one feild such as Section. My question
is, is it possible to search in all the 3 fields at the same time? If i want
to look for Section 1, Township 54, and Range 2...how can i insert that data
to obtain the certain information? All help is much appreciated. Thank you.
...
|
4 |
19.09.2006 00:57:35 |
|
|
Refer to control on 3 pages tab control in subform within form
Hello All,
Windows XP
Access 2003
ADP Project with all unbound fields.
SQL Server backend.
It may be simple, and probably it is. But I can't figure it out.
I have main form FRM1, which has combo box CMB1
I have subform within main form SUBFRM1
On the subform, I have a tab control with 3 pages.
On one of the page (PAGE1), I have text box, combo box (CMB 2) and few
other control.
Whe...
|
5 |
19.09.2006 00:55:49 |
|
|
Re-Naming Query Promps "Enter Perameter Values
--
Bob Levin...
|
3 |
19.09.2006 00:28:02 |
|
|
unexpected error 2121
anyone know what unexpected error 2121 is and how to fix? Using Access 97
and windows xp - everything was fine until today. no changes except adding
some new records. Access is setup as front end and backend. suddenly
getting unexpected error 2121. All of my files are there.
...
|
1 |
19.09.2006 00:03:12 |