Search results

Oh, I think this is prettier... I've put that in, and it does the same job... so I'll go with that one! Thanks arnelgp!

Thank you both, I ended up putting this: If Me.attControl.AttachmentCount > 1 Then Me.attControl.CurrentAttachment = Me.attControl.AttachmentCount - 1 End If Into the Forms OnCurrent event - which appears to do the job!

Thank you, arnelgp! That looked like a winner... except that once implemented, when I open the form, I'm now getting an Error 28 - out of stack space? :(

Hello, Long time, no post! I have a form with an Attachment field on it - this field is used to store user photographs. Once in a while, these pictures are updated, but the old ones are retained too. They follow the naming convention of: CCYY_MM_DD_HH_MM_SS.jpg When there is a single photo...

Bingo! :D Got there in the end! For anyone else who may look this up one day in the future, it was as simple as the fact that the bit of code in the VALUE attribute in the form needed quotes around it, like so: <input name="FullName" type="text"...

Hello, Apologies if this is a very simple problem - but it's got me foxed! I am VERY new to ASP webpage development, learning as I go. I have a webpage that retrieves user details from an access database on the web server. What I want to do, is for the currently saved user details (e.g. Full...

Well, to be honest, I didn't even really know you COULD do that... so no, none of those either!!!

Not as far as I'm aware! As far as I understand it - this is where you have more than one primary key in a table, yes? If so, then no, just 1 PK per table...

I've just noticed something - not sure if it will help at all. In the qryCallClosings query, the criteria I've specified on the EventType field of 2, if I change this to 2 Or 13 Or 14, when I run that 3rd query, I get the same error, but 3 times. So, I tried removing the criteria from the...

I've just tried what you've posted, and am still getting the same error message, I'm afraid :(

Yes, that is with SQL backend. I'm using the query builder in Access, and I've checked as far as I can see, and everything looks OK name-wise. I assume the two source queries must be OK, as they both run individually - but equally, all the names seem to check out on the 3rd query I mentioned? :(

Hello all, I am puzzled (as usual)... I have 2 queries in a call logging db, which return a list of events associated with calls be opened, and then the other returns events of calls being closed. qryCallOpenings: SELECT tblIncident.IncidentID, tblIncident.PC, tblEvent.EventType...

Another goldfish! Nay, a whole bloomin' fish tank! Thank you - really!

Bingo! Give that man a goldfish! :D Thank you - sure enough, changing the "#NONE#" to 0 has stopped the error, and is now populating with 0 as expected. I believe that will probably do just fine, we will never use a Nominee reference number of 0, so it should still show up on reports as being...

Certainly. SELECT tblCrest.*, IIf([AccID]="GPEP",3,IIf([accid]="ISA",2,IIf(IsNull([AccID]),1,"#NONE#"))) AS Nominee INTO tblLocalCrest FROM tblCrest WHERE (((tblCrest.PartID)<>"44A05")); If it helps, tblCrest is a linked CSV file. The purpose of this query is to just import that CSV into...

I have the following nested IIf statement in an Access query – which works fine, except the final “#NONE#” message. IIf([AccID]="GPEP",3,IIf([AccID]="ISA",2,IIf(IsNull([AccID]),1,"#NONE#"))) The idea is, if [AccID] contains any of the specified strings, or is null, a number is returned (1, 2...

The only way to get those table names into a table is to type them (well, copy & paste) them manually - they aren't the same names as we have in our contact management system, so it's not like I can export them. If I have to do that - I may as well probably export them all manually - which...

That bit I know - it is the looping bit I don't really understand! The tables don't have nice logical names either - they are client names, which is less than helpful!

Hello, I have a DB which contains about 110 tables, all have the same fields in (I know, poor design, it is an export from some dodgy 3rd party bit of software). Anyway - I would like to export them all to either seperate spreadsheets, or a single spreadsheet, either as seperate sheets, or all...

I thought it might be something to do with permissions as you do - so I have just tried it on another PC. This is a PC which was exhibiting the problem when I was logged in as someone else. So - I logged onto the PC as both the domain administrator, and myself, and the same problem occurs...