Recent content by HappyBunny

How do I set my Default Value to "..."? It's set,but the minute I change the format of the drop-down list columns it disappers. My entire code hangs on this default value. How do I make it show on the form when no criteria is selected? (It's for a query)

Thanks Pat :D

I want to enter the criteria and get the matching records with a button that opens up a detailed form? How do I do that.

How do I link my Query to my Form with 5 independent of each other drop-down lists of criteria selectors(combo boxes). I want to have a "Run Query" Button on the form opening the query and showing the query recordset for the selected values?? Thanks

How can I store the pdf files so that when I move the whole folder to another drive I wouldn't have to change all the hyperlinks in Access? Please help :)

I have 8 drop-down list selectors ( Relay ID, Substation, Manufacturer, Type, Model number... and so on). There is a "Run Query" button linked to a Query that has a separate criteria statement for each of the 8 fields. For example, I want to be able to select a Substation and a Type, but leave...

I have 8 unbound combo box controls in a form and a "Run Query" Button below. What should I put in my query criteria fields?? How do I accomodate for the OR logic necessary here? I want to be able to select as many and as few of the given 8 optional search criteria selectors, but I always...

Thanks Statsman. :D What kind of a format is COMBO# in? Do I just put down a number..like 2, for example??

HI, I have a form with a few combo boxes on it and want to add a 'Run Query' Button to it to open a query for each combo box. BUT What do I put for a criteria in each query field???? i tried [Forms]![frmCOMBOBOX].[cboRelay_ID] , but it didin't work.. COMBOBOX is the name of my form with the...

how do I make my query look like this [ NOT a cascading sequence. completely independent of one another ] Select Product ---> drop down combo box type list gives me options Select Type-----> combo box options given Select Job number--->... Select.. blah blah blah..---> Then I can have...

How do I attach files to records in Access 2003? How do hyperlinks work? How are the files mapped and setup?

I have a form that needs to have 3 macro buttons. Delete (record) Insert (record) Edit (record) Not sure how to do that? Can you help me please?

I want to have restricted access for some users and I want my database to record every single change that was made with the date, purpose, user information, and details changed saved somewhere. Is there an easy way of doing this or should i mastermind it from scratch? :D thanks

Hi.....Im trying to learn how to attach a file to the form....The idea is, the user can not only add a record but will also be able to add an attachment for that particular record....lets say I would like to add an excel or word doc...this has nothing to do with sending attachments and...

I've seen Access 2007 explanations, but Access 2003 doesn't seem to have an Attachment option under Data Type. How do I go about it. :D Please help. Thanks