As for the situation with your boss, unfortunately it is an old story. So many programmers I know are complete tits about MS. As developers we know it's limitations and security issues better than they do. However, it's also the most user friendly, easy to develop and cost effective solution out there for a lot of requirements.
When a client asks me if Access is a good product for their needs I always say it depends what you want...
MMcCarthy
Last Activity: Mar 27 '15, 03:00 AM
Joined: Aug 8 '06
Location: Dublin, Ireland
-
The UK job market is not bad for Access and Excel work. Better for Excel work if you have any skills in that area. Honestly though at your level there are few full time jobs. Project work is much more likely. Companies looking to develop bespoke Access and Excel applications but not looking to hire someone on a permanent basis.
Have a look at the jobs currently advertised on the online jobsites. Look at the temporary contract sector...Leave a comment:
-
I'm not seeing any attachments, you probably have to zip them up before attaching them.
I would guess that your issue is mainly to do with either missing libraries or out of date libraries. Until I see the macro code I won't be able to tell.Leave a comment:
-
You don't miss the boat very often so this one is allowed should it prove to be the case LOL!Leave a comment:
-
Your problem is just with your logic. You are putting the code in the load event of the form you want to protect. Instead put it in the event that opens the form.
That way the form never opens if the password is incorrect.
...Code:Private Sub OpenMyForm() Dim Password As String Password = InputBox("Enter Administrator Password") If Password = "mypasscode" ThenLeave a comment:
-
I just double checked it and COUNTIF is not case sensitive so it should find the text regardless of case.Leave a comment:
-
I'll have to think about that one, leave it with me.Leave a comment:
-
MMcCarthy started a topic How to use the SEARCH, SUBSTITUTE and REPLACE Worksheet Functions in Excelin ExcelHow to use the SEARCH, SUBSTITUTE and REPLACE Worksheet Functions in Excel
There are so many functions available in Excel Worksheets that users often stick with the most common ones until they start exploring trying to find a solution to a problem. Sometimes it doesn't even occur to them that there may be a function to deal with the issue. So I decided to draw on my experience and the experience of some of my colleagues to note some of the lessor known functions we have found to be very useful.
As the title...Last edited by MMcCarthy; May 20 '13, 05:15 PM. -
MMcCarthy started a topic How to use the COUNTIF, COUNTIFS and SUMPRODUCT Worksheet Functions in Excelin ExcelHow to use the COUNTIF, COUNTIFS and SUMPRODUCT Worksheet Functions in Excel
These three Worksheet functions preform similar tasks but there are key differences between them. The COUNTIFS function is only available in Excel 2007 and later.
COUNTIF()
The COUNTIF function is used to "Count" instances of a set criteria in a given range. So you are counting the number of times your given criteria is true in the cells of whatever range you set.
The syntax for the function is:
COUNTIF...Last edited by MMcCarthy; May 20 '13, 04:22 PM. -
The COUNTIFS function does not work this way. It allows you to select multiple criteria. So your formula would only give a results if all 3 were true. I would recommend instead using multiple COUNTIF functions as follows:
That should give you the result you want.Code:=COUNTIF(B3:H22,"*Quiz*")+COUNTIF(B3:H22,"*Test*")+COUNTIF(B3:H22,"*Assessment*")
Leave a comment:
-
I removed the last paragraph and changed the thread title to make it a better search result. I'll look at doing another thread with SEARCH, SUBSTITUTE and REPLACE.Leave a comment:
-
Consultant vs. Contractor: What’s the difference ?
I’m often asked if I describe myself as a Consultant or a Contractor. These days I call myself a Consultant but once upon a time I was a Contractor. So what’s the difference?
Consultant
A Consultant is someone engaged by a client to complete a specific project.
The project is normally for a set time and cost pre-agreed between the Client and the Consultant. Depending on the size and scope of the project this... -
How to use the CLEAN, FIND and ISERROR Worksheet Functions in Excel
There are so many functions available in Excel Worksheets that users often stick with the most common ones until they start exploring trying to find a solution to a problem. Sometimes it doesn't even occur to them that there may be a function to deal with the issue. So I decided to draw on my experience to note some of the lessor known functions I have found to be very useful.
As the title of this article suggests these are Excel Worksheet...Last edited by MMcCarthy; May 16 '13, 02:47 AM. -
As I understand your question you will have a list of numbers (e.g. 10,11,21 and 22) and you want to make sure than no two people have the same number in any column. So each column would be unique values. Am I correct?
If so can you guarantee that there will always be at least as many numbers as people or will you just stop assigning people when you run out of numbers. So if you only had 10 numbers you could only ever assign a maximum...Leave a comment:
-
No problem, glad to help :)Leave a comment:
-
Thanks Smiley, I will definitely find this one useful :) I'll be implementing it on my next project and will give you feedback when it's running with the client. Probably won't be for a while. I think it may become one of my "must have" tools.Leave a comment:
-
If I read your post correctly it sounds like you are doing the reverse of what would normally be done.
Normally the records sheet would be entered first with formulas for any calculated field.
Then your invoices could be set up as a template in Excel or Word using the records worksheet as your record source for a merge.Leave a comment:
-
OK the Hour function will give the hour difference between two dates, the Minute function will give the number of minutes and the Text function will allow you to format the date in hh:mm format. So assuming the start date/time is in cell A1 and the end date/time is in cell B1 then the formula will be as follows.
Code:=TEXT(HOUR(B1-A1) & ":" & MINUTE(B1-A1),"hh:mm")
Leave a comment:
-
Hi Austin
All experience is good experience. I have found some of my previous career paths very useful in surprising ways when developing.
However, what an employer may see as valuable can be different. It all depends on the employer and the field they are in. Strict IT Development firms are usually interested in hiring specific programmers to fill their skill base.
There are a lot more jobs in the...Leave a comment:
-
My path was, I started out years ago doing general office work. Took an interest in computers and did some programming courses. It took a while to break from one field to the other. I took on low paying short term jobs just for the experience. Built up my reputation doing agency contract work (I still do an odd job for agencies I built up relationships with). Eventually, I went out on my own as a consultant.
So essentially, my career...Leave a comment:
No activity results to display
Leave a comment: