Recent content by stumbler

seems the 'group' events are only triggering when you open the report in print or print preview mode, not when you click on the green report icon so it was my mistake :D

i'm trying to hide a group footer at the moment when a c ertain calculated value is zero. Private Sub Groupfooter2_Format(Cancel As Integer, FormatCount As Integer) If Me!qtyYear = 0 Then Me.Groupfooter2.visible = False Else Me.Groupfooter2.visible = True End If...

Found this: http://www.pcreview.co.uk/forums/modify-control-value-access-report-through-vba-t2924379.html So it seems not to be possible. I solved as discribed: link the control to the form where the users open the report. and that works

Private Sub Report_Open(Cancel As Integer) Reports("rptSalesPerMonth").txtSupplier = "LANNEA" Me.txtSupplier = "LANNEA" End Sub gives me the error: cannot assign value to thisd control

just click the three dots next to record source in the properties of the report. There you can modify as you like

Hello, i need to total up all sales for 1 supplier and compare to the total. I was thinking on adding a condition in a calculated field. The condition refers to a textbox on the report header. =Sum(IIf([supplier]=[txtSupplier];totalqty;0)) but each time i get a prompt to supply the value: it's...

Thx for your help! solved it by enumerating the fields to update as John suggested Don't really trust adding info to an autonumber:eek: think it's better to give that privilege to access

i want to avoid going to the table line by line and do a mass update. if possible.

I removed the column containing the autonumber out of the temp table (ALTER TABLE temp DROP COLUMN xyz (=the autonumber column). all other fields are identical but still it is not working.

Hi, I 'm trying to add records to a table, but this table contains a autonumber. The command i use strSQLcommand = "INSERT INTO [tblOrder] select * FROM temp" cmdCreateTable.CommandText = strSQLcommand cmdCreateTable.Execute but the problem is that there is an...

found solution myself (on this forum) SELECT * INTO [B_match] FROM [B_All]

Hello, When I try: create table temp as (SELECT * FROM [tblOrder-master] WHERE order='2012102302'); i get error: instruction CREATE TABLE contains syntax error. Anyone that can help?

this is my first post