Search results for query: *

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

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

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

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

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

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

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

Hi, I would like a user to be able to select (perhaps via check boxes) a number of individual records from a table and then to run a query/chart over those records only. The records can't be distinguished via a query as they are unrelated. Does anyone know if this is possible please? Any...

Hello, I have two combo boxes, neither of which are bound to a table (so I can move values into them by using the next record buttons). The first one shows all three fields of a table (Bank, City, BankID), the second one only shows the second field (City). Therefore a user can either select...

Hello, I have two combos showing two different fields that are part of but are not bound to a table. If the combination of the two fields does not exist on the table as a single record the user is prompted to add a record via another form. So far so good. However, after the user has added...

Hi, I am trying to find the value of my key field based on two fields entered seperately. I have the following code where my table City-Bank contains three fields, Bank, City, BankID. Result = DLookup("[BankID]", "[City-Bank]", "[Bank] = '" & Bank2 & "' And...

Hi, I am trying to allow users to select a record via a combo box in a form header and via the next/previous buttons so I can then update related details in a subform on a seperate page. However when I select a record with the combo box the table is being updated with whichever record number...

I have a form with a header, details and 1 page of details with a subform. The record on the details/subform should be updated in 2 ways: Firstly by selecting the next/previous buttons and secondly by chosing a record from a combo box in the form header which contains three fields from a table...