Search results for query: *

Our universe consists of 1 header table and 4 joined tables (with 1-N relationships to header). When I try to validate the universe - in terms of being sufficiently user friendly for non-technical staff - I find there are problems in adding columns from 2 of the N tables. It is possible if I...

Or in other words a left outer join! I have a table where I want the count of the records and another where I want the sum. However not all records in table 1 have records in table 2. The universe has an outer join set-up. But when I create the report the count results are as a inner join...

I am using Access 2003 References VBA Access 11 OLE Automation DAO 3.6 ADO 2.1 Background I have a form from which I kick off another form - which then requeries the original form. I want to store the bookmark and then return to it when the kicked form closes So when the form opens I store...

See the below code The Msboxes do kick up 3709 and the usual error description Set mcnn = CreateObject("ADODB.Connection") Set pkg = DTSGlobalVariables.Parent Set tsk = pkg.Tasks("DTSTask_DTSExecuteSQLTask_11").CustomTask Set fso = CreateObject("Scripting.FileSystemObject") Set wsh =...

I know next to nothing about JS but would love a bit of help to overcome a small problem Currently mailto:thursday_footy@footylist.info?subject=Footy: Thursday dd-mmm-yyyy&body=Update dd-mmm-yyyy above and send this with a short message, if you wish. Note: if you're not already...

I want to know whether it is possible to pass a highlighted part of a text box as a variable eg This is a textbox with some text in it. Lets say "textbox with" is highlighted, you right click and select "Custom Action" a Msgbox popups with "textbox with" Any suggestions outside of using the...

I am writing a document that links back to a lot of data in a database - instead of having it all displayed (cumbersomely) in the document I want the user to launch the data from the word document. The code to get the data and display it (in excel) is done - all I want is someway of launching...

I have adopted a number of undocumented databases - all of whom serve multiple purposes. Strange behaviour has been noted in a data table which none of the queries seem capable of achieving. I have checked the code in the databases I know that use the data table and no luck. I know in a Front...

As I want started off as properly but it is probably something I have missed. I have the following code, but if the date is before the 12th day of the month it swaps to US format dtmMax, so doesnt work. Public Function fncGetMaxStatus(intRequest As Integer) As Integer Dim dtmMax As Date...

I have some code as follows: Set dbs = CurrentDb strSQL = "SELECT tbl_Request.RequestID, tbl_Request.PriorityMIS, " & _ "tbl_MIS.Name, tbl_Request.DateDelivery, tbl_Request.Time " & _ "FROM tbl_MIS INNER JOIN tbl_Request ON tbl_MIS.MISID =...

This is another good one for you all to think about. To make my life easier I have a public const in a database that is a network or local path. I use this as the root for all files for the database. All I have to do is change the public const to move the database from dev to live. However...

When a database is opened it launches another database which performs some timer based tasks which I would rather have running from another database. Come the end of the day the user will close the main database, from here I want the database to also close the other database. IE Look through...

The powers that be have decided that the method in which a number is calculated should be changed. We have many hundreds of reports generated from a large number of databases. I have written code that scans the SQL of each query in a database and tells me the query and the string it contains...

We have a number of large databases that are used by a few number of users. When I have updated a development copy of a database I copy it into the "live" directory. When the user opens their local copy of the database it runs through the queries, reports, and forms and copies over any...

This may just me being a complete arse but the following code works fine if you navigate through the records but when you tab from the final field of the form to a the next record you get 2455 invalid reference to the property form/report. Any ideas welcome and thanks in advance Private Sub...

I have a form which is used as a cosmetic surround for a datasheet subform. When I double click on a record a popup form is loaded where I can perform various tasks. On closing of this form the subform recalculates and takes me to the top of the list. Is there anyway of preventing this and...

I am formatting a date column using format(date,"mmm yyyy") and then sorting on the column. Unfortunately it is returning April first. I would like January to still appear first. Any suggestions on this one.

This is a fun one for you all. I am exporting data into excel from Access, some of these values are null. I pass this information to management who being management find it difficult to review numbers so instead want pretty pictures. They simply click the Graph Wizard and get confused. They...

Another strange one here. My machine has UK settings for dates. I create a parameter based on a date, I append that into a string which I then use as the string for a query. The string is correct but when the query runs it changes the date to US format. Any ideas. Below is the code intDwn = 6...

I have the following query: SELECT tblToday.AgRef, tblStatuses.Status, tblStatusGroups.StatusGroup, IIf([OldStatus] Is Null,[NewStatus],[OldStatus]) AS Old_Status, IIf([OldStatusGroup] Is Null,[tblStatusGroups]![StatusGroup],[OldStatusGroup]) AS OldStatusGrp, tblToday.PytsDown...