Search results

I have a weird situation involving a report that is ran from a form. Whenever a user tries to open a report from my form and decides to cancel opening the report, Access will lock up and I have to get into Task Manager to close Access. I am running Windows Vista and Office 2007. The form that...

I would like to sort records based on a range of years for a chart. The chart is based on a cross-tab query. An example of this range would be 7/01/2003 to 01/30/2006. I would like to sort this based on oldest date to newest date. Listed below is an example of the Row source of the chart...

I would like to sort records based on fiscal year for a chart. The fiscal year would be 7/01/2003 to 06/30/2004. I would like to sort this based on oldest date to newest date. This query could span several fiscal years. Any help would be greatly appreciated.

I have the following string: NE1220904 I need to remove the left two characters and the right four characters of a string in a query. I have found how to remove one side or the other, but not from both sides. Thanks in advance for the help!

I have a query that pulls a date field from a table. The field is in the dd/mm/yyyy format. Is there an easy way of pulling the month out of the field and then pull the year when I run the query? The query I want to build has to look up records based on individual months and by fiscal year...

I am looking to Import and append multipe ASCII Comma Quote delimited files into one Access table. The files can be imported one at a time but I would like to have this process automated as much as possible. Is there some sample code that I can reference to accomplish this task? Thanks in...

I have this VB Module that prints a report. The first page prints on letterhead and the rest prints on regular paper. This code is set up to print on two trays. My problem is that when I print a report that is only 1 page, a second page will print. The second page will have page number 2 of...

I want my report to calculate the sum of a field called credit_3. The field calculates fine until there are blank records on the report. When blank records show up, the calculated field shows #error. I have tried to use the nz function EX: (=Sum(nzl([credit_3])), but still get the same error...

I am trying to set up a continuous subform that has the ability to delete individual records. The main form is based on a table, but the subform is based on a query of two tables. I want to be able to place a delete button next to the row of the continuous subform and delete the record based...

I want to be able to add a chart to a report that shows the high and low values of 6 fields in a bar graph. Getting the graph to show the high and low values together in the graph is where I am stuck. Any help would be greatly appreciated.

Is there a way to left or right justify fields in the datasheet view of a table? Any help would be greatly appreciated.

I am printing 2 copies of the first page to letterhead and the rest of the report prints to plain paper. The report prints fine if there are multiple pages to the report, however if there is only one page, the report prints two copies to letterhead and one copy to plain paper. The copy that...

I am using a trim function on a report line that will place the address number, address prefix, address street, address type, address suffix, and address extension on one line. The problem I am having is if I do not have an address number or address prefix, the line does not left justify. The...

I have a report based on a query. I want to be able to show a field on the report from the results of my query, but not be part of the criteria for the query. If I add the field to my query, I get more records than what I need. Is there a way to get the field I want to show up on the report...

I am having some problems creating a query that will produce the results I am looking for. Here is the problem. I have a table called test. I want to query Cert_no, Serial_no, Weight_no and retest_no. The query will produce a report that will show all Serial_no, Weight_no and retest_no for...

I am trying to place code into my on click event of my print report button that will print a report to letterhead and plain paper. Ther are two drawers on the printer one is for letter and the other is for letterhead. Listed below is my code for accomplishing this task. One problem I have is...

I have a problem calculating the sum of another calculated field. Here is my calculated field, called total1. =IIf([TYP_CHARGE1]="E",[QTY1]*[UNIT_PRICE1],[hours1]*[Unit_price]) I need to calculate the grand total for the total1 field. Any help would be greatly appreciated.

I am having a strange problem with a continuous subform writing to a table. I have 8 fields that are bound to a table and 1 field that is unbound. The unbound field is a field that is pulled in from another form. When I am entering in test data into my subform, all the data is written to the...

I have a form with two subforms. Both subforms are based on queries. There are two tables that I need to write the information to. There are no relationships between the two tables. I can use DAO to write unbound fields to my main table, but, I need to find a way to write subform data to my...

I am trying to add an incrementing 4 digit number to the middle of a string. The incrementing number is not working. There must be a better way of writing this. The result I would like should look like this: LB-0001-02. Where LB is static, 0001 is the incrementing number and 02 is the year...