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!

Register Log in
  • Congratulations Chriss Miller 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: *

  1. Sloaner

    Display format of number field

    Thanks Roy, but this doesn't save the format in the table. I should've been more specific. I want the value to be saved as displayed on the screen. This worked on the screen but remains as a single digit in the table.
  2. Sloaner

    Display format of number field

    I have a form displaying a number field called jobnum. How can I get the number to be a 3 digit number and thus always print as 001,002,003 etc.. up to 999 In the table the jobnum is defined as Data Type = Number Field size = Long Integer Decimal places = Auto Default = 0 Required = No Indexed = No
  3. Sloaner

    Calculated fields in report

    I have a form with a label whose value is being passed in from a form(LabelA). There's also a textbox which is a calculated control(Label G). I need to know how to set another textbox as the difference of the 2. So far I have the textbox controlsource as =([LabelA]- [LabelG]) which gives the...
  4. Sloaner

    Combobox blank on old records

    Thanks for all your suggestions.... I got it to work.
  5. Sloaner

    Combobox blank on old records

    Hi Richard, the purpose of the combobox is to look up orders of a particular customer. By selecting a name from the combobox and populating the company & locations the user can visually verify that the order displayed is for the correct customer. To answer your question ... Yes CompanyID is in...
  6. Sloaner

    Resizing a report to fit on a single page

    Is there a way to move/change all the fields on a report at once by compressing them to fit on a page. I created a report and some of the fields have gone over into page 2 & 3 when they should all fit on 1 page. I know this sounds like a very basic question ... but I'm new to this and was hoping...
  7. Sloaner

    Combobox blank on old records

    ...[Contact].[PersonID], [Suffix] & " " & [FirstName] & " " & [MiddleName] & " " & [lastname] AS name, [Contact].[LocationID], [Contact].[CompanyID], * FROM Contact; The afterupdate of the combobox updates 2 other textboxes with company name & location. I'm having a problem with the combobox...
  8. Sloaner

    Passing value from a form Combobox to a Report

    Thanks ... it works like a charmb.
  9. Sloaner

    Passing value from a form Combobox to a Report

    Actually the field in my report has the following as controlsource =([LabelTypeName] & " " & [ContainerTypeName])
  10. Sloaner

    Passing value from a form Combobox to a Report

    I have a form with a button that calls a report.The form prompts for companyName and for ordertype(2 comboboxes).I would like to know how to pass the value of the ordertype combobox to my report. The report controlsource is a query. In that query I have the ordertype as Label_ContainerType...
  11. Sloaner

    Table setup for use in Form with subform

    Never mind my previous post ... I got it to work. Thanks for your suggestions to you both Richard and Ken. This was a good opportunity to try different things and learn.
  12. Sloaner

    Table setup for use in Form with subform

    ...Contact and Order. I'm by no means an expert and cannot figure out why I get an error in this code for the SQL. SELECT C.RecipientName, D.* FROM (Contact as C INNER JOIN SysMain as S ON C.RecipientName = S.RecipientName) INNER JOIN SysDetail as D ON S.InvoiceID = D.InvoiceID; I did...
  13. Sloaner

    Table setup for use in Form with subform

    No it's not ... it's showing all the order details that exist. You see so far I only have a small sample in the DB as I'm still building it. So I know that there are 4 orders in the DB and the Details total 8. When I bring up the form I see 8 orders and 8 details on every single record.Some of...
  14. Sloaner

    Table setup for use in Form with subform

    Yes I did.. I just double checked. The master/Child properties are both set to Recipient.
  15. Sloaner

    Table setup for use in Form with subform

    Richard, I understand what you've proposed but what I'm looking for is actually for Customer and Invoice Details.In your scenario a customer can have many invoices. What I'm looking for is the details on all the invoices per customer. The problem is that MainSys doesn’t have the info...
  16. Sloaner

    Table setup for use in Form with subform

    Thank you all for responding. Ken, I tried your approach...but am having some problems... hope you're still available to help. First I have to tell you that I have created the form with a combobox that select the customer name from the MainSys table and fills in company and location. when I...
  17. Sloaner

    Updating subform field from main form

    How can I update a field in a subform table from the Main table?. I have a main form Orders with a ComboBox ReceivingCompanyID; and in the afterupdate event procedure of ReceivingCompanyID I want to update the table of the subform. I have the following code which gives me an error...
  18. Sloaner

    Table setup for use in Form with subform

    I've created a form that contains a subform with Order details info. The main form MainSys has a primary key OrderID and the subform SysDetail has a primary key OrderDetailID and also contains OrderID. The link Child fields and link Master fields are OrderID & OrderID. The subform's recordsource...
  19. Sloaner

    Populating Textboxes from Combobox selection

    Thank you former Texan... I'll be sure to check out the archives as I'm not done with this project. Thanks Willir.. This was just what I needed for my example and applied them with ease.Again I thank you all.
  20. Sloaner

    Populating Textboxes from Combobox selection

    I have a form called MainSys which will have Name, Company & Address. The form's record source is a table with CompanyId(a number), LocationID(a number) and Contact(a text). I have Name as a combobox and would like to know how to get Company & address to be populated as Company Name and Address...

Part and Inventory Search

Back
Top