Search results

Why do you want to turn off the autosave? I know that it can be irritating as it slows Excel down a bit but not half as irritating as when a sheet you have been working on for ages is lost when your computer crashes! Would it not be better to convert the workbook to a regular database. That...

Shades, Sorry - I'm not always good at describing the problem. Basically, I have a sheet with the names of all our staff and their sections. There are 5 columns (FirstName;LastName;Directorate;Unit;Section) Leaving the names aside for now, the last three columns contain lists of the relevant...

I have a long list of all the staff and their respective directorates, units and sections. I know the number of directorates and units but i need to know the number of sections. Is there any way to count the number of different names in each cell of a list? Thanks in advance

Adeptus Thanks for the info. I eventually found out that the Livebox is 802.11g so I guess I'll go for one of the cards that support that Are there any good cards/who should I avoid? Cheers & TIA David:)

Anyone help? Does it matter which wireless network adapter I get if I want to set up a wireless network at home? I've got the Wanadoo Livebox after upgrading my existing Wanadoo service. The Livebox is wireless capable and I want to make use of the functionality. Also, which is the best...

Can anyone help? 5 wks ago, my laptop suffered meltdown. I had a trojan that made a real mess of the system with one result being that both explorer.exe and IE6 fail to run. All that happens is that both the icons and toolbar disappear. After a few seconds they come back but no explorer...

I have cobbled together some code to open a Word template that is a merge doc associated with a query. The code has a syntax error and I'm not sure what' wrong: Private Sub Command0_Click() Set objword = CreateObject("Word.application") With objword .Visible = True...

I originally posted this in the reports section following an earlier post. This section may be better: Thanks guys, I'm getting really frustrated - I want to produce a report of files associated with an individual. The name should be picked from a list and a sub-form would list all the files...

Thanks guys, I'm getting really frustrated - I want to produce a report of files associated with an individual. The name should be picked from a list and a sub-form would list all the files. A report would then be produced based on the results. The tables I have got so far are: tblGroup...

Before I head down a blind alley, can I use cascading combos directly in a report to limit the report's contents or do I need to use a form first? I've been looking through all the threads on cascading combos and have got a little lost! Cheers David

Pat, Thanks for the reply - having considered what you said, I think I'll do something a bit more simple. Cheers David

Can anyone help? Is it possible to have an autonumber that is generated depending on the entry in a particular field? I'm creating a database to track various enquiries and I would like each enquiry to have a unique number that is preceded by a codenumber that identifies its origin. For...

:confused: I am looking into transferring my videos of family holidays, birthdays etc for long term storage and also for converting onto DVD. Problem is, I don't know what's the best way to do it. I've looked at TV input devices but don't which is best and as I have a laptop, it should...

over the hill

Thanks to both of you and sorry for not getting back to you sooner. I got temporarily yanked off the project and put onto something else, so my focus has been elsewhere. I'm sorry for the confusion about devices and equipment - they are one and the same. I have a bad habit of switching terms...

I am currently designing a database to solve our organisation's training requirements. The db needs to be able to identify an individual member of staff at any particular site and list all the medical devices that they have training on and to what level of competency. So far I have five...

I am looking at getting a book or two about VBA programming so I can really let rip in my databases. One thing - is Access VBA the same as Excel VBA? :confused:

Thanks for the suggestion. I am keen to make it somewhat fancy, if only so that the end-users (line managers and such) don't have to do much. Can you recommend any good books on VBA programming. I have a couple on VB 6.0 which I am just starting to work through but I understand that VBA is...

I am currently working on a project for our training dept to link staff members to particular peices of equipment. I have created two tables - tblEquipment and tblStaff_Table. I have also created a form based on a query that gets the staff details based on the surname. Within the staff form I...

I hope someone can help me. Iam currently constructing a database to track information requests made to our organisation. I have done a number of searches on working days and have got two or three solutions that will calculate the working days btw two dates. What I need to do is, given a...