Looks like you're expecting the macro variable to hold a text character, which it will, but you're not populating the variable in macro code, e.g.:
%local _param;
%let param=SYSPARM();
title1 "Report for &_param.".
You're treating it as if it were a datastep variable, and you can do this but...
Is there a way to check this code?"
Yeah review it. How could a set of literal values be checked otherwise?
Or did I misunderstand this question?
*Ignore if this is a dead issue.
I killed inetinfo in the Task Manager (a goof), and I think this managed to **** up Explorer (oh, it's a browser application, not an integral part of the OS,right...?).
I couldn't get System Restore to run, so I used the original XP disc (Dell) to reinstall/repair XP Pro.
Now in the middle of...
Suggestions (you may have inherited names...)
--get rid of spaces in table names as a general rule
--use aliases to make the code more legible and compact
--debug.print the SQL string once it's put together, copy to clipboard, create new query in Access and paste SQL into it to see if it works...
Thanks Roy. I tried those too (I set break on all errors to true to confirm that no errors were occurring and reset to break on unhandled; save VBA project and compile.)
Sounds like you suspect the same sort of thing (a residual code project property from having a break point in place).
I'll...
Thanks PHV...you know, I put that in there as a potential fix--it was doing so prior ;-)
I've seen this before with Word. I didn't try a reboot, so I wonder if stepping through with F8 set some session property that's causing this.
Jeff Roberts
Insight Data Consulting
Access and SQL Server...
I've got some simple Word VBA that worked fine in a couple of docs, but now it goes into BREAK mode on every iteration (with no errors). What gives? TIA
Sub RevisionsToTextFile()
On Error Resume Next
Dim Rev As Revision
Dim intFreeFile As Integer
Dim lngRevCount As Long, i As...
Here's a freebie (assumes that all linked tables reside in the same file):
Set DB = CurrentDb
For Each Tdf In DB.TableDefs
If Len(Tdf.Connect) Then
strExternalMdb = Tdf.Connect
Exit For 'One table is sufficient
End If
Next
Jeff Roberts
Insight Data Consulting...
Have you tried making sure that all unnecessary objects are closed and you've saved both form object (if working on a module behind form) and vba project?
I get a cursor that won't even space away from first code word when there's too much in the edit buffer (just like what you're describing)...
You can program Access with VB Script:
Set objAcc = CreateObject("Access.Application")
objAcc.QueryDefs.Add strSQL
etc.
How remote? WAN or HTTP? If it's WAN a copy of Access elsewhere can connect remotely.
Jeff Roberts
Insight Data Consulting
Access and SQL Server Development...
Sorry for the late post folks...
SQL 89
select t1.*, t2.*
from
t1,t2
where t1.joinfield=t2.joinfield
SQL 92
select t1.*, t2.*
from
t1 inner join t2
on t1.joinfield=t2.joinfield
It's just different syntax for the join. The problem with outer joins is application support & syntax...
Sure, VBScript will do that. Now do the homework...the time you spend will more than equal the cost of an Access stand-alone.
Jeff Roberts
Insight Data Consulting
Access and SQL Server Development
www.InsightDataConsulting.com
ADO is superior to ODBC, although it may not make a hill of bills at the end of the day.
--can't tell you how many times I've posted these, but what you need to know is here:
http://www.connectionstrings.com/
http://www.able-consulting.com/ADO_Conn.htm
Jeff Roberts
Insight Data Consulting...
I get cursor problems when I haven't saved in VBA editor or when there are too many objects open for design. I think this is a memory issue. So don't climb 50 feet up before placing a protection point, so to speak. Save often, keep only needed objects open.
Jeff Roberts
Insight Data...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.