Search results

Yes, it occurred to me that the variable report size must be the issue. The printer will always print a full A4 page with each iteration, won't it. Other than printing a line at a time, I can't see an easy way round it.

@Pat Hartman Pat. I often work inside the front end. For instance if I am preparing a quotation, I work on temporary tables in the front end. If the user cancels, there's no issues. If the quote is finalised, then the temporary tables get appended to the back end. So in this case having...

Surely you can use page layout/ set up to determine the size of your document. If it's a continuous roll, can't you get the print routine to print a few extra blank lines, and then just tear off the print? How do you actually expect to separate the receipt? On reflection maybe you can't do...

Might the adverse performance be caused by having multiple concurrent users? In which case you might need to look at all users establishing a persistent connection to the backend database. I think that's what you've described in your last post. Each user needs to maintain a connection to the...

Here is the full module which includes the public types referred to, and the API process calls. Note that this is for 32bit Access. You can comment out the reference to smode and tblconstants. When I run this the black ftp screen opens and echo's the commands. I was trying to suppress that...

I use this command to send/retrieve a file. Call ExecCommand("C:\Windows\System32\ftp.exe -ns:" & Chr(34) & scriptfolder & ScriptFile & Chr(34), vbMinimizedFocus) scriptfolder and scriptfile give the path to the .bat file This is ExecCommand. I haven't kept a note of where I found it. I...

But do you need a login when you reach the FTP site?

Don't you need a username and password for the FTP site login. You have two cd lines. One needs to be LCD, doesn't it? Or are you trying to navigate to one folder, then a subfolder of that folder. Is the FTP path correct? I create FTP scripts as you are doing and then run them by calling FTP...

Use transfertext with no delimiter? Or with a delimiter that won't be in the file, such as a pipe symbol, maybe. You could treat it a fixed length text file, and position your own delimiters. I presume it must be fixed width. Then it will create multiple columns. If you already have a the...

What does that "with events" qualifier do? Is there startup code running when you instantiate TVW that could fail without raising an error? Could you include an onerror trap before the "set NVW" statement?

The hard bit that even a lot of system admins don't really get, is that logins to a RDP server, or a Citrix set up, have to be directed to a unique folder for each user. Although in theory a single access front end database is multi user, in practice there can be difficulties and we advise...

Generally you can't have too many spaces. I add them between all terms in a SQL string even if they aren't necessary. Sometimes they are, and it saves hunting for the syntax error.

Not in a report, but I have stored data in a string field with a separator. I can then assign the string field to a combo box value list, and change the string into a nicely presented layout. I use it to store document version histories for instance, to show a file name, date etc, and then the...

Do you mean that if the combo box just contains a single column of text values, you can still derive the index number of the selected row? If so, I didn't appreciate you could do that, and I also don't really see a benefit from doing so.

A bound combo box is set to reference a specified column of the query, normally the first column (column(0)), but it doesn't have to be. It displays the first non zero width column, which is most likely not the same thing. When you say ordinal number, I presume you mean cardinal number...

Do you have option explicit in the module? How have you declared TVW?

Wouldn't Val return the correct value? Not sure if the slashes would interfere.

But it is awkward to define a date correctly when there is a time involved.

Well I assumed the server was on the LAN, and somebody must be able to connect to it. Even if it's Firebird, does Firebird not offer management tools to ascertain who is connected, and stop the connection if necessary? I assume we have a professional corporate system here.

What I was wondering was why it was as an issue. Is there still the same problem that you can't perhaps redesign the back end while it is showing as in use?