Search results

Does anyone have a recommended way to deal with images (ie. linked to file, OLE object embedded, others I'm not aware of)??? I have a report which summarizes the history of a project. In this report I have a subreport which has task information. As a user enters task information they have the...

I have a problem with my report not showing all my linked images. I think I have found the problem (see background below), but wondering if anyone knows the solution, a work-around, or anything I can try. I need to be able to print my reports. HELP. BACKGROUND I found OldSoftBoss's...

I have a report with 3 columns organized to fill accross and then down. I use this report as a sub-report in a few other places. It seems that whenever I try to use "Page Setup", it takes 30 or more seconds to open the page-setup dialog box. This is true for the report itself and any report...

I searched and found a very helpful thread for understanding and working with many-to-many relationships. The database Pat Hartman attached to the following thread was very helpful: many-to-manyDB Now I have an additional question that I will base on the database attached to the...

I have encountered an error in converting my 2000 database back into '97. My database has the user check out the next available number for an experiment ID [TestID]. After clicking on a "Save" command button the code assigns this testID # to an integer variable and closes the form. The...

I have a database (2000) whose code works fine on my home computer, but not when I brought it to work to begin implementation. I make the following assignment in code in a Form-Load event: Forms![Experiment_Num_FRM]![TestNumber] = LastTestNum [TestNumber] is a textbox and LastTestNum is...

Filtering a Form Using a Query - See attached DB Please find the 1 attached MS Access 2000 databases that has been considerably simplified in order to demonstrate my dilemma. I want to know why Db1 works and Db2 does not. Db1 is attached to the post, but you can create Db2 by deleting column...

I have a report that is based on a table. Pretty straight forward so far. I have the design and layout that I like with the appropriate fields. I have several queries that are based on that same table. Each query outputs the same fields. The only difference is that they differ greatly on...

See Attached Db's (Filtering Form Using Query) Please find the 3 attached MS Access 2000 databases that have been considerably simplified in order to demonstrate my dilemma. I want to know why Db1 works and Db2 and Db3 do not. The desired result is to run “Macro1” and have it perform the...

I have a report that is based on a query. When I open the report from a VBA module, the report does not show the current values in the query. Even when I switch the report into Design View and then back to Report view, the data stays the same (OLD). If I manually run the query, close it, and...

I have a database in ACCESS '97. I tried to convert it and/or open it in ACCESS 2000. It asks me if I want to convert or open. Either answer results in the same thing - - - a blank screen staring back at me (No database present). I've waited up to 5 minutes and nothing. Its not a very big...

If I need to edit data in a table via VBA code, do I have to operate on the data through the form object or can I do it directly to a table. I've tried it for data on a form, but it doesn't seem to work when I tried it directly on the table that a form was based on. The reason I ask is because...

I wish to have a command button on my form that invokes a file browser to allow the user to search for the desired file. I then want to store the path and file name in two separate fields for later use in addition to storing the full path in a hyperlink field. My main questions are: 1)...

From my experience, Access has a limitation on the number of fields for an individual table (255). General Questions: Is this accurate? If so why? Query time performance? Any work arounds? Does this limitation apply to queries as well? My Specific Application: I have created a database of...

I read that Access saves the formatting of a report (ie. margins and landscape vs. portrait). Sometimes it remembers them and sometimes it does not. The database is used by several people and I need to ensure that when someone opens a report it is brought up in the correct format. Is there a...

I don't see where Access gives me the functionality to create a stacked column chart in a standard report. I have the flexibility of listing the data in whatever format in the table it needs to be, but I NEED a stacked column chart to show how portions of my data contribute to the whole. I am...

I am working with a tab control (functioning ok). HOWEVER, . . .when I transition from Design View into Form View or . . .when I start the form directly I have to scroll up to get the tab labels to show up. No matter how I position the tab control on the form it always positions the scroll...