Search results

I have a datasheet as my subform and on the form are the search buttons to bring up a specific record. Question: How do I show all records in the datasheet. When I run the query which is the record source by itself, it works showing all records. I can't get it to work on the form. HELP...

Do I set relationships in the front-end program or the back-end data? Thanks for any help.

I have a database where I set the relationships. They keep getting broken. How is it they get broken and I get left with orphaned records?

My form is opened in a report. The size of the detail section depends on which report the user selects from a list. How do I change the height of the detail section of the form so there is not much unused space at the bottom. Thanks.

This is my first time using an access database to link to oracle tables. What's the verbage needed to connect to the tables? Thanks

I have an access db that links to tables on a CD drive. Any code out there for when the clients have their CD's mapped to different drives? For instance, one is mapped to E: and another is mapped to F: and we don't want them to have to relink each time. Thanks.

I have a form that opens when a command button is clicked on the main form. When the form opens it is automatically maximizing even though I don't have docmd.maximize in the code. I don't want the form minimized, but want it to come up not maximized. How do I achieve this? Thanks in advance...

How do you change the color of a tab control on a form to say yellow or blue? thanks in advance for any help!

I have a relationship set between two tables in my database, but when I go to do a new query with them the relationship line does not appear in the query like it normally would when a relationship is set. Thanks in advance for any help.

I have a form set up so the user picks a project from a list. He can then pick a charge code type, ie, Hourly, Fixed, etc, which describes how the person is paid. so they can pick a project and they can choose "hourly" for all hourly persons working on the specific project. My problem: They...

I would like a pie chart to come out for each department. What is happening, I get the new data but the chart does not change. How do I get the chart to reflect the changes in data?

In access2000 I need to round up to nearest whole number. Here's an example: 1.00001 would be 2. Anyone know how to do this? Thanks.

Okay, I know how to make the mouse an hourglass, on the MouseDown event. How do I get it back to the arrow when my process is complete? Thanks.

I have a field stored in my table as 000.\a format. So it looks like 008.1, or it can be 008. On my report the field comes out as 0081. I need the "008.1" format to come out. How do I do that. the field is defined as text in the table. Thanks in advance for any help.

I am deleting items in a table through a form. I get msg nbr 3320: "Function is not available in expression in table-level validation expression" This deletion works on my pc but on my users pc's it does not. Any experience with this problem and how do I resolve it? Thanks.

How do you get the created date off the database pjroperty general tab? Thanks.

I need to let my users know what the name of the database is they are running reports from, ie, at the bottom of each page, it would read DatabaseName.mdb, created date: mm/dd/yy. Thank you for any help!

I have a hard time with functions. Can anyone write one that: The user enters a number into Text1. The function needs to calculate a tax that is: Round(Text1/500)*4.3 The number needs to be rounded up. Do I call the function from the AfterUpdate event on Text1? thanks in advance for your...

I have 2 textbox fields on a form. When I enter data in them (these are unbound, used as parameters in a query), and open the form again, the data I entered before is still displaying in the text box. I have tried initializing to " " on Open and Activate, but get same result, ie, previous data...

Does anyone have code to go from 800 x 600 to 1024 x 768? I have an access db I developed on my pc (1024 x 768) and a few of the users keep their display at 800 x 600. I would like code that temporarily changes their resolution to 1024 x 768 so they can see the whole form on their screen...