Recent content by jerbacher

I posted this question here as well because I wanted to know how to do this on a form control as well as a table field, and didn't know if it might be different for the two

I posted this question here as well because I wanted to know how to do this on a form control as well as a table field, and didn't know if it might be different for the two

Hi, How can I make a control equal the last two digits of the current year?

Hi, How can I make a field equal the last two digits of the current year?

Tim, PRO-02-0001 stands for and engineering project at the company i work for. 02 represents the year. PRO is simply a prefix they use currently outside of the database which needs to remain. This prefix needs to also be attatched to every record in this table, therefore, I do need the code...

Hi everyone, This is a fairly simple question: How can I make an autonumber field which numbers PRO-02-0001, PRO-02-0002 etc.? Any suggestions would be great! Thanks a lot. Jon

Hi everyone, I'm not extremely fluent in queries, but I have a question. I have information in a table which is updated from an external source in the form of an excel spreadsheet. I was just wondering what type of query to use (if a query is even the thing to do) to update the information in...

jon.erbacher@dometicusa.com access 2000

Thank you, but unfortunatly the company I work for has a firewall which doesnt allow me to view that page, sorry. Maybe if you could email that file to me at jon.erbacher@dometicusa.com, i think i might be able to get it that way. thank you!

Hello everyone, I have a form titled "frmInstallationAudit". On this form are two combo boxes. In the first combo box are company names which are pulled from the table "tblCustomers". In the second combo box, I wish to display a list of contacts which relate to the company chosen in the...

that link says access 97...is it going to make any difference that im on 2000?

Actually, thats a great idea, and I tried it. It functions as a button would but theres one small problem. This may be dumb thing, but the label then doesn't animate as if it's pushing in like buttons do. This is a small thing, but I think my users would want that feeling of knowing they're...

Actually, the button doesn't work then because I'm clicking the label. Is there anyway to make the label so I click through it or something?

Good idea, thanks a lot!

Hey everyone, This is a pretty simple question so I'll keep it short. Is there any way to change the color of a button on a form? Not the text color, but the color of the button itself...Thanks a lot. -Jon