Search results

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

Thanks alot! That will help much

Hello everyone, All I really want to do is have a button on a form that opens an excel spreadsheet. I know I can have a button run excel, but I would like it to also open a particular spreadsheet. I unfortunatly have not found any code or macros that do this. I was just wondering if anyone...

I'm working with a form which is based on a linked table. I haven't had any trouble with it before. While using the wizard to create a goto previous record button, as I click Finish, I receive the message "Subscript out of range" and am unable to create the control. I've created controls...

After making some minor changes to a fairly complex form, it now appears as a blank grey window in form view. All the controls and labels etc. are visible and can be modified in design view, but for some reason I can't see any of it in form view. Any suggestions?