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?

Yes done a mail merge in Word - this side of things is OK. For each customer who I send a letter to I want to create a note to state that I've done this - this note will be the first of many notes if the customer takes the product being offered therefore I have put the notes in a separate table...

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

This is a new marketing initiative so no current recording method. I will be sending to all new customers (another product) who haven't already shown interest in my product. Surely getting access to create new records en-mass in another linked table can't be that difficult - any ideas?

Subforms is a good idea BUT the other day I sent over 60 intro letters - I don;t want to have to go through each record to input the details of the letter sent! I want to be able to run a query (or something automated) which inputs the note for this action - for most this will be the first note...

the intro letter note may be the first of many depending on the followup action needed. so yes it will need to be a text field.

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

Thanks but I will be entering a number of entries with the same first two fields and only want to have to enter them once - looking at your suggestion I would need to enter these values for every entry - is there a way of doing this ie a box appearing which will set the default values????

Hi, New to Access so there may be a better way to do this but how I would do it is to - in the action section of the macro choose openReport and in the bottom of the screen Action Arguments chose View| Print. Repeat this for as many reports as you wish to open - each on a new action line. And...

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

I know it's probably very simple but I'm new to SQL and have tried looking at the other posts and I'm still lost. I've tried puting [forms]![Order Detail Subform]![CustomerID] into the SQL query but can't get it to work - where am I going wrong??

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

Thanks for looking! The person whom I'm doing the database for has no set way of discounting the prices so although it would be easier to do it the way you suggest it wouldn't fit in with how the company work! Each product has a name, packaging and discription, however, this is too much...

It's not from NorthWind - it's either from Office website or Access installed templates - I can't quite remember! But I've done so many changes to it anyway! I thought it would be easier that way - guess I was wrong!! :( All help appreciated! Thanks, Mary