Search results

Hello! Create a control on your form. In the Data source of the control, type the following: =[Adults]+[Children] (assuming that "Adults" and "Children" are the names of the other fields.) You could also put that same expression in a query. In the top row of the query, type...

Melody, if the "primary" vs. "foreign" thing is confusing, just know that the field type in the child table should not be autonumber (which automatically makes it a primary key) but a regular Number with the size of Long Integer. Hope this helps. Dan

I'm creating an app to schedule people into numbered Time Slots(Each person can be scheduled in many time slots; also, each time slot can include many people). We just figured out how to structure the table to link them using an intermediate table: People->Events->Time Slots. Now I would like...

Thanks. The Auto Tab thing worked with a bit of tweaking (you think controls are lined up horizontally, but you find one must be a pixel higher). This still does not explain why the tab orders manually filled in do not stick. Pretty annoying. Warmly, Dan

Access 97 problem: I have a pretty ordinary form with a tabbed control containing address information. When I set the tab order of the controls, it does not keep what I set but has me jump around in a completely non-logical way. Any ideas? Thanks, Dan

I have a report that I want to export to a text file to create an address list that my users can look up using Notepad (rather than opening Access every time). Problem is, when I export it, it adds all kinds of extra spaces between lines and records. This necessitates me opening the file in a...

I imported a DB from 97 to 2000. Some of the reports were generated by the label wizard and use the Trim function. When I run the report, Access does not recognize the Trim function, asking me to type it as if it's a parameter function, then returning #Error instead of data. What gives...

Keith, That totally makes sense. Thanks for that bit of wisdom. From Florida, the current center of the political universe, Dan

Thanks for the tip. I put the event on the whole form rather than a control because I want the mod date to update on any data change, not just one or two fields. And it's not that the record is already saved. When I try to exit the form, I am told that the edit or addition can not be saved at...

I put a simple command in the AfterUpdate event property of a form, to update a "modified date" field: Private Sub Form_AfterUpdate(Cancel As Integer) Me![txtModDate] = Date End Sub Then when I try to add or edit a record and go to the next one, I get the message "You can't go to the...