I have a form button which when pressed is supposed to activate a macro which sends a string telling Access to open up another database. This is not working, even though the prior '97 version that we converted does work perfectly. The file path name is defined correctly. When the button is...
I am using DDE to run a program called ISYS which is a search program. These are my commands:
#1 Isyschannel = DDEInitiate("IQW", QryCmd")
#2 Access.DDEPoke Isyschannel "Action", "Query" & Searchstring
I can get ACCESS and ISYS talking to one another, because my minimize commands work, but...
I am using DDE to run a program called ISYS which is a search program. These are my commands:
#1 Isyschannel = DDEInitiate("IQW", QryCmd")
#2 Access.DDEPoke Isyschannel "Action", "Query" & Searchstring
I can get ACCESS and ISYS talking to one another, because my minimize commands work, but...
We have a Oracle 7._ database on a server with Novell Network. I have tried unsuccessfully to understand a way to Load the SQL Netware Module - "SQLDBA". Typically, the Novell command should be.."LOAD SQLDBA Line MOde = Y" Everything we do this we get a error, saying that the file does not...
I am using a sql statement to create a table at runtime in my access database.
strSQL2 = "create table test_new ([ID Number] Integer, Title text(255), [Report Number] text(50), [Date] date, [On CD] logical, Collection text(10));"
The field [On CD] is my logical field. This works...
I have 2 subforms; one is an author subform and the other is for keywords, both linked to the main form by record_id.
I would like to be able to type in a author or keyword on the search page that i am designing, and have the main form show all the forms limited to showing those with that...
We have a web site that is currently hosted on a Windows NT server. The current configuration uses a visual foxpro database being served through a netscape commerce server. Web serving and database integration are accomplished with the help of foxweb.
Somehow our netscape commerce software...
I have a front end connecting to backend which contains all my tables. When I set a password for the backend (which is the way it was set up before I converted to 2000), I get an error when I open up the frontend. Also, I am unable to open up any of the links to the backend tables, I get a...
Has anyone ever seen a statement like this using a operator like -<, eg. if alltrim(customer->password) then...{some code}.
I thought that -> equated to equal, but now I am not sure. Does anyone know the meaning of this?
Hello,
I am trying to combine the following 2 statements and keep getting an error when I try to set to filter using the following. (By themselves, each statement works, but together I get no items returned in browse mode). Assume that table query1 is already open.
set filter to...
Does anyone know how one can call a foxpro program at the time that a web page is opened. How would this be done?
Can you give me any idea what the code looks like.
Thank you,
G. Miller
Does anyone have any code for a javascript enabled counter that I could use for my home page. Reading through the various threads I see lots of similar requests, but no code has been provided. Like others, I would like to use my own code, not a third party site. if they go out of business than...
I am trying to exit excell from a Access application.
Using "Application.close " closes everything, I just want to close Excell.
Any ideas?
Thanks,
garry
When I run the following code I get an error '91' " Object Variable or with block variable not set". Can anyone please give me a clue as to what I'm missing here. Thanks, GM
Private Sub Command12_Click()
Set appword = CreateObject("Word.Application") '...
I am interested in finding out how I can implement a search and replace function using VBA to search either Microsoft Word or .txt documents. Can anyone put me on the right path where I would be able to find out information about this? The function should be able to replace all instances of a...
I am interested in finding out how I can implement a search and replace function using VBA to search either Microsoft Word or .txt documents. Can anyone put me on the right path where I would be able to find out information about this? The function should be able to replace all instances of a...
Can someone tell me if you think the following code is valid? I cannot get it to work on my computer...someone in my office says you can't do this, that is set your recordsetclone = to a form name. However the book is "Microsoft Access 2000, Visual Basic Applications Fundamentals...by...
Help! I have 2 calculated fields on my form.., they seem very simple.
= Sum([Actual Cost]) and =34000-Sum[[Actual Cost]). These are in the control source line of the properties box.
...Where the first expression totals all by expenses, the 2nd expression subtracts my total expenses from my...
I use the following code fine to open numerous spreadsheets and it opens them fine...
Dim wks As Workbook, strwks As String
strwks = "c:\Reports\Test4.xls"
Set wks = GetObject(strwks)
wks.Parent.Visible = True
wks.Windows(1).Visible = True
wks.Worksheets("FY01").Select
Set...
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.