Search results

Hi, I have a main form with 5 tabbed pages. These pages relate to various groups within my office. i.e Head of Service, District Manager, Senior Member..etc etc. Each page has command buttons to launch appropriate reports. Is it possible to restrict each group to their relevant page(s)? I...

Hi, I have a single form with quite a few command buttons on it. I have just discovered how to Create a tabbed form, but when I cut and paste the controls into a page, it loses the 'On Click' properties. Is there a way to use my existing controls on my new pages without re-entering the 'On...

Thanks for that...I should have given more detail though. My Macro runs a make table query, with warnings set off, then Starts Word with the mail merge template. The mail merge template uses the newly created table as it's data source....so that's why I can't use a simple hyperlink. Actually...

Never Mind...I got it sorted by deleting table and recreating them from scratch along with relationships. Franky

Hi, I have four groups, each group has various reports available to them. I want to use 2 combo boxes, one to select the group, and then the 2nd combo box to populate with the appropriate reports. What is the best way to set up the tables for this purpose? I'm having trouble setting up the...

Can I get it to please! frank.gibson@ps.glasgow.gov.uk

Hi, Is it possible to Start Word and lauch a template. I can start Word no problem but don't know what the switch is for launching a doc or template. Can anyone help? Thanks Franky G ps I'm doing this using macros as I don't have the first clue about coding it!

Hi, I have a Report with various sub reports, one of which has date and page x of x fields in the report footer. These fields work fine when the subreport is run manually (the subreport is used as a main report for another user) but when running the large report, the sub-report always returns...

Hi, Using Access 97 on a Win 95 machine (the office).when I get to the final stage in report wizard, preview or modify design, it just hangs. I have to Ctrl-Alt-Del to get back to desktop. report wizard works when I log into a different PC, any suggestion what could be causing the problem...

thx, I was in the process of trying different combinations. It's working the way I want now! Thanks again for your help, Franky

Hi Mike, nearly there...just one more thing! My reports are based on multiple queries, so that the report should close if all the underlying queries return no data. I'm trying to figure out how to do this with the code you provided below, Private Sub SDG_Report_1_Click() If...

Ok Mike, I'll try that when I'm back at the office. regards Frank

Mike, you already helped me on this one; I'm trying to close a report (or not even run it) if there is no data. The problem is that in my Header section there is always the From and Until fields which prevent the On No data function from being used. Here's what you posted last time; Private...

Hi, I have a main form from which I launch a Word doucument. The Document opens OK but when I return to Access, the Form now has the Web toolbar active! I really want the form to be maximised and no toolbars to be active. is there a way to do this? Thx Franky G

HI, I have a few reports which I want to close when there is no data. I'm using this code; Private Sub Report_NoData(Cancel As Integer) MsgBox "No Data in Report", vbInformation, "Report is cancelled" Cancel = True End Sub Problem is that I have fields in the report such as the present date...

Thats an idea..I might do that. As for SQL passthrough query...um..I haven't learned anything about that yet! What's it for ? Franky

Thanks, it's working the way I want now. FrankY

Hi all, I have a button which I use to clear various fields, as below. Private Sub Clear_Form_Command_Button_Click() Me.From_Date = Null Me.Until_Date = Null Me.Description_Text = Null Me.Area_Team = Null Me.Requery End Sub trouble is, when either of the date fields fails to meet the...

Thanks for the suggestion, although this would take to long for the users. The Database queries a rather large oracle database, so even a print preview can take 3 or 4 mins. To mave to the last record(in print preview) takes a while to. To then print the report would just try everyone's...

Hi, I nearly have this, but not quite! Using a form to input text, from which a report will run using the text as part of a search. I want the report to run, 1) When the command button is pressed,or, 2) When the user hits <CR> Don't want it to run if any other key is pressed, such as TAB...