Recent content by caliandro

Hi, I'm facing the below issue: With the below code I create the excel file but the format of the sheet is not as the template I want it to be. Looks the code is not working properly but I'm not receiving any error after running it. What is wrong? Thank you DoCmd.OutputTo acOutputTable...

I find POP UP mode in form property

Hi, I'm facing this issue. With ACCESS 2007-16 I don'y find the way to reduce the size of the Form. I would have a very small Form 4" x 6 " but I cannot find anything in the property to change such dimension.. Also move the Form with the mouse. Thank you in advance

@Pat Hartman Dear Pat. The relation between comments and tagnumbers is 1 to many. One comment to many tagnumbers. I cannot publish the supplier document for legal reason but image the comment is for example: "painting color RAL should be RAL1731" and this comment is applied to all the tags...

@Pat Hartman Dear Pat Hartman, thank you again for your follow-up. Very appreciated. In my case the format of the data to be registered are pretty complicated to be managed by voice. Format of tagnumber is always a string composed by 12 characters for example "45**AC342001". In addition, may be...

@Pat Hartman Dear Pat, I understand what you mean for make easy automation between drawing issue and control of the documentation always well updated. This is possible when the drawing format is consolidated and the company can invest money. This happen in most of cases. In my case I'm free...

@Pat Hartman , Dear Pat, first of all thank you for your follow-up. I will explain my situation and what I want to do. I'm working as document controller in the middle between several small companies (vendors) and one big contractor (company). Basically the flow of my job should be as below: 1)...

@Pat Hartman Dear Pat, thank you. The matter of the fact is that I haven't a spread sheet (i need to create it each time I need to register a document). In all cases the document is a pdf document and I need to read it and register the tagnumber. I have not well identified the best way to do...

@Pat Hartman Dear Pat, thank you for your reply. I have multiple situation in my case. The application is for registration of results of document review. When document return with comment I need to register each comment and for each comment I need to list the tagnumber "impacted" by the...

@arnelgp Thank you very much arnelgp this solution looks very smart. I will try to apply it in my case. Francesco

Thank you to all for the several answers! @Pat Hartman Dear Pat, your answer is helping me think about the path to take. Unfortunately, data entry is almost all manual (no copy and paste of long lists). The form you sent is very interesting (Looks like a split Form). My idea is to use the...

Hi, I have this idea: inside the main form I have another form (sub-form) that can be managed in different view: 1) datasheet view for a simple data entry (past and copy is working very well for multiple records in one time) 2) single form (when I need to add an event to one object inside the...

Hi everyone, I'm Francesco Caliandro from Milano. I'm not a programmer but I'm enjoining using and programming access for my office work as expediter of bulk materials. Sometimes I can do some very strange questions, I'm sorry for that. I will explain my purpose each time. ciao Francesco