Help
in [Access]
|
Iff hi i have a query that takes values from two other queries rejectreason_baseweeklysum.sumof1 = number of repairs (entered daily) rejectreason_baseweeklysum Query = producton (entered weekly) 1per: Sum((rejectreason_baseweeklysum.sumof1/ [rejectreason_baseweeklysum Query].wk1)) if rejectreason_baseweeklysum ... 24 Feb 2010 04:13
Need to print an query in an array I am having a hard time wrapping my head around how to do this task in Access. I have a word document (does not have to stay in word, can be a report) where I have the following layout. Label1 Record1Field1 Record2Field1 Record3Field1 Label2 Record1F... 22 Feb 2010 17:31
Tools to monitor Access /Jet reads in Traditional FE/BE application I am trying to help a user debug slowness in an Access app with a traditional FE/BE structure. I know of this utility for counting reads and writes http://technet.microsoft.com/en-us/sysinternals/bb896653.aspx Anyone know of other utilities that can help me with the process of identifying the quantity and ... 22 Feb 2010 22:01
Writing a text file to UTF-8 Hi, I have a recordset I want to export to various different text based formats, such as YAML and JSON. I know that it is possible to export a rs using TransferText and have an export specification, but obviously I need the flexibility to use different formats. I have looked around to see if I could use ADODB.... 23 Feb 2010 09:00
You do not have exclusive access Hi, I have a database located on a server with about three users. Two of the users have no problem opening the database and working. However, I have one user that when they open the database they get the message that they don't have exclusive access to the database and changes will not be saved. It is as if t... 24 Feb 2010 09:42
Parameters on Subforms broken in Access 2007 ADP Working with an ADP in all previous versions of Access prior to Access 2007, this worked fine when populating a subform using VBA: Me.Child.Form.InputParameters = "@SomeParameter = Forms! FormName.ControlName, @ID = FunctionName()" Me.Child.Form.RecordSource = "dbo.SprocName" Now it does not work in Access 200... 25 Feb 2010 10:14
Migrate from Access 97? Hi, I have an application written in Access 97 that is distributed using the runtime. We've done all of our development work for years using Access 97, but as I'm working on a major new release right now, I'm wondering if it might be time to move up to a newer version of Access. The choices would seem to be.... ... 25 Feb 2010 12:30
Late Binding worked until Access 2007 The following late binding code used to work with all previous versions of MS Access prior to Access 2007 to export a contact to Outlook. It worked exporting from Access 2003/2002/2000 to Outlook including Outlook 2007. It worked whether or not Outlook was open. However, now with Access 2007 it only works if Outlo... 20 Feb 2010 13:30
Help in a query Hello, If i use this query: ================================================= select S.fam_code FAM, S.fam_nom NOME, ( select sum(SB.vn_atelier)+sum(SB.vn_loja) from roa_stat01_det_f SB where SB.dt>='20100101' and SB.dt<='20100104' and SB.fam_code=S.fam_code )[VN PDV] from roa_stat01_det_f S where S.dt>='201... 18 Feb 2010 17:20
BrowseTo command Also I have to mention that when executing there is an error 6054 and the message and that the path is incorrect offcourse and that a valid path argument is of the form: "MainForm1.Subform1>Form1.Subform1" - this is different from the "MainForm.NavigationSubForm>Form1.Subform1" that access gives at the "Path to... 17 Feb 2010 04:28 |