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!

Register Log in
  • Congratulations strongm 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. stevedi

    Code to open form in design view and then back in datasheet view

    Oops I misunderstood which form. Roy-VIDAR has it.
  2. stevedi

    Code to open form in design view and then back in datasheet view

    try for the button or what ever your using to open the next form; DoCmd.OpenForm "next_form", acFormDS Steve
  3. stevedi

    response.buffer = true ?

    Thanks folks, I took the redirect.flush out and it worked. DNG your link helped my understand.
  4. stevedi

    response.buffer = true ?

    Hi, I have an asp page that I would like to process some script then be redirected to another page. I'm using response.buffer = true to withhold the page during process then issue the redirect. I get this error: Response object error 'ASP 0156 : 80004005' Header Error temp1.asp, line 10...
  5. stevedi

    Newbie question on field lists

    Open the report in design view. Open report properties (select black box in the upper left corner. right click). assign a data source (i.e. table or query) to the overall report. The fields in that datasource become the field list for the report.
  6. stevedi

    Open Access Report

    got ya! Many thanks!!!!!!!
  7. stevedi

    Open Access Report

    Hi, I've got a VB6.0 sub that I want to open access reports selected from a treeview. I'm using the Access 9.0 Object Library to reference the report object. It kinda works, it generates the report but the access app does not stay open. I briefly see the report then access closes. Any...
  8. stevedi

    Linked form

    never mind. I figured it out.
  9. stevedi

    Linked form

    Hi, I'm trying to create a main form and a linked form using the wizard. I go through the wizard select the 2 related tables along with all the fields. However the related records in the linked form are not being displayed. When I go through wizard again but choose subform rather than linked...
  10. stevedi

    Echo data from one form to anouther

    You can pass the parameter to the third page via the second page a couple of ways From second page(to send) Using a link: thirdpage?value1=<%value1%>&value2<%=value2%> or Response.Redirect&quot;thirdpage?value1=<%value1%>&value2<%value2%>&quot; Then on third page (to receive) <% Dim Value1...
  11. stevedi

    access 2000 xml

    Hi! Considering that I just learned what XML stands for yesterday. Is there away to write Access 2000 tables/queries to xml using VBA? Thanks SteveDi
  12. stevedi

    Reading first file in a folder

    Define first. First sorted by name, date? In your example the first file is 593993.tif if you use the above code.
  13. stevedi

    Reading first file in a folder

    You mean like this? if you take out for each... and next that would give you the first. <% dim fs,fo,x set fs=Server.CreateObject(&quot;Scripting.FileSystemObject&quot;) set fo=fs.GetFolder(&quot;c:\folder\&quot;) for each x in fo.files 'Print the name of all files in the foldername folder...
  14. stevedi

    Row counter on a query

    Go here, http://support.microsoft.com/default.aspx?scid=kb;EN-US;207626 and download the example database it's in there. SteveDi
  15. stevedi

    Passing checkbox value to Access 2k back end

    I think that Access stores Yes values as -1 and No values as 0. Try substituting -1 and 0 for &quot;yes&quot; and &quot;no&quot;. SteveDi
  16. stevedi

    Include file

    Tarwn, I've got it. In the asp (A) file I was executing in the server.execute I left the html, header, body etc tags in. So when I viewed the source per your suggestion I saw tags for that page and the originating page (B). I took all the tags out of the asp (A) then it worked. Make sense...
  17. stevedi

    Include file

    Tarwn and Steve, Thanks for the responses. It tried the Server.Execute and put it at the top of the page before the <html> tag. it executes and returns to the original page but doesn't write the html. This page has 2 frames in it. I tested the Server.execute on a nonframed page and it...
  18. stevedi

    Include file

    Hi, I have this website where a small portion of the site should only be available to certain users. I'm using using a database to store UserIDs. I have a login form which checks if they are in the db, if so allows them to the first page and stores the UserID as a session variable. The thing...
  19. stevedi

    listbox multiselect

    Hi, I have a listbox on a form that I use to filter records using a select query. I use [Forms]![theForm]![ListName] as criteria in the select query. The query runs if the listbox multiselect property is set to none. I would like to be able to make multiple selections in the listbox this...
  20. stevedi

    listbox multiselect

    Hi, I have a listbox on a form that I use to filter records using a select query. I use [Forms]![theForm]![ListName] as criteria in the select query. The query runs and returns records if the listbox multiselect property is set to none. I would like to be able to make multiple selections in...

Part and Inventory Search

Back
Top