Search results

Thanks Pat, it feels very reassuring to me! 1. I will follow your suggestion and will deactivate the compact on close in future release. My local tables on the FE are really small. 2. in fact I also use a simple batch file since a couple of years, and this way updates are much easier as you...

hello, I am not a professional programmer but always enjoyed using VBA. About five years ago I started to develop a database for the sales office where I work and then it started to grow to other departments of our company, maybe a common story. It's now an Access FE and SQL server BE, with...

I have tried also Access 2010 runtime but it gives the same as Access 2013 runtime. The accdb file has been opened without problems even in Runtime 2013, the problem lies in the accde. The PC doesn't have native Access so I cannot check if it opens the accdb with native Access! Andy

Hello everybody, this morning I had to run our accde project (used in our company in about 40 stations) on a new pc. It has Windows 7 SP1 and I installed Access Runtime 2013. The accde has been compiled on Access 2010 on my laptop. I got the above message and cannot find the solution and then...

Thanks, I used your first solution and it works neatly, because when the form is loaded the fields are shown as blank which is what I was looking for! I just preferred to loop throught the controls in the detail section, because many fields were not used. For Each ctrl In...

Hello, sometimes I have forms in which the underlying query can be very big, i.e. hundred thousands of records. Forms are designed as split forms with some filters in the header and the records as datasheet in the main body. I want to avoid a long delay when the form is opened so I open the...

Ok, that is also an option but I don't like duplicating information. Inviato dal mio iPhone utilizzando Tapatalk

Thanks MarkK, I understand but in some way I need a query to be under the form because the query is programmatically built when a user logs in. According to the user then query will restrict the data seen by the form (e.g. a user will see only orders for customers in some countries). It cannot...

Hello, I have a simple "Orders" form, based on a select query, something like: SELECT *.tblOrders, country.tblCustomer FROM tblOrders INNER JOIN tblCustomers ON tbl.Orders.CustId=tbl.Customers.CustID The form simply display the orders with some customers details like Country. My problem...

Correct, it's a memo field. I will try with this interesting idea, thanks Inviato dal mio iPhone utilizzando Tapatalk

Normally only once Inviato dal mio iPhone utilizzando Tapatalk

yes, that is the right one. But the issue is that the field "minutes" is normally a long text, and the user sometime stop filling it and then hit somewhere else on the form and then goes back to the minute and this will trigger the event more times. See the attached screenshot below. One of the...

no, the form is not modal. But there are also users that will only navigate the records for reviewing the reports and they will open and close the form but they will not need to trigger that email notification.

hello, I have a form in which users input reports of "sales visit". Usual fields as "customerID", "meetingDAte", etc and the main field is the "minute of meeting". The last field is the most important, users type in long texts and sometimes past from word or emails. I have included a cmd...

thanks CJ, I solved it with the lcase function. Anyway I wonder why the different behaviour of Oracle tables and SQL....but sometimes it's enough to find the workaround! thanks

Hello, today I noticed a strange behaviour on a simple DLookup function on two linked tables. value = Nz(DLookup("field1", "table", "field2='" & activeuser & "'"), "NN") If the "table" is a linked table to SQL server database, then comparison will be case unsensitive (which I prefer). If...

(I sent incomplete msg by mistake) internal system which includes delivery notes, production orders and so on.

The Application is purely commercial, basically it's a database to collect sales activities like offers, visit reports, projects, etc and it's also linked to our internal

Hello, I thought it was solved but in fact according to our IT manager anything that will not use VPN will not be safe. So in any case I am still stuck at this point.

Thanks for the quick reply, I will have a look. I hope it will work on Windows server 2008...