Search results

Thanks. Unfortunately, all they're being sent is a short message, along the lines of 'ABC has requested that you return any parts number 12345 that you have in stock, as a fault has been discovered'. If I start adding links, it'll get shot down as overcomplicating things at their end.

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...

Thanks, all. I checked the font color and it wasn't the problem. Spoke to IT and asked for a reinstall. Was told would take a few days. I asked if they'd sent out any updates that might have caused this and was assured they hadn't. However, I came in after the weekend to find the PC has been...

Thanks for the reply. This PC has been set up and running for about four years now. Wouldn't a bad install have manifested itself before now?

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...

Thanks. No references were missing, but I've used this as the starting point to raise a ticket for tech support to start their investigation.

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...

Thanks again. I can get by using Double, but it was bugging me why I could choose Decimal from the drop-down list of number types in design view but can't work out how to use it via VBA. Oh well, no time to puzzle it out now.

Thanks very much. May be a stupid question, but if I were doing it manually I could select Decimal as a data type. Is that not available via VBA?

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...

Okay, as is often the case, asking the question (and clarifying the problem) got me thinking differently. That, coupled with Pat's kind code snippet, got me a working version. The user runs the function, it prompts them to select an Access db, it then populates a table with each Db name (or...

That looks very useful. Thanks a lot, I'll give it a go.

Error 3265: Item not found in this collection If I hover the cursor over the variables, I can see that intCounter is at 0, so it's the first field, and Tdf.Name is the name of a table I'm linked to, via ODBC, in a remote db.

Sorry the colour won't save, so I added the lines underneath. strFieldName = CurrentDb.TableDefs(Tdf.Name).Fields(intCounter).Name intFieldType = CurrentDb.TableDefs(Tdf.Name).Fields(intCounter).Type

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 =...

Two corrupt records out of 1MM+. No way to read any of the fields in them other than the the ID. They were over 12 years old, so I had the admins run whatever their equivalent of a 'compact and repair' on the table. All working now. Thanks all for the suggestions that pointed me in the right...

Thanks, I'll post if I locate anything

Unfortunately, I tried adding that to the criteria and also tried changing the field to Nz(funWorkDaysDifference([CALENDAR_PROCESS_DATE],Date()),0) Neither helped.

Sadly, it's huge, is an ODBC table I link to, and contains a lot of confidential data. If I make a local copy and cut it down to a size where I can post it, I think that would negate any benefit?

No, when I run it as a select query, there are none.