Search results

I can't see this specific problem described already, here or via Google, but I apologize in advance if I was just searching using the wrong terms. Many of the Access databases I look after include some variation of If Nz(txtApproval, "") <> "" Then Where Nz is used to replace a Null value in...

I'm running the following line of code in a module kill "Q:\Auto\Used Data\CasesCurrentlyBeingImported.csv" It doesn't produce an error message, but doesn't do anything. The module ends at that point and exits out. I thought it was a permission thing, but if I insert a break point just before...

This one sounds a little odd, I know. I have a table in an Access 2010 db, in which one of the fields has Date Type 'Date/Time'. The format for the field is 'General Date, which includes a time component. The field is auto-populated when a user enters a new record. Of the 26 users, 25 have...

I know there are a whole range of causes for this message. What I can't find is a reason why a given query would produce this error then run without any problems a minute or two later. I'm getting it from different queries which run as part of a nightly refresh. All of these have run hundreds...

I have a form that is used to enter search criteria relating to car warranty claims. One of the fields is an unbound text box that allows the user to enter a specific keyword. The problem I have is that Access removes any trailing spaces from any entered word and there are times when the space...

I try to run the following query and get a message "The Microsoft Access database engine stopped the process because you an another user are attempting to change the data at the dame time". SELECT Max(tblActivityTracker_Import.TimeStamp) AS MaxOfTimeStamp FROM tblActivityTracker_Import WHERE...

I have the following code which I found online in a standalone sub procedure, just to test it out for future use. It's in Access 2010, in case that makes a difference. Dim xlApp As Excel.Application Dim xlWB As Excel.Workbook Dim strMasterBook as...

I'm using VBA to send emails a fair bit. Someone has requested that I create a form to send emailed notifications to certain people and then record when each email is read. The problems I have are that 1. Outlook (which is the email software the company uses) allows you to choose whether or...

In the past, I've had the odd db 'lose' its VBA code. I followed the list of known causes I found online, relating to db corruption, and it hasn't happened for a while. Today, however, I opened a db and found that the VBA windows were all blank. Forms, reports, modules, all showed no code...

I have a team of around twenty guys using copies of the same Access db. Put simply, it's got one main form with a number of subforms, displaying data pulled from an ODBC source. All bar one of these users are experiencing no problems, but one gets an error message at various times: The decimal...

I've tried the following, but each gives me a 'syntax error in field definition' message. CurrentDb.Execute "ALTER TABLE [AEO32B] ADD COLUMN Severity3 DECIMAL(10,3)", dbFailOnError CurrentDb.Execute "ALTER TABLE [AEO32B] ADD COLUMN Severity3 NUMBER(10,3)", dbFailOnError CurrentDb.Execute...

I'm testing using the following to print field names and data types of the Access tables in my db. For Each Tdf In RemoteDb.TableDefs intNumberofFields = Tdf.Fields.Count For intCounter = 0 To intNumberofFields - 1 strFieldName =...

I have a query that pulls data from a number of tables. My manager has asked that I add a field, using data from a function he created (copied?) years ago, which calculates the number of work days between two dates and returns this as a LONG number. I should add that this function is used...

I have a report that's generated using VBA. The underlying data source is correct and if I open the report in Design view then look at the datasource for the chart on it, the records all appear as expected e.g. Jan 20 Feb 20 Mar 20 These are text values, created by taking the first three...

Firstly, I'm not sure that 'Modules and VBA' is the correct place for this question, but it feels the most appropriate. Our company recently upgraded to Office 365. However, we still use Access 2010 because of this ongoing issue...

I'm trying to make sense of some old databases. Each has a large number of tables and forms I'm sure aren't needed any more and I want to get rid of them. The Object Dependencies tool is useful but, given the hundreds of items I'm checking, slower than I'd like. I found some code to search for...

I have a table of criteria, one field of which contains part numbers, these can be any length from 1 character up. The lower the number of characters, the broader the range of items the part applies to. For example: 12345 might be a specific part from a machine Parts starting with 1234 might...

I've found various questions about Access speed over a remote connection but can't find one that quite covers this problem. Apologies if I've missed it. Until two weeks ago, we had a load of databases on a shared drive (P:\). They were set up with a shared back end and each user having their...

Our company just upgraded everyone from Access 2010 on a Windows 7 device to Access 2016 on a Windows 10 device. One of the problems encountered is as follows, but only happens to one person, which has me puzzled. There is a line of code in a few of the databases that uses a global password and...

Does anyone have any experience of adding a driver for accdb files under Windows 10? I'm testing out Qlik View with Access which means, for the first time, I'm trying to install a 32-bit driver on my home PC. The steps I used were as follows: I open the Control panel I click on 'Set up ODBC...