Search results

Hi I am trying to create the below function. I managed to bring the correct result, however, the field EDF, might contain data or zero or empty. While with data or zero, i get the result i want, when empty, the function returns error. Is there any way i could work it around ? Public Function...

This report, is a kind of invoice. It opens on filter [Forms]![FormName]![FieldName] , its different each time Then i send each "invoice" to each client, the .pdf document has ALWAYS the same name, the name of the report "VGM" I would like to get the document name VGM01, VGM02 and so on...

Sure, but, if user has to do all this manually, it is better to keep on as is, send emails with the same attachment name.

Hi With DoCmd.SendObject methode, we can send reports as email attachments. Could we customize the attached file name ? My report is tuned to filter on load [Forms]![FormName]![FieldName] With the below line, the report on email attachment gets always the same name, the report name (or report...

Hi, the A column

I would like to make it look like this , will be easier to read.

This is a VBA script from which i export data from access database to an excel. The excel looks like this and may contain 2000 or more lines. I have removed several lines from the code, those lines that format and calculate, just to make it shorter. My "goal" now is to apply an alternative...

I made it. Is there any way we could leave only "lockrec" key unlocked? Because, once i lock the record, this protects from accidental edits, then i might need to unlock but now only on table level i could do it.

The below code, performs the required action, If i click on the yes/no field 'lockrec', the record gets locked, however, if i close and reopen the form, then form edit is allowed. How could i make it so the record remains locked. Private Sub LockRec_Click() If Me.lockrec = True Then...

Hi, my "problem" is the extra lines between first line "plastic fruits S A" and second line "Redmond" In access form, the data is as below Plastic fruits SA Redmond Washington 98052-6399 USA When i export in excel, the data i see is the same format When i copy paste from excel and paste on...

Long story sort, I have created an access application in which i update a form, then i extract an excel that is exactly how it should be, i send this excel file as attached email, then i copy paste the whole excel form and paste on email body The problem is this, once i paste it, the text...

Unfortunately, the height of three ceslls (c2, d2, e2, ) outlines company name address and contact person as well as telephones emails These are b/lading parts so, c2 is Shipper, d2 Consignee and e2 notify party and are never the same size One BL might have as shipper, a company with very long...

Yes I have, it auto this fits the row as per the height of the 1st cell, e.g. e5 , not as per the tallest which might be the b5 or c5

Hi When we extract from access a report to excel (see my previous topic https://www.access-programmers.co.uk/forums/threads/extract-excel-from-access.324274/#post-1838727) we can format various fields When we want to fix the width of a column we have .Columns("A:A").EntireColumn.AutoFit...

Correction, clarification i wrote i have to play B in all guitar positions, every 3rd quarter the guitar sound will bip so i know i have played the correct note. I should right i have to play B in all guitar positions, every 3rd quarter the guitar sound will bip the B sound, so i know i...

Hi I am learning to play the guitar. There is one exercise. I must memorize , in each guitar position (12 fret by 6 strings = 72 positions), which note is. To do so, i need a metronome, one tik every 4 seconds for example and someone to tell me randomly one note, for example "D#" or...

Okay, i found it With dlookup function, i can open it ... many thanks

Thanks, could we use dlookup statement ? Application.FollowHyperlink and then dlookup ? This is because my file contains some Chinese characters and if i paste in va editor, i get ??? G:\F IIDS LETTER\Temp_Long Term 免费用箱申请表_1.doc

Hi I need to open a specific word document from a form. I have created a command button with the below bit of code but i get run time error 53 , file not found When i repeat same function using notepad.exe , then the txt file opens without error. Private Sub Command67_Click()...

Many thanks to all