Search results

I would like to set up a query that captures records entered from the previous 15 working days, not including today? My table records the date entered but how do I tell it to gather 15 "working days" worth of data, up to yesterday or the previous day.? Additionally I will be setting up excel...

All, I have searched the threads but cannot find anything specifically to what I need. I track escalations with my new DB and extract monthly reports into Excel to produce charts. I have a field to log the age of the escalation but I need the following criteria. If the Status of the...

Can anyone offer any help with this one ? Thanks

Ok Not sure how you attach a picture to this thread, so I'll try to describe my form a bit The main form has a hidden field called "Status", there are also two other fields (combo's) one called "Txtsearchcriteria" for the owners name the other is "status". Additionally there is a Company Name...

Not sure on how I apply the code, is this using the option of having the Subforms SourceObject set when you select an option form a main form menu (in my case several labels), thus making that particular subform visible or are you laoding all subforms and hiding them or making them visible ...

Sorry when I say "SelectSource" I mean "SourceObject"

Pat, I have tried using this option for my DB, I have a main form and several forms that I am trying to configure by using the "Selectsource" method, to open as subforms. My main form (and Subform) lists escalation details, where the main form holds the owners name and the subform should list...

I seem to have a problem with Access loading switchboards, In my new DB I don't actually use a switchboard and have not seen this problem come up but I am looking at other ways of using the switchboard and when I load the SB it comes up with the following error box: Run-time Error '-2147024769...

Ok whilst looking into the coding etc.. I tried this bit of code on the form itself, If Me.Status = "Closed" Then Me.txtAge = DateDiff("d", Me.txtDate_Opened, Me.txtClosed) Else Me.txtAge = DateDiff("d", Me.txtDate_Opened, Date) End If I put this in as a...

SJ Mc Abney, Thanks for the quick repsonse, I'll have a go with this code and see how it goes. Many thanks MattP

Ok, I currently have a form (called frmreview) that is linked to a Query (called qryreview). On my form I have a field for date opened, one ofr date closed and a field for age of issue. How can I set the form so that if there is no closed date the age is a running total of date opened to...

Trucktime, Superb, works a treat. Many thanks for your help

Thanks for the responses, I have now got this working with a combination of what you have advised and "tweaking" certain other aspects of VBA code. many thanks for all your help Matt P

I have a form with a subform, that collates escalation update history. Sometimes the update notes are quite lengthy and are too long for the standard 1 line height in the datasheet view ( and the width I have to work with). I don't want to make it any higher as it does not look neat & tidy...

Thanks for the link and this does look like a good format, however I've no idea how to configure that. I am trying something at the moment where I have a form open with a sub form, on the click of a button I need another subform to appear but the first one to no longer be visible. When you...

Does anyone know how, or have a sample of how, to create switchboard to look like MS Outlook, with the sidebar for navigating. I've seen it on some demo's so no it's possible but does this require serious coding/progrmming ? I basically want to be able to navigate my database using buttons and...

Does anyone know how, or have a sample of how, to create switchboard to look like MS Outlook, with the sidebar for navigating. I've seen it on some demo's so no it's possible but does this require serious coding/progrmming ? I basically want to be able to navigate my database using buttons and...

Thanks for the very quick response, I found some threads and have had a good read through and now have it all working. Many thanks for your help

Ok thanks, I'll have a look through and see what I can find.

This may be a real easy one to fix but I'm stumped, I have a DB that tracks and records escalations I am dealing with. Within the main review form there is a subform that is used to enter a new update, this is stored in a seperate, linked, table "tblEscJournal". If I try to delete the main...