Search results

I'm sure there is something very very simple that I'm missing here but I have 2 global variables FDateFrom and FDateTo which contain 2 dates for a search. I need to output these in a text field - every time I add the name of the variables to the string Access overrides me and changes them to...

Hi all, I've got a couple of Access front ends connected to SQL server - 1 of which is working fine in terms of connecting to the server, the other one which has always worked with no issues has this morning suddenly started displaying Connection failed: SQL state 'S1000' and can't generate...

Hi all, I've got an access form where the scroll bars are set to Both in the format properties but they don't appear, the forms are all set to open in Dialog view - that wouldn't make a difference would it? Thanks in advance

Hi, I'm sure there is a very simple solution to this, I just can't see it! I've got a sql procedure that appends records between 2 dates from 1 table to another - there are 2 parameters @datefrom and @dateto, both have the date datatype I'm using an access front end and have 2 text boxes...

Hi, I'm using the standard link to tables VBA script found here All of my tables are stored in a local table - only issue is, is that when I add the names of the new tables into the local table to be linked -they don't appear as linked tables? All of my existing tables that I've been using...

I'm using SQL server express 2019 which recently could only be accessed via a VPN. I'm using a standard ODBC connection string: ODBC;Driver={SQL Server};SERVER=#######DATABASE=#######;UID=####### ;PWD=#######; When I first changed the name of the server to connect without the VPN it worked...