Search results

Hello, I am running a database with Access front end and SQL backend, totally about 50 users. Some users are working overseas (US, China) and normally they connect to a terminal server through a VPN, while most of the users are within the LAN and working with local front ends. Back end is in...

Hello Everybody, I have a company database with Access front end (about 50 users, all with their own front-end copy) and SQL server back end. Another 20 users connect to the database through a terminal server from outside of the company, each user has a desktop with their own front end on the...

Thanks, I have tested it now and it works fine! Just a remark: I had to put the code Me![MemoField] = Me.txtMemo in the txtMemo Before Update event and not on the Form Before Update event, otherwise if you edit only the txtMemo this will not fire the Form Before Update event because it's...

There is no recordsource swap in the last version I have tested, the code is exactly the one I posted (the second one). But the issue is still there. I think your suggestion about the SQL server is the right one. In fact I moved the related tables to local access table, using the same form...

Yes you are both correct in all statements. The Ntext was chosen automatically when I did an upsize of the database to SQL server last year. Then I recently changed to nvarchar(max) because I read on a book that Ntext is an old type which will be soon replaced and I thought this was the cause...

The recordsource of the form is a query based on a linked SQL table. The textbox is bound to a nvarchar(max) field in the query/table.

Hello VBA and Rainlover, there is a lot of code but none is related to the famous text box, which is never mentioned there. The textbox is nothing special, no events, no code interacting with that. Also the changing of recordsource is not related to that, I use that just when the user apply...

I have removed the save button and the related code, but the issue is still there, i.e. the textbox get erased when you move to another record. As before this happens only when you stay idle for a some time before moving to another record (1 min or more). Thanks for helping and sorry for the...

I confirm all the above: no front end sharing, same select query for all the fields and nothing different for the text box. I will try tonight to remove the save button.

yes, users have all the same front end. Record source is always the same select query based on the same table (linked SQL table). The textbox is bound to a field which an nvarchar(max) field. I normally keep a save button because users like to push it! Moreover they need to conferm changes in...

Hello, I have an update to this old post as the present is still there. What happened is the following: a user enter a new record and fill some text boxes like customer, date of meeting, etc; then he moves to a small subform where he fill the meeting attendants (it may be a list box but I...

Hello, I use the following command line to export a form (a split form) to an excel file. DoCmd.OutputTo acOutputForm, strFormname, acFormatXLSX, strLocal Everything fine but the column headers on the excel file show the field name but I would like them to show the datasheetview label of...

yes, it's already live. What I meant is that I am not sure it will solve the issue: the issue was not there all the time, i.e. also the previous one was working well in all my tests, but at the end some of the users (and not always the same) complained! I will keep you updated. thanks

Thanks, I will try that and see if it solves the issue. It will take some days to see if it solves in "production" environment. Andy

The SQL resides on the same common server. For all other forms and tables of the same application everything is working fine. There is no much activity on that table, maybe 6-7 new records per day. The command to save record is a command button on the form and the associated code is a simple...

Hello, sorry for not being precise. It should be: contents of the text box get deleted when the user saves the record. So the record is saved with null values. There is no message of writing conflicts or anything like that. The back end is SQL server and tables are linked tables in the Access...

After few days the problems is appearing again. Some users complain some fields get cancelled as soon as the save button is pressed. Any idea could be causing this? The code has no event which may cause the fields to be cancelled.

Hello, I have converted the data type to nvarchar(max) on the SQL table, it went straight. I still don't know whether the problem will be solved (it doesn't happen all the time), I will see! thanks Andrea

Hello, I have a form for meeting records. One text box contains meeting notes, which is linked to ntext variable (SQL linked table) on the underlying table. The database has about 40 users but this particular form get no more than 10 new records per day, not so much activity. This is the...

well, at the beginning I also thought that it would be a keyword, but my Italian version doesn't accept "true" and "false" as value of properties through VBA.