Search results

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 don't know if i explained myself well and i am sorry about that so I will state it again. I have a label program i made in access. I have set up a text box on a form that grows and shrinks depending on how many lines are put into it. The user puts all the non repetitive data lines in this...

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

I have been thinking about it and what i think I am going to do is make a form with 10 fields on it. and then let the user type in however many distinct rows they need to. then i will do a check to see the first row that is null. that will give me the amount of distinct rows for that record...

I have a bit of an issue. My comany wants me to make a label program to print labels out. I have some variables. each piece of tape has different amount of lines we have to print depending on the size of tubing (ie. 1" tubing uses 29 lines per piece and 1.5" tubing uses 43 lines per piece of...

yes that is exactly what i was looking for. I new you could get just the date with the dateval() i didn't know the time one. thank you very much.:)

I have a job wanding system that involves people logging start times and stop times of jobs in the system. The problem i am having is that the system works off a date/time system. I need to make an adjustment to the code to account for lunch. so i made this if statement If...

I have bar code label program for shipping I am making . I created a form that gathers all the information i need to make my barcodes for a specific order. Then i linked the report to get all the information from my form. The problem that i have is that one of our customers requests that if...

how do I check my text box value see if i have a "-" in it.? Thank you

ok here is my problem. I have a form where most of the data i need for my report comes up automatically through a query from another database. The rest of the information has to be put in manually through text boxes. what i need is a way to mesh both types of information(the query info and...

I am in a slump lately. i can't seem to think of a way to make a form do what i want. i was hoping someone would maybe give me a boost. I have data i need to query out of our manufaturing system by a sales order number. after i get that i have to have the user add some more fields to this...

i want access to look up to see if a certain file that is my item ID is on my server. the way i was doing it was If "\\st1\D\departments\engineering\BRAZING\" & txtItemID & ".doc" Then txtitemID is the name of my text box value i want to use. any ideas?

I am trying to print a word document out of access. the problem i have with the reply's to these questions is that access does not recognize word.document as an object. I am obviously missing something important here. can someone clue me in please?

I am working on our travelers for work. people would like to be able to print the travelers keying off a part number. and if a corresponding word or excel sheet is available(named the same as the part number) automaticaly print those as well.

this is probably a very simple question. I only want the form to come up from the MDE that i made. Not Access. Is there a way to do this?

I have a main form (frmshipment)that when i open it i would like to have the cursor in one of my subform(fselshipment1) fields called txtSalesOrderID. i tried one of the solutions but it didn't work my code was this Me.Child119.Form.txtSalesOrderID.SetFocus can anyone help me. thank you

I want to have a do while loop on one form that keeps looping through until another form is closed. is there a way to do this?

thank you very much for your help. I have one more problem though. I am putting the openform code in the before update part of my form. I need to have a do while loop in my main form waiting for a bool vaue or something to be returned from the form i opened to tell the program that it is...

I know this is probably a really easy thing to do. Basically I have a program that I am editing that makes a user enter in a sales number in one form to put it on a shiplist. Then they have to go into another form and enter the same sales order number to ship it. What I want to do is have the...