Search results

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...

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...

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...

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...

please can someone look at this and tell me why i am not getting the 001 that i want when there is not entry matching the query code in the onload section of page 'generate the message no fom a query +1 If DMax("[IDLocal]", "[tblSentEmail]"...

any ideas how i can get the month out of a date here comes the hard part i need it in text for a query. i have a reporting cycle based on months and as part of it there is a record of weekly correction numbers. that are sequential i need to look up the previous month numbers and present them...

any suggestions for an approach on this would be really useful. i have written and distributed a DB with front end MDE and backend MDB to met a requiremet which has been in use for some time gathering data / producing reports. The requirement has now changed and we need to add another field to...

I have a review database that when a persone has 3 entries in this has to be reported it is set up to do this manually for operational reasons. when entering new data on a person (in on form) you see all existing entries (in a second form in contineous form mode) and there is a yes/no box to...

Why is this not working can anyone say i have a query that i am specifying a date range using a form with the following criteria in the query Between forms!formname!startdate And forms!formname!enddate my problem is if i have record on the same date as the end date they dont show up ie i...

could be useful date calculations example the attached file has one form in it htat might be useful i came accross the data on the Ms Website it has a range of date calculations in it to make life easier for the simple fokes like me

I have a report that shows the number of accidents within 2 dates. the accidents are counted in groups ie a = slips b = falls etc up to q the people who read the report like to see graphs as well as statistics. is there a way i can show the groups that have 0 on the graph (the date range...

HI there am near the end of my project (appraisal DB) now and want to add some nice touches Each person has a report with up to 12 items assessed in grades A to E i want to calculate an average for the report i dont need this stored as it can be calculated each time you view the data so am...

I know MS did it in the northwind thing but could someone help me with this as i dont get ohw they did it i am just a simple sailer you see. i want to have a form open the the first time a DB is run so the users can enter location info (ship name actuallly) and then open every other time with...

I am using a macro to export data in txt for (transfertext) the users select which records to export by a tick box on the record which is generated by a query at the time of export the records are closed i have tired but cant seem to suceed how can i change the tick box to false when the...

help please i can t figure this one out and need to. We have a quartly report that has comments about individuals from ships which we report in 2 sections one by the personnel department on performance and the second by the training department on training needs. It is currently displayed with 5...