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

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

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

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(&quot;m&quot;, -0, Now()), &quot;mmm&quot;) Text263 = Format(DateAdd(&quot;m&quot;, -1, Now()), &quot;mmm&quot;) 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...

I am having trouble running the following code. I am trying to access a query named &quot;Schedule Email List&quot; and I wanting to email a report to each individual in that query. I am getting an error on the set rst line. the error is a runtime 13 error type mismatch. Im sure it is a...

I am having trouble with Access displaying NAME#? In any field that has date() as it’s control source. I have isolated the problem to be an issue when I distribute the .mde file to other users who may have some of the references missing on their system. My question is how can I have a list of...

I am trying to eliminate the warning box that appears when an action query is selected. I want to do this programmatically instead of under the tools:options selection. I tried using the docmd.setwarnings=false but to no avail any suggestions?

Is there a way to shrink and grow a list box automatically on form open to only fit the number of records that will be represented in the box?

Here's my delima. I have a form in a access database that has two combo boxes. Each box starts at 9:00 PM and works itself up to 11:59 PM. After the second box has been selected then the data in both are saved into two seperate text boxes and the difference in hours is saved into a third box...

I am trying to use Dtpicker in an access 2000 form however when I try to have the results saved from dtpicker into a short formatted text field it saves both the date and a time stamp which is limiting my options. How can I get it to only save the selected date only in the text field?

I have 2 socket servers running on a remote machine. On my local machine i start a PERL program that should pick an idle server on the remote host instead of just queueing up on the first servers listen socket. How can i see if a socket server is busy and i just end up no. 5 in the listen queue...