|
"Identical" query SQL Throws Error
Quoted below are two SQL strings from querydefs that are supposed to be
identical except that in one the grouping is on Factory, in the other it's on
Team. The first query runs fine. The second one, however, throws one of
those mysterious "sorry, we have to shut down, should we tell Microsoft about
it?" errors.
Team vs. Factory is the only obvious difference, but the only way I've f...
|
8 |
30.08.2006 13:38:45 |
|
|
Create ODBC Connectoin
I have an MS Access application which needs to read/update a table on a
separate SQL server.
With the appropriate security, I can link that table to my application, but
my application calls to this table only works on workstations which have the
ODBC connection defined in the ODBC Datasource Administrator (odbcad32.exe).
What VBA code can I use in my app to create the configuration on ...
|
5 |
30.08.2006 14:15:02 |
|
|
COS Functions
I was wondering if there is an equivalant function to ACOS in Access, the
function is available in VBA for Excel but I cannot find it in Access, I know
it has COS, Tan and Sin but I really need th ACOS function...
|
6 |
30.08.2006 13:18:02 |
|
|
Working Day calculations
Hello,
I've been given a project at work which involves using forms and tables in
Access.
I've got the possibility of two different dates being entered into a field.
I need to calculate a certain amount of working days depending on which field
the user completes.
I've seen this code;
Public Function WorkingDays2(StartDate As Date, EndDate As Date) As Integer
'.........................
|
2 |
30.08.2006 12:45:30 |
|
|
hints and tips for organising VBA code
As I have constructed my code "on-the-hoof" as I have developed the db, the
application has decided to corrupt itself. I am still trying to de-corrupt
the file without much luck.
My VBA code are in a different number of modules. Should this be the case or
is it better to have all the code in a single module.
Any website links I can look at?
cheers in advance...
|
2 |
30.08.2006 12:33:50 |
|
|
create ade file using vba
I would like to be able to create an ADE file from my ADP using VBA. Is this
possible? What would the code look like?...
|
3 |
30.08.2006 11:43:02 |
|
|
redemption codes for email
Does anyone have any examples of redemption code that will allow me to set
To, Subject and the message in an email from my access databse. The codes
supplied on the redeemption site do not appear to work...
|
1 |
30.08.2006 10:24:02 |
|
|
Auto Log Off for MS ACCESS 97
Hi there, i'm having a big problem with my ms access 97 database which
is on the server. Many users can access it. However when we trying to
do some updates( either front end or back end) we can't because some
users have it open. How can i implement an auto log off on my form(s)
which will close ms access after 1 hour for example.
...
|
2 |
30.08.2006 09:49:27 |
|
|
problem with number and char formatting..
I'm working in Access2000 and am having trouble finding a way to take
imported "OLEPath" field values in my database and filter out or
eliminate all the alpha text so we only get numeral values, allowing
for number formatting. only the first and the last 4 of every value is
text. Here's some examples taken from a table: "A1011.bmp" or
"A201.bmp". I need to get the values to read as "1011" and...
|
4 |
30.08.2006 08:45:25 |
|
|
Compile error
I'm using Access 2003. When I run the sub below I get the following error
message: "Compile error. Wrong number of arguments or improper property
assignment."
I'm trying to append about 50 tables through vba to a table called "tblAll".
I don't know what the issue is. The code is as follows:
Sub AppendTables()
Dim db As Database, rs As Recordset, i As Integer
Set db = CurrentDb()...
|
2 |
30.08.2006 07:31:26 |
|
|
Programatically change a property in all reports
I have a database with hundreds of reports. I want to change a property in
all of them. How do I do it programmatically in vba? I have not worked with
the reports object model before.
Thanks,
Loren...
|
3 |
29.08.2006 22:15:02 |
|
|
Microsoft Dynamics CRM 3.0 Implementation For Large Corporation (August 2006)
How Microsoft CRM 3.0 could contribute and be a part of its computer
environment.
(Sales Module, MS CRM Security, Integration with Microsoft Dynamics GP
9.0/Microsoft Great Plains,Integration with IBM Lotus Notes Domino
,International Considerations, Competition)
http://microsoft-crm-3.blogspot.com/2006/08/microsoft-dynamics-crm-30.html
...
|
1 |
29.08.2006 21:53:27 |
|
|
Can database files be networked? Similair to sales a CRM.
Worked with many CRM sales databases, can extract reports from all clients in
the database. In Access, all client files are in separate folders, causing
redundancy in certain pull down menu options and inability to extract from
the database, using an Excel spreadsheet upload the redundancy, extract the
redundancy, create a trimmed spread sheet, and then upload back into Access.
In theo...
|
1 |
29.08.2006 21:52:01 |
|
|
Text file I/O in VBA
Hello,
Kind of struggling here. I need to read in a text file that contains prices
from a vendor. It is a formatted text file, so the first line is a heading,
second line spaces, third line heading, fourth line all dashes, then the
good stuff.
Each of the next lines have upc, date, old price, new price...
From reading, I thought this may work. Really hokey how I did the first
fou...
|
18 |
29.08.2006 19:42:14 |
|
|
Run-time error 3146 ODBC Connection
Why would an odbc connection through vba work sometimes, but not always?
I have written code to connect to SQL Server and it will run several times
with no problem, then suddenly it stops working. I haven't changed anything
in my code and I've checked to verify that it is passing the username and
password to the ODBC Connection string.
I've been researching the problem, but I haven't ...
|
1 |
29.08.2006 19:40:02 |
|
|
If...and
I am trying to create VB Code for a form that says...
If [Status] = "Complete" And [Ended] Is Not Null Then
[Complete] = "Yes"
Else
[Complete] = "No"
End If
Status is a text field, Ended is a date field, and Complete is a text field.
I can't get it to work and all the books I've tried do not help me.
Can someone please tell me what I am doing wrong. I'm getting d...
|
5 |
29.08.2006 19:16:02 |
|
|
Accessing Subdataset Records in VBA
I have a query that has a subdatasheet..when I open that query and have the
subdatasheet expanded, is there any way in vba to extract that data in the
subdatasheet into an array?
Thanks...
|
1 |
29.08.2006 18:58:02 |
|
|
Call AS400 iSeries Program
I have created a database that utilizes linked tables to files on the iSeries
through ODBC. The files on the iSeries are created by AS400 Query. I would
like to call the query, on the iSeries, from the Access database. Any
suggestions?
Thanks,
David...
|
2 |
29.08.2006 17:59:14 |
|
|
Transfer Excel Worksheet
When transfering data in from excel is there a way to refer to a specific
sheet and not a specific range. The excel file I want to import from has
several worksheets and I do not want to have the user set a named range as
the range changes. I just want to be able to say the file name and worksheet
name.
The stCombine below is the file path with subdirectories.
DoCmd.TransferSprea...
|
7 |
29.08.2006 17:43:02 |
|
|
Query form
I have created a form based on a query I have used criteria to determine what
user's info is required and also I want to filter certain records with a yes
no box. I have put in criteria that I want to display only records with the
box not ticked (NO) but when I try to call up a user wuth this box unticked I
get a blank form...please help?...
|
1 |
29.08.2006 16:30:01 |
|
|
using list function while using if conditions
I want using list while using if condition
e.g cell A1 = Lorry expenses" i want cell b1 will show the following in
list format i will select any one of this. Kindly inform what formulla i
will use?
FC Expenses
Fuel expenses
Retreading charges
Spares
Other exp...
|
2 |
29.08.2006 16:19:03 |
|
|
Time differences
I'm trying to get the differences between two times in Access 2003.
I tried using Format([StartTime] -1 -[EndTime], "Short Time") which I got
from the MVP website. However, when I use it for the following times:
Begin Time: 08/29/2006 6:26:00 AM
End Time: 08/29/2006 6:26:00 AM
The result is: 12:00:00 AM when it should be 00:00:00.
If I use:
Begin Time: 08/29/2006 6:33:54 AM
...
|
4 |
29.08.2006 16:19:01 |
|
|
list box, "no current record"
I have a list box for which I change the rowsource, depending on the
selections of the user. I am performing a loop of code based off the query
on the list box- it updates a table for each record in that current query.
The update works the first time through, but if the user wishes to make a new
selection, then update the table based on the new query/recordset, I get an
error message "...
|
1 |
29.08.2006 15:16:01 |
|
|
Picture in a Table
I have a database with in a table a field for pictures. how can i load
automaticle pictures from a web page in to a table yousing VBA. i now the
path from the picture.
Koen
...
|
1 |
29.08.2006 14:58:02 |
|
|
Grid Control
There doesn't seem to be a grid control available with Access. A vsFlexGrid
came with our edition of Access but it didn't seem to include a license to
use it. What needs to be purchased to have access to Msflxgrd.ocx. Or, is
there another worthy grid control that is cheaply available??
--
mcater...
|
5 |
29.08.2006 14:51:32 |