Search results

hi, could somebody tell me what is the syntax for exporting the content of a string variable into a text file? thanks SWK

I have a list on a continuous form which goes like this: 1 adsf 1 qwer ----------------- 2 sdfg 2 rzrzur 2 gjkghjk 2 nmfhj ----------------- 3 sdfgrtwe 3 wrtwret I would like to have a line appearing under each category. Is it possible to do? Thanks for the help. SWK

Hi, I have html formatted text sitting in records - its a helptext for the application. I need to convince Access to display them correctly. I tried to create a data access page to display them - but I need to have the display as a floating window displaying only one record at a time with no...

Hi, I am designing a database. It is going to store data from questionnaires. The natural way seems to be to have a table - that stores where the data comes from, what is it about, what is the question and what is the answer, like this: DataProviderID; FocusID; QuestionID; AnswerValue My...

Hi, does somebody know where would I capture the resize event of the application (not the resize of a form) ? Thanks. SWK

Is there a way to remove the scrollbar from the Access application window that appears if the form is larger than the application window size? (Not the scrollbar of a form.) Thanks. SWK

Hi, I am opening a form functioning as a Switchboard from code (from the Login form). I would like to have the Switchboard no min, max and restore buttons but to occupy the full screen. I can do this if there are no menubars, but I have a custom menubar that I need to display. I've read the...

I am trying to delete a record and all of its children recursively, but I had no success so far. Below is what I tried. Thanks for the help. SWK Public Sub DeleteJobGroupHeader(JobGroupHeaderID As Integer) Set cn = CurrentProject.Connection 'Find all the children SQLstring = _ "Select...

I would like to delete records from one table that are not present in a query. I can solve the scenario when I need to compare one column: Delete From AllRecords Where AllRecords.ID Not In (Select ID From MustStay) However I cant solve this same scenario when the ID is composed of two...

I have a graph in a report. The graph doesn't display the first row of data. If I open the Chart's Datasheet I can see that the data is there in the first row. Interestingly the first row is not numbered in the datasheet. If I drag all the data down one row the chart becomes correct, however...

I am storing values on scales. I would like to store an equation which would use those values and return the result. I am not sure how to do this. Here is an example: I stored the values on a number of scales: S1 = 3 S2 = 5 S3 =10 Now the user can specify an equation which I store as text in a...

I just realised that I can use pivot tables in AccessXP but I don't seem to be able to find any reference on how to manipulate the pivot table from code. Could somebody refer me to some examples\documentation\tutorial? Many thanks. SWK

As I see form footers - logically - appear from the bottom of the form. If the detail section doesn't fill out the whole page there can be a gap before the footer comes. Is there a way to change the footer section so that it would appear immediately after the detail section? Thanks. SWK

Ten cutpoints are placed within a range and I would like to let the user modify them. I thought that a slider control would be ideal to visualize the cutpoints (the relative distance between them and that cutpoints can only be moved within the range of the neighbouring cutpoints), but the...

I have a table with one column (for the matter of simplicity). I am looking for the number where X percent of the numbers in that column are smaller than that number. When X=50 the number I should get is the median, but that is just an example I would need to find a generic solution to this...

I have a report which displays correctly on screen, but I found absolutely no way of outputting it to anything including: - printing the document to printer or pdf - publish it to Word or Excel - Save As anything When I try to do any of these Access flashes up for a moment something that might...

I have a table which contains 3 columns. For each CompID CutPointValue goes from 1 to 10 and I have a count for it, like this: CompID, CutPointValue, CountCutPointValue 1,1,20 1,2,30 1,3,14 .. 1,10,14 2,2,15 2,3,10 ... The problem is that in a few cases a few CutPointValue numbers may be...

I am creating a report in an Access Project. The report contains a graph. I couldn't find out how to specify the RowSource of the graph. I wanted to supply the rowsource when opening the report, like this. Dim objGraph As Object Set objGraph = Me.Histogram SQLString = " SELECT ........"...

I am trying to create a report where there is one graph for every record in the detail section of the report. I can place the graph in the detail section but I don't know how to generate a different graph for every value. I tried to change the rowsource property of the graph in the OnFormat...

I have a very simple recursive function below, which seems to work well. I would like to be able to specify how deeply the recursion can go - how many levels to refresh, but though I spent a long-long time trying am still unable to find a way to do it. Thanks for your help in advance. SWK...