Recent content by stevedi

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

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

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

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

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.

got ya! Many thanks!!!!!!!

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

never mind. I figured it out.

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

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

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

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

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

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

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