Search results for query: *

Hello All, I have a table that holds data for overnight uploads, it has 3 fields. I would like to display this information in a form, but I want the data to be displayed like a multi-column report. E.g. **** Column 1 ***** | ***** Column 2 **** 123155 12/06/2003 Y | 134540 13/02/2004 Y...

Hi All, I have successfully created a query using CreateQueryDef which is used by my report. The problem is that sometimes there are no records to display. I would like a way to check if there is anything to display within my VBA code, so that I can display a message to the screen. a...

Hi All, I have a report that has a sum field called sumExamFeeCost = sum(detExamFeeCost) and a detail field called detExamFeeCost. The report runs off of a query, which can result in no records being returned. When no records are returned there are no records to sum or display. The details...

Hello, I have 1 main form, which can be used to edit/create new users. When adding a new record, I want to check if a record existing, if so, then populate the form/subforms and go into edit mode. To check if the record exists I use an index based on the Lastname and Firstname. This check...

Hi there, I have a main form that has tab controls containing subforms to display/add information. And I need to populate the subform from a recordset. e.g. I get a recordset for the main form, then use an ID field from it to get another recordset for the subform, which I want to populate...

Hi, I've implemented the code according the the FAQ (705-2562) on this subject and it works fine, however I would like to take it a step further and I need some help. My application has many forms, so ideally I would like open one form and hide the other, and when I close the current form I...

Hi, I want to change the back color of a disabled textbox to something other than gray, is this possible? Thanks G

Hi, I am creating a new workbook with 3 sheets which have been copied from another workbook. When I open the new workbook it asks to update the links for the formula's, Is there a way using VBA to prevent this from happening? so that it uses the sheets that are in the new workbook only? Garfield

Hi, I'm copying a range of cells from one sheet to another. One of the cell columns has a number in it which is used in a formula, the formula shows #N/A as it doesn't thinks its a number. However, if I re-type the number in the cell the formula works. Any ideas as to why this may be...

Hi, I have an Access form that has a number of checkboxs. These checkboxes determine the db query that is built using CreateQueryDef. I then run a report based on the query. 5 reports can be created, but with different titles. No point in having 5 different reports when 1 generic one will...