Search results

thanks a lot twoplustwo, that's just what I needed.

These days I reckon it's more about learning the framework (ie .net) than the language. If you learn C# then you'd find it pretty easy to pick up VB.net and vice versa. However, personally I'd go for C# as it seems to be the one Microsoft are concentrating on - for example they have launched an...

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

Thanks a lot Ken. I've just had a meeting and it looks like it might be a lot more complex than I initially thought. We need to keep track of honorariums, secondments, employee history (for previous grades/scale points), post history (who was assigned previously to posts) blah blah! Are there...

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

well said helicopter

haha yeah that's what I thought unmarkedhelicopter, however I'm pretty sure I know what you meant DCrake and I've read the article. It is interesting but unfortunately doesn't go into the benefits of using ADO over Querytable or using csv file as I was after which is the fastest method or even...

Probably a better solution though is to use the VB control box (through toolbars / Visual Basic) and use the code below: Private Sub Processor_Click() On Error GoTo Processor_Err Dim rn As String Application.ScreenUpdating = False ' Store currently selected cell rn =...

You mean like the attached? Just add that VB code but for other check boxes if so. Sub Processor_Unhide() Rows("15").Select If Selection.EntireRow.Hidden Then Selection.EntireRow.Hidden = False Else Selection.EntireRow.Hidden = True End If End Sub Is this...

hey thanks rsmonkey that's a great help. As to what I want to get into, not 100% sure really I'm just really keen to start using new technologies instead of messing around with Access, Excel and VBA still - feel like I'm getting left behind. My dream from a kid was to develop computer games but...

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

I've solevd this now by pulling in 3 sperate versions of the same query, each looking at a different date and all linked on school number. However I am still interested in knowing if you can produce your own total functions as we have had this before when wanting to create statistical functions...

An example of the actual raw data is attached, basically we want to produce 1 row for these 5 rows where the blue highlighted columns are totalled by showing trends, e.g. Up trend or Down etc. (some fields we will want to create average as well but that is straghtforward obviously). Many thanks...

Thanks for your reply. Not currently, there is 1 column for the year. There are say 3 rows for each school (with 3 different years in). We want to be able to turn this into 1 row per school with a trend of the 3 years data for each num/field. At the moment the data has 1 column called year...

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