Recent content by cos

thanks again mate!! i tried that be4, but for some reason it didnt work.. many thanks again :)

nvm.. this seems to work: Private Sub FilterBtn_Click() Dim strFilter As String Dim strDateStart As String Dim strDateEnd As String strDateStart = "#" & Format(Forms![FRM_Visit]![DateFilter1], "yyyy-mm-dd") & "#" strDateEnd = "#" & Format(Forms![FRM_Visit]![DateFilter2], "yyyy-mm-dd") & "#"...

this is all i can attach it as =(

Hi fellers, it's me with my stupid data filter issue again.. right.. i have my table with dates and a continuous form to show that data. On the form i have two unbound text boxes in which i wish the user can select a date and click filter, and the form will be filtered where the date in the...

Table to excel code: http://www.access-programmers.co.uk/forums/showthread.php?p=1187804#post1187804

Re: export table to excel in runtime Thx Bob!! its working now! many thanks :)

Re: export table to excel in runtime i placed the "Export A Table Or Query To Excel" code in a new module, named it ShopsToExcel. changed the: strTQName - TBL_Shop and strSheetName - TBL_Shop2 created a button on my little form. made an OnClick event for my button, chosen macro, and set...

export table to excel in runtime hi guys, is there any way i can create a button on a form, to export a whole table to excel and save it? cuz this database will be used in runtime version, and there's no option to export data like there is in normal access.. i know that i could link an excel...

Event: On Current: Form.AllowAdditions = False worked best!! cheers guys!

Hi guys, is there any way of inserting bullet points into a message box? i've got my message in a macro, and if its not possible in macro, maybe there's an idiots guide on how to do it in code?

however.. quick question.. how can i filter a subform from this value now? :S

haha.. its working now!! thx a lot Trevor! and Pr2!

and for yours Trevor, i get this error: "The expression On Click you entered as the event property setting produced the following error: Invalid outside procedure."

i have no idea where to put that code.. as i tried and nothin works.. =/

how can i show a selected by the user record from a list box in an unbound text box? i made a listbox which has two columns and shows various info, and i need the selected record, what appears to be in column two to be shown in my text box.. any ideas?