Search results

ive added that macro in and it still brings up a blank form. Is it because it JobReference is a Text Field? I know i have had to change macros in the past because of this

sorry i had writted the where condition in before. On the button I created a macro. It was an 'OpenForm' macro with: Form Name: FRMVacancies View: Form Filter Name: Where Condition: [Forms]![FRMBrowse]![BTNBrowse]=[JobReference] Data Mode: Window Mode: Normal I hadnt created a code. Does...

Ive tried that before and i couldnt get it to work?

Hi I have a combo box on a form. I also have a button which when pressed should go to the form of the 'JobReference' in the combo box. My form the combo box and button is on is called 'FRMBrowse' The combobox contains 'JobReference' from a table The button is called 'BTNBrowse' The form...

Is there no other solution as I need the user to open the query because I need the information to be able to be copied over into excel so they can plkay around with graphs etc on it. The users of my database have no knowledge of access!!

Hello - I have an Access 2007 application with mutiple forms, etc that my user will interact with. Upon clicking a particular button, I have put the VBA code docmd.openquery "query1" that works fine, however it opens the query on a tab behind all of my forms and I need it to open on top of the...

I have a 'form1' which when you click a button it opens up the modal form. I have set this so that the 'form1' doesnt close when the modal form pops up. On the modal form if you click the button it opens up the query. If I put the above code in the modal form it hides but the query opens...

Hi I have a modal form which has a button on it that when I press it opens a query. how do I get this modal form to hide behind the query when it opens? I have managed to do it for a report but I dont know where to add vba codes in for a query. Thanks for any help!

Thank you so much :)

Thanks do I put these in the code builder in the form or report? Sorry new to acces still learning!!

Hi I have a modal form with a button on it to run a report. When I press the button I want it to show the report and hide the modal form behind it. How do i do this??? Thanks for the help in advance!!

Hi, I have an unbound textbox that I want to apply conditional formatting to. I have a listbox and when certain rows are highlighted in the listbox I want my unbound textbox to turn grey scale. My listbox is sourced from a seperate table. Any help would be greatly appreciated!! Im on...

Thank you so much!!!!!

How do i change the vba so that it opens the report instad of printing the report?? Thanks!!

ok that works now but it is printing the reports instead of opening them!

This is the vba code: Private Sub LISTReport_BeforeUpdate(Cancel As Integer) DoCmd OpenReport cboLISTReport.Column(1) End Sub

I have created the table with 3 columns after the primary key. In the event on property sheet under 'onclick' I have entered the code DoCmd OpenReport cboLISTReport.Column(1) as my list box is called 'LISTReport' This is highlighting this command as red and it wont work? ANy...

Hi On access 2007 I have created a modal form which I want to contain a list of my reports. I want a button to run the report that is highlighted. I also want a button that will run the query of the report that is highlighted. How do I do this? I am new to access and help will be much...

Having looked into this further, I have set up a modal form with a list box which detail my report titles, these are unbound and i need to find a way to link these to the reports themselves. I also have unbound text boxes titled 'txtstartdate' and 'txtenddate' where required the start and...

Having looked into this further, I have set up a modal form with a list box which detail my report titles, these are unbound and i need to find a way to link these to the reports themselves. I also have unbound text boxes titled 'txtstartdate' and 'txtenddate' where required the start and...