Search results

Thanks for your help Bob. I appreciate the design flaws, which is one reason I hate working on existing projects that a non-Access designer has created. Eugggh! If you do have any ideas, much appreciated.

Let me be clear... On the Student Information form that opens on opening the database, click the Courses tab. The idea is your can pick off a FacultyID and it will populate the field for that current student.

Ok, I have uploaded the file at the following link: www.logme.info/Test v5.zip I've hated working on this database because it was adapted by a non-programmer from a Microsoft template. Yuk!

They got Vista wrong!

It worked and its quite fun too!

It broke here: '*** delete the table if it exists CurrentDb.TableDefs.Delete "tblRandom"

Ok Bob, whenever you are ready. :)

I think its a step backwards. Why on earth would they do that. :(

I am aware of that. But I like the use of the Wizard. Anyone?

Very nice. I can see how that would work. Thank you!

When I use the Form Wizard for a button that opens a Form, it creates a Macro. How do I get it to create the vba code instead, like earlier Access versions? Thanks, Dave

Examples are Query1 is based upon another Query with Totals and criteria, whereas Query 2 is based upon a table with just different criteria. Does that help?

Bit confused by what you mean. The Queries have the same fields on them as the controls on the Form, so that shouldn't be an issue, yes?

I have a switchboard with 3 buttons. Each button opens the same Form, but I would like the Query to be different. How can I do this? Thanks, Dave

I don't mind actually. Might be easier for me to just do a find and replace. On the other hand, it might be useful for these forums to have such a tool.

"The record source '~sq_cDataScramble~sq_ccboFieldName1' specified on this form or report does not exist." It appears when I first click the drop down on the Field Name combo. Maybe something to do with the fact I removed tbl from the Table Name filter and so its showing other Objects?

Thanks Bob. I notice on the Field Name combo, it comes up with an error message so I think there is something that needs updating on there too.

Or I could just do a find and replace on the tables...

It doesn't seem to work in Access 2007 and the site says its for Access 2000. :(

The database is Access 2007. Would I export the tables to 2000 format, scramble and re-import?