Search results

If Me.lstBusinessDetails.ListIndex + 1 = 0 Then MsgBox "please select a row" Exit Sub End If

Its a report. I set the line's visible property in the "Detail_format" event so I know its possible to do this through VBA. The issue is once the whole page has been generarted, I need a way of referencing the last occuring line of that page

Hi I am currently making a line placed below a textbox disappear if the contents of the textbox is NULL. I have done this through VBA and it works fine. I would like the line to be made visible (visible=TRUE) if the textbox of the current detail section is at the bottom (the last detail...

Heres a small version of the db. There are 2 records in the promotion table. The query called "qry_Count_Promos_incorrect" returns the number of days in total of both records instead of just counting the number of promotions. I would like to use the tblPromotion_day table for grouping the...

Hi I have a many-many relationship between a “promotions” table and a “trading periods” table. This relationship is resolved with a 3rd table called “tblPromo_TP” The promotions table has 2 date fields that store the start date and end date of a promotion The Trading periods table has fields...

Cheers, your a star... thats a nice solution. I just realised that when the next import occurs, i need to set records 3001 and 4001's (in the temp table about) fDetails_changed to FALSE if their details (strDetails1 and/or strDetails2 and/or strDetails3) are identical to to previous (by previous...

Hi, I have a projects table with projects that all have start dates and end dates in the same table PROJECT ID Project name start end 12 Grand sale 27sep2010 10oct2010 18 Sony clearout 14oct2010 15oct2010...

Hi 1. The records in tblCurrent represent the data that was last imported on a previous occasion. 2. The records in tblTemp are records to be imported at the end of the day. 3. records 1001 (richard) and 2001 (peter) should NOT be imported because the changes occurred in fields that are...

True, but in this case I dont have control over the source of the data (Excel docs). We're basically importing the same xls every day so its up to the database to exclude genuine duplicates (all fields are the same) and import records that have changed (ID is the same but 1 or more of 6 fields...

Hi I have 2 tables, 1 for temp (records imported from excel) and 1 for permenant records appended from the temp table. I'd like to: 1. compare IDs from both tables and if I find a match then i compare 3 fields in these tables. If tmp tables field are different, then append record from tmp to...