Search results

You don't need to do this in VBA at all. If your relationships are set up with cascade deletes, all child table records will automatically be deleted. As for identifying records older than 7 years, this SQL will do the trick SELECT DateSample.MyDate FROM DateSample WHERE...

I don't think you can set the limit to list to no when you lookup data in another table as that would require a new entry in the source table. I would add a new field for custom notes and an entry in the Note table for 'Custom Note'. You could then set your new fields visibility based on the...

following on from Rich's advice by using a lookup table of coded responses you would also considerably reduce the amount of data stored as you would only be storing a reference to the actual text.

I would agree guys if this were a table however wouldn't this just be case of using the beforeupdate event to cancel the update at users request. If you are talking about backing out of a session's worth of updating where you have edited multiple records then I refer you to the previous responses

Another way to do it is open the form hidden and make it visible if there are records. Dim stDocName As String Dim stLinkCriteria As String Const NoRecords = 0 stLinkCriteria = "[AnyText]='David'" 'criteria stDocName = "frmTestIfAnyRecords" 'form to open and test for...

try here... http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=22499&highlight=limit+the+number+of+records+per+page

Please provide us with more detail on what inputs are required before the record is saved, can you please post your code so far and where it is falling down.

I have a little speaker in the bottom corner with a volume control - does that have any effect?

You can use Docmd.SetWarning = False to eliminate any warnings if you are importing in VBA, but you must turn it back on after the import to be notified of relevant errors.

not being familiar with SPSS I don't know the answer but here's another site which deals with manipulating an SPSS file. http://pages.infinit.net/rlevesqu/Scripts/ImportExport/td_ExportAsXML.txt

sorry, my mistake, should be: Me.YourLabel.Caption = strCaption

add a label to the head of the document and then set the caption in the OnOpen event. Dim inputFrom as string Dim inputTo as string Dim strCaption as string inputFrom = InputBox("Enter Start Date") inputTo = InputBox("Enter End Date") strCaption = "from " & inputFrom & " to " & inputTo...

probably already done the rounds... Title: Cigar Insurance -------------------------------------------------------------------------------- Another example of why this country needs a few more good lawyers! A Charlotte, North Carolina man, having purchased a case of rare, very expensive...

If I am reading your question correctly, you need 3 queries. Query 1: Grouped by Person, Summing how many are processed within 10 days suchas SELECT tblProcessExample.AName, "<10" AS t, Count(tblProcessExample.AName) AS CountOfAName FROM tblProcessExample WHERE...

apologies, just recovering from a bout of man-flu (10 x normal flu) :)

andy, why would you want to duplicate the value across all records when by definition it is the same for all records, it is a bad approach. Instead, when you need this value either do a DLOOKUP for the value from a reference table or include your reference table in your objects source query...

short and sweet A man walks into a fishmongers with a haddock under his arm. "Do you sell fish fingers" he asks. "of course we do" says the fishmonger, we wouldn't be proper fishmongers if we didn't". The man grins with glee and says "Oh good it's his birthday"

short and sweet A man walks into a fishmongers with a haddock under his arm. "Do you sell fish fingers" he asks. "of course we do" says the fishmonger, we wouldn't be proper fishmongers if we didn't". The man grins with glee and says "Oh good it's his birthday"

Nice one Pat, well worth remembering

Mile, bad practice I know but, come on dude, give a guy a break