Search results

You add a subform the same way you do any other control. Click on the subform icon on the toolbox, then click where you want it on your form. If you have the wizard engaged, it will walk you through the process of identifying the subform and the field that links the main form to the subform. Of...

I assume this is related to your other question in the Forms section. Have you checked out the Validation Rule and Validation Text properties on your tables and text boxes?

One way to get around this is to go to the ChangeTitle field in the table and under the Validation Rule property, put Is Not Null. Then, under the Validation Text field, you can put whatever message you want to convey. When someone tries to leave that field empty on the form, they will get the...

It seems to me it should work. If your DB is not too big, and not confidential, I'd be glad to look at it if you e-mailed it to me.

You could use a combo box on a form. The combo box would have the various topics (either listed or drawn from a table or query). On the After Update event, you write code saying: DoCmd.OpenReport "YourReport",,,"[Topic] = Me!ComboTopic" The report will open showing only items where the topic...

Data doesn't get saved to a form, only a table. If you want to view data in the form, you have to give it some criteria so it knows which record to display. It sounds to me like your form is set up to open empty so you can add a new record. To get it to open to a specific record, you probably...

I had to do that just today. You can put this as the Control Source of the text box: =[lstname].Column(1) Column(0) contains the ID, Column(1) contains the name.

All you need to do is put the form and control name as the criteria of the category field in your query. The syntax is forms!YourFormName!YourCategoryDropdown Access will even add the brackets for you.

Where does the close date come from? If you open the report from a form that has a text box containing the date, you set that form and and text box as the control source. I.e. = forms!YourFormName!TextBoxName

On the On Open event of the switchboard form, put in this code: DoCmd.Maximize

Date() will return today's date.

Adobe has a support document saying how to bypass the Save As dialog box and print directly, but it doesn't address how to automate the process in Access. I suspect you just designate Acrobat PDFWriter as your printer in VBA. The Adobe instructions are located at...

Build a query off the action table and include all the fields you need, including the one that links to your cases table. Then set the sort of the DateOfAction field as descending. Finally, make the query, instead of the table, the subform's Record Source.

It is bad form to post your questions under various subjects. I could spend an hour answering your question under "General" only to find someone else has already answered it under "Forms".

What do you mean by amend? Just change the record? You can do that with a form using the table as its record source.

Does the information for the subform come from a query? You could set the query sort the same way you've set the query for the main form.

I have a report/subreport that does exactly what you want to do. I have the subreport set up to print in three columns, which it does, both on its own and in the main report. I can't imagine why yours won't work. On the main report, have you made the subreport field wide enough to accommodate...

Do you need to use subforms? If you only want to see part of a record on a given tab, just put those controls on it. Your record source would be the same for every tab since they are really just part of the same form.

Try this: If TextBox1 = "Yes" then TextBox2.Visible = True TextBox3.Visible = False Else: TextBox2.Visible = False TextBox3.Visible = True

I haven't tried it, but this might work: Iif([CashAmt] > 0 and [MiscTotal]+[ReTotal]+[DiTotal]+[GasTotal]= 0,[CshOnTranFee],[FuFuel])