Search results

I have a fairly large ERP-system that I'm maintaining for a company. It's a MS Access front end with a SQL database. No issues so far. Now I'm setting up a new table, like I have done numerous times in this system (and others), but now I'm running into this problem: My new table allows...

Access-FE on SQL-db, multiuser. I have a mainform (invoices) with some 15 combo's in which user selects data (f.e. invoicesender, invoicereceiver, paymentterms etc) There is a subform (invoicelines) that is linked to the mainform (on InvoiceID, master/child). The recordsource of the subform...

I have a table in SQL tblOrdOutput which holds an integer field. This field needs to contain decimals from now on, so I changed the field to "real" on SQL server. When I link the table directly, the field displays as numeric/single in Access. There is a view that read info from this table...

I have a MS Access client with a SQL database with linked tables and views. In some forms I display records from a SQL view which works good. The form is a main form with a subform. Mainform does not have a recordsource, the subform has a recordsource which is a linked SQL view that is...

I have a Accessclient/SQLserver setup running at a company where all users work on a RDP-server. Some users have their Windowslanguage set to English, some have Dutch (as have I). Every users gets their own client in their windowsprofile through a batchfile, ensuring everybody always has a fresh...

I'm using a dictionary to build a list of keys and values. The keys comes from a recordset (stringfield), the items are Excel-columns (A, B, C etc). The code determines the Excelcolumn based on a "columnname" in the table Meta by searching for a column with the corresponding name, then gets the...

In a certain database I'm setting (square-sized) images in a table in word. The code should handle 1 or two images in a table in a wordtemplate. The code finds the correct table, add a column if needed and places 1 or 2 images in the cell (or two cells) wTbl is a word table object and in this...

I have this database, MS Access front end on a SQL database (SQL Express server) with an ODBC-connnection. Everything runs quite nice - even thought the connection to the SQL-server is bad (bad network, cannot fix), however I have one problem/challenge. Backend used to be Access, but I'm...

For a database (Accessclient, SQL-backend) I'm creating a form with a searchfield. The form holds a listbox lstObjects that displays records (based on a rowsource SQL, not a recordset). After finding the wanted record it needs to be edited by opening an editform. After editing records the...

I want to open files from a networklocation from VBA, only normal users don't have access to that location (and should preferably not get it). I instead of using shell("explorer.exe filepath") to open files using windows standard app for the file, which needs userpermissions to the path the...

I have a problem with an Accessclient for which I am migrating the backend to SQL-server. The database contains contact-data amongst other, in particular a table "contacts" (relaties) and a table "contact_adresses" (relatie_adressen) in which for a contact multiple adresses are stored...

I'm building an Accessclient which works on a SQL-backend (2008r2). I'm working on a VBA-module that updates the backend in steps, so that it's easy to deploy from DEVELOP to TEST, to PRODUCTION: the client will update the backend with the necessary changes (when possible if changes not too...

A bit of a story, bare with me ;) I do support for a small company that has a few Access-databases built over the last 15 years, but the developer suddenly left the company just over a year ago (and just dropped everything) :banghead: That's not the problem (nor MY problem ;) ). I just jump...

I have an Access-db, currently split in frontend Access 2013, backend 2013. I need to upsize to SQL-server. In this database the DAO-recordset is used a lot, not ADODB. In cases where data needs to be found the .findfirst method is used, which works properly when using the Access-backend. For...

I have an Access-application working on SQL-server with ODBC. Since last week I have a problem that in one of the linked tables records "lock" after inserting them, or to be more precise, when I want to edit/delete an existing record, I get: "This record has been changed by another user blabla...

I'm trying to output some logging to a form with a Rich text textbox This is what the form is displaying: 14:16:32: check OK: 500<10000andS235='s460'> 14:16:32: check OK: 500<10000andS235='s355'> 14:16:32: check failed:too short 500<1000231231 > 14:16:32: Ready ... There is some coloring in...

For a certain database I'm looping a record which fills an Excel worksheet. All working fine. in simple: Sub WriteExcel() rst as recordset rstDifferent as recordset for each Record in RST Wsht.Cells(t, "A") = "EUR" & "000" Wsht.Cells(t, "B") = Round(RST!Amount,2) * 100 Wsht.Cells(t...

For a certain database I'm looping a record which fills an Excel worksheet. All working fine. in simple: Sub WriteExcel() rst as recordset rstDifferent as recordset for each Record in RST Wsht.Cells(t, "A") = "EUR" & "000" Wsht.Cells(t, "B") = Round(RST!Amount,2) * 100 Wsht.Cells(t...

I have a form with a listbox in which users should be able to move the items up and down. The listbox has 4 columns and multiple selection is enabled. For a NON multiselect box I have it working, and also for a multiple selection box but in that case it works only for one row at a time. For a...