Search results for query: *

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

Can i use the dlookup() feature on a form? I would base the dlookup on the result of field on the form. This form will of course feed a table. The table "Vendor List" includes both fields "Vendor Name" and "Vendor Nbr". THe form name is "Vendor-REp Info". The form has the following as Row...

cghoga, it works perfectly thanks very mucho

I have a form that contains a combo box. This combo box displays 2 fields : 1) Vendor name 2) Vendor Number. User make the selection by name and the form stores value for vendor number in the database. I actually need both fields to store in the database. Can this be done within a combo box...

i have a switchboard, with several forms and no buttons for reports. i would like to have buttons for reports for certain users only. Can i have buttons appears based on specific users?

I have a form that includes a field that has trhe following propoerties SELECT [Vendor].[Vendor Name], [Vendor].[Vendor Nbr] FROM Vendor ORDER BY [Vendor].[Vendor Name]; How can i the the vendor nbr to populate a field called vendor number based on the selection of vendor name