Search results

Function abadmin1() Dim dbs As Database, field_name_all_proj As Variant, field_name_comp_proj As String Dim rst As Recordset, test As Variant, IntI As Integer ' Return reference to current database. Set dbs = CurrentDb Set rst = dbs.OpenRecordset("job_codes", dbOpenTable) field_name_all_proj...

Wasnt sure where to put this: so here goes: Function abadmin1() Dim dbs As Database, field_name_all_proj As Variant, field_name_comp_proj As String Dim rst As Recordset, test As Variant, IntI As Integer ' Return reference to current database. Set dbs = CurrentDb Set rst =...

I have a number of forms that are generated on the fly. I have added various controls and labels yet want to change the font and color on some of the labels, and the data sources in the details section. However i want to do this by VBA. Set all_proj_date_lbl = CreateReportControl(rpt.Name...

I have a query that displays a list of records...say X number of them. but this number can change, its generated on the fly. I then have a macro which calls another macro and i would like it to run X-1 times so basically to the end of the record set. (As previously it has already ran once.) i...

I have set up a situation when a user imports an excel file it creates a new table based on a template. That is all fine and dandy, however, I need to recreate some queries to query the new table that are similar to the other ones present. is there a way of passing a variable to the select...