Search results

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

Actually, I did look pretty hard for documentation. All of my VBA code written in 2000 and 2003 seems working fine in 2007. As far as I can remember, the only major change made to VBA was in the Office 2000 release. Since then, MS didn't mention anything about the language in Office product. If...

I mean if the query you want to load have a naming pattern like "qry001, qry002" etc. You can use instr(qry.name, parttern) to check whether the query name match the pattern you specified and decide what to do with it in later statement

Its there any change made to VBA language in Office 2007 since 2003? I mean the language itself, not its enviroment or extension. I checked the msdn documentation, found nothing.

Import source table as linked. Create an append query in target database that filters the records and add records to target table. If the source table records can be sorted. You can sort those records then use "Top #" sql statement to select a number of rows.

Actually, I was expierenced the same problem years back. If you look carefully, the vba year function are actually "year()" without capital "Y". The function you used shows up like "Year", so I immidiately realised that you have a field, function or variable named "Year".