Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. parkfairfax

    oepn form macro in 2003 not working

    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...
  2. parkfairfax

    Problems using DDE to call application

    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...
  3. parkfairfax

    Using DDE command in Access

    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...
  4. parkfairfax

    load sqldba

    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...
  5. parkfairfax

    yes/no vs. 0 & -1

    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...
  6. parkfairfax

    applying subform filter to main form

    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...
  7. parkfairfax

    iis and foxpro to enable web site

    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...
  8. parkfairfax

    problems connecting to backend

    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...
  9. parkfairfax

    operator question regarding use of (->)

    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?
  10. parkfairfax

    combining filters

    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...
  11. parkfairfax

    foxpro startup from web site?

    Does anyone have any ideas how one initiate on the server side a foxpro program when a user calls up a web page.
  12. parkfairfax

    call a program from a web page on startup

    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
  13. parkfairfax

    need to create a counter with my own code.

    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...
  14. parkfairfax

    exiting excell won't work!!!!

    I am trying to exit excell from a Access application. Using &quot;Application.close &quot; closes everything, I just want to close Excell. Any ideas? Thanks, garry
  15. parkfairfax

    application not working

    When I run the following code I get an error '91' &quot; Object Variable or with block variable not set&quot;. Can anyone please give me a clue as to what I'm missing here. Thanks, GM Private Sub Command12_Click() Set appword = CreateObject(&quot;Word.Application&quot;) '...
  16. parkfairfax

    search &amp; replace function for VBA in Word

    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...
  17. parkfairfax

    search routine in 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...
  18. parkfairfax

    RST reference not working

    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 &quot;Microsoft Access 2000, Visual Basic Applications Fundamentals...by...
  19. parkfairfax

    calculated field not updating

    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...
  20. parkfairfax

    memory can't read

    I use the following code fine to open numerous spreadsheets and it opens them fine... Dim wks As Workbook, strwks As String strwks = &quot;c:\Reports\Test4.xls&quot; Set wks = GetObject(strwks) wks.Parent.Visible = True wks.Windows(1).Visible = True wks.Worksheets(&quot;FY01&quot;).Select Set...

Part and Inventory Search

Back
Top