Search results for query: *

I have a text file from a legacy system that I am trying to clean up. I have opened the file in word and created a macro to make changes to some of the text, this works without any problems . I then created a macro to find the specific text I was searching for, and a second to delete 2 lines. I...

I have 3 fields that when combined are a date, this data is exported form an old AS400 program and can not be changed. The fields combined are for a new contract date. The fields are "T01CONDTM" (Contract date Month), "T01CONDTD" (Contract date day), and "T01CONDTM" (Contract date Month), and...

I have a situatin where we are trying to use information from a data base. One of the fields we have is a quarterly fee. I am trying to automate the printing of contracts. In the database the fee would be "345". But on the contact it need to be printed as "Three Hundred Forty Five Dollars...

I just wanted to thank everyone here for all the help you have given me, and wish everyone HAPPY HOLIDAYS!. Alan Senility at its finest

I have a form with a combobox that uses a lookup to get a company name from a linked table to a different database. The lookup is 5 columns wide, with the first column being the one that is bound. What I would like to happen is that after a company is picked that on the afterupdate that...

We coach hearings for our clients. I have a simple database with entrys for each hearing. I have a query that starts with the contract month for our clients, and then brings back the hearings for each client within a time frame. What I really need is the total of hearings for each client, not...

We have single page reports that are unique to each state, that are added to our clients annual report. I have a query that will return all of the information that I need for every client that need a report for a specified month. The month needed and a line of text are entered onto a form. A...

I have a query that displays information that has been selected with checkbox's on a continuous form. The data is state abreviations. Say the user selects Alabama, Arizona and California. The queries output shows AL, AR, and CA as 3 seperate lines. Is there a way to combine them? The desired...

I am having a problem with record sorting. The data being pulled is for primary and secondary company locations. I have 2 queries that pull the data seperatly, but need a way of combining the output. The first query will give me all of the Primary locations. SELECT DISTINCT QAMAIN.T01PLSL...

I am having trouble setting checkbox's on a form to specific entries in a table. The name of the table is States and contains the following 4 fields. ST (the Abreiviation) , Full Name, Region (Single letter to represent which of our offices handles the state) and Selected (Yes/No). There are 53...

I am using a query to combine 9 queries for the detail to populate a printed form. I am sure that there must be a better way, but I am at a loss. To explain the whole process. The user fills in a form, with an ssn#, a name, an amount and a code number. The form is linked to a temporary table, as...

I have many state reports that have as a record source a query whos data is entered in a form. This allows the user to select and print an individual client's informatin for a specific state. There will be times when there will be a need to print these reports for every client in the state. I...

In my database I have a field that contains client Company names. One of its uses is as a data source used in mail merge. There are names that end with a period, ie "Company, Inc." In some instatnces the field needs to be at the end of a sentence, which ends in a period. Useing this code I can...

I have a form that is used to select and print reports. On it is a combo box to select the desired state, a text box to enter Cust number and an option group to select which of 4 different reports or all of them to print. When the form is opened no choice is selected in the option group. The...

I am having trouble with how to handle a null value. In the records their are 2 contact fields. Normally the 2nd one is used. There are cases when there is no second entry. In this case I want to use the first contact. I thought it could be done with an IIf statement, but cannot figure out how...

This will sound stupid, but how do you add a new option to an exsisting option group. I have an option group that consists of 4 buttons that allow the user to pick which report to print. If the user wants all of the reports he has to select each of the buttons in turn. I want to add a new...

I am trying to print to preprinted state forms. This is 2 part question with both parts tying togeather. Between an input form and a query I am able to get the records that I need to print. The state form can be 1 or more pages, which is determined by the amount of records returned. If there...

I used the wizard to create a option group on my form. It represents 6 different reports that can be selected. When I look at the properties of the buttons, I see tat they are named toggle9 through toggle14 with the values of 1 through 6 respectivly. My thought was to use the value to select...

I have a form that prints a report from entering a companies UC#. The reports are specific to the state that the company is in. The following code is on the on_Click property of a button on the form Dim varx As Variant varx = DLookup("[SLSTATE]", "TDNR") DoCmd.OpenReport...

I am not sure if I should be thanking you all or cursing you. With your help I imported data from our AS400, originally it was suppose to be a one time deal, It came in all Caps and got converted with "StrConv" to Upper/Lower. After running a query, we were able to correct any oddities that we...