Search results

I have two criteria i need to group on. One is a true/false field and the other is a date field. What I want to do is group all the true fields together at the beginning of the report then I want all the false records to group by date. The results i am getting is either all the true fields...

Thank you very much. Great help

I have a customization i need to make in a system we have. I have a new form that I need to open in code from the form that is active. The problem that i have is that i need the previous form to wait until the new form closes to finish executing it's code(put it in a loop or something?)...

I have a report based on a query. The report shows the user multiple part numbers and then details of thier usage in the detail part of the report with a running sum text box also in the detail part of the report. I don't want any of the detail information in of the unique part number to show...

I have a query that uses about six other queries to get it's result. Is there any way I can combine all of them into one big sql statement? Thanks Sean

I actually am having the same problem. I wonder if it is a bug.

i would like to be able to type in the record number in the record field and have the record come up. If the record is not there I would like to ask the user if they want to create a new record. I know you can use the find button associated with access but my clients don't like it. I also...

I have a program where I need to insert a solid strait arrow on a line in a text box right after some text. like this but solid. tube 5674 direction -----------> Is there any way of doing this? P.S. I cant use a image field. needs to be a text field

I have a barcode program i am using where the user is going to be away from the computer. I want to use a beep if the record was posted and some other sound if it wasn't. so are there any other sounds than just beep?

nevermind. My mind is out of it today. Sorry

I am using the API code that is in this post to bring up the open/save windowand It works great. The only question I have is this. Is there a function in the code that will allow me to get the path to the file they want to choose. What I am trying to do is get that path and then copy the file...

Thank you very much Wayne.

Is there a way in access to flip the text you are printing 180 degrees? Basiccally printing backwards. I have a thermal printer and it prints my labels backwards. Thanks Sean

that's great! thank you i have been trying to do that for a while. i am not a programmer and I will never claim to be one thank you both again for your help. :)

This is probably one of the stupidest questions to ask but i am lost. this is my delema. I have never made a form that grabs data from a table without actually using the recordset property on the form. I am trying to move up a level by having an unbound text box and grabbing the record I need...

IT DOES PRINT OUT AFTER EVERY "NTH" DETAIL. I NEED IT TO PRINT OUT AFTER EVERY "NTH" LINE(MY TEXT BOX I AM WORKING WITH GROWS AND SHRINKS DEPENDING ON THE AMOUNT OF LINES IT HAS IN IT). IT WAS A GREAT HELP THOUGH. I NEVER WOULD HAVE GOTTEN THAT FAR. THANK YOU SEAN

I HAVE A REPORT THAT MAKES LABELS. i WOULD LIKE TO HAVE A SEPERATOR EVERY 11TH LINE SO THE PERSON CAN CUT THE LABEL ON THE SEPERATOR LINE INSTEAD OF COUNTING 11 LINES EVERY TIME. IS THERE A WAY TO DO THIS? ALSO I AM USING A TEXT BOX IN MY DETAIL PART OF THE REPORT THAT SHRINKS AND GROWS...

THANK YOU FOR YOUR REPLY IT WORKED GREAT

WORKED GREAT THANK YOU

I need to use the carriage return or line feed as the delimiter. could you tell me what the code is for a carriage return. i.e what i need to put in the delimiter part of the function please. thank you very much