|
VBA Editor acting goofy
I have been having problems while editing VBA code lately. for instance I'll
type in me. and the drop down list will appear for only two or three seconds
then disappear leaving me with red text and when I try to finish typing the
cursor will jump around and screw up what I'm trying to type. This problem
only happens after I have been in the database for a while and I have to
completely reboo...
|
2 |
05.03.2006 22:23:57 |
|
|
New Sites of Carlettabell
Hi Please let me know what you think. I am new at this and I would like to
make new friends. So smile lets be Friends Contact me at carletta Bell
carletta_bell@hotmail.com Here is my site Page again carlettabell
http://health.groups.yahoo.com/group/carlettabell/
Have A Nice Day! Smile!
...
|
1 |
05.03.2006 18:26:43 |
|
|
Access12
What will access12 bring for access-project or where cab i find more about
it.
Thanks,
Filip
...
|
3 |
05.03.2006 05:01:20 |
|
|
SQL Server as a backend and logging in
I'm playing around with SQL Server as a backend. I've upsized the tables and
have been able to get my app linked to SQL Server when both SQL Server and my
app are on the same machine.
I hope I can ask this probably basic SQL Server question here, but, how do I
connect to SQL Server from another machine running my app. I'm getting the
following message on the second machine:
Connection fa...
|
3 |
04.03.2006 20:05:57 |
|
|
Need help with project
I have a project that is going to use ADP as a front end and SQL server as
the database. Now I need to import flat text files to a temptable in SQL.
Right now, what I created is a macro in ADP that will call a batch
file on the drive that will open up an MDB database and import the files
that way onto sql. Few problems I have right now
1) I have a form where the user clicks on "Locate f...
|
2 |
04.03.2006 17:48:01 |
|
|
Connection to SQL Express
I'm using Access XP.
May you tell me why, if I use the following connection string:
"Provider=SQLNCLI;Server=mycomputer\sqlexpress;Database=databasename;UID=sa;PWD=sapassword;MarsConn=yes;Encrypt=yes"
I continue to receive a "Specified SQL Server not found" error,
while, if I use the following one:
"Provider=SQLOLEDB.1;Persist Security Info=False;Data Source=mycomputer\sqlexpress;Us...
|
3 |
04.03.2006 17:46:10 |
|
|
New INSERT syntax problem
I need a date insererted in the ESR_OPEN_DATE column when I run this code
but I get 12:00 AM instead. The variable is loaded with a valid date. I have
tried every kind of formatting and syntax alteration I can think of and found
posted but I cannot get this to work. I am going to spend all weekend working
this so if anyone can help, please do. I suppose the time field will be an
issue once...
|
2 |
04.03.2006 02:02:15 |
|
|
INSERT statement error
I'm trying to add a record to a table and am getting Error 8152:
String or binary data would be truncated.
Here is my statement written with VBA in an Access project.
Both datatypes are nvarchar
Private Sub cmdCreateJob_Click()
Dim strJcn As String
Dim strParcTag As String
Dim strSql As String
strJcn = 999999
strParcTag = Me.cboEquipID.Column(0)
str...
|
5 |
03.03.2006 22:33:06 |
|
|
ADP Help
I need help with this project. The project requires upload of text into
table. I am using sql server as the database, since the data is going to be
10k+. I made an mdb template that when user calls for it(thru form), it will
open up the form and execute all the transfer text to sql. Unfor, the form is
calling a batch file that will then call the mdb. I am trying to have code
that the ad...
|
1 |
03.03.2006 00:20:27 |
|
|
ADP help
I need help with this project. The project requires upload of text into
table. I am using sql server as the database, since the data is going to be
10k+. I made an mdb template that when user calls for it(thru form), it will
open up the form and execute all the transfer text to sql. Unfor, the form is
calling a batch file that will then call the mdb. I am trying to have code
that the ad...
|
1 |
03.03.2006 00:20:27 |
|
|
CASE problem
I had the following IIF function as the recordsource of a text box in an
Access mdb and it worked fine.
=IIf(IsNull([STATUS_STOP_TIME]),DateDiff("n",Now(),([STATUS_START_DATE]+
[STATUS_START_TIME]))/60,DateDiff("n",([STATUS_START_DATE]+[STATUS_START_TIME]
),([STATUS_STOP_DATE]+[STATUS_STOP_TIME]))/60)
Simply put, If the stop time is null, use the difference between the start
and NOW() ot...
|
2 |
02.03.2006 20:09:52 |
|
|
EARN $3,000.00 A DAY. OPEN AN INCOME-DAILY ACCOUNT WITH US
<HTML>
<HEAD>
<META NAME="GENERATOR" Content="Microsoft DHTML Editing Control">
<TITLE></TITLE>
</HEAD>
<BODY>
<P>YOU COULD BE EARNING OVER $3K A DAY , $100K A
MONTH.INCOME. CHECK IT OUT. Investment is only $5. 99cents a month.</P>
<P><A href="http://www.vosar.net">www.vosar.net</A></P>
<P>Tel: 775-333-11...
|
1 |
01.03.2006 07:13:19 |
|
|
Open an ADO recordset with cmd syntax problem
I'm trying to open an ADO recordset using the following method but keep
getting a syntax error when I get to the Set rst line. None of the examples I
have seen on how to perform this deal with passing a date to the sp.
Thanks for any help.
datCurStart = "2/1/2006"
cmd.CommandText = pr_EAR_Records
Set rst = cmd.Execute(Parameters:="'" & datCurStart & "'", options:
=adCm...
|
3 |
01.03.2006 01:13:42 |
|
|
dateadd
I searched for an answer and tried a couple examples, but i'm still
getting an error message...I am trying to query people whose birthday
makes them less than 19 years old from today:
....WHERE Birthday > DATEADD(y, - 19, CONVERT(char(10), GETDATE(),
101)))
but i keep getting an error message saying invalid use of getdate() in
a function.
Any ideas what i'm doing wrong here?
...
|
6 |
28.02.2006 21:10:53 |
|
|
Sql 2005 with Access 2003 sort order issue
I have an access 2003 adp using a SQL 2005 database as the datasource. I
have a list which uses a function as the data source. When I execute the
function the results are sorted per the order by fields, but when I look at
the list in Access the list is seemingly random? Any ideas as to why?
SQL Function:
ALTER FUNCTION [dbo].[QtyByOrderNo_PendingOrders]()
RETURNS TABLE
AS
RET...
|
3 |
28.02.2006 20:57:37 |
|
|
Change MS Access Database to Internet Site
I know this is VERY general question and don't expect someone to list ever
step for me. I'm looking for some suggestions on which steps to take. Let me
explain my Database first...
Multiple Tables (some are actually linked as a SharePoint List)
Multiple Queries (select, append, update, delete...etc all sorts of essential
queries)
Multiple Forms (all have VB code which perform different t...
|
2 |
28.02.2006 00:26:50 |
|
|
how to delete duplicates
hai,
i am using a table in sqlserver, table name is sample1,
fields are
ename varchar(20)
in this table there are 4 names
i.e
jaffar
jaffar
jaffar
jaffar
i want to delete last filed value i.e i want to delete last jaffar from the
table
i want result as
jaffar
jaffar
jaffar
what is the query for that,
warm regards
jaffar ali
...
|
1 |
27.02.2006 07:39:37 |
|
|
SQL Error trapping
I have a column that does not allow nulls and it works just fine. When a user
trys to enter a new reccord and leaves the field blank they get an error.
How do I trap the error from the server so I can write my own message and
perform vba code once the user acknowleges the message.
Thanks.
--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-adp-sql...
|
2 |
27.02.2006 05:12:00 |
|
|
Real Estate - Free post Your ads about property for sale.
Real Estate - Free post Your ads about property for sale.
You can join for free and post your ads about property for sale or for rent.
www.World-Estate.com
...
|
1 |
26.02.2006 16:59:16 |
|
|
Temp tables for reporting data
Hello again
I am migrating an MDB/MDE to MSDE/ADE (both XP).
Currently the front-end (mde) holds several tables which are used to
temporarilly store data for reporting etc. There are also tables in another
mdb (linked) on the local hard drive used for a similar purpose.
Using an ADP(E) then, what is the best way to store temporary data for
reporting etc.?
We are trying to avoid ...
|
4 |
24.02.2006 23:02:05 |
|
|
SQL Server execute permission denied on object
I have an Access FE to a SQL BE that has been running fine for several
years. Recently the SQL part was moved to a new server. I changed the
connect string to reflect the new server name and my user can get to the db
but she has started getting
SQL Server execute permission denied on object
messages that did not appear previously.
Example problem VB code is
Dim cmd As New ADODB.Co...
|
2 |
24.02.2006 22:30:44 |
|
|
Dynamically changing background HELP
Hi,
I have a table with dynamic values form the a recordset, one matches upto
the other and sets the background images accordingly and everything is
working ok to a point.
Problem is that there are more than 2 options (i.e. types of vehicle) I need
4 options, types of vehicle are
Standard
Executive
MPV
Estate
The snippet below only returns 2 values and need 2 more.
<td wi...
|
2 |
24.02.2006 21:35:57 |
|
|
Adding records through a view: ADP and SQL Server 2005
Hi,
I am encountering a problem in SQL Server 2005 that I have never before
encountered with previous versions of SQL Server. I have an Access
(ADP) client accessing data on a SQL Server backend. A form is bound to
a view and records can be added in the usual way.
With SQL Server 2005, I get an "Invalid Input Parameters Values. Check
the status values for detail." error. This has nothing...
|
8 |
24.02.2006 20:29:36 |
|
|
Newly Created tables
I have a situation where I need to create a new table in the current sql
database in my access project and then use the contents of the table in other
parts of the project. It seems that the project cannot see the new table
unless I disconnect and re-connect the ADO connection. Is there another way
to do this?
thanks
--
Barbara Musante
Partner...
|
6 |
24.02.2006 20:15:27 |
|
|
Migrating from mdb to ADP: dbengine.idle dbRefreshcache
Hi
Using Access XP (with integrated windows security), MSDE and a very very
slow network.
I am migrating a small mdb to ADP and have many instances where I use
"dbEngine.Idle dbRefreshCache" etc.
When I use this in the ADP I am getting prompted for a (Workgroup) login
etc. As far as I can tell this only happens the first time.
I have two questions then:
First: Is it necessary ...
|
4 |
24.02.2006 07:26:32 |