Search results

My friend EzGoingKev I fully understood what are you looking for. Forget macro, go to VBA. I know nothing from VBA but i made it, so , everyone can make it. It will take you few hours embroidery. Since last month, i have managed to export with formating and I enjoy performing difficult tasks...

Hi there. Certain ideas are not comprehensible by our notion/perception. We can only come a bit closer to it through examples and "big bang" is an example of it. A chicken or a goat, cannot understand certain numbers. Five eggs or 10 eggs, or 6 eggs and two chicken doesn't make difference. A...

Thanks, this is what I am doing, no big issue but, as time grows on, i end up with too many objects in my database, many of those redundant and is a bit difficult to tide it up.

Hi, I have a field, name "weight", data type short text. The data is displayed like this 00015300.350 I can convert this to number by using the val function in query like this. expr1:val(weight) The question is IF we can keep the name of field "weight" in the query, without causing...

Sure Gasman. i didn't copy paste the whole line, "importfolderpath" and A is examples. It works , The code line is this one xlBook.SaveAs "C:\Users\peddo\Desktop\BkList" & "" & "StarDur_BkList" & "_" & VOY & ".xlsx", AccessMode:=xlExclusive, ConflictResolution:=True Meaningful names, yes...

Hi, i appreciate your concer. Apologies, i am not a native english speaker, i an mot IT either, i don't have any programing knowledge. Only few experience, i would say by 80% experience and knowledge i have gained from this site, thank you all. I find ready code which i can tune to my needs...

Okay, i have just found it, I made some test in line and i found it I put the A outside quotes fullFilePath = importFolderPath & "" & "A.xlsx" fullFilePath = importFolderPath & "" & A".xlsx"

Hi, many thanks I have managed to enter this line in my code and save the excel as "A" 'fullFilePath = importFolderPath & "" & "A.xlsx" wb.SaveAs fullFilePath, AccessMode:=xlExclusive, ConflictResolution:=True Now, how could someone replace the "A" with a field from the code and save the...

Hi, suppose that the code that pushes data to excel is the below. (original site http://accessjitsu.com/2015/09/13/code-listing-introduction-to-exporting-data-from-microsoft-access-to-excel-part-3/) Where should i insert this bit ? UG Added Code Tags Application.DisplayAlerts = False Set xls =...

At first, i was in need to export from access a formatted excel report and i reached my goal. The thread is here. https://www.access-programmers.co.uk/forums/showthread.php?t=308329 In this address i found the code which i fixed to my needs...

Yes I have, the problem with mail merge is that i don't want to send via email to a recipient list. I must create it and print it. I made a mail merge but when i saved it as "save as", still was refreshing data from the access

Hi, can we import a word document in access and use it as report ? There is a business word document which we fill with data. The data is already stored in my database. Instead of copy paste manually, could we import the .doc n access? Document is mixed English and Chinese.

Hi, I have managed to make the code working on my file, however, if the recordset, my query, is with a criteria such as Forms!CustomerF!CustomerID, it returns the error “Run time error 3061 Too few parameters, Expected 1”.

Hi In this youtube, https://www.youtube.com/watch?v=6s5jY09KZT8 i found 110% of what i am looking for

Is there any source with more info about this? So far, i have done this, i export the report as excel on my desktop and then an excel macro makes the format in another sheet. But this method doesn't look very "professional"

Hi, the excel doesn't transfer the format and layout of the report. For example In the report we have tailored the layout as below: Table one Field 1 : A Field 2 : B Field 3 : C Table two Field 4 Field 5 Field 6 D......... . E ...........F In...

Hi There I have created two tables, one to many relationship. I can retrieve info from reports and looks good. However, i need to email this good looking report as excel and look as good as the report. It must look like this one very simple excel which i have found randomly in web...

Thanks Understand your point. What purpose does the "bound column" serves ?

Hi There I have a field (footbal) in a table (team) , i don't know why it is so hard to tune the lookup properties. This field, "footbal", looks up values from another table (foot). Foot table has three fields, id auto number, primary, the team name and the country. The "footbal"...

Many thanks This WHERE (((IsNumeric([ALFA]))=False)); and this WHERE (((IsNumeric([ALFA]))<>True)); have solved my puzzle of the day. About this A21 34B So far i haven't met such case, believe the "numeric false" will remove it.