Search results

Hi all. I have partially solved my problem. I am able to show the Print Options menu when I open the report in Print Preview mode thus giving the users the ability to adjust the paper size, margins, etc. before printing. I used the following and placed it in On Click of the button to open...

Hi. See attached picture. This is what it looks like when I disable everything in the Access Options. No menus or toolbars. It does not give the users the chance to "explore" and this is fine with me. The top portion is clean. This is also what it looks like when I open a report in Print...

I have disabled the following in Access Options: Navigation Pane, Allow Full Menus, Allow Default Shortcut Menus. I do not want users to have access to commands and right-click options. I have a report that opens in Print Preview. Users want to be able to see the look of the report first...

That is true.

That is true but all the forms AND reports will still have the name of the original company. As an accountant myself, I would not want to be printing reports that have the incorrect company name splattered all over the reports. Yes, I could use correction tape/liquid paper and manually write...

Thanks for the suggestion. To give you a background, I have a simple bookkeeping program. (Date, account title, debit or credit amount.) I am planning to give an accountant a copy of this program. The Company Name will be entered by me. Table Company only has one field and that is...

Example: Field name is companyname. companyname = hersheysintl.accdb For a user to be able to open this MS Access file, the name of the MS Access file should be hersheysintl.accdb. Otherwise, the file will not open. Is this doable?

^Good explanation (specially: "The csv file is just one long text string. ") Is it still possible for me to go through each row in the text file to run the Replace function with left and mid functions?

To clarify: why is it that if I use the code with the DUMMY replacement, Access goes through ALL the rows? Access replaces all the DUMMY texts in ALL the rows. If I use the code with left, mid, right functions (it is essentially the same replacement function code but with the additional left...

Before - Without Replace code After - With Replace code The following code works (replaces affected text in ALL rows): sTemp = Replace(sTemp, ",""DUMMY""", "") I cannot figure out why the one I wrote (with the left, len, mid functions) does not affect all the rows.

I get the logic of the above and I tried it as soon as I read your reply. This only changes the LAST ROW of my file. I have 5 rows and the first 4 rows are not affected (but they should be). This is a portion of my code: sFileName = CurrentProject.Path & "" & strCsv iFileNum = FreeFile Open...

^You are correct. Replace([stemp],",""dummy""","") actually works. I used it again and it worked. There must have been a line in my code that did not make it work previously.

how do i replace a character that is the 10th character from the right? 2nd character from the left, etc. i have read about sql STUFF function. does access have a similar function?

SOLVED: Re: export to text: remove blank lines/empty rows the union query does not have any blank rows. i use the transfertext command to export to csv or text. i found something that works for me. this deletes the last blank row (access creates 2 blank rows) but still leaves one blank row...

^the query does not have blank rows (or even blank fields).

i am exporting a union query to a text file. i expect the cursor to be at the end of my data. instead, when i open the text file, the cursor is 2 rows away from the last row (with data). the export creates blank rows. the blank rows cause an error when i upload the text file to another...

^thanks, static. ALMOST there. if i do your suggestion, access will put quotes around each text field. i have decided to use alias fields and then do a replace command on the alias fields after the export.

i am updating a csv file exported from a union query. i found a workaround for this. 1st replace: (sTemp, """DUMMY""", "DUMMY") --replace with just the word DUMMY with no quotes. 2nd replace: (sTemp, ",DUMMY", "")

this is the error i get: Compile error: Expected: list separator or )

thanks for the quick response. i have commas and double quotes in the file that should not be replaced. i need to replace the comma and quotes that are in this format: comma-double quote-text-double quote with null.