Search results

>=DateAdd(-2,"m",Date)

This topic has been discussed in depth on this forum many times. Do a search for 'stock' posts, the answer is there.

Why not use a linked table with an update query if the data 'needs' to be imported ?

Bert and ernie shared a bed as I recall, with a rubber duckie. How broad minded. For further character lists see: http://www-cs-students.stanford.edu/~csilvers/muppet-characters.html

Presumably, the text file indicates the dataset date, if it doesn't you can use the FileDateTime function to return the creation/last modification date of the file. Including this in a recordset update loop for each file would allow you to assign this to a particular field. You could then...

If IsNull(Fld1) Or IsNull(Fld2) Or IsNull(Fld3) then Msgbox "Some Values Missing - do nothing" Else 'run your code here End if

Would changing the settings under Tools>Options>Keyboard help?

This could be standardised even further using DoCmd.OpenForm "CalledForm", , , , , , Me.Name

Add a picture table to your database with two fields, key(primary key text) and path(text)). The key will be the course identifier and path is a string location of the file. Assuming the size of the picture table is quite small you can use a DLOOKUP function to retrieve the value...

There'd certainly be a 'big bird'. Maybe 'grouch' could be the obligatory moustached dude.

It's forn(ic)atian street I've been waiting for :D

As I recall the error is caused by the calling form having not completed it's action NOT the OnNoData event, you need error trapping in your button for error(hint: use Msgbox Err.Number to establish the error number to catch). I think it's either 2501 or 2051, I never remember. :)

Use the createdatabase method to create a database of your choosing(you'll have to check that it doesn't already exist first). There are quite good examples in help.

You don't need to include it in your result set, its just criteria - exactly the same as when you don't display the criteria column in the QBE grid by unticking the box under it.

If you used text boxes as Rich suggests you could set the source to an expression suchas =Format(DateAdd("m",x,Me.OpenArgs),"mmm-yy" where x = an integer from 1 -12 dependent on how many months to calculate forward Header_Update_Date is passed as the OpenArgs value in the...

It seems to me you need data validation using the before update event to cancel the record being saved if the user does not complete fields. There are many posts on this forum explaining how to do this.

Could you just tag page two on the end of the first page and insert a page break. Thinking sideways, could you have Page 2 pre-printed on the back of page 1's source paper? If these aren't feasible, then the only alternative is to change the report to return only one record at a time then...

In many instances where people write an SQL Statement, there is no need to, instead use a presaved update query and run that from your code: Docmd.OpenQuery "QueryName" The next question usually posted is how do I stop it notifying me that it has updated a record, this is done by surrounding...

You can't save the database under another name whilst it is still open as far as I know, so the only alternative I can think of is to import the entire DB and relationships into an empty shell or rename the file to reclaim the mdb extension. Such a task would be accomplished by: Name file.zlh...

Query Optimization Tips... 1. Display the minimum number of fields in a query. Set criteria dependant fields that are not required in the dynast to "not shown". 2. Index all restriction based fields, all fields included in expressions, all sorted fields and all join fields. 3. Use primary...