Search results

I want to print a replica of a check. The user will enter the amount in dollars and cents. How do I take that amount and convert it to words for the second line of the check. IE - the user enters 20.83 and the report shows "Twenty eighty-three". Thanks, Roni

I have created a report grouped by date that breaks appropriately down the page. However, the user wants the information to go across the page instead. Is there a way to cause breakpoints to print across rather than down? I realize I will have to make this a landscape report. As it will...

I was interested in your answer because I have a similar problem with a report that contains both an Access generated graph as well as text. I tried your suggestion, but the graph did not transfer over to the rich text format file that was created. Anyone have any ideas? If so, it would be...

I have a report which is based on a query. I used the report wizard to create a block style report that looks like: Goal1 Objective1 Initiative1 Status1 Status2 Initiative2 Status1...

The plot thickens. I substituted another query in the code where 'qryEmployeeExists' is. The code works - both for a query w/records and one without. SO now we are down to the problem being the query itself. The query compares an employee id garnered from the LAN using VB code to employee...

I have the following code launching on the 'Get Focus' of one of my fields on my form. Basically, the code is to run a query and display a message box indicating whether or not there are records in the query. Private Sub CustomerLastName_GotFocus() Dim db As Database Dim rs As Recordset Set...

I have an imported table with a name field in the last, first format. I need to go through each record and split the first and last names into two different fields. Each name contains a comma, but of course, each last name is a different length. I have created blank fields to store the last...

All of my users must log onto a fileserver to use access. I have a db that they are required to enter their employee id on each record. I would like to create a macro that automatically pulls the id from their lan logon. How do I use the Setvalue function to check for the LAN ID? Will I need...