Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: CMooreJr
  • Content: Threads
  • Order by date
  1. CMooreJr

    ASP VBScript problems...

    Hey all...I'm trying to create a page that ask students for: Their name E-mail Address Company and then I have a list of Check boxes with classes they may be interested in. I followed the examples on the Dreamweaver MX files page given to me earlier, but I constantly get "cannot display page"...
  2. CMooreJr

    Website Survey

    Hey guys....hope this is the best place to post this.... My boss wants an Internal page where our students can go to to fill out their name, company, and e-mail....the second section will say "Let us know any other classes you are interested in (with checkboxes) and the last section will ask...
  3. CMooreJr

    Form/Subform problem...

    Hey all...OK..here goes.... I have a form that simply has the company name and address, and the vendor name and address. The company name and vendor name are combo boxes that pulls the address, phone number, etc from other tables, namely tblCompany, and tblVendor. Now there is a subform that...
  4. CMooreJr

    Pulling data from EDI converted file into access

    Hey all! OK, I have a company that sends data to another company via EDI. They want this to come to them now as an Excel sheet to be imported into access. Someone else is doing the EDI to Excel stuff, and here is a sample of the file she gave me.... ITEM CHO35 AVAILABLE LOC/QTY 346 1 353...
  5. CMooreJr

    Need to get percentage of an overall rating by different category #.

    I have a query that has a category number (10-60..10,20,30..) and in each category number there are several different lines that has different information for each category number(the number of lines varies) and each one has a rating number. I need to be able to get an overall rating per...
  6. CMooreJr

    on not in list failing....

    I have a combo box in a form that allows the users to put in new info if it isn't in the box. I have done this right many times with no problem, but now I get an error,...can you tell me why?? Here is the code: the cbobox is "Heardfromus" and the lookup table is "tblHeardfromus"...the cbobox...
  7. CMooreJr

    Form to print as report

    Hey all...I have what I know to be a simple question, I just cant seem to figure it out. I have a form that I want all the data to print in report format. What I want is a print button that will print just the data that is on the screen in REPORT format, not FORM format. The only way I can get...
  8. CMooreJr

    Percentage showing as triple digits...

    Hey all....I'm trying to figure out the following... I have a "Cost" field that is currency I have a "Discount" field that is percent. (Double, 0 decimal places) When I put in say, 5 for 5 percent, it comes up as 500% What am I doing wrong? I need this to be a pecent cause...
  9. CMooreJr

    simeple..sorry..makeing the "&" character...

    Hey all...I have to put at the bottom of all my reports the name of he company, which has the "&" in the name...of course access is looking at it as being "underline the next letter"...I've tried it in quotes, etc....how can I do it? The logo is AB&T...its in a text...
  10. CMooreJr

    Duplicating a record automatically

    Hey all! I have 2 forms, "frmNewItemForm" and "frmChangeItemForm" They hold pretty much the exact same info. What the client needs is this... They need to open the New Item form and input the data. The data is detailed info on the item, such as NetCost, ModelNumber, etc...
  11. CMooreJr

    Subform not saving data...WHY?

    Hey all! OK, I have been tasked to get something to work TODAY so the company can show it to the President of the company tomorrow morning...nothing like pressure huh? Here's the scenerio... I have a form and a subform. The form contains Retailer info (address and such), Vendor info, Week...
  12. CMooreJr

    Form Subform linking problem...

    Hey all...I have a form which includes a retailer address and a Vendor address, a week beginning field and week ending field,(as well as a Autonumber field that is the primary key) I have a subform which shows the details of items the vendor has sold to the retailer for that week. Of course I...
  13. CMooreJr

    Repeating Subform Data

    Hey everyone! I have a subform that holds the following info. SKU Description NetCost MSRP Available UnitsSold RetailSold CostSold InventoryonHand WeeksonHand Now, this data is WEEKLY from a vendor for a particular retail company. For instance, for the week of 1/1/2004 to 1/7/2004 it may look...
  14. CMooreJr

    Multiple cbobox filter to a subform

    Hey all! I have a quick question.....I have 2 combo boxes on a form labeled "frmInventory"... cboRetailer cboVendor I also have a subform "frmInventorySubform". I have the cboboxes pull addresses etc from the retailer and vendor on the form which is great, however, I wish...
  15. CMooreJr

    Multiple cbobox retrival and subform copying

    Hey all! OK, let me set the scenerio... I have a form that has a cbobox for the Retailer, called "cboCompany". When a company is selected, the address, etc is autofilled from the tblCompany table. There is also a cbobox for the vendor, called "cboVendor". When the vendor is...
  16. CMooreJr

    Stopping formula from returning DIV/0 or #Num! error

    Hey all! I have a report with 2 fields, "UnitsSold" and "PrevTotSold" I need to calculate the percentage of change in these fields. I have created a textbox with the control source.. =([UnitsSold]-[PrevTotSold])/[PrevTotSold] set as a percent. This works great if there are...
  17. CMooreJr

    Complex formula regarding 1 field

    Hey all! I have a report that breaks down the total number of items sold during the month. It is broken down by week. The user inputs the start and end date, and it pulls all items sold each week, and the cost. Now what they want is this. From week 1, say we have "Item1" that sold...
  18. CMooreJr

    Complex formula regarding 1 field

    Hey all! I have a report that breaks down the total number of items sold during the month. It is broken down by week. The user inputs the start and end date, and it pulls all items sold each week, and the cost. Now what they want is this. From week 1, say we have "Item1" that sold...
  19. CMooreJr

    Form directly to Report...

    Hey all...I have what I believe to be a simple question, I just cant seem to figure it out. I have a form with a subform. This form/subform holds products for a particular week. What I want is a print button that will print just the data that is on the screen in REPORT format, not FORM format...
  20. CMooreJr

    Autopopulating fields in a form

    Hey guys! I want to have the user choose a company from a drop down box. This box pulls from the "COMPANY" table. I want the address, phone number, etc to automatically populate the corresponding fields in the form. (This data is also stored in the "COMPANY" table. How can I...

Part and Inventory Search

Back
Top