Search results

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

Unfortunately, the popup form idea won't work. This is actually a part of a larger form (the pending tasks show up as a subform in a box on a main form), so I really need to find a workaround for the continuous subforms within continuous forms issue.

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

Thanks for the suggestions. Unfortunately the data that becomes the primary key has already been created before the information is entered into the database, so I truly do need to ensure that the primary key doesn't exist before the data is entered. I was using exactly the DLookUp code as...

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

Thanks, that gave me the idea that finally worked. When I put the image on top of a transparent command button, Access defaulted to "seeing" the image first when the user clicks on it (and, thus, not executing the OnCurrent code). The problem was solved by sending the image to the back and...

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

Success! (I think.) Time to test it out with the other subforms. Thanks again... I think you may have solved the problem.

Ian, Thanks for your continued help with this. I am still getting used to Access and therefore may be missing something obvious, but my problem with using the list box is that I can't figure out a way to insert the three command buttons to the left of each record (which would then be in...

I thought that was going to work, until I just looked at the form again. As I have it designed now, the "main" form or frame (left side) consists of a one-line detail section that's set to continuous form view, which creates the scrolling list on the left side of the screen. If I try to put...

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