Search results

i want to replace the text: ,"dummy" with null. this is my code: stemp = replace(stemp, ",""dummy""", "") it does not work. what is the correct code to deal with both the comma and the double quote? tia.

the final file should look like this: "hdr","john",2,02/14/1989,"manager","ny" "dtl","eric",06/04/1989,"john" "dtl","lisa",11/15/1995,"john" with what you are proposing, this is what access will do: "hdr","john",2,02/14/1989,"manager","ny" "dtl","eric",,06/04/1989,"john"...

thanks ridders. i really wish i can use a union query because i find union query easy but , like what i said in my first post, i cannot use dummy fields because when i export the query, access will consider the dummy fields as columns. the resulting exported file will have commas to signify a...

thanks. i am new to filesystem. i assume that the "writing" of lines involves additional codes to end up with a csv file. it is not like you copy text from one file and paste to another file? i use the transfertext to export to a delimited csv file. there is no coding or formatting for me to...

I need to export 2 queries to 1 csv file. The 2 queries do not have the same number of columns. I cannot use Union because this requires I have the same column numbers. I cannot make alias columns or null columns because the resulting exported file will have commas to signify a blank field...

^that syntax does not work. access will only accept a filename with an extension of .csv. this is why i had to resort to the rename command (i need a filename with an extension that is not.csv but csv formatted) the save as filedialog allows the user to select the desired folder location AND...

thanks! both work! what is the syntax to bring up the dialog box to just choose where to save the file? i realized that i do not want the user to be able to make up his own filename on generation. and, what do i add to automatically replace existing files? (this is for the line: Name strCsv...

hi. i copied this code from someone and did some changes. it works fine to export my query to a csv-formatted file. the Save File dialog box pops up. when i choose cancel, the 2522 run-time error message appears. what can i do to suppress this message? tia. Private Sub...

i am not articulate with syntax or code. it is easier for me when i see a sample syntax/code and i just tweak the latter based on our requirements. thanks anyway.

i found the solution here: https://www.access-programmers.co.uk/forums/showthread.php?t=235843&highlight=export+csv+file+extension this is the code he used: Name "C:\Exports\MyFile.txt" As "C:\Export\MyFile.rpd"

i know this is an old thread. have you found a simpler solution to this? i am in the same situation. i need to export a query to a csv format. docmd.transfertext /transfertext macro works as long as the file extension name is .CSV. i just need the final filename extension to be .XYZ. the...

the figures that you see in the report are TOTALS already (group footer). i tried using the field in the filter option where field <> 0 but every time i run the report, it looks for that field (like it wants me to enter a value as a parameter).

i want the report not to show data with zero balances. example: if my report has 10 line items and 3 of these line items have 0 balances, then the report should only show the 7 items that do not have 0 balances. (the report should use up 7 lines / rows only.) kindly see the attached report...

I have a database that has transactions since year 2009. I want the users to only be able to view and edit transactions that were entered in the last 6 days. I was initially able to do this by putting a filter in the Property Sheet section of the form and choosing Yes for Filter on Load...

Thanks for replying. My main problem was how to create the schedule (like create rows equal to the payment tenor). If the loan is payable in 10 months, Access should be able to create 10 rows for each of the month. I've figured out a way to do this by using a macro. Since I'm not a...

I need to create a Loan Database Management Program. What's critical is the creation of the amortization schedule. I know that this is easier done in Excel. But I need to do this in Access. After the user enters the loan amount, interest, terms, etc., I want the program to be able to...

thanks!!! i've been looking for this solution to my disappearing ribbon when in runtime mode!

thanks tonyluke. is there any way to disable data entry thru tables? i dont really mind if the user is able to see the data just as long as he cannot edit any of the data via tables? i've kinda given up on the navigation pane. so even if the user can activate the navigation pane BUT cannot...

you guys are correct about the user being able to reset the options. jamesmcs, how can i do the one above? isn't there another way to disable data entry thru tables? :confused::confused::confused:

hi jamesMcS. i am using ms access 2007. how do i exactly disable the database window? i already have a start-up form. even with my start-up form, the user is still able to unhide/enable the navigation pane and see all the objects including the tables. i don't want to change the table names...