Search results

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...

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...

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?

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?

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...

Im sure that this is an over asked question, but, how may i remove duplicates from my query? I have a visits table, with managers doing these visits; and i have a field called "Manager". The problem now is that when i put this in a form, and create a search combo box, the combo shows me the same...

every time i want to close the form or the application for rhat matter, access bugs me by asking whether i wish to save the current form i am on.. and it does this non-stop!! any ideas how i can fix this? cuz the database is fearly complex now and i don't want to re-create it all again =/...

hi guys, how do i make my forms Detail - read only, and leave the header as normal? you see, i have a combo box which filters the form in the header section, but if i open the whole form in read only view, the combo doesn't work what results no filter for me :mad: or alternatively, how do i...

hi guys, basicly, i got an Add Contact button, which runs the macro attached to this post, what opens a blank form; at which stage i wish for the form to enter a value in one of the fields from another form: On Load event: Private Sub Form_Load() Me.ShopInfoID =...

so.. i have a continuous form within the subform of a form (hope it makes sense cuz its gona get worse). I have a button for every record in the continuous form, so that i can edit that specific record in a new form. the button has the following macro, attached to this post... the form...

so, i went through my wizzard on creating a form, where i use two tables, and i had chosen the option to have "linked forms" rather than "form with subform(s)". When i click on the button to open the child form, i want the parent form to close... any ideas at all? cuz i tried almost...

Has anyone got any ideas on how you can carry previous information onto an other form? I was told that OpenArgs may help, but i have no idea on how to use it.. for instance, i have information which i fill in one for, then when i click on the Next button, another form opens with the previous...

How can i make a form open, with the default correct foreign key from a previous form, so that i can enter a new record? i tried the "Open form" macro, and set "where condition" to equal the foreign key ( [ShopID]=[Forms]![FRM_Shop]![ShopID] ) and that didn't seem to work.. any ideas fellers?

Hi fellas, how do i combine two queries in to one? As you may have noticed, i seem to run in to problems frequently, due to trying to accomplish too much at once. As per usual.. i have my contracts table (with 707 records) and my sub-contracts table (with 317 records) with ContractID as...

Right.. I have a table with all of my contracts, with main items being StartDate, EndDate and Price. All of those values are used in a query to show how much the client must pay (due to inflation, the prices vary every month, and the formula is fairly complex, one being: March2012...

i have two dates: StartDate EndDate I also have a contract made with a cient so that he pays me one sum on the first month, and that sum multipies every month (due to the inflation, which figures are stored in another table), and i will need a cost at the current month, even if its between the...

hi guys, i need to be able to sort the whole set of data from a query, by selcting a value from a combo box. i have about 900 records with 5 different status options. i found this guy on youtube: http://www.youtube.com/watch?v=khndDXtFC7I&feature=relmfu but he has an entry field, and i need...

well the issue i have, is that when i select one value from one combo box, i want only a certain set of results appear in the second combo box related to the answer in the first, which i can select. :banghead: Any ideas how i might be able to resovle this problem? [and both of the values are...

How come the homepage of the website looks so fresh and highly moddern relted to the woring eviroment: http://www.access-programmers.co.uk/ where as the forums have a more classic appeal? is it maybe possible to invsigate in a more moddern look?