Search results

Hi all How does one store the value derived from a combo box to another text box in a form? E.g. Supplier name is a combo box. The combo box has 2 columns, supplier and supplier ID.the supplier name stores the supplier in its own text box. When you select the supplier, the supplierID appears in...

Hi All! I managed to email Access report from MS Outlook generated within the Access application using DoCmd.SendObject. Everything works fine. However, when I use the same Access application in a Remote Desktop environment, it comes out with an error message that says, Runtime error 2282 The...

Hi All! How can I email a report as a PDF format? I searched and found this but I get error message. DoCmd.SendObject acSendReport, [report name], acFormatPDF, "recipient's email", [title], [message], True This command is attached to a button. When I click the button, it runs this code but...

Dear All Thanks for your response! I am sorry I was out of action for a little while. The values AM, PM are stored in the field named Session in a table. I need to use these values in a report.The date field is stored separately in another field named Date.

Hi gerry Thanks for your prompt response! I am afraid I cannot get what you are saying. In my form, the field session is combo box where the row values are "AM","PM" and "All Day". There is a field corresponding to this combo box where I input the Sales value. e.g. I select AM and in the...

Hi All! Wish everyone well! I have a combo box named Session which comprises of am and pm. I have a number of fields that relate to this combo box. E.G. Monday am Sales £1000 Monday pm Sales £2000 I want to create a total Sales of the am and pm to derive a total of £3000.i.e. Monday...

Thanks Gemma for your prompt response! I have the week number in my query. My subform is linked to the main form by the company ID. Therefore, my subform records will show all the week numbers records i.e. wk.1,2, etc. The week number in the main form is generated automatically. If this week...

dear all i have searched through the forum trying to get a solution as per above subject but to no avail eventhough I have gone through the 20 pagaes of threads. Maybe somenone can help me?? I have a summary form with the company name,week number, week-ending automatically populated. e.g...

Dear All I have been figuring a way to do this but it is not working... I have a combo box named session which drops down either AM or PM. I have an amount text box relating to the session. e.g. AM £1000 PM £2000 I also have a Total Sales Amount text box that we input the day's Sales...

Hi Sean! Please find attached file for your perusal pertaining to the above subject! Sorry there was a delay as I was assigned somewhere else. Thanks and regards!

Thanks David for your quick response.... The query actually returns calculated fields that are not updateable. But isnt there a way to make a form appears even there are no records. I have tried setting the calculated fields default value to 0 but this doesn't work either. Mind boggling...

Hi Guy! thanks for your response. AllowAdditions was set to Yes previously. I am still facing the problem....Can't think of anything else at present.

When a query returns no records, the form appears blank. how can I make the form appear eventhough there are no records to show prior to inputting data. I have searched the forum but to no avail of what I need to do. Anyone please???

Hi Sean! Will try to do what I can to upload within the next few days! Thanks for your help! regards

Hi Sean The .rar file after compact & repair is still 2.8mb. Any other way i can forward to you? thanks for your help.

Thank you All! I have created the queries as Bob has taught me. True enough I get the sums for all the tables correctly. But I now face the problem of a blank form. The form appears only when the sum totals have a value. If some tables have a sum total and some tables have no sum totals, the...

Hi Sean and Bob! I have been trying to create a query for the totals but it merely works for each table. When I add a few tables in and do the sum totals i get wrong answers. say, Table A total is 1000 and table B total is 3000 When I do a total query on table A alone, I get 1000 but when I...

Dear All I need to pull the calculated values from approximately 10 forms into another form. This is a summary form that should have all the totals pulled from the other forms. e.g. Form A has a textbox that reflects the sum of the amount. This is the total balance of form A. Form B, Form C...

Hi Bob! just a quick update to you. I created a new db and imported all the files. I have been having 2 db as one is for the tables and the other for the other objects. Still no joy! I suppose I have to resolve to pulling the fields from the tables and then calculate within the form. Please...

Hi Bob! That is what we call efficiency! What a prompt response.... Thanks! I still have some nails left!! Ha! Been really stress trying to get the db ready for testing. Ok! I will create a new blank db and import everything over to see if it works... If not, I need to pull the fields from the...