Search results for query: *

Hi, I am trying to export an Access data to Excel via a report and noticed that the Report Header is NOT exported, only the page headers (Field column Headers) and row data are exported. I was thinking of a template of which an existing Excel File has a Report Header AND just append the...

Thanks Leonie, it worked.

I have a list query sitting in a tab form that needs to be requeried/refreshed when i update variable field in Form A. The tab form is sitting in Form A. How do you requery the list in the Tab Form if the event is placed in the AfterUpdate property of the variable field in Form A? Thanks +++

It worked, brilliant! Thank you for that...

I need help on this. I have a table of which REMITAMTINCLADJ is updated from REMITAMTINCGST, ADJ1, ADJ2, and ADJ3. All fields reside in the same table and are of currency type. I am using Update Query to update the RemitAmtInclAdj The formula in the Update Query is...

Thank guys for all your answers. Yes, Form_B should take from Form_A not the other way around. I figure out already with your help...my problem also is syntax. However, how do you make form fields referencing if Form C sits in TAB FORM B and TAB FORM B sits in Form A. I want to update a field...

I need some help on this... I have Form B sitting inside From A. Form B is not really a subform of A, they are not linked. In Form A, I have a text field (not save in database) called PERIOD. In Form B, I have several fields called by a query, a field in Form B called PAID_PERIOD will be...

If my understanding is correct, the way to do it is by using concatenation: in EXCEL do it this way: --------------------------- A B C D E 1 I AM HAPPY =B1&" "&C1&" "&D1 2 NO I AM NOT =B2&"-"&C2&"-"&D2 The result in row 1 will look like this in cell E1...

The records that need to be converted into one line has common SOPNUMBE and LNITMSEQ. The LNITMSEQ is not unique to the overall records, it is repeated within different SOPNUMBE. I have actually solved the problem by making several queries and saved them temporarily in different tables and...

Hi, I need some help in making the data below to be in ONE LINE (see desired result in Result 2). The data below is already the result of query from several tables. I could not go any further--please help.[sadeyes] Result 1: ========= SOPNUMBE LNITMSEQ CMPNTSEQ ITEMNMBR SERLTNUM ---------...

I have already applied trim() for some fields it works fine but the error is still there. Is cell comment in spreadsheet causing the overflow?I may have to try that... Thanks +++

Hi, I created a query to update a MS acces table from Excel spreadsheet. When I run the raw append query it works perfectly well. when I add a parameter value in a field to append only certain records in raw query it also works fine. But when i pass on the parameter value in a form and the...

Unfortunately, I do not know vba. Importing external data allows text file only and still requires manual manipulation. I was thinking of like a straightforward cut and paste...supposing the user is dumbed. It would be good if you can provide the code for vb... Thanks anyway...

Hi, I would like some assistance on this append query. If I remove the INNER JOIN, the link source table, and just add the fields from the source table the query works. Otherwise, the query below doesn't work. Is it because i link two fields? or Is is because in my WHERE CLAUSE i have two...

How do you merge two or more excel files with the SAME FILE STRUCTURES into one. Everyday i receive excel files and usually cut and paste (append) this one into a master summary for the month with exactly the same columns. This become cumbersome since there are several files to cut and paste...

Hi Petrosky, Thanks for the link. The example given in the link does not actually work. The SUM formula doesn't work but making it as SUMPRODUCT works. I didn't realised that you can actually add more than two arrays. I was just lazy not going back to online help. Here is my final formula that...

Pivot would have been an easy job. But my target tab sheet is pre-formatted with charts ready for printing and contains the monthly figure which is updated from other tabs also. the source tab sheet is just one of the sheets that updates the target tab sheet. I have updated the target tab sheet...

Hi, I need some help on this. My objective is to place the sum amount from one tab sheet to another. Source Sheet Tab: ---------------- Dealer - TrnType - Amount ------ ------- ------ ZT5 RUBY $100 ZT5 RUBY 150 ZT5 PORT 90 ZT5 PORT 110 XXX...

You can also use a Report and set the destination to a file.

Use TransferDatabase function and/or in conjunction with macro.