Search results

There may be a more elegant way to do what you want, but I would suggest using Append action queries to write the records you need based on which checkbox(s) are checked. HTH JT

In our training room this week where we recently re-imaged the hard drives of the PC we had the following two problems. Hopefully someone can shed some light on ways to correct them. We are using Access 97 and Windows 2000. 1) After opening a database, then when opening a table the students...

Page setup 'settings' ARE saved with the report design itself. JT

Is there a way to send Access to Excel and specify to 'Which Sheet' I want it to go to. For example if I wanted to send data to a sheet named "January" in an Excel workbook file named "2003 Data.xls". Any suggestions would be greatly appreciated. Thanks. JT

If still interested, send to vcs.jack@erols.com, preferably WinZipped JT

Not likely. You might be able to accomplish what you want to do with VBA instead. JT

Since it sounds like you already know how to us IIF in a query, have you considered in the Calculation field testing the value of a checkbox then setting your formula to A-b or A+B, etc. ?? HTH JT

Have you tied the macro to the after update event of the specific field on your sibform ? Also I would use a conditional macro which would check all variations you need. = 2 then Msgbox 'about two', >3 then Msgbox '4 or more'. HTH JT

Cathy Could you post the necessary objects. Maybe can identify a way around your problem. JT

Don't think you can do it 'dynamically' in a macro but you should be able to use VBA code to accomplish what you want... DoCmd.SetWarnings False DoCmd.TransferSpreadsheet acExport, acFormatXLS, "name of table (or possibly query)", "c:\db_Excel\NANGenderCalls.xls", False, ""...

Worth a try if the user enters UDP08 or UDP03 (with the or as shown) your query should pick it up properly. Just a matter of training the user. HTH JT

You're right this is a project ! First you must create a query or query form to allow the user to enter Width, Height, etc. needed. Then you can probably use the Report Wizard to create the basic report but you'll have to add the Company logo, etc. manually. Good luck. JT

Grouping renders a query 'un-updateable'. Try using an UPDATE query once you know which groups you need to change. HTH JT

If your query has parameter questions when you run the report (that's how you're providing the Start and End dates) then in the report place a text box for each and for the Control Source property type in =[same phrase you used in query parameter question]. HTH JT

If you could post the necessary objects, maybe someone can 'see the problem better'. JT

You could use checkboxes on the form, then build the SQL statement to pick up the correct data for the report. To see how to build the SQL statement, build a Query (in design view) and look at the SQL 'behind the query' (see View menu item). This will help you discover the SQL code necessary...

IS your combo box tied to a source field ? If so, the width of entry would be held to that field's size in the table. If no Control Source, try increasing the size by adding your own Column Width and IF you do, also put the total width in List Width. HTH JT

Best I could do is create the Texbox at 0.01" high, place its top edge hortizonally across from the bottom edge of your Memo field control. Set the Texbox properties CanGrow/Shrink to Yes. HTH JT

Instead of splitting into multiple forms as it sounds like you've done, have you considered using a single TABBED form, putting the data categorically on each tab as necessary ? Sounds like the problem you currently have is that Access thinks more than one of you are changing the same record...

On the AfterUpdate property of the field in question use Event Procedure: [Name of Field]. value = UCase([Name of Field]) HTH JT