Search results

Ciao, thanks for the help, just a little thing because I print several times and I need to maintain uniqueness number, I mean: first time I print 25 labels... starting 10000004 to 10000029 next time I print 11 labels... starting 10000029 to 10000040 ... so and so Sorry for my terrible...

Dear all, I would need a field where specify a certain number of records destined to print labels (rptLabels). The Trolley (SKU) field is "Autonumber", while in "NR" I would like to be able to enter the number of unique records to be created. Attached the Database. Thanks in advance to anyone...

Thanks ASAP

Hello Everyone, I will ask if it is possible in a DB Access to translate short and long text fields from one identical table to another. Thanks in advance Best regards, Georg B.

Hi Vlad, sorry for late answer but here in Italy as you know per News we have some CoronaVirus problems. Only to say thank you very much this code is perfect for me. Georg

Hi, sorry but it doesn't increment number... Thanks for prompt reply

Dear All, I have a simple Access Data Base that records truck arrival. I need a field that automatically give a sequential number to the new record (new truck arrival), 1,2,3,4..etc And at arrival of the new Month, start again with 1,2,3,4..etc, without any user intervention. Attached a draft...

Hi, Thanks in advance, let's try and let you know.

Hi, I cannot modify named ranges in the Excel file, or any other feature of the same. The file is as the last I sent. I think I need something different, OLE automation may be a solution, but it is something out of my knowledge. Could you help me with this, is there any other way? Thanks in...

DearAll, Thanks to all. I will try, with your suggestions. Best regards.

Hi, thank you for prompt reply. I added the *.zip file of the original Excel file. I don't know how to add excel specific ranges (not homogeneous, but fixed) , to specific fields of the access table. I attached an image (IMPORT_EXCEL.pdf) of what I need. I hope this draw is clear. Georg

Dear All, I need to import data to an Access table only certain Excel range ( Attached the pdf image of excel file). I am newbie, for this matter. Could you please help with the VBA code to use for this case? Many thanks in advance, Best regards, Georg

Dear All, many thanks for help each time I receive a suggestion, I learn something new. Best regards, Georg

Dear All, I am not an expert of Access. I have the following query: SELECT [Ordine_Versamento] & ";;" & [Material] & ";" & [Quantità] & ";;;" AS A, [Ordine_Versamento] & ";" & "V" & ";;;;" AS B FROM TABELLA_IPOS_VERSAMENTO; Where I obtain the following result: A B PREL_LL;;28LR078921;2...

Good morning every all, I am going to transfer my database (access 2007) on Cloud (not yet decide which one). It is a divided database with *.accde file for the users. How will this impact? Do I need to make some particular changes? Thanks in advance for help,

Sorry I need something like in excel: http://www.excel-pratique.com/en/cou...int_object.png my english is terrible sorry.

Ciao, thanks for prompt answer, I need only a bigger Close Button that I Have already created, to help the users when will not print the Report.the Problem is when they will print it, for i.e. in the objects have a flag in the propriety to avoid the printing. I need something in excel...

Hi all, do you think is possible give to a Button placed on a Report, the property "NO PRINT"? For example I add a close button, and I cannot find the way to avoid its printout. I have MS access 2007. Thanks in advance!!

PS: I need to output word not PDF because so the user will be able to do some changes.