Search results

It is popular for web based project management systems to use a Kanban board to display actions. So a task would have a status field with for example: assigned, WIP, solved, closed etc. The GUI would display four columns and the tasks would be listed according to their status. To change a status...

I am returning to creating databases after a long absence. I am trying to re-use code from previous databases I have designed to save a time. Historically I have a function that checks that the access front end is able to connect to the SQL back end. I have copied this function across to the new...

I have a database that stores risks, at any one point there can be many risks with each having values from 1 to 5 for current impact (CI) and current probability (CP). Once a week I would like to tally up how many risks have CI of 5, CI of 4 ......... PI of 5, PI of 4 etc. and store them to a...

I tend to write inefficient code, as an example one of my databases creates an Excel workbook with two sheets one displaying open issues, the other closed. Both sheets are identical in appearance and hence coded identical, the only difference is the query to generate the data. Up until recently...

I have an access database which produces monthly management reports by creating an Excel Workbook from Access using VBA. This has been running hunky dory every month for years. Now all of a sudden I am getting the Error: The standard VBA error code: 1004 The standard VBA error description: No...

I have a form with a project selection button. A user selects a project then clicks a button. When this happens a pass through SQL query is produced. The code is here: Private Sub cmdIssueList_Click() On Error GoTo err_cmdIssueList_Click Dim strSql As String Dim strQdfName As String...

I have been developing databases for my company for some time now. All have a default "splashscreen" form that opens up when the database is opened by a user. In the background VBA runs on the "on open" event of the form to validate who the user is via their windows username. All my databases...

Getting pretty confused. I have a backend database in MS SQL with a field called Link set to Varchar(Max). I have a front end Access database containing a bound form with a bound subform. The subform contains a field called Link with source bound to the "Link" field in the SQL table. It is...

I am trying to import data from an excel worksheet (WS) into SQL but I am having a number of issues. The import export wizard is incorrectly identifying data types. There are two columns on the WS that contain only a heading, nulls and integer values but the wizard classes then as double...

I currently run a number of Access databases as a front end that connect to databases on the company SQL server. The connection method I use is windows authentication. All front end databases I distribute are compiled accde files. The IT department who are responsible for the servers have...

For some time I have been designing all my database with unbound forms that input and output data on a SQL server using VBA. To protect against SQL injection on all my forms for adding and editing records I use a simple function I created: Public Function MakeSqlSafe(varInput As Variant) As...

I am using Access to insert a string into a table cell in a Word using VBA. The string is of the format: "Subject 1: text goes here & vbCrLf & Subject 2: More text goes here & vbCrLf & Subject 3: Yet more text goes here" In the word document I would like it to appear like this: Subject 1...

I wish to create a word document containing field values for a parent recordset and child recordsets. I have created a word template that contains a table to control layout. In each cell I have created a bookmark to insert the recordset values. This works fine for all parent recordset fields...

I am using the IsNull function to prevent passing Null values to another function, but the line with the IsNull check is itself throwing an Invalid Use of Null Error. I am a little confused and would appreciate any insight into what the problem may be. The Error is returning at line 20. Private...

I have a SQL recursive query (below), which runs fine on SQL server and also runs fine when I create a QDF in in MS Access navigation window. But when I try to create it in VBA I get an error "Invalid SQL statement; expected 'DELETE', 'INSERT', 'PROCEDURE', 'SELECT', or 'UPDATE'." The query...

I have a database for weekly timesheets. It contains a function I created the can be used each week to send reminder emails to those who have not completed a timesheet. The database and function have worked fine for years, but recently it has stopped working on one users machine. When the...

I have a recently created SQL database for actions called "Actions", there is already an existing database on the same server for "Employees". I wish to pull the Employee name via their staff number into the actions database (every action has a "By_Who" field of same data type as the staff...

I am trying to write a procedure that takes an string array of field names and a tab delimited string and then splits the appropriate value for each field from the string so it can be appended with a querydef. The code suffers a runtime error on line 30 type mismatch but I cannot work out why...

I am trying to process a tab delimited text file, the ultimate aim to populate a table in access with the contents of each line. But I am unable to detect the "tabs" in the test file. I have tried using the split function with various arguments and also strReplace with various argument. None of...

I have never really used arrays to any degrees. I am trying to create a function to split a string by tabs, but I am struggling to get it to work even with spaces (not even tried tabs yet). I keep getting a type mismatch compile error but I can't see why. Can any advise? Public Function...