Recent content by intrep11

I have hit a bit of a wall and could use some advice basically i need to grab the computer name of PCs on a network and put them into a table. I have code to access the AD and get me the names of the PCs but am not sure how to put them into a table. Public Function listcomputers(ndname As...

thanks Pat / rv Thanks my understanding is much improved the DB was written a long time ago and i now dont have time to rewrite it. access makes it much easier when you are learning to use query based relationships than table based ones and in most simple apps that is good enough that is...

? RV sorry i dont understand which part of my posting dosnt follow pats advice ? the shipname field in the 'tblShipName' table is a non duplicate index joined one to many(left) to a data field (ship) in the 'tbldatatable' table which gives me the updateable query as advised and allows me to...

thanks pat Thanks Pat i have the tblShipName.ShipName indexed but it allowed duplicates and the 1 to many the wrong way round because i had been trying all combinations wondering why it didnt work it should be this the index no duplicates and the query as SELECT tbldatatable.*...

ok am lost now whats wrong here Pat thanks for that i can confirm that both tables have a primary key (which is not field they are joined on) and that you can write to the data in both tables when they are separate but thgat query is not updateable ???? any suggestions on where to look ? thanks

I needs some advice on how to proceed. Our company is devolving some operations to a sub office for 3 out of 11 business units. we have a central DB that we use to record monthly events the problem is that the parent group has to be able to update records for all units but the sub office is...

Basically i would like advise on if this is the best method or not I am setting up a system that needs to import personnel data from another external DB. (the data is then used to build an evaluation report). over time people will progress and the imported data will need updating. in...

simular thing I have suffered a simular issue in the past and solved it the same way as you however it came back it effected what appeared to be random forms in the DB to solve it for good create a blank DB and import all your DB too it the delete the old one. I would also check you PC for a...

please can you advise what is going on when i opened my DB it reported it needed a repair when completed any time i try to run any VB code i get an error microsoft visual basic module not found it then opens the debug window It feels like some kind of virus but i cant find anything any...

export to snapshot Export the report to a snapshot format and email that there is some code int he forums that will do that for you that is where i got it from to do mine

the source is not my data base and i cant alter it its part of a personnel system and that is the way they have coded it (they use their own team of programmes to use a bespoke VB front end not using access at all) so unfortunatelly i have to live with no extensions

names unfortunatelly not the name of the picture on the hard disk is a1234567 so adding .jpg to the name string will just make the form look for a1234567.jpg which it wont find because it dosnt exist so it goes automatically to my error there is no picture here code.

I have a DB that stores linked images in a directory without their file identifier ie it renames the file to an id number and removes the .jpg bit of the name so the files name becomes a123456. Unfortunatelly if i try and use the images from their source in another DB i have (used to produce ID...

I am trying to get round a problem and could use advice. we have a requirement to nuber emails consecutivly to about 15 locations which are sent out once per day. the whole office adds content during the day and then the number is added and they get sent. at the moment we use 15 word...

thanks a million thank a million that did the trick seems a bit odd as i thought they were the same but i can live with ti now i know cheers for your help ND