Recent content by sammylou

The sql bit is fine, the where bit comes from a text field in the table so my q.sql is SELECT qry_tickback_template.* FROM qry_tickback_template WHERE (((qry_tickback_template.SourceSystem)="Brio") AND ((qry_tickback_template.ReportFrequency)="Monthly") AND ((qry_tickback_template.[Status of...

I would really appreciate if someone can help with this Thanks Sam

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...

Bob Yes I do have both tables set to 2 in the master and it's in the COPY that is on the user's computer that has the tbl-fe_version set at 1. It is now sort of working but the database is not closing itself. The delete and copy is working Ok I am having trouble with the re-opening bit as...

Help with Auto FE update utility I too have used Bobs great utility but am having some problems getting it to work properly. local FE is on c:\ with record in local tbl-fe_version set as 1 and master FE on a network drive with record tbl-version_fe_master set as 2 One problem is that I don't...

Can anyone please advise me on my post any help would be really appreciated Thanks Sam

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 am using Access 2002. Thanks again for all your help. My systems people have now put the missing help files in place!

Thank You very much for all your help. I can now see that I have 3 help files missing including the JET SQL reference one, although I have now located the .chm file on my C:\drive. I am assuming now though that I need to replace all my "Make Table" Queries in the FE DB with modules showing...

I am assuming you mean the tab page "contents" under help? If this is correct then the topic is definately not under there. If "Table of contents" is something else than the Help menu at the top, then I have no idea where it is, I have looked under all the menus and cannot see anything...

Again thanks for your help, however I must have some help files missing because I have looked under "Creating and working with Databases and Objects folder" but I don't have "Database objects" + "Queries" + "Microsoft Jet SQL Reference" folder?? I have also tryed searching by using a Jet SQL...

thanks for your help. Unfortunately I cannot locate this Help file in Access, I have even expanded all of the Help files. Additionally I now have a problem whereby one member of staff who uses a laptop to connect to the network drive, cannot use the same FE as everyone else. This is because...

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...

InvoiceID is a unique numeric number i.e. 4048 which I know is working OK because that number is the record ID in the Invoicing Details table which is being updated correctly. What it is not doing is storing 4048 in the InvoiceID field in the Report Details table, and ticking the field...