Search results

In the end I just changed the drop down box to a text box and the home page's on load event filled them with only numeric data (it seems that the long date which was pre-filled with a date including "September" wasn't registering as a date when opened on a computer with a non English system...

I think I may have uncovered the root of the problem though I haven't yet come up with solution! So painstakingly going through the calculated fields one by one and in each one swapping out the variables for hardcoded values, it seems that the error comes from when the calculated field refers...

I'll look into all of those ideas! Thanks! I'm also going to ask IT to re-install Access on one of the computers which doesn't run it as the 15.0 libraries should be present according to Old Man Devin. I thought spaces in field names were fine if surrounded by square brackets (?)...

Thanks Rx, though to be honest I think that kind of solution would be out of my capabilities to provide (and to maintain). Cronk - yes I am absolutely positive that there are no null fields causing the #error. The same code (the same database in fact) works perfectly on other computers. Old...

Thanks a lot for your advice. I would still like to know the reason why because I don't feel comfortable making Access tools when I can't guarantee that they will work on multiple machines. I will definitely try what you're suggesting but does anybody have any other ideas?

Some of the computers are using Access 2013, some of them Access 2010 and some Access 2007. The access version doesn't seem to correlate to the issue. Also the latest versions are on brand new computers so have not been upgraded to 2013, they've been installed directly to 2013. Do you have any...

I have an issue with an Access database which I set up to manage the total number of months worked by an employee over multiple temporary contracts with any time in a specific period subtracted. This was due to a necessity to control exactly how many months temporary staff had been employed by...

Filter Error With Calculated Fields "syntax error missing operator in expression" Hi there, I tend to work with large amounts of data (extracts from company systems) and I create a lot of Access/VBA based tools to automate processes. I have an annoying error which has always appeared but I...

I have an Access database with embedded OLE "audio" objects (wav files mainly). Thing is, I need to get them out of there because the DB is too large. I really don't want to start creating duplicates of the db and linking them together to achieve the larger size we need. I've had no luck in my...

Maybe the above is too detailed? Imagine there is recordset called FTA which contains a field called "AudioRef" which is an OLE object (a .wav file). The following does save a wav file at the specified location but its corrupt and wont open when the newly saved file is "double clicked"...

Hi there, Just to start I should clarify that when I refer to "characters" in this thread, I'm referring to a particular "part" played by actor ^_^ In my job I work with a lot of different audio files recorded by many different actors as many different characters over various languages and I...

Hi all, As suggested I'm introducing myself here as a new member though to be honest I've been reading this forum for years already! I work in video game audio localisation and tend to find the biggest challenge being to efficiently run the same action/check hundreds of thousands of times on...