|
Renaming a table via code
Hi
Can anyone show me how to go about rename a table in code?
SysAccountant....
|
6 |
29.09.2006 15:37:26 |
|
|
Datasheet does not auto update on Access graph
I have an Access graph and need to show a data label on only the last data
point on the graph. When I go into the design view I cant see the end of the
graph, it cuts off at the previous data point. When I double click the graph
and bring up the datasheet it never shows the latest set of data, I have to
go in and manually update the datasheet with the new figures then it will
allow me ...
|
1 |
29.09.2006 15:37:01 |
|
|
Smart card identification
Hello,
What are your exeperiences with smart card identification?
Can Access 2003 handle this task?
How does application "communicate" with smart card?
Is there an ActiveX control that can be embedded to capture card insertion
and card removal events??
Please help!
Domac
...
|
2 |
29.09.2006 15:34:02 |
|
|
Making records in an access table read-only
I want to define an access table so that records can be inserted into
it, but once inserted, they cannot be updated or deleted. Is it
possible to do this, and if so, how?
Thanks in advance.
...
|
2 |
29.09.2006 15:29:55 |
|
|
STORED QUERY
Another thread reminded of this (Access 2000):
? CurrentProject.Connection.Properties("Procedure Term").Value
STORED QUERY
OK that's very interesting but what does it actually tell me? Is there
any kind of syntax that uses this term?
Wouldn't it be more useful to return the term 'PROCEDURE' because it is
a Jet 4.0 keyword? I don't mean to suggest that 'PROCEDURE' would be of
any pract...
|
1 |
29.09.2006 15:26:03 |
|
|
Calculating "maturity" with queries
Hi! I'm having trouble preparing a query (in order to make a report
chart). Here is the situation:
I have a table where I have each worker, it's admitance date and it's
firing date (Fields: ID; Name; AdmitDate;FiringDate). Some workers were
hired in previous years, others were hired sometime this year. On
firing dates there is a mixture, too: some were fired in previous
years, others, duri...
|
2 |
29.09.2006 15:24:01 |
|
|
How to find top values accross multiple fields
I have a table that was imported from an oracle database into access. The
database has sales dollar values for each branch of the organization for each
customer. I need to go across all branches and find the top 100. Not for each
branch, but for the organization overall. I need toe query to look at branch
1, branch2, and branch 3, and give me the top 100 dollar values as well as
the cust...
|
2 |
29.09.2006 15:11:04 |
|
|
SendObject email to multiple addresses
I have set up a sendobject macro and run macro command button in my customers
form.
I can send emails to a customer one at a time, but want to be able to send
to all the customers at once.
How can this be done?...
|
4 |
29.09.2006 15:01:03 |
|
|
Backup back-end
Hi. My database has a front end and back end. In menu File, backup database I
can make a backup of the front-end, but what I really wanted was to make a
backup of back end, because is the database that contains the data.
Can anyone help me?
Marco....
|
2 |
29.09.2006 14:57:55 |
|
|
Access Reports
Can anyone tell me the limitation of the # of fields for a report? I am
getting an error for to many fields.
Thank you,
--
Splendalisa...
|
3 |
29.09.2006 14:50:24 |
|
|
Problem Sending a report with Access 97
Hello, I'm having a little problem trying to send an email from access using
this line:
DoCmd.SendObject acSendReport, "Send Quote Report", acFormatRTF,
"lmarrero@certipay.com", , , "Test", "body Test"
Ok the problem is not an error on logic or at least i think... the error is:
Microsoft Access
Run-time error '2287'
Microsoft Access can't open the mail session.
Check your mail applicat...
|
1 |
29.09.2006 14:45:05 |
|
|
opening a database file that was down loaded from the internet
I Have downloaded a Tutorial Database from a the internet to my desktop when
I try to open it with access i get a pop up saying,
Microsft Access canot open file
Tis file is located outsice the intranet or on a untrusted site. to open
file copy to your machine.
I add the site into my trusted site in mybrowser still no luck.
Can I set a opion to open all file?
Or can anyone tell me how ...
|
3 |
29.09.2006 14:42:02 |
|
|
Problems with ODBC Wizard with Access 2003
When going to File --> Get External Data --> Link Tables. And then
change the Files of Type to ODBC Database() the pop up window does not
appear. I have installed component for Access. I have tried 3 other
machines within my company and they are all the same.
Please help, is this a know problem.
...
|
4 |
29.09.2006 14:36:35 |
|
|
reset password can not figure out how. Kevin Kirwin a@ msn.com
I am trying to reset my password and I can not figure out how to do it. I
sent a message to my msn e-mail and I will try that out.
----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the ...
|
2 |
29.09.2006 14:35:00 |
|
|
USING A QUERY IN AN SQL PHRASE
I have written this code:
sql_str = "UPDATE dbo.tbl_soft_items " & _
"SET dbo.tbl_soft_items.fld_upgraded = 1 " & _
"WHERE dbo.tbl_soft_items.fld_software_item_id = dbo.
view_software_upg_from.fld_upgraded_from_item_id"
Debug.Print sql_str
DoCmd.RunSQL sql_str
However when I run it, an error occurs, which reads:
The column prefix "dbo.view_software_upg_...
|
4 |
29.09.2006 14:33:32 |
|
|
Query help - anyone?
Hi,
I have four columns in my table. First is ID (Number), second DATE
(DATE/TIME), third TIME (Text) and the fourth AMOUNT (Number).
My table looks something like this:
123 || 5.7.2006 || 07:15 || 35
232 || 8.7.2006 || 07:39 || 45
234 || 8.7.2006 || 07:43 || 21
432 || 9.7.2006 || 07:55 || 23
....
I'am trying to make two queries but I still didn't find the way to do
it propertl...
|
5 |
29.09.2006 14:18:34 |
|
|
Convert table format to a different kind
May I know, what feature that I need to use (query, functions etc) to
convert Table A to the format of Table B
Table A
Time Curve Values
0 A 10
1 B 20
2 C 30
0 A 40
1 B 50
2 C 60
0 A 70
1 B 80
2 C 90
Table B
Time CurveA Curv...
|
2 |
29.09.2006 14:16:51 |
|
|
source code control project contains more than one database name file
We have 3 developers working on a large database. Every few days one of us
gets the error
'the source code control project contains more than one database name file.
in order to avoid conflicts, you should run sourcesafe and remove the extra
file(s).'
I assume this issue affects the local machine as when it happens the otehr
developers are fine. When it happens the scc folder only cont...
|
3 |
29.09.2006 14:12:21 |
|
|
Access Upgrade
I recently purchased a new PC with Office Basic (Word, Excel and Outlook). I
had upgraded my old PC from Office Professional 97 to 2000. I now wish to
install Access to my new PC but only have my upgrade discs for the 2000
version (97 CD's went out in the trash). Can I upgrade my Basic 2003 to add
just Access from my 2000 upgrade disc?...
|
2 |
29.09.2006 14:03:27 |
|
|
SqlServer2005 with Win2k workstations running Access 2003
Hi
Has anyone out there had any problems running Win2k (SP4)
workstations/Access 2003/SqlServer 2005 in combination?
I have a client reporting connection dropout when loading our shrink-wrapped
Access ADE app, preceded by an error message saying 'class not registered'.
Not sure if this is an Access problem, or a Win2k problem run against the
SQL Server...
Any relevant comments gr...
|
4 |
29.09.2006 13:58:02 |
|
|
sourcesafe module check-in dirty bug
access 2003
if you edit a module and check it in without saving the dirty flag is
cleared! You then close access without saving your changes. At this point
sourcesafe contaisn the changes you made. You then check out the module
again and it does not contain your most recent changes as they were not
saved and it does not bother getting them back from sourcesafe (I guess it
assumes y...
|
1 |
29.09.2006 13:46:52 |
|
|
Trying to do a sql subselect
This has got me all confused. I want to get all the values from one
table which are NOT in a related table.
So in regular sql I could do:
select lastName from table1
where lastName not in (select lastName from table2)
But (if I'm seeing straight) this doesn't work in Access. How can I do
this, preferably with standard sql?
TIA,
Jim
...
|
6 |
29.09.2006 13:35:29 |
|
|
Changing MS Office language breaks the application
I used the French version of MS Access to develop a French Access
application. Everything works well, if my users have the Microsoft Office
language set to French. One of my users had this set to English and the
application "almost" works well. The only thing is that all the
"Forms!MyForm!MyControl" text that I set in property sheets get translated to
"Formulaires!MyForm!MyControl" by Fr...
|
5 |
29.09.2006 13:19:02 |
|
|
Recordset with non Latin characters?
Hi All,
I have a recordset working with a translation table, please have a look at
my below code:
Dim rst As Recordset
Dim strSQL As String
Dim DB As Database
Dim stringText As String
strSQL = "SELECT Translation FROM [FORMTEXT] WHERE Text_ID = " & text_id
Set DB = CurrentDb
Set rst = DB.OpenRecordset(strSQL)
rst.MoveFirst
stringText = rst!Translation
rst.Close
Set rst = No...
|
1 |
29.09.2006 12:31:02 |
|
|
Access front end hosted back end
I am looking to move my lan based access application for real estate to an
internet solution. It would be great if I could attach my tables to a hosted
back end. SQL or otherwise. Is this possible? will access attach over the
internet?
If not, I am looking for the next access. I will need merge ability with
word. It has to be rapidly customaizable and easy like access but allow ...
|
3 |
29.09.2006 12:24:02 |