Search results

I am creating a dispatch list for our manufacturing shop. I am Grouping the Report By Work Centers. Some Work Centers could have 1 page of data printing out daily and others could have up to 20 pages daily. Obviously they cannot do 20 Pages Worth of work in one day so it is a waste of paper...

I am trying to use the replace function in one of my queries and i get the error "Undefined function replace in expression". I was under the impression that access 2K had this capability. The replace function works in the form code. Is there some reference file I am missing or something? Any...

I am trying to create a PO Reciept Label that prints out once the data has been posted to my Sql Database. What I wanted to do is grab the data right after it has posted and print it out on a label using my default printer. Is there a print command where you can just print these variables out...

I have a form that checked to see if a part number was entered into the DB. I Have made some code to check and if the part was not entered open up the part entry form for them to enter it in. The problem I am facing is that once they are done entering the new part in and close the form the...

I have a datasheet form and was wondering if anyone knew how to make a date automatically enter when a record has been changed.

I have a program that uses continuous label stock. The width of the label stock is always the same but depending on certain variables the hieght of the stock varies from 1.5 inches high to 12 inches high. I need to be able to specify in code what size i want the page to be so I can have my...

I am having a Braincramp. I have a subform where i want a user to type in a job number. Once the jobnumber is typed in I want to go out to a table in my database and get the POID, Serial number, and partnumber and auto input them in my subform automatically. I think I have done this before...

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

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

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

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

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

Is there a way to find out how many lines or carriage returns are in a memo field?

i need to make a memo field print out multiple times without any breaks or form feeds. does anyone have any ideas on how to do this please?

I want to be able to print one record multiple times whether it be a hundred or 20 with no page breaks like this my one record the way i have it set up now: beginning of page Part 1 is 10 inches-------> 2 inches from the side is 3 end of page what i need it to do: beginning of page Part...