Recent content by AlexMidd

OK, cancel that. It is now working. I haven't a clue why, but it is working. I used the computer name in the URL instead of localhost. Have fun! :o) Alex Middleton

I have searched high and low for a solution to this problem with no luck, although it seems to be a common problem. I have installed Apache server 2.0.59 and then Cold Fusion 6.1. When I go to view any .cfm file in the browser I just get asked if I want to save the file, and yet .html files are...

If you need criteria for different fields, are they "OR" or "AND"? This determines where on the grid you have to put the criteria. Some idea of the logic and requirements that you are trying to achieve might be of help. Have fun! :o) Alex Middleton

OK, I take it you know how to add a tabbed window to your form and how to set up the report and you just need to know how to programme a control to display/print the report? Have fun! :o) Alex Middleton

What is the relationship between the tables and how is the boolean value calculated? Have fun! :o) Alex Middleton

IIf([AVERAGE DEMAND]=0,0,[AVERAGE DEMAND]/20) Have fun! :o) Alex Middleton

One table for customers containing all the customer details and a unique identifier as the primary key, and another table for the product details with a unique product id as the primary key and a field to contain the customer id to act as a foreign key. You can then pull out products for...

Glad to have been of help. Have fun! :o) Alex Middleton

You will ned to relink the back-end to the security (.mdw) file that contains the user-level security data. Have fun! :o) Alex Middleton

You might need to create a field in your query for the form, which calculates the same result as txtBalance, then set the control source for the textbox in the form footer to that field. Have fun! :o) Alex Middleton

How's about putting a button on the picture, setting its size to tha same as the doors, and its Transparent property to true? Have fun! :o) Alex Middleton

Create a report from the query then open the report using code in a button as follows: Dim Condition as String Condition = "[Field1] = '" & [Forms]![Form1]![Combo1] & "'" DoCmd.OpenReport "Report1", acViewPreview, , Condition Replace "Field1" with the field used to filter the table and...

Set the table or a query based on the table as the form's Record Source. You can then use this table or query or create a new query for use in the report. Have fun! :o) Alex Middleton

Agency name should probably be in a group header for the agency field, rather than the page header. Have fun! :o) Alex Middleton

Not sure what you mean by "two sub reports in one". You can have as many sub reports within the detail section as you wish, but to work correctly they need to be related to a table that the main table for the report has a one-to-many relationship with and link the master/child fields on the...