Search results

unfortunatly that hasnt fixed it im still getting "false" in the messge body altho the compile error seems to have disapeared

Good Morning Im having problems automatically sending an email from access I have the following code to send the email, other than the body text the code I a direct cut and paste of a collegues code and his works but mine doesn’t Were both at a bit of a loss as to why? Public Sub...

Now then im exporting one of my tables to a specific folder as an excel doc, im wanting to to automatically format this excel workbook when i press the export button on my form the code i use to export is DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "Unlocked"...

Thats brilliant thanks very much! :) exactly what i needed could this thread be removed? or at least the attachements are i realised i left some potentially "private" info in the tables and i dont want to get shot Thanks for all your help again Matthew

Thanks for taking a look Dcrake but can you post it in a ZIP? the security systems at work wont let me open it atm Thanks

See attched...if it worked Thanks

Still no luck :( im not even sure if this is possible in access. im not getting any error messages anywhere its just the cboSearchObjective isnt populating with the values it should depending on the variable in cboSearchCriteria

Thanks for getting back to be DCrake but unfortuanatly ive still had no luck the cboSearchObjective box still isnt displaying any results. could it be somthing to do with where the event prodecure is? i was just assuming it would be in the on_click Cheers

Afternoon all I need a quick hand with a couple of combo boxes and would be much obliged if your could help me out I have am creating a search form where the search type is in 1 combo box (called cboSearch) that calls to a table tblSearchCriteria to get its drop down values – the values are...

Both methods work perfectly :) is there a way of showing the final result in a form that has the record source set to my table tho? Table is called Table1 and Form is Called Form1

i know this is probably really simple i just cant get my head round it i have 3 tick boxes on a form called "Form", Field1, 2, and 3 i need a calculated field or a field of some sort that counts per line the number of instances of my tick boxes that are true. Ie if 1 and 3 are ticked the...

Right ive narrowed down what i think is the problem. it doesnt recognise the bit in red below i keep getting an error message saying compile error: method or data member not found Private Sub Form_Close() Open CurrentProject.Path & "\ShowMe.Txt" For Output As #1 Print #1...

Hi Thanks for your help. Do I have to add the file name and path in the code? I have created the module simply called module1 and changed the form name part to “ForceBox3” which is the name of the start up form. I have also added the other code to the OnClose event of the form “ForceBox3”...

Hi Thanks for your help. Do I have to add the file name and path in the code? I have created the module simply called module1 and changed the form name part to “ForceBox3” which is the name of the start up form. I have also added the other code to the OnClose event of the form “ForceBox3”...

Hi guys Is it possible to have a form that appears at start up unless a parameter is set to true, in my case a tick box on the form. The form is a notice of changes that have been made the problem with this being that people only need to read it once and I cant remove it because about 800...

do i apply this to the form/search button or tick box. i would assume the search button but i just want to be sure lol. also will this allow me to search as before ?

Hi guys & gals Can some try and give me a hand with some VBA stuff? Im not necessarily new to access but I am new to the script side of it (hard to believe I know) because I’ve never really had the need to use it in my job. Basically I have a search form with the location of the 6 sites of...

Hello I have a problem with the search function that CORE helped me with in the Queries Macros and More thread. Basically I have ditched the filters for a standard search function. The user is presented with a form with combo boxes that contain the search criteria eg site, task priority...

IT WORKS! thank you so so much :) can i be cheeky and ask 1 tiny thing extra? is there a way of resetting the combos back to * with a command button or something similar. when i was using a form rather than a form pointing at a query, i used the showall macro, this showed all the records...

thanks for you help but when i select a combo box it brings up the popup box as if i had written [paramater] in the criteria of the query. so i have to type the criteria rather than using the combo box. also the * function i have put in the Or section of the query along with the...