Recent content by Vav

Hello, Does anyone know of a way that I can get rid of characters off a product code so all I am left with is just the characters greater than zero? Example... AA0000000652618... I only want to be left with 652618. Would it be best to use a left trim or to use a right trim function...

It worked....NICE!! Thanks, I figured it out.... only the products starting with A's showed up all 50,000 of them Seeing you are helping.... do you know where I would add in a Right Trim piece of code to trim off the digits after 6 characters....? Ie, AA0000000652618... I only want to be...

Right direction... Thanks for the advice.... but could you explain a little furhter. I am fairly new to this. Regards, Peter Vav

Hello, I need to create a query that will seach through a column and only return a result with product codes starting with A. An example of a product code is AA0000034567.... however there is no realy consistancy. Some start with the AA and some don't. Some have 5 zeros before the numbers...

Hello, I have created a "Pop Up" form that asks the user to make a selection. "Open New Form", or "Edit or Update existing Form" If the user requests "Open New Form" I want the intended form to open up with a brand new (blank) record. Does anyone know how to do this. Thanks

Hello... This maybe easy but it has me stumped. I need to find out how many days are between two dates. (Ie.) Jan 31 2004 and Jan 1 2004 The results I am getting are not accurate. What I am trying to do is this: I have report that pulls info from a query. There is a sales period date and...

Hi Guys.... I got an easy one for you..... I need to make a query that will find sales between two dates... Jan 1 and Mar 31... The query is pulling information from a table, and the date is set to format "Date/Time".... so the record in my table looks like this 1/10/2004 ... i.e Jan 10 2004...

Hello, I have to develope a report that shows 6 Sales Rreps sales totals. (That is not the part that I am having trouble with.) What I am finding difficult is coming up with a way to handle the ramp up period for the Guarantee on Commission. Meaning.... the company pays (for example) a ramp...

Hello, (A few days ago I asked this question but the suggestion I got back did not work) I want to validate a form to make sure all the required information is filled out by the user before going to another record or exiting the form all together. The suggestion I received was to write code...

Thank you Thanks for the advise. It worked great!! Peter Vav

Hello, several weeks ago I posted a topic about hidding zero values in a report. A suggestion came back to me that i should use the IIF statement in the control source of that particular text box. I now understand the theory except it does not seem to work. I keep getting #Error message in the...

Hello, Quick question. I want to add some validation rules to my form. I want a message box to pop up when the user is either moving from one form to another or when the user is exiting the form instructing them to fill out the required text boxes. Where should i do this. For example, if a...

Hello, got a question. I have a report that displays three categories. Prod, Prod/Release, Release.... Only Prod/Release and Release items have a dollar value assigned to them. (Example of report below:) Prod Prod/Release Release P $0.00...

BRILLIANT Thanks so much. It worked like a charm. Sometimes it is the easy things that seem the hardest. Your help was appreciated. Peter Vav

Hello, Got a question, I have a report based off a query. In the query the user is prompted with to questions. 1) Enter the begining date 2) Enter the Ending date I was wondering if it were posible to display on the report the two parameter that the user was required to fill in. I think it...