Search results

Hello everyone, After trawling through data and queries for days I have finally stumbled upon the reason figures weren't matching which is because when the Max function is given the values ("3", "L") it returns "L" in MS Access and yet in MS Excel the same Max function returns "3". Firstly -...

Hello all, I've got some school data in Excel for 5 subjects and we can create a bar chart of this data no problem. The problem is we need to also display (as a line or points) Lancashire data on top of the bars. I've added another data series but cannot get the points to tie up with the...

Hello all, I've written code using the examples given at http://msdn.microsoft.com/en-us/library/aa155434(office.10).aspx to import data into Access from Word via word forms. I've generated a template with data and when I tried dummy data this imported fine, but the templates have now been...

Hello all, We have had this ongoing problem that I'm sure must be fairly simple if we know how. Basically we have a lot of data in different groups that for example we need to display for specific years e.g. the last 5 years. The trouble is, as the data is calculated, there may not be data...

Hello, I'm trying to develop a staff/employee database and have run into a problem: I have 3 main tables tblEmployee (table of all employee basic details) tblPost (table of all posts in the department) tblEmployeeInPost (main table of employees and their assigned posts) The prob is I need a...

Hello all, I'm developing a staff database and have a number of tables e.g.: tlkDepartment, tlkGroup, tlkTeam and tlkLocation. I've got a form that correctly lets the user select from these and then store the ID in the tblPost table. However what I would like is if they select say...

Hello all, I'm developing an Employee/Staff database and have done a lot of work trying to get the structure right on paper. I'm coming to now implement the design but there's something I'm stuck with. Basically I have a SalaryScaleFrom and SalaryScaleTo field in the Post table, I want the...

Hello all, I'm developnig an Employee/Staff database and have done a lot of work trying to get the structure right on paper. I'm coming to now implement the desing but there's something I'm stuck with. Basically I have a SalaryScaleFrom and SalaryScaleTo field in the Post table, I want the...

Hello all, I'm an expereinced data analyst that's looking at developing a database to record all our staff/posts/post history/assets etc. We already have an old Access DB but it's such a mess - anyway I've been drawing up some table and relationship plans and would just like to ask (I'm sure)...

Hello there people, has anyone any tips on how to break into the software development industry? I've been into programming for years but only have experience in vba and bits of vb and my dream job is to be in software development and it has been for the last 15 yrs but I just can't seem to get...

Hello all, Could anyone tell me the fastest way to pull Access query data into Excel using vba. Note we need to be able to amend the queries in a loop to automate report generation (so the criteria changes on each loop). We currently use something along the lines of that below but some queries...

Hello all, basically we have had this problem a number of times before, we need to be able to write our own custom function to total queries as in the ones available in query designer (sum, min , max etc.). Basically we need to group a number of years together and for these years calculate...

Hello there, I was wondering if anyone could anyone point me in the right direction for doing the following: I have a table of groups of School numbers that belong to certain groups and I would like to create a form for users to select/deselect schools easily for each group. It is explained...

Has anyone experienced "Error! Not a valid link." after linking access/excel/word I admit that this problem is more than likely associated with Excel but it is quite advanced so hoped more people that might know the answer might look here. Basically I have a vba macro that runs in excel and...

Hi.. This has had me and the team stumped for a while. Basically I need to use the excel 'slope' function (and intercept etc.) on a group of values returned in a query. I have managed to create a function to sort of do this but I want to know if I can create a function in VBA and then use it...

I'm sick of the lame excuse for error messages that Access gives out.. I'm talking about 'Overflow', 'invalid use of Null' and such like. What about telling you what field/expression caused the error and on what record if applicable. It's so frustrating - Access obviously knows what caused the...

I want to create a number of functions that can be called from a number of different databases. At the moment we store the same functions in a module in each of the databases but when we want to change something we have to update them all which is not only time consuming but it is easy to miss...

Hello, I have a query that has a number of fields one of which is checking to see if one value is in a list. To do this I created the following function in vba.. Function tot(a As Variant) As Long If a = "1" Or a = "2" Or a = "2A" Or a = "2B" Or a = "2C" Or a = "3" Or a = "4" Or a = "4+" Or...