Recent content by aikea

select count(id), name from your_table_name group by name having count(id) > 3;

Same thing, Use a rectangle to contain your controls in details area. Make sure the rectangle is well sized: Or you can put two rectangles to cover edge Make sure the rectangle color is different to detail background color

Basicly, you can use a "Rectangle" control as background. Effect

Go to Query page -> create new query -> SQL -> type in that sql statement

select id, count(name) as name_count from your_table_name group by id having name_count > 3;

Here: http://msdn.microsoft.com/archive/default.asp?url=/archive/en-us/dnarofftalk/html/office09072000.asp

Delete: Duplicate post.

You need to call combobox's requery method every time you want to refresh the containing data. For example: Sub Combo27_OnClick() ComboBoxEmployee.Requery End Sub

Place a Rectange control on the form. Place control within that rectangle. Set the rectangle z-index to lowest number. and set its color.

There is a "Linked Table Manager" in "Database Tools" tab.

There is code example in msdn.com. If shows you how to check whether a file or folder exist, list files in a particular folder etc. Go to msdn.com then "VBA Dir()"

I spent last two days compare VBA built-in functions between 2003 and 2007. I didn't find any differences. Actually, the 2007 version is exactly a copy&paste of 2003. Some addin classes are changed or depreciated, but they are all platform dependant. -------------------- You can use Visual...

That's completely defeat me. You may wish to try to port all of your file to a new machine and try it again to see what happen.

Well, that is something to do with forms rather than VBA itself. But, now I am quite sure the code I write in Access 2007 will run on any version since 2000 as long as no platform dependent feature included. Thanks for all

Try this: DoCmd.TransferDatabase acImport, "dBase IV", "C:\internet\download\peardat.dbf", acTable, "peardat", "peardat", False