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...
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 = "One Dollar and 00/100") 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
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...
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 = "SELECT [Schedule Email List].[emailaddressPrimary] FROM [Schedule Email List];"...
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...
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("m", -0, Now()), "mmm")
Text263 = Format(DateAdd("m", -1, Now()), "mmm")
Text262...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.