Search results

Hi everyone, I am using VBA & SQL to try and filter/order data in a sub form. I am getting the following error: Run-time error '3079': The specified field 'Code' could refer to more than one table listed in the FROM clause of your SQL statement. Here is the relevant VBA code: Private...

Hi, I have been developing databases for a while - and I have collected a selection of common problems/solutions that I come across. I want to build a simple data entry/search database to store this in, but was wondering if there is a way to store actual VBA code in a table field and then...

Hi, I have a report that summarises teams totals in a dreamteam competition, and have used the following code to alternate the background colour of each row: Dim blnalternate As Boolean Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) If blnalternate Then...

Hi, I have a fantasy football database, and I identify new weekly points by New:Sum([Current_Pts]-[Previous_Pts]) from table Teams, in a query. And then 'manager of the week' by =IIf([New]=DMax("New","qry_SummaryPts"),"***","") on a summary report. Also, on this report I have a column...

Hi, The problem I have is that I need to open a query in datasheet view but in maximum window. Currently I am using: DoCmd.OpenQuery "name of query", acViewNormal, acEdit This opens, but not in a maximum window. Is there a way to do this in VBA, or anything else in Access 03?