Search results for query: *

this thread is starting to sound like therapy - people seem to be venting! well it's good to get it off your chest and move on. let me be clear - it is a REALLY stupid idea. I agree with ALL your comments but it doesn't negate the fact that this is a customer requirement and whilst the...

Andy - totally agree but then again we sometimes have to work with what we've got and in this case it is a paranoid company with limited resources and even more limited talent. The sum total of all this is to create apps that are totally foolproof - hence my query. for anyone reading this feel...

thanks Tony & kjv. I will continue to trial things and take a look at he api calls idea. just to be clear - I have already disabled all toolbars, created a custom toolbar on the fly with the buttons on it I want and displayed it, turned off the exel file menu ( file, edit etc...), removed the...

Ok - I have trawled the interweb to no avail on this one so once again I turn to you my friends... Rightly or wrongly I want to disable ALL right click menu / pop up events when my workbook opens. Whilst there is a plethora of code and tips out there on how to do this at a cell, sheet, ply...

Thanks Skip. I was assuming that I could maybe load the data on the tab into a recordset and then filter / manipulate the data that way. I'm battling through some articles to try and fathom how to do it. If anyone has an example of how to do this in Excel it would be appreciated. I will take...

I have searched many forms for a match to this question to no avail but if you know of one please point me in the right direction. I have a sheet that records meeting room bookings. Each room has a unique ID (column B) and each booking has a date (Column h) and a start and end time of the...

Thanks soccercook44, I'm trying to keep the ongoing development down and the flexibility up. Your way would require the creation and storage of hundreds of forms potentially (as this dbase grows). I write a query or report and place it in this central dbase for end users to then run (adds...

Thanks - if you could supply the vba for steps 1 to 5 then you would have answered my question! Simplest way to think of this would be that I want to programmatically be able to recreate the actions that invoking the form wizard would give you (i.e you give it a query as the record source and...

Cheers MajP. Maybe I should be clearer. The user selects a pre written query from a Main form. I want the Main form to remain open. The Main form is pop-up and modal so keeps the focus. when a user has selected a query I want them to be able to view the results - if I open the query (even as...

I have a list of querys (all different) and a utility that allows a user to pick a query from the list. I want the user to be able to view the results for the query they have seleceted whilst maintaining control over the screen. I don't want them to be able to edit the query for example...

I have a summary project report that I am designing and on that report I want to display the next deliverable that each project has. I have managed to get this to work but in some instances it 'misses' returning a value. The only common thing I can see is that it misses returning a value for...

I have a report that is currently output as a snapshot using the docmd.outputo function (something like: DoCmd.OutputTo acOutputReport, "rptName", "Snapshot"). I'm using this rather than 'save as' because it is a convenient way to produce the snapshot format I need. What it doesn't seem to...

Cheers All, I have the following in place now (which I can't take full credit for because it is a group of bits of code I found on tek-tips in the past - so top marks to those who originally provided them!) The user specifies the path of a folder to search in cell B2 (i.e "c:\mydocuments\")...

Got the following to work... ------------------------------------------------------------ Sub GetWorkbookProperties() Dim fs As Variant Dim f As Variant Dim stModifiedDate As String Dim stAccessedDate As String Dim wbookpath As String Dim wbookname As String...

I have a number of users who each have a workbook for recording their time in. All the users workbooks are in the same network location (i.e. Employee 1.xls, Employee 2.xls...). I need to create a 'Master' workbook (independent of these) that lists the employees and the date that their own...

Good call Skip. For my example though I have decided to restrict the user input in column A using a validation list. The users can now only select 'Default' from the list. I have also changed the 'hard' coded values to be written in the coresponding row so that they reference users values on...

All - thanks for your help. Here is what I now have; Private Sub Worksheet_Change(ByVal Target As Range) If Target.Column <> 1 Then Exit Sub If Target.Value = "Default" Or Target.Value = "default" Then Application.EnableEvents = False Target.Offset(0, 1).Value = "1"...

All - Here is what I have at the moment. This seems to work BUT if you highlight multiple cells in column A it crashes... Can anyone refine this? Private Sub Worksheet_Change(ByVal Target As Excel.Range) Application.EnableEvents = False If Target.Column = 1 Then ThisRow = Target.Row...

Thanks Geoff, It's the 'do your thang' bit I'm struggling with. As I said, I need to 'detect' what row in column A the user has changed and use this information to then update the adjacent columns of the same row. Any help is always appreciated though. I love deadlines. I like the whooshing...

Thanks Geoff, It's the 'do your thang' bit I'm struggling with. As I said - I can't work out how to 'detect' what row the user has altered in column A and then use this information to update columns in that very same row. I love deadlines. I like the whooshing sound they make as they fly by...