Search results for query: *

I am using the following code to print multiple labels in a report If number = 0 Then Me.NextRecord = True Me.MoveLayout = False Me.PrintSection = False Else If PrintCount < number Then Me.NextRecord = False End If End If Evert time I go to open the report it gives...

Thanks a million that was the ticket!

I would like to be able to print checks to pay invoices from Access how can I get the currency number to be formatted in text (ex: $1.00 = &quot;One Dollar and 00/100&quot;) for the printed check? Thanks

I am using the following code to requery several listboxes on a form after an append query has been run [Forms]![position select]![List60].Requery [Forms]![position select]![List142].Requery [Forms]![position select]![List187].Requery [Forms]![position select]![List89].Requery...

My company has a basic form online for submitting data. What I wanted to bea able to do was copy the data on one of my forms into the appropriate fields on the form instead of manually using copy then paste into the form field

Is there a way I can copy information in a access form to a borm based on the WWW?

I need to programatically set some of the items that are available in the page set up for printing a report. I want to set the report margins and the number of columns and column width Thanks

I have a database form that allows an employee to enter a day off request or a requested schedule by selecting a date from a calendar and choosing either a “requested schedule” check box or a “day off” check box. Currently if the employee needs to request a week off they need to create...

I need to set up an access report that will print on mailing labels from a table/query. My delima is that in each record there is a number cell that tells me how many of duplicates of that record I need to print. Some records will need only one label printed and others will need multiple...

How can I copy the contents of a text box to the clipboard?

Every time I try to open my database I get the following message: AppName: msaccess.exe AppVer: 9.0.0.4506 ModName: vbe6.dll ModVer: 6.0.89.67 Offset: 000a391d I feel the error is in the VBe6.dll file. I think the problem is based on the fact that I first installed the runtime version of...

I need a few suggestions on how to solve my problem. I have a report that displays seven days worth of data on one 8x14 sheet of paper on landscape setting. I have been successful in grouping the records by day but when I run the report if there is a day with too few records then the next day...

Currently This is the code I am using to email the schedule Dim db As Database, rst As Recordset Dim strSQL As String Dim Names As String 'Return reference to current database Set db = CurrentDb strSQL = &quot;SELECT [Schedule Email List].[emailaddressPrimary] FROM [Schedule Email List];&quot...

A few examples of using the string variable would be very helpful Thaks

What I am trying to do is to use a query named Schedule Email List to send a series of records in a table named schedule as a full email message using MS outlook. I have been successful in using the Docmd send object but that sends the report as an attachment what I am trying to get...

That was it thanks a million....I burned alot of midnight oil trying to figure that one out.

Now I get a too few parameters error message when I know there is a matching record in the query. Any Ideas?

I have a Form that has 12 Text Boxes each one uses the following code to populate the box: -----------------Beginning of Code------------------------ Text251 = Format(DateAdd(&quot;m&quot;, -0, Now()), &quot;mmm&quot;) Text263 = Format(DateAdd(&quot;m&quot;, -1, Now()), &quot;mmm&quot;) Text262...

That did it.... much better Thank you very much

Here’s my delima. I have a form that has 84 text boxes that are populated with information from one table. I have successfully pulled the data from the table using the dlookup function but it was very time consuming and it takes the form over 30 seconds to load . There has to be a better way...