Search results

Sendkeys has always has it's issues, and many developers recommend against it - sometimes focus has changed, and the keystrokes ends up somewhere else... I've read somewhere that Sendkeys with Access 2003 isn't supported by Vista, but I don't know, as I don't use it. I'd be rude, or bold enough...

Yeah, it did work on my a2k, but not on my a2k7 ;)

neileg is probably spot on - you're probably using a lookup field in your table, and experience one of the many reasons why many of us recommend against it. See for instance http://www.mvps.org/access/lookupfields.htm for more info.

Some alternatives 1 - right click form title bar, select Close All (o2k7), or select design view, and then close 2 - hit ctrl+g, then type just quit, application.quit or docmd.close acform, "switchboard" 3 - hit ctrl right arrow, or ctrl+comma, then Ctrl+w or Ctrl+f4 or Alt+F4 I have pesky...

<smile>the division 1/1/2006 equals something very small</smile> Try with date delimiters If Me.StartDate >= #1 /1/2006# Then Seeing you're from UK, in the VBE Access is most interested in US dates, so if you do a comparision against say 1/12/2006, where you intend it to be first of december...

Be careful that this might reseed the Autothingie, so that you end up getting dupe numbers. Contrary to common belief, the functionality of the Autonumber field isn't to give unique numbers, but provide numbers in some sort of order (or lack thereof). Either incremental or random. What provides...

Grin - out of my league, I'm afraid. I stopped liking datasheet view long ago, and use mainly continuous forms or listboxes in stead - good luck ;)

I don't know how Oldsoftboss' sample file works, but I can tell you that disabling the Access Min, Max and Close buttons, does not force your users to use your custom "Close Application" button. Among the ones I'm able to remember, theres Ctrl+F4, Ctrl+W (both will close current form) and...

Edit: Seing it is "solved", changing a bit. Your base seems to suffer from some corruption. One recommandation would be to use the /decompile option - see Tony Toews page http://www.granite.ab.ca/access/decompile.htm for detailed instructions - note - between step 2 and 3, exit the base, and...

What version are you on? If you're back on 97, I think you're out of luck. It works on my setups a2k and later.

Move the MessageMod sub to a general module. It needs public/global scope, which it doesn't have when it resides within a form or reports class module. Edit: btw - here's a recent discussion from an Access NG...

Try using the acCmdSelectRecord arguement of the DoCmd.RunCommand method. Me!TheSubFormControl.SetFocus ' if focus is on a main form DoCmd.RunCommand acCmdSelectRecord

What is displayed in combos/lists is text, so any number formatting applied, usually doesn't show. You probably need to format in the query. In the rowsource property of your combo, try SELECT pkVAT, Format(VAT, "0.0%") FROM VAT Note that if there are more than one decimal, using this, it gets...

A table is actually saved in a meaningful order, but to whom ;) The Jet primary key designation, is a clustered index, meaning it (should) store records in primary key order. What happens, since Jet is a file based system, is that when adding records to a table, they are added where there's...

Found a VBA implementation that works; http://www.vbaexpress.com/kb/getarticle.php?kb_id=405 I've read somewhere that it might return different/odd result on Win 2003/Vista, but I don't have the possibility of testing.

Ah, sorry, haven't done that before. There are probably more than one approach to this, but one is involve investigating the GetDetailsOf() method - here's a couple of VBScript thingies I found through a little search...

You need bitwise comparison to get at the file attributes. See http://msdn2.microsoft.com/en-us/library/5tx15443.aspx for codes, i e (air code)If f.Attributes and Normal Then msgbox "no attributes set" End If If f.Attributes and Archive Then msgbox "Archive attribute set" End If If...

Sometimes MS Query wont recognize different querytypes, such as Unions. One trick that sometimes work, is to create another query based on that - just a select all the columns from the Union query, store it, and then it might produce results (and be found through MS Query).

Perhaps is we get the errormessage? I'm guessing it might have to do with using reserved words as name of field (Date). If that field is also of datatype Date/Time, then you'll get an error when using single quote as delimiter (') it needs #, and you probably also need to format the data to an...

If you really have to ;) then have a look at Alllen Brownes article http://allenbrowne.com/ser-35.html, which has another way of referring to different instances. I've never worked with this, so I can't offer more assistance, but there should be some samples around that should be found through...