Search results

The Bookmark property with forms to set a bookmark that uniquely identifies a particular record in the form's underlying table, query, or SQL statement. Maurice St-Cyr

This should be quite simple in a query. How are your tables linked?

I've posted a sample database that does what you're looking for, namely the example MoveRecord. Hope this helps. Best regards Maurice http://www.access-programmers.co.uk/forums/showthread.php?t=103456

It's not a good idea to store the results in a table. You can use the formulas in the query. I imagine that you have created functions ( modules ) for the formulas.

I would just put this code in the form - that's what I did the last time. Read the incoming data then dump it into your table, I normally let the data capture run for 10 min. then add it to the table, then reset the data capture file

There is a good sample in the Sample Databases area

I've used this before and works quite well: Open "Com1,9600,n,8,1" for output as #1 Print #1,"This is a test" Close #1

As per the sample I provided you can calculate the working days as long as you have both a Start Date and an End Date. Typically the calculation would be done on the On Current event, if you do the calculation on the After Update event, which means that you have changed a date, then you should...

Hi I created a small sample for you over the lunch hour. If you need additional help please let me know.

if you wish I can make up a sample of this for you.. Maurice

Yes you would create a form on which you would enter the StartDate and the EndDate. Then the StartDate and EndDate of your function would be called from the form...ie. forms!myform!startdate

Create a new module and paste the following code into it. If you have any problems please feel free to post back. Public Function mlfWorkingDays(BeginDate As Date, EndDate As Date) As Integer 'Returns # of whole working days (M-F) between 2 dates. 'assumptions: ' Working days are M-F ' Day...

Hi Rosemary If you are just looking for a simple way of doing form letters, you can always download a copy of the Form Letter Generator sample that I uploaded a while back. You can find this at the following location: http://www.access-programmers.co.uk/forums/showthread.php?t=113956

Hi One of the samples in the Sample Databases area would be a good start for you, simply modify the code a bit. This is located at: http://www.access-programmers.co.uk/forums/showthread.php?t=108698

Have you looked at the Northwind sample that ships with Access... there's enough there to get you started

I just tried it with the following, and seems to work fine.. Open "Com1,9600,n,8,1" for output as #1 Print #1,"This is a test" Close #1

This sample allows the user to select the OrderBy of a report via a popup form.

This allows the user to filter a report data from the popup form Access 2000

I saw an example of that in this forum just a day or so ago. Do a search in the forum.

What's wrong with the report designer?