Recent content by rexrivas

The Edit / Go To / Special / Objects work perfectly, it evens eliminates the links Thanks a gazillion

i want delete all shapes in column A along with their hyperlinks. column A currently contains Data, image(shape) and hyperlink. Alli need is the data

it's all in column A. THe shapes all seem to be picture, but each one has a unique name: picture 1 , picture 2 and so on.

How can i delete a columns worth of hyperlinks and graphics.THe problem is that each shape has its own shape name ("picture x"). I wrote a simple macro Sub A_Hyper() ' ' A_Hyper Macro ' ActiveSheet.Shapes("Picture 4").Select Selection.ShapeRange.Item(1).Hyperlink.Delete...

Is it possible to create a switchboard that will launch several options to open a database. I have 3 databases that i want to link to one switchboard. Based on the choice made a particular database would open

Revised... I have a form with the following fields: Name, location, date.All are required fields. Location properties include row source type = Table/Query and limited to list . I created another subform for the user to create a new location via a macro tha twill close the form and launch the...

I have a form with the following fields: Name, location, date.All are required fields. Location properties include row source type = Table/Query and limited to list . I created another subform for the user to create a new location via add new record. but i ocasionally get "the database can not...

I would send them a email advising that they would be "locked out", this would prevent an astrays in from logging in by mistake.

Wouldn't be simpler for me to change the file name, from access database.mdb to access database-rex.mdb. Everybody shortcut is pointed to access database.mdb , so that way whe nthey try to open the database the file is not found. This would allow me to play in it exclusively until i am done...

As admin of a shared database i would like to make changes without getting the "You do not have exclusive access to the database at this time. If you proceed to make changes, you may not be able to save them later" message. So far if i want to make changes i need to get arrive at work at about...

sorry kjv, i am drawing a blank. i have a bad case of the mondays. How do i set up a variable?

made the recommended changes, table is not updated

No, under control source i have : =DLookUp("[Vendor Name]","[Vendor list]","[Vendor Nbr]='" & [Vendor Info] & "'") i guesss i shoiuld have this somewhere else

using the record selector at the bottom of the form. By clicking on next record button

PHV, I've used your code. it appeaers on the form, but when saved the Vednor Name field on the table is blank. i would like for the Vendor Name to appear on the table once the record has been saved. Any thoughts that can be helpful are greatly appreciated