Search results

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?

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...

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...

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

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?