Search results

After looking at the data some system have as much as 200 servers attached is there any way this could be done in VB. (although my VB skills need improving)

Docman, Thanks for the quick answer. This solution appears to looklike it could work, although some of the system have as much as a 30 related hardware attached wich will mean at least 30 queries in the union query.

Hi, I am importing some data from a excel spread sheet to my access database. However the format in the spreadsheet is causing me some issue. This is shown below. The format the spread sheet is in First column System Name (which is the name of the system) i.e Server1,This only ever has one...

Hi, I have got access to generate a report in excel. However the excel report generated needs some minor reformatting. Is it possible to send a command from Access to the newly created .xls document to reformat the document? I have the commands needed to reformat the excel document I am just...

Great thanks guys, I managed to get it to work with your help... Finally lets just hope my boss is happy with what he wanted...

HI __, Will this allow me to open files within this directory. What I am attempting to do is click on a button in my DB this will open the windows explorer box and allow the user to open documents in that directory.

Hi, I am trying to create a hyperlink to a directory and so that users can select the file they want to open. I saw this link below Hyperlink database which seemed exactly what I wanted. However when ever I try the sample database I get the error "There is No object in this control". I have...

Thanks NAVGUY

Hi, I have an access database with user name and passwords. I am planning to move it from one computer to another. I know it is not as simple as copy and paste. Does anyone have any recomendations on how to move the access database keeping the user names and passwords. I am running access...

I am trying to keep track of every time a field changes. The field will be “Release No”. I will need to keep a record of each time this field is updated for a particular server and the reason and date it was updated. I have searched under “Audit” and could find nothing that helped me although I...

Thanks all this now seems to work, :D (well more or less)

This is nearly what I was looking for, except I was hoping to be able to update a table, rather then just give me a list of options (The table is updated from the list of options). Sorry I was not very specific in my initial question. This has given me some useful pointers. - Thanks for the help.

Is it possible to create a dependent lookup list? I.e with two fields the options available in the list for the second field dependant on the value entered in the first field. An example would be “Manufacture” and “Model” of cars. If in the first field “Volkswagen” is picked the options for the...

Thanks Doc, I have not used autonumber for the server name, I am looking in to your advise and seeing if I can get it to work. I will not be using autonumber, I guess I want Access to automatically number the peripherals as I add them. However I would like to be able to delete and reuse the...

I have created a database to record information about a number of servers. I have created a separate table to record the server information and a separate table to record the peripheral information. I wish to auto number the peripherals 1 to X grouped the server name on the peripheral table...