Search results

I have some code which basically opens up a query called "qry_tickback_template2" and by looping through a table called "tble_List_Tickback_Queries_Criteria_GTM" it changes the parameters each time and creates excel files based on each record criteria. The criteria for the query is held in the...

I have been using Bob Larson's Excellent Auto FE Update utility http://www.access-programmers.co.uk/forums/showthread.php?p=593273&posted=1#post593273 but am struggling with the batch file because I want to re-open the database using a secure workgroup currently I have changed the PRINT...

I have a form called frmHotspots and dependant on which mainframe system table the user selects from a combo box above called ComboTable, I want the list box below called MyList to be populated with the field names of that system table. Each mainframe system table has its own table in my DB...

I have just split my multi-user DB into Front end and back end. All appears fine apart from there is code in the autoexec module that checks to see if a particular table has been updated today. Basically the first person to login to the DB each day will run this procedure without realising...

I have a form Create_Invoicing_Details which opens from another form Reports (table behind this is Report Details) and creates new Invoicing details. After the invoicing record has been saved (into a table called Invoicing Details) by clicking on a button (this table entry works fine) the...

Before anyone says "check these forums for an anwer", I have done so already! My problem is that since converting from Access 97 to 2002, I am finding it a real pain in the *** that I cannot develop any new forms, modules etc whilst the users have the DB open because I am not logged in...

:confused: I have a report header which always used to come out as a separate front page with my Customer Name headers starting on the next page and forcing a new page before each section. Since converting from version 97 to v2002, the report header is coming out on the first page with the...

Have searched thru all threads and can't find the answer. Does anyone know if it is possible when using the DoCmd.SendObject syntax, to specify the actual font for the email i.e Frutiger Light. All of our company emails have to be sent in this font. Additionally is there anyway you can link...

I know this has been posted many times and I have searched through this site for answers but nothing resolves my problem , especially as "yes, I am providing the parameters from my form!! This is my code: (note the SELECT statement is all on one line in my DB) Dim mysql3 As String Dim myrset3...

I have the following module which correctly calculates the number of working days in a given month and accounts for Bank holidays by referencing a table within my DB. this all works fine when you run it direct from the module. However I am struggling to change the module so that it can be...

:( Has anyone else experienced problems with 2002 databases keep closing down and corrupting? I have created a brand new DB but it keeps closing down and now it is corrupted beyond repair. I've tried re-importing tables etc into a blank database but it won't import the modules etc as it says...