Search results for query: *

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.

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

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

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

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

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

I have a form with a combobox(unbound) that allows the user to select a Person's name. The rowsource is SELECT DISTINCTROW [Contact].[PersonID], [Suffix] & " " & [FirstName] & " " & [MiddleName] & " " & [lastname] AS name, [Contact].[LocationID], [Contact].[CompanyID], * FROM Contact; The...

Thanks ... it works like a charmb.

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

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

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.

Richard, I'm in the process of implementing your code and was wandering if you were available today whether or not you could take a look at the code you provided to see if may be there was a piece missing. First I have to say that I decided to go back and change the layout so Recipient actually...

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

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

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

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

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

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

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.

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