Hi Every1.
I have an Excel worksheet that contains 4 columns.
I select column A and B, and add a conditional formatting to change the color of DUPLICATE cells to a color. So, some cells in column A and B turn to color.
Here is what I want to accomplish:
NO CHANGE TO COLUMN A.
Delete cells in column B,C,D that the B is NOT colored (there is no match in column A), and of course, move cells...
Alireza355
Last Activity: Jun 11 '16, 10:38 PM
Joined: Feb 28 '09
Location: Iran
-
Delete cells based on conditional formatting color
-
ok. Today, I spend a couple of hours on my database, and I am beginning to remember what I did 10 years ago.
The reason why I had Application.Run Command acCmdSelectReco rd set on the "on current" event of the subform was that I wanted the whole record to be highlighted at all times.
The reason why it is now giving me errors, I don't know :(
I took it away, and the form and subform are working fine,... -
Dear Neopa
thank you for your reply. There ARE records and they are shown in the subform. but I get that error. even when I click on another record on the subform, since the code is on its "on current" event, I get the error again and againLeave a comment:
-
ok. the debug is now working and it is taking me to the problem area.
like I said before, I created this database about 10 years ago, with a lot of help from people like you, and now after 10 years of not doing anything "code!!!!" I have forgotten lots of my knowledge.
so the error I am getting right now is "no current record" and debug takes me to:
...Code:Application.RunCommand acCmdSelectRecord
Leave a comment:
-
Thank you mbizup and neopa.
I will give it a try...Leave a comment:
-
error handling question
Dear all,
I have an old (2003) access database with tons and tons of codes for different events and everything imaginable...
I have not used this database for about 10 years now, and now that I went back to it, lots of errors keep popping up because of changes and updates, etc...
For my error handling, I have:
...Code:errorhandler: MsgBox "Error: (" & Err.Number & ") -
Yes, it works. thanx a lot....Leave a comment:
-
Dear jforbes,
thank you for your response. I will give it a try and let you know.Leave a comment:
-
Recordset.Recordcount problem
Dear all,
a few years ago, I made an access database with a lot of forms, queries, etc...
I stopped using the database for a few years, and now that I went back to it, I notice a problem:
In a form, I have a textbox that for it's control source it has:
=[forms]![frmMAINFORM]![frmSUBFORM].[form].[recordset].[recordcount]
but it returns #Name
It seems like it... -
Dear NeoPa,
I checked the references and here is what is checked:
Visual Basic for applications
Microsoft access 11.0 object library
OLE automation
Microsoft DAO 3.6 object library
Microsoft visual basic for applications extensibility 5.3
since I really don't know what these are, I can't say if there is anything wrong with these or not.
I have also tried...Leave a comment:
-
I will let you know as soon as possible, because I am out of town now. Thank you very much for your kind attention all the time.Leave a comment:
-
Still need help
Dear NeoPa,
Thank you very much for your reply.
I think I need a little more assistance, if possible, please.
I am still stuck!!!Leave a comment:
-
New behavior in Switchboard form
Hi everyone.
I have an access 2002/3 database that I have been using for 4 years with no problem but now, all of a sudden, I get this funny error in the Switchboard that says "error in loading DLL" and it seems to come from the code behind the switchboard form in the FillOptions procedure:
Set con = Application.Cur rentProject.Con nection
I think maybe a recent automatic update to Windows XP might... -
Thanx a lot
Yesssssssssssss ssssssssssssss
It worksssssssssss sssssssssssssss ss
Thank you so much...Leave a comment:
-
interesting...
Dear ADezii,
Thank you so much for your kind help.
I will give it a try, and let you know shortly.
Thanx a lot.Leave a comment:
-
How to know if a user has a form open
Dear all,
Is there any way to say if a user of the front-end of a given database has a specific form "open"?
Thanx a lot... -
Link/Break Link????
Programatically linking / breaking links to tables seems so interesting. Can you please provide more information? ThanxLeave a comment:
-
Two users using same table PROBLEM
Dear friends,
I have a big database, that I have splitted into two different versions (front office and back office).
One is used by sales department users, to input some data and see some reports, some edits and so on... , and the other one (main one) is used by the accounting department, to do all the rest of more important actions...
In one of my forms, I have used some VBA code, to rename a table... -
Thanx a lot
Thanx a lot.
It worked perfect...
Best Regards,
Alireza355Leave a comment:
-
Combobox dropdown
Dear all,
I have a combobox, which shows some records from a query in the combobox rowsource.
I want the combobox to dropdown whenever it receives focus from the previous field, so that the user becomes familiar with the information that has already been entered by previous users in the past...
I would appreciate your assistance.
Thank you so much.
No activity results to display
Leave a comment: