Recent content by DFeil

Hi Bob, Thanks for the reply, yes I do still want to see the existing records. I have already tried setting the form and subform data entry properties to yes, but do not see the previously enter records. Is there any way to do it so the existing records can still be accessed? Thank you for...

Hello, I have a main form with multiple subforms in tab view, right now the forms only open in edit mode, I would like all forms to open to new record mode. I know I can set the main form with the switchboard manager but what about the subforms? Help please. :) Thank you in advance. Dave

Hello, I was wondering if it is possible to create custom security permissions in access. For example I have created an employee database, with security. I would like to have it when a manager logs on, it will only display his employee's information and no other departments. Is this...

Once again you rock, worked like a charm. Thanks. Dave:)

Hello I would like to create a form, that be used to enter data into multiple different tables. I would like to use tabs for each different table. Can this be done? Thanks in advance. Dave :)

Nope, and since you couldn't figure it out, I'm not going to tell you!

I got the answer in another forum!

Hello, I have created a database which has 9 tables, the first table being the contact information, but in all tables there are fields for firstname, lastname. Is there a way when you enter the firstname/lastname fields into the main table that it can populate the same information in to the...

Both worked, you guys rock! Thank you.

Yes the users will use a form, and and have to enter the month and the year they would like the queries/reports generated on. Format mm/yyyy . Does this help?:)

Thanks Alan, that will work, but I am looking for a way for the current date to be used as the base criteria, so that the user does not have to think about which number a month is... Got to keep is very simple if you know what I mean. Thanks. Dave:)

Hello, can you tell me what expression to use to generate a query based on a month alone, not a year? For example, If I run the query today, it should bring up all the records for the month of November, but it doesn't matter what year the record was entered. Does that make sense? Thank you in...

YOU ROCK!!!!!!!!!!! It works! Thank you, would this expression work for years as well?

Yes that is exactly correct. Thank you.

Thanks for your help, quitting till Monday, have a good weekend. Dave