Search results

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

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

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

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

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

Hello, Got a question. I have to run a report which will show all the work in progess during two given time periods. I have made a query which goes like this: SELECT [tbl_Production_Release].[PR_Company_Name], [tbl_Production_Release].[PR_Cust_Code]...

Hello, I have been looking at this project for way too long. Could someone help me with a bit of code. What I need is an IF Statement for a Check Box. The form has a text box (1). I want to write a line of code so that if the "Yes" value of the check box is selected the hidden txt box (2)...

Have not worked in Access for a while. I need to validate a text box on a form to make sure that it is not empty when the form closes. Only problem is i can't remeber which declaration is should come under. I know it is not "Form" "Unload" cause that just checks to see if the current forms...

Hello, my database keeps coming up with an error message. Its says Form-Form1 is misspelled or refers to a form that does not exist. Weird thing is I don't have a form called Form1. In the main window, the form does not appear as one of the forms that I have created, but if I go into the VB...

Hi everyone. Got a question... I have two forms, which are identicle to one another, except one is a "Quote" Form and the other is an "Invoice" form. These forms have a sub form on them. After i have filled out a Quote form and want to make an invoice of that form what i have done is put a...

Hello... it is late here in Canada and my head is starting to spin.... I have a problem... I have a form called [Request_For_Quote] and that form has a subform on it called

Hi there... Quick question, I have a small qlitch on a form that i have developed. It is an order form and on that order form i have a "Print Order Form" command button. I found that once i have entered the information in the form and hit print, it does not print all the information, unless i...

I was wondering how you build a form off a junction table. Meaning if the Junction Table, holds info on customers and book for exaple the fields in the juction table (tbl_customer_book) were customer_book_id , Customer_id and Book_id. If I create a form called frmOrders which will track...