Search results

Yes sorry you can probably tell I wrote that response pretty quickly, thought I'd get in before anyone wasted too much time writing a lengthy reply. The code has changed a bit since then, but you get the picture. Thanks for the reply :)

Just realised I'm probably being thick (not the first time, sorry) I can do this just using the before update event to check the value and cancel/undo/msgbox etc.... Consider my previous question an academic exercise :D For anyone in my situation here's what i used in the end: Private Sub...

Hi all, Please help, I'm having some trouble with a control on a form: The control asks for a value between 0 and 50, so naturally I entered the Validation rule <=50. I haven't used a lot of validation rules (for some reason) but that seems to work, so that's not really the problem. If a user...

Interesting point. In this case I wasn't editing anything, it happened to one of the users but he doesn't know what went wrong it just popped up when he opened the file. But you're right I shouldn't edit while on the network, and though I'd like to say I've never done it before, I must...

Thanks Ranman256, I had a feeling that was the case but I was unable to replicate the circumstances to test it.

Hi all, When you get this message, does it delete Macro's as well as the VBA project? I'd like to setup some kind of prompt/message to trigger if this has happened, but of course I can't use VBA to do it! Any thoughts appreciated :) Many thanks,

I did, but that didn't help either haha... Actually I found it after some poking about, I had to set the new primary key's identity specification to Yes (in column properties for anyone else reading), the field just needed to know it was an Autonumber. Thanks for the help you really pointed...

Hi Paul, Thanks for the quick reply! Actually I forgot to add the Primary Key; but it wasn't enough to fix the problem :( All fields (except the PK) currently allow nulls. Thanks

Hi all, I've been working with Access for a few years now but this is my first real test on SQL server. I have just transferred the back end of an access database onto SQL Server and connected the front via linked tables, so the fe database works as normal, except for one insert query which...

Hi all, So I don't know if this is the right place to ask but I noticed this does appear to be a forum for Excel questions, despite this being the 'Access' Programmers forums (whacky right!? :eek:) Anyway, A colleague of mine has a form with about a bazillion hyperlinks, all of which were...

Found it! In the Format tab on properties for the Doc Name control, there's an option called 'Hide Duplicates' that was set to Yes by default.. I switched it to No and it's problem solved. Woohoo :D

Hi all, I have a table of Document references, and am trying to print an index of all documents on the system. I've grouped the records by DocumentType, and this has produced the desired result, see JPG1. However the report only looks like this when each document has a different name to the...

Might have just solved this one myself... in case anyone else needs to know I added another Condition on the append query to find records where the Auto ID was < the ID of the latest one, as referenced in the form. In SQL: UPDATE [Personnel-Qualifications] SET...

Hi all, Can anyone advise how I might select all the records within a query except for the most recent one? I have an AutoNumber ID field and a date stamp to use , but I can't figure out how to exclude just the biggest record. In a nutshell, I am trying to run an update query on the...

Hi JDraw, So it's basically down to personal preference. I just wondered if there were any performance/practical reasons why one method should be used over the other. thanks for the reply,

Hi all, Wasn't sure if this question should come under the Tables section so sorry if i'm in the wrong place. I'm just trying to figure out why Access allows me to apply multiple Primary Keys to a table, surely every table should have just one? The situation comes about in many to many joins...

Hi Frothingslosh. Lovely name btw. Can you please explain what you mean when you say they can't store a null value? Do you mean to say that it's it's bad practice or a physical impossibility? - because to my human eye it's never been an issue as long as the numeric field isn't a primary key and...

Hi all, So this is really bugging me, I am using Access 2013 and in table design view. Whenever I add a new 'Number' or 'Currency' field the 'Default Value' property is (by default) always 0. This is fine except when i want to refer to a foreign key or amount which could be unknown. In either...

Ruddy marvelous, can't believe this hasn't come up before. Thanks for the help as always :)

[Solved] if null .Visible = True - not working! Hi all, I have what would seem to be a simple issue, but I can't figure out why this isn't working... I have a form named [Assets] which contains two command buttons named [Retire] and [UnRetire], these buttons simply add or remove today's date...