Search results for query: *

Works perfectly, thank you.

Hi, I'm outputting html from custom tags using style sheets. Sometimes the row will be empty and I'd like the output to appear as if there is no row there at all. No matter how I change the border, margins etc., the empty table row still takes up some space on the page. Is it possible to...

You are very right, QDFFSCRA is one of the tables within the QDFRTVFD API. Too much time reading through those 65 pages has clearly addled my head. Anyway, I ending up giving up, I still don't know if it's possible. Thanks anyway. Dave

Hi, Has anyone seen any good documentation on how to configure two seperate application servers to seperate ports using seperate datasources with seperate virtual hosts? (preferably on iSeries). Unfortunately I'm having problems using my second HTTP server with my second instance with 'not...

Hi, has anyone successfully used the QDFFSCRA API and would be prepared to share some code? I need to retrieve details of the fields and any No Display indicators associated with them. Is this even possible? Thanks in advance, Dave

erik71, try just filling the tables using a couple of runsql commands such as DoCmd.RunSQL "INSERT INTO tblName (FieldA, FieldB, etc.) VALUES ('" & FieldA & "', FieldB, etc.);" Just a suggestion, but it might work... Dave

Hi, I'm running the following code to delete a specific record from a table from a 'delete form'. (No idea if this is relevant). About half the time the DoCmd.Close line is executed the whole of access closes. (The other half it seems to behave normally and just shuts the form). This is...

Hi, I have a 3Mb database that at the moment is mostly forms, queries etc. It was very slow when I run it off the network so I decided to split it and put the back end on the server and front end on PC. However, the speed has not improved at all and forms and queries are still taking a long...

Danyul, The 'Count' above is a variable of mine as I am reading down the excel table until I run out of rows and each time specifying three fields for the graph. If there is another 'count' property I probably just picked a bad name. The number of rows (and hence 'bubbles' on my graph) can...

Danyul, Thanks very much for your help again. I felt like I was getting the hang of this now. The only problem is that when I am running the macro in access to create my charts in excel, the line; appExcel.ActiveChart.SeriesCollection(Count).XValues = "=tblOutputofMetricData!R" &...

JVFriederick - Unfortunately I have many charts being created off a lot of different data and I want the user to select which chart they want to see. Danyul - That works brilliantly, I'll have to get into this monitoring for errors thing. You don't know if it is possible to store and run the...

Hi, I am exporting a table from access to excel and then running a macro over the data to create a chart (I'm doing it in excel as it's a bubble chart and i've no idea how to code the macro over and access table). I would like to do one of two things, Either, check if the chart worksheet...

Thanks for the reply but I would like another record to be displayed, even if it is just the first record. It seems crazy to find the first record again but i guess i will...

Thanks for the reply, it does remove the record from the combo options but remains being displayed initially until you select something else. I'll keep bashing away. Thanks again...

Hi, I have a subform which contains a combo box. The combo box selection moves the data on the subform to the selected record. A button on the subform deletes whichever record is selected at the time. I cannot get the deleted record to disappear from the combo box even though I am doing...

That works fantastically, Thanks very much, Dave

Hi, I have a form that is based over a table that is created from a make table query (So that the user can select records from a smaller number of records). One of the fields is a check box that is built over a yes/no field on the table. If the first query generates a lot of records, I would...

thanks for the reply, still don't know why this happened, managed to solve it by saving the record before the query was run. Thanks again.

Hi, I have a form from which I select individual records using a check box. Those records selected are then output from a query with fields that are calculated. When I run the query, individual records are sometimes missing depending on where I position the cursor prior to pressing the query...

thanks Simon, that's looking pretty good...