Search results

I have the Cisco IT Essentials PC Hardware & Software certificate - is this the same as CompTia A+? I know A+ is important in Desktop Support jobs - should i do the A+ or is the Cisco module interchangeable?

-------------------------------------------------------------------------------- Hi folks, New marketing initiative in work and I'm trying to record it in access. I have two tables - one with customer details and one with notes linked by Customer ID. On a monthly basis I will be entering new...

Hi folks, I have two tables - one with customer details and one with notes linked by Customer ID. On a monthly basis I will be entering new customers and sending them a letter of introduction - I would like to record in the notes table that I have done this - if I was using one table I could...

Hi all, I have some really important and irreplaceable work on my PC HDD but the tower fell over on its side yesterday and now it won't start. Originally I couldn't get it to start Windows (Win 2K installed) but I done chkdsk and fixmbr then recieved a message re: missing or corrupt ntfs.sys...

Hi All, I've been using the following function to create summaries in reports - where "criteria" is changed to match the item being counted. =Abs(Sum([Status]="criteria")) This has been working fine until I tried to use it to count empty cells - I've tried changing the criteria to NULL...

Hi All, I have a db which contains a form and a subform for information to be entered if required - I can edit information in the sub form when the data has been previously entered but am unable to enter any information when it is a new "sub record"! The error message states something about the...

Hi folks, I'm currently an IT trainer in Microsoft Office programs and Web Design and have a fair amount of software knowledge but would like in the future to be a DBA or Software Developer - any suggestions on what experience, qualifications, programming languages would be best for me do do...

Hi All, I am hoping to create form that will prompt the user to enter default values for certain fields ie Week No and WB Date before allowing any data to be input into the form. Any help on how to do this would be appreciated. Thanks, Mary

Hi folks, Working in a report - trying to get it to count entries in a field depending on input - like the countif function in excel ie count entries if they read "Attended" and so on - how do I do this??? Many Thanks, Mary

Hi All, Using the Month formula to pull out the month from a date - the result is displaying as a number (1 - 12) but I would like this to be displayed as text (Jan - Dec) - can this be done using this formula or is there an alternative formula? Thanks, Mary

Hi, I'm experimenting with the database attached (Access 2003) and on the Order Deatails subform I would like to be able to view only the products for the related CustomerID! Any pointers on how to do this - very much appreciated :D ! Thanks, Mary (PS Some non-essential db components have...

Hi Folks, I'm working on an order management database for a small company and have an order details form which I hoped to list each product of the order. As each customer has a different price per product I have a combo (based on a query) to choose the product and display the unit price...

I am making a database for a small company who charge different amounts for their products depending on the customer - I'd like the products to be choosen from a list and that particular customers unit price to automatically appear! Currently I have a Customers table, a products table, a price...

Hi Folks, Trying to set an input mask to Capitalize the first letter of a surname but also to do this for ie MacDonald or O'Brian? How can i do this?? Thanks, Mary

Hi Everyone, I am creating a customer order database and have a table for customers with a billing address and one for orders with a delivery address. Most orders go to the billing address, however, the odd order may go else where so I would like to set the default delivery address for each...

Hi All, I've put an input mask into a table and would like to personalise the error message to give the user more information about how they should be entering the data correctly. I don't know where to start with this - can someone point me in the right direction?? Many Thanks, Mary

Hi All, I've put an input mask into a table and would like to personalise the error message to give the user more information about how they should be entering the data correctly. I don't know where to start with this - can someone point me in the right direction?? Many Thanks, Mary

Hi Folks, I'm looking to create an autonumber field which will work normally (ie increase 1 number at a time) but at the beginning of a new year I'd like it to automatically return to the number 1 again and start increasing 1 at a time again. Any help on this would be appreciated! Many...

Hi folks, I'm sure this is pretty simple to do but I'm stuck - please help if you can! I have a table with a date field and once the date is entered I would like it to automatically generate a reference number in the Ref No field which is the date as a number in reverse order ie 16th August...