Search results

Hi everyone, So I have this tracker type database with an SQL server backend, and I just noticed that using Ctrl-f to find some record or using DoCmd.FindRecord doesn't seem to work unless the records are already loaded. It simply loads and loads indefinitely or until pressing Ctrl + Break. I...

Hello everyone, What's the best way to use VBA to transfer the contents of an Access table to a Microsoft Cloud SQL server (Azure) on a daily basis? I have a table with around 60-70 rows, and it takes hours when for example linking the SQL Server table and using INSERT INTO takes many hours...

Hi everyone, We have a table with around 60-70k records that needs to be inserted from an Access table into an SQL Server Azure table. Doing this with regular inserts takes several hours. So my idea was to make a stored procedure and submit many lines at the same time. This worked just fine...

I have a form that doesn't really fit fully on the screen with scaling set to 125% or more in Windows 10 in Full HD resolution, so I want another form to be loaded instead if users have scaling over 100%. I already have code which checks if users have lower screen resolution, but I haven't been...

Hi everyone, An Access database that we have developed doesn't work properly on a few computers in the company which use Windows 7, and we haven't been able to find any difference between the installed related software on those computers with Windows 7 where it works and those where it doesn't...

I have a database using querydefs for connection to the MS SQL Server back-end, but I want to replace all these with ADODB-connections for security reasons (the database uses a service account with credentials in the connection string, and creating querydefs exposes the passwords so you can...

Hi everyone, I'm working on an Access datbase with a Microsoft SQL Server back-end. Unfortunately we have to use a service account to connect to the back-end, so to add a bit of security I'm trying to clear each query's connection string after every time it has been used (users will have a...

Hi everyone, I have some problems with NewQueryDef adding undesired (illegal) characters to my PassThrough Query that the iSeries Access ODBC Driver can't handle. For instance, I have an SQL string like this: sql_str = "SELECT GLCO FROM JD_CSEFP7.F0911" Set qdf = db.CreateQueryDef("Q01_PT"...

Hi everyone, I have a table with a field called Comment of data type "Long Text", and I want to make an update query that adds a certain text, say "abc" + what is already in the field to all lines except those which don't already have this text. My query looks somthing like: Update tbl_a SET...

Hi everyone, I'm using Access 2010. Whenever I try to make an update query based on another table/query I seem to get this error: Operation must use an updatable query. (Error 3073) Let's say I have two tables: TbA: Inv PO -------------- 1 2 2 5 TbB: Inv...

Hi, I am trying to make a database that will keep track of invoice backlogs for different locations within a company. Each day a report file is imported into an Access database (2010), and a query will display all locations with the backlog count of invoices for each of them. Something like...

Hello, When I start my database normally, I'm not able to add fields, change chart type, etc, by right clicking in a pivot chart or table. It works when I open the database while holding down the shift key though, so I suppose there is an option in my database somewhere that I have changed...

Hello, I have a query that displays the difference between the number of scanned and processed invoices for each date (invoices scanned minus processed). Now I would like to make a query that for each date based on this shows the total backlog accumulated. Example table: The first column...

Hello, I have a function in a module that looks like this (it takes 2 dates as arguments): Function get_KPIScanAgeRange(in_ScanDate As Date, KPIDate As Date) As String Dim ret As String ret = "Invalid" ' return value, by default is because age is negative number Dim int_ScanAge As...

Hello, I have a table for invoices (one record per invoice). Each record contains a location ID and a received date. Let's call the table "tbA", the location ID "loc" and the date "rdate". Now I would like to make a query that display one line for each location and in each column shows the...

Hello everyone, I have two tables, let's call them tbA and tbB. In tbA I keep track of the number of invoices added to the system for each location on a given date and in tbB how many invoices were processed for each location on a given date. My primary keys for both tables are composite...

Hello, I have a table that looks something like this in structure: P_date (date) Location_No (integer) Invoice_type_A (integer) Invoice_type_B (integer) Invoice_type_C (integer) Invoice_type_D (integer) I want to create a query which shows the sum of the number of all four invoice types...

Hello everyone, I was asked by my boss at work who knows I have some experience with Microsoft Access to put together a database tool (I'm using Access 2010 which is new to me, previously I have used Access 2003) to monitor the number of processed invoices for various locations on a daily...