Search results

Hello, I am running an Access application since more than 10 years. It has become a very large one in our organization but I would say very successful: about 100-120 users in different locations across the globe. All front ends are linked to a main SQL backend (read/write) and some other back...

Hello, since this morning one linked table (to a SQL server) is not accessible from my computer, and it show all records as belows. All other tables are ok. This system is used by many users (about 80) and no pc has this issue except mine. The table is fine in SQL. I have tried to delete the...

Hello, I have a simple LEFT JOIN query like below. The left table (tblSmall) is a from an SQL server (1000 records), the right table (tableLarge) is from a Oracle back end (200k records). I would like to use this query as the data source of a simple form in datasheet view where the user...

Hello, I have a text box of a subform in datasheet view which contains an hyperlink to a file located on a shared folder. Is it possible to hide the hyperlink target? This is shown when you hover on the textbox an you step there a couple of seconds (see below). I would like to have no target...

I would like to have a subform (in datasheetview) to appear as "upside down", i.e. with row headings being the field names and the columns the different records. I don't know if there is a way to do it. The reason is simply "aesthetic": the users of this would just store calculations which are...

Hello, I got an "Overflow error 6" when loading a form at some users of my application. I noticed that it comes out from a statement like this: me.subForm.width=me.InsideWidth - 100 I noticed that some users have very large monitors, hence the value in TWIPS to be assigned exceed the limit of...

Hello, I worked for many year with Access 2010 on an application we use in our company, this is distributed to about 60 users. I recently changed my pc from WIndows 7 to Win 10 and Access 2019 (32 bit). The previous accdb seems to open correctly except that I got frequent unexpected crashes...

Hello, I have a form with a subform in datasheet view. The form (frmMainForm) is originally saved with the form property "Allowedits" set a as false. If I open the form from the navigation panel then the subform is not editable, as expected. If I open the form via VBA with the docmd.openform...

Hello everybody, I have form with a subform in datasheet view and a subsubform also in datasheet view. I have a routine that once the main form is open applies permissions to each control (like hiding colums) and when the control is a subform it goes one level below, i.e. runs throught the...

Hello, I noticed that on all my forms my both comboboxes or text boxes shows a comma (,) instead of period (.) when using the numerical keypad for input the period. This is happening even if the the system keypad is correctly set to English and out of Access the keypad gives correctly the...

Hello everybody I tried to search in the forum and internet but no results: I would like to include in my project an instant messaging system, i.e. a simple form wher you can type a text and send to another user of the database. I have a database with about 40-50 connected users, with a SQL...

Hello, I have tried to look through the forum about this but I didn't find anything on this. I am running a company database with SQL server backend and about 70 users. It would be nice to add a very simple user to user chat system for users which are connected to the database. Any...

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...

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...

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...

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...

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...

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...

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...