Search results

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?

Microsoft Access Multi-Field Search Form: http://www.youtube.com/watch?v=CTiA_4Me0cI

ty mate.. all good now

hay guys, how do i make the disabled fields have darker font so that they are more visible? cuz if i try to even select a darker color in the home tab, it doesn't seem to do much.. are there some sort of options where this can be edited? or is there an alternative method of doing this? :D

hi fellers, how do i set a double filter? i have two combo boxes with a selection of record details, so that when u select an option in the first combo box, the form filters; when u select an option in the second combo box, i want it to filter with two criteria's now.. however if one of them...

but i don't want to delete any of the records.. all i need is that visually, in the combo box, the user can select wanted manager without having to go through the endless duplicates. and i have considered having a separate table for managers, but that will confuse the hell out of the system, and...