Getting Started

Can I launch a form from a report?
Hi, Is it possible to launch a form from a report? I would like my users to be able to click a record on a report and a specific form pops up. How can I do this? Thank You!!!! ... 16 Jun 2008 18:20

Formatting a List Control
I am having a bit of trouble with a list control - I am trying to display multiple resocrds one to a row - I would like to add some calculated fields in between my Table Fields, is that possible ? Also, is there an easy way of formatting the column widths or do I have to edit the Column Widths property - not v... 16 Jun 2008 15:14

Control source in an 'Unbound' control ?
I have various unbound Text controls on a Form - at the moment I can type a formula into the Control Source code point - as some of the code I want to use is long and complicated. I would like to put it into a routine somewhere - how do I do that and how do I tell the control to use it ? Thanks ... 16 Jun 2008 19:21

'Skipping' (via the Tab) fields on a Form
Is there a way to have the Tab 'skip' over (IE not select) fields on a Form ? I have a Form with some fields which I don't think should get focus unless the user actually clicks into them with a mouse left click. Is there a property I can set that means the control will not receive focus when the user is tab... 16 Jun 2008 13:12

DLookup Syntax
What's wrong with this syntax..... E-MAIL CONTACT: DLookUp("[DEALER #]","tblMasterDealerContact","[AUTAC LOOKUP CODE]= ([DEALER NUMBER] & "SRVM")") "DEALER #" and "AUTAC LOOKUP CODE" are fields in the table "tblMasterDealerContact". Thanks for any help in advance..... Shannan -- Message posted via ht... 16 Jun 2008 13:42

Actual Date
How can I have a form to show the actual date as soon as it open and have the data empty ready for input? I tried "On Current" but it doesn't let me move back to a previous date. Thanks. ... 16 Jun 2008 16:48

Data Collection
Which code can I use to get data from a certain range of Date? Example: Date: 6/3/2008 Items Qty Sold Left ----------------------------------- Books 50 5 45 Pencils 90 30 60 I am trying to get the total of Books and Pencils between 6/3/2008 and 6/... 16 Jun 2008 20:22

Creating an Order form
Hi, I want to create an order form. I have my customer form. I created a button that brings me to the order form. There, i have the list of products. What i want is that when i push the button to bring me to the order form, it automatically brings me there, with all of my customer information (the one i was on... 16 Jun 2008 17:18

Access Active X - No Licence Warning
I am trying to debug a DB from someone else - this comes up with a message saying that I am using an ActiveX or OLE Object for which I do not have a licence - it fails to say anything about the object that this message is about - How do I track down and remove this item ? Thanks ... 16 Jun 2008 10:07

Validate at Before Update
I want to do some validation at the Before Update point - what VB code do I use to stop the update (or Add) taking place if the choices fail my validation rules ? Thanks ... 16 Jun 2008 14:13