Search results

  1. S

    Can a PPT file be generated by using Access?

    Hi Minty, You have perfectly identified the process. As regards the data, well it is already created in the software for the company (Access 2013). The images are saved in a folder on the network computer. Have to just pull both the data and the images and create the slides, using a standard...
  2. S

    Can a PPT file be generated by using Access?

    Thank you, TheDBGuy. I am going through the article.
  3. S

    Can a PPT file be generated by using Access?

    Hi all, Your response was overwhelming. I thank you for the same. I am working for a company which is into marketing and branding. Everyday 4 to 5 persons are assigned task of going into the fields, click photographs, take measurement and notes and forward it to the company via Whatsapp. Each...
  4. S

    How to edit records in multiple tables through a form in Access 2013

    At last, I just overhauled the SQL query in the design view of the query table as well as the record source of the property sheet and now I am able to view and edit as per requirement. Sometimes, discussion helps and unclogs the otherwise clogged brain. Thanks for your help.
  5. S

    How to edit records in multiple tables through a form in Access 2013

    A single customer may or may not have multiple projects which are assigned to us. Each project may have equal to or more than one item (element) to be supplied or attended to by us. Moreover that same customer may repeat the assignment for the same project but with different items (in a span of...
  6. S

    How to edit records in multiple tables through a form in Access 2013

    Sir, presently I am using just one table to edit and its name is "tblSizeQtyAsPerRecce". The other tables are related for the descriptions in them which has to be displayed on the form for easy understanding of the user so they do not get confused and make error. I have posted the SQL query in...
  7. S

    How to edit records in multiple tables through a form in Access 2013

    Hi CJ, herebelow please find the SQL query, as required by you: SELECT DISTINCT [Project master].Proj_Id, [Project master].[Project name] AS [Outlet name], [Recce order].CustId, [Customer master].[Customer name], [Recce done details].Recce_done_date, [Emp_first_name] & ' ' & [Emp_last_name] AS...
  8. S

    Can a PPT file be generated by using Access?

    Just a thought: A person clicks a photograph on an android phone and sends it to his peers who in turn prepares a PPT with rectangle lines (selection of a jobwork to be done) on the clicked images (which is possible in PPT). Is there any way where the PPT file can be prepared electronically...
  9. S

    How to edit records in multiple tables through a form in Access 2013

    To start with, there are around ten tables for each process. The first process starts with the order received from the client; the info is stored in the first table. The second process is about an employee being assigned to carry out the reconnaissance, where he gets all the required...
  10. S

    Hi Everyone!

    Thanks Gina, I will post in the Forms section thread. However, replying to your query, I would respond as follows: To start with, there are around ten tables for each process. The first process starts with the order received from the client; the info is stored in the first table. The second...
  11. S

    Hi Everyone!

    The recordsource in the property sheet of the form is: SELECT [qtyForformEdittblSizeQtyAsPerRecce].[Element], [qtyForformEdittblSizeQtyAsPerRecce].[ProjWidth], [qtyForformEdittblSizeQtyAsPerRecce].[ProjHeight], [qtyForformEdittblSizeQtyAsPerRecce].[ProjDepth]...
  12. S

    Hi Everyone!

    Thank you, sir!
  13. S

    Hi Everyone!

    Thank you, sir!
  14. S

    Hi Everyone!

    I have created a main form with two subforms (each subform is allotted a table independent of each other) which is linked by a Job number. I can enter details on the form which are easily passed into the respective tables. Now later when the user wants to edit certain or many components in one...
  15. S

    Hi Everyone!

    I am Sebastian from India. I was a computer programmer 20 years ago and did computer programs in D'Base, Foxbase and Foxpro. Later on I shifted my job profile to marketing, administration, etc. Now I am back in computer programming using Access 13 as my tool. I am compiling an ERP-type...
Top Bottom