Search results

Talk to Brad at clermontsoftware in Florida. He did something similar for me with SQL tables as the backend and I was able to email front end Access databases to the users.

Which report is it?

Can you upload a sample table and I'll knock it put for you quickly.

In the group/ sort. Is seq just a sort, then group by station? Or is it group on seq and group on station?

Yes. Add a footer to the grouping. And then add a dashed line.

You can sort on items that aren't visible on the report so keep your sort field and add another field with he dashes.

Is the control source of the form set to the table? Go to form properties, all tab very first property is the control source. You should see the table name.

You can create a query that shows all items not ordered by that company. I can knock it out in 5 minutes if you upload some sample data.

Yes, use the macro send email, for the to field use =forms![nameofyourform].[nameofyourfield]

Also create a macro to open form, go to record, go to new record.

Go to form properties, data tab and set allow edits and allow deletions to no.

Yes, barely:)

Shouldn't you use the quit option int the macro?

Ran accross this forum using Tapatalk on my Iphone. I've been using Access for 14 years now. I'm doing a lot of hybrid databases and am very excited for the future of Access and Office365. If I'm not working on Access, you'll find me on a lake riding the Sky Ski (skyski.com) or hanging with...