Search results

Hi - I have a form used to enter criteria for display of records on a subform. There is a refresh procedure that is used to update the subform. This procedure is called on load as well as after changing any of the criteria. This has worked fine on multiple computers running both Access 02...

Hi - I'm trying to set the recordsource of a subform from VBA. In Access 2002, I used syntax like this - Me.frmsubSubname.Form.RecordSource = strSQL This worked fine. However, in 2003 I now get an error - "2455: You entered an expression that has an invalid reference to the property...

Hi - Suppose I have a generic query that returns a group of records. Is there some way to generate a field containing the number sequence of each record? E.g. if there are 10 records, generate the numbers 1 through 10? Must be a simple way to do this, I'm just a bit dense today... Thanks, -g

Hi - Trying to display PDF in a form. Ideally, I would like to link one or more PDF's to each record in a table and be able to view the PDF within the form. Opening the file via double-click would be a nice bonus. I've looked at a helpful post here...

In trying to respond to another thread, I have run into something that is confounding me (or maybe I'm just getting dense). We have a subform. One field has an event on DblClick to launch a search form. When the user identifies the target, he/she clicks a button on the subform. This pushes...

A database with a search form that allows the user to enter multiple criteria and then retrieve the matching records using a "Search" button. Open the form frmSearch and enter criteria in the appropriate fields then hit search (enter just a few or you may get no records). A variety of search...

A simple calendar form that does not use ActiveX. On load, the calendar displays the current month. There are month navigation buttons to move forward and backwards. Clicking on a date changes the background color of the text box. A message box also pops up displaying the date clicked...

Hi - It seems like when I try to post a quick reponse, the web page goes off in the weeds: I hit a "Post Quick Reply" and the forum does include my response. I don't ever get back to the view of the thread - seems to hang indefinitely. I know my response is posted, because I can back up and...