Search results

Are you first displaying the Customize window? If not, Right-click any toolbar and select Customize, then right click your custom button, you should see assign macro.

Open the form in design view, right click the combo box and select properties. In the properties list select Row Source. Click the build button, this displays the query design view of the SQL statement. Under the field you want, change the Sort to ascending or descending. Close the SQL statement...

Right click on the form and choose Design to open it in design view.

I've got flash and would be willing to do the 20 seconds to create the animation for you. Attach the file and I'll get back to you. One question, continuous rotation, or just one?

It's easier to address your problem this way. If it can happen, it will, so build the database accordingly. What I mean is, it would be better to create another table with the address information and create a one (family id) to many (addresses) relationship between them. This way a family...

Wouldn't it be simpler to view the form in datasheet view?

Add a date field to your archive table and in the append query add a column Datestamp: today(). When the query is run, it will add the current date to the table.

Try using a switchboard. The main switchboard directs into a form with command buttons for all the functions of that choice, ie Rockville. When building your forms, reports, etc. base them on queries for each group. Then you can just copy the form/report and change the source.

Do you need to update from this form or not, there are a couple of solutions, I'd just like to be able to steer you in the right direction.

Use the: On Error GoTo errortrap before your code begins, then somewhere in the procedure errortrap: Select Case Err.Number Case 'an error number that needs attention' Case Else 'display default error message' MsgBox Err.Description & " " & Err.Number...

You could create an On Open event for the form that could append a record to a table containing the user name, time, and form name. Then base your report on the table.

You could use a self join for the care-giver/receiver issue. Basically you'd link the table to itself on the care-giver and patient id. So a normal patient's care-giver would be themself, patient # = care giver id. Where a care-reciever would have another patient's id in that field.

To avoid the headers and sum, select what needs to be imported and name the range. DoCmd.TransferSpreadsheet [transfertype][, spreadsheettype], tablename, filename[, hasfieldnames][, range] Just insert the name you gave it for "range."

Ideally, you'd just run the query on the five tables instead of one. Unless there's some design issue, you shouldn't even bother trying to repeat data from one table in another. Once you've created the query, you can base other queries, forms, and reports off the new query. That way, it's automatic.

I'm guessing you want to merge the fields in a query. Hopefully both fields have the date/time format. In design view, in the first row of a column type [date]+[time]. Run the query and the output should work. If the fields are formatted text or something else, you'll have to try and convert to...