Search results

This is where it gets silly & I will answer your question after I explain a little more. I was called ICT Administrator & one of my tasks was to look after the corporate database (non Access) & whatever that system could not do I did on Access. Years went by & powers at be decided to change...

My workplace is currently going through a restructure & it's been decided that most of our job titles are to be changed because of the fear of being seconded by "others" if it's found that the "others" claim to do what we do. Wanting a better job title anyway I was keen to finally get one that...

I'm shocked. Very sad news indeed :-(

I'm thinking of a Data Analyst.....What do you all think? We are supposed to be moving away from Access but 4 years down the line I am still waiting for them to stop using my database:confused: In the meantime they should give me a suitable title for what I am currently involved in. When they...

Looking at a similar thread from a few years ago I found alot of users had the following titles 1. Administrative Assistant 2. Consultant and Software Developer 3. Data Control Engineer 4. Data Reporting Specialist 5. Finance Technician 6. IT Support Officer 7. IT Systems Supervisor/Quality...

Hi All, What type of job titles do people generally hold that work with Access databases? I used to be down as an ICT admintrator but that will be changing shortly & I'm hoping to get something more suitable to what I do. I'm going to be classed as Senior Administration Officer but that...

Wishing you both all the best during these hard times.

Thank you.

Hi everyone, Need some advice please I have a database (v2003) with a front & back end, each user has a copy of the front end & the back end is situated on a local server. There are about 30 users each having their own user name & password, but there usually never more than 14 users logged in...

Thanks, I've seen something similar to this method but it turns out that what I need is to first display the folders within a folder, not the documents within those folders, if you know what I mean. For example: I have a folder on the network that has over 1000 folders within that i need to...

Not sure if this can be done or not but does anyone know how to display the contents of a folder using Access. I was thinking possibly viewing it using a list box like you do when it's based on a query then when a file within the folder is selected it then opens up the file ready for updating...

I found this solution that you add to a macro in excel. Public Sub Convert_To_Hyperlinks() Dim Cell As Range For Each Cell In Intersect(Selection, ActiveSheet.UsedRange) If Cell <> "" Then ActiveSheet.Hyperlinks.Add Cell, Cell.Value End If Next End Sub

painful coughing fits

Anyone know how to keep the hyperlinks when exporting to excel? My db table has a field called FilePath & I've set the data type to Hyperlink which is great when viewing the links via a query but for some reason when I export the data to exel the hyperlinks do not move across :confused: All I'm...

Thank You, I understand now :)

If X <= y Or x >= z Then That's the method I can only seem to get to workIf Me.txtStartDate <= Date - 7 Or Me.txtStartDate >= Date + 7 Then MsgBox "This date may be incorrect please check your records & try again" Me.txtStartDate = "" Me.txtStartedHidden = "" End If

Hi DCrake, Where do you put your code so I can try it out?

Mmm, I found that solution from another post somewhere & perhaps was based on a query. Oh, well. My other method seems to work & happy to use it if noone else says otherwise Thanks Brian :)

Yes, I tried to add "then" to the end of the line but it errors out :confused: Must be something wrong with "Between" as that is highlighted in red If Me.txtStartDate Between DateAdd("ww", -2, Date()) And DateAdd("ww", 2, Date())

Hi, The following code now works after formating the date field to short date Private Sub txtStartDate_AfterUpdate() If Me.txtStartDate <= Date - 14 Or Me.txtStartDate >= Date + 14 Then MsgBox "This date may be incorrect please check your records & try again" Me.txtStartDate = ""...