Recent content by userZ

Thank you for your help.

I have a subform that is linked to a table. The subform is part of my form. The table has fields such as date, time and true/false(false being the default value) field. In the begin of each day 12 rows gets added to the table. One row for each hour. Some other applications somewhere else can...

No, it is not a school work. It is a fun project.

Access DB: TableA: ID, team, group, date, time, game, result, city, country Need a query that extracts the last (max (date plus time)) game a team has played where city name starts with "abc" or "def". select ID, team, group, date, time, game, result, city from TableA ..... :banghead:

No, this table has primary field as well as index keys. After copied and pasted the original table with its data+structure, then renamed the new one works as it should. Not sure what is the difference.

In access 2010, I tried to append a group of records like 100 to my table, I know that already 99 of them are in my table and I expect only one out of the 99 get added. It gives an error that 100 could NOT be added due to key violation. I search for the lines, I found all, except one out of the...

hi. Within batch file, I use the following command: MSACCESS.EXE mymdbpath /compact I get the exclusive in use error. How can I suppress such error or warning messages from within the batch file?.

TableA stores product shipment information. inpdate, inptime are the entered date and time for each product. Need to query the last , MAX(date+time), entry for each product where the "delivered" is yes and location is "loc1". The fields to query are shown in TableB.

From tableA, need a query to get to something like TableB. TableA: TableB: In Access, i tried multiple queries to get it done. I like one query that does it. It may use less resources.

In my report open handler, If I got: if (case1 = true) then With MyReport.lable1 .Caption="MyLable1": .Visible=True : End With end ifCan i some how move the if statement to inside the With statement?. Something like: With MyReport.lable1 if (...) then .Caption="MyLable1" end if...

MAX ID/date. I need to get TableB to TableA without using Group by. TableA: ID name1 name2 dt 1 n1A n2A 1/1/2010 2 n1A n2B 1/1/2010 3 n1C n2C 3/12/2011 4 n1D n2D 5/03/2013 5 n1D n2E 6/7/2014 6 n1D n2F 8/12/2011 . .TableB: ID name1 name2 dt 2 n1A...

access 2003, with this update query I get the error operation must use an updateable query UPDATE table1A INNER JOIN Query1 ON table1A.f1 = Query1.f1 SET table1A.f2 = Query1.f2;If I save the Query1 records to a table, table2, then this works. why?. UPDATE table1A INNER JOIN table2 ON...