I have been trying to figure out a way to essentially force a subreport into a text box on the main report. For example, I have a main table and then two related tables that have only two fields: the ID code relating the subordinate tables to the main, and one other field.
Because there are...
I am trying to create a continuous form with a continuous subform but Access won't allow this, so I'm wondering if anyone has a workaround or any suggestions. What I'm trying to do is create a task list that will appear on the screen (in a form, not a report) in essentially this format:
X...
I have a form (actually, it's a subform, but I don't think that matters for purposes of this question) that is set to display only in continuous-form mode. The form takes up the left hald of the screen and each of the records is displayed in one line. There are a series of buttons associated...
I'm trying to create coding for a button that will allow the user, when the button is clicked, to access a company directory. If the user is working either from the office or on a laptop with an Internet connection, I'd like to have Access open the web page into a form.
If, however, the user...
I am trying to create a function that can be called from several forms to validate an entry in a table.
What I would like to do is pass a user-input value to the function, have the function test to see if a record with the passed value exists in a specific table (in the primary key field)...
I have a series of reports based on the same query and have been using the reports and the query without problems for several months.
Yesterday I added a table to the query. When viewed, the query operates correctly and generates no error messages.
However, when I run the reports based on the...
I currently have a form with several command buttons on it, but every time I insert an image into the button, Access automatically transforms the image's background to gray. I have several images with white background and would like to leave them thay way.
To combat the problem, I changed the...
I have been working on setting up an Access database and thought I had everything
figured out (especially thanks to some help from folks here), but I have been running
into a problem that I haven't been able to solve. It's taken me about a month to try
various options without success --...
Does Access support either frames or a workaround in forms? Here's what I am trying to do, and maybe you could suggest ways to accomplish it.
On the left 1/3 of the screen, I want a "frame" that will display certain fields of the main database table. Next to each record will be 2-3 buttons...