Search results

hi ben, you could create a listbox and set its rowsource to a query which counts the records from your table where the "outcome" = "completed" or you could use DCOUNT. Is this what you want?

hi DocMan, firstly il apologize ... im not sure if i should have called it SideBar or Explorer Bar! :o Well Iv been searching on the web, and I found something on this particular page. http://www.aadconsulting.com/sidebarswb.html This is exactly what im looking for.. id like to have such a...

hi, how bout placing the label next to the button? Are you using the command button control that is available in Access itself or is it some special colored or stylised button? If you are using the command button control (the one in access itself) and have an associated label along with it...

Hello, I wonder if i'm posting inthe right forum, but this is driving me mad! I'm in the process of building a database whereby i can check whether there is any duplication of items. I have a form that lists the tables in the database and the the fields corresponding to the selected table...

Hello, :( I'm having a slightly wierd problem. I have a form that is based on a parameter query. The month field of the query has a parameter which is: Like IIF(IsNull(Me.combomonth.value),"*",Me.combomonth.value) combomonth refers to a combo box containing all the months. The query is...

hi shadow, I'l try that out and let you know. thanks again!!!

Hello Shadow, I tried putting combo boxes and stuff but the trouble is that the combo box is on the main form. even if i try to apply some sort of a filter in the after update event it doesnt apply to the three subforms! Is there any particular way to refer to a subform. I was checking up...

hi shadow, thanks for you reply! i'l definitely try that out!

Hello, I'm sure this has a simple solution, but iv searched this forum and every solution that i get is filled with code that goes over my head! Well here goes... I have a main form called expense... which contains a tab control. the tabcontrol in turn has three pages containing a subform...

Hello, Am having a bit of a problem here. :( i have a form which contains three subforms. the subforms are based on queries which get their parameter value from an option group. all this was working fine until i had the bright idea of displaying a msgbox when no records are found in the...

hello, I am having some trouble with a particular query. I basically have a table that contains all the expenses accrued over the year. I have a form which displays these expenses. I need to have options in this form whereby a user is given option buttons, where he can click on a button to view...

Hello, Does anyone know how to color alternate rows in two different colors in a continuous form? :(

hi, this is cool. although is it not possible to do this without creating another table? thanks for the help anyways... it solves my problem! thanks a bunch! Hassled no more!

hello, what you could do is initially set the autonumber field's visible property to No. then you can have an after Update event for the first text box that you will type in. (am assuming your users will have to type in a given field first vefore going to another field) In the afterupdate event...

hi, I have a form which is based on a query that displays the expenses for a given month(the parameter value). In my expense table i had set up the month field as a lookup column which basically consisted of two columns, one was the month and the other the numerical value of that month. for...

cool!!! :)

hi, I would like to use icons and interactive buttons for my forms to give them a more professional look. does anyone know where i can get such icons? i'm quite an illiterate fool when it comes to making the icons using icon editors. i tried searching on the web but it always throws up stuff...

Hello, If you use the switchboard manager to create a second switchboard page then you wont be able to view that second switchboard. if you want to open it then you should use the switchboard manager to add a new button, which on clicking would take you to the second switchboard. to do this go...

IF u cud it wud be real cool ........... been breaking ma head over this! :(

okie il hazard a try... can ya help me out with the code?