Search results

Thank you very much. I knew this forum is full of helpful knowledge people

Thanks. do you know how to point to only a range of cells to be changed and not all cells.

I am using Excel 2003. I can't seem to understand your code. I have attached a sample file of what i actually whant to do. Any Help Please.

I am trying to conditional format( Colours) a range of cells( C8: AG8) to colour of another cell ( AH1) based on value in the range = value of (AH1). Tried googling around and search the forum Can't seem to find something close. Need urgent help on these. Very new to this but required. Found...

thank you.

I am trying to create a form which is continuous form . Inside the continuous from is a button where on click open a from based on what the record is selected. I saw one example before but i can't seem to locate it. Any help with one sample file for me to learn from. Please.

Removing the brackets helped. I thought i was just grouping them by putting the brackets

I need Help please. I am trying to do a chooser form similiar to one user had posted. PICOffen- Text PICNos-Number ChapOff-Text I have input the following code in the queries but i get syntax error. The Whole line is as below. DCount("[PICOffen]","tblPICItems","[PICNos] = " &...

Thankss alot. It worked. I think it is referencing to numbers and strings.

it does not work. Same error. Type mismatch

Any Help Please. I have a table with many fields of which Sno is a number name is string Sno is one and the name is many I have instances where the name can be same only the sno can be different. I have a form with list boxes 1st list box display- Sno user select from list and the...

I have a Word Template which, the format i am unable to do in Access Report. As such I want to get the data i want from access and then open Word Template and input the data in the word template. Anyone can help me on how to go about doing this .

thanks man.. If you could help how to set the list box to point to the record i just enter in the dialog box or to the last record

I have this problem and not sure how to go around it. I have a main form to enter data. The user can click on a button to open up another form which open in dialog mode. This is what the problem is. AFter enter data in dialog form , i want the list box in main form to be updated but when i...

I managed to solve it. Here's the link refernce. COuldn't locate in earlier search http://www.access-programmers.co.uk/forums/showthread.php?t=112197

HI.. Hope theres help. I have looked through the referencing link but i can's seem to get it to work. I have two tabs and inside the tabs are subforms. i want to set focus or change value of a field when a button is clicked. i enter this code but i always get error Me!tab1...

Thanks alot. Managed to do it.

Hi.. I am a newbie here. I tried searching but can seem to locate any solutions. I am trying to do this not sure if possible I have three tables but not linked to each other Lets say A B C I want to create a form with multiple tabs representing data entry for the 3 tables seperately. \Tab...