Search results

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)

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

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

I have a datasheet subform that shows a different number of raws/records for each record in the main form. HOW DO I FORMAT THE EMPTY SPACE LEFT WHEN THERE'S ONLY A FEW RAWS SHOWING. BACKGROUND COLOR AND SUCH. <Also, if anyone knows why i can't get a blank record for data entry on that form...

I had lots of tables with 8000-10000 records in them. I need to add more info, so I created a form. How do make the bound controls into combo boxes from this point. i have separate tables containing the options that could be selected for each field. Help... anyone.. anyone..:(

A single form subform stays put at all times, even when it has to be blank due to the lack of data. A datasheet subform disappears and I can't add the first record in it. What do I do? PLEASE HELP. I'M desperate

I build a form for the 8000 or something main records and now I can't add new data to them because when I set it to data entry my records go down to 1. WHAT DO I DO. I've been stuck on this for a week. Also, my subforms are not blank, but missing when a record doesn't have data for them. How...

My subforms disappear when there's no table value for them. How do I get a blank subform that I can fill in from the form. PLEASE HELP. Thanks