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

Rich, Thanks for the reply! Where would this code be placed. Please forgive my ignorance.

Would this work for a cross tab query as well? I just realized that I have a chart that I need to build based on fiscal year. Your suggestion worked great for my select query, but it does not work on my cross tab query. Any suggestions would be greatly appreciated. Thanks, Greg

Thanks for the reply!! Your solution worked great.

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.

Perfect! Thanks for your help!!

Thanks for the reply! I tried your suggestion. The middle of the string is variable length. When the field is smaller than the rest, it places a zero in the field. NE10903 has only one character that I need (1) but the result in the query is 10. Listed below is my code that I am using...

How would I enter this into a field for a query. Thanks!

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!

Thanks for the reply!

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 tried your suggestion and it worked! Thanks for your help!

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

Perfect! Thank you for your help! Greg

Thanks for the reply! There is another problem with the calculated field when there are no records on the report. When the report is displayed and no records are present, the calculated fields show #error. Is there a way to fix that to?

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

Neil, Thanks for the reply. I need to delete only individual records on the continuous subforms. I will try to use the delete query idea.

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