General
in [Access]
|
Weird tab color behavior in A2003 on Win7 On Win7 in A2003 (SP3) when I create a tabbook on a form all tab pages are white, and there seems to be no way of changing them to gray. Even changing the tabbook's background style to transparent doesn't help. Funny enough, an A2003 mdb that I made on another machine and now opening on the Win7 machine, shows ... 24 May 2010 11:15
can someone tell me where my formula going wrong V2 =DSum("[Amount6a6fs]","[Sales Analysis]","[Posting Date Period] = '" & [cbMonth] & "' And [Revenue Stream Division] = 'Production' or [Revenue Stream Division] = 'other' And ([Customer No] = 'C01317')") every works apart from the last par customer no, the table name is correct spelling, the sun i'm getting ... 28 May 2010 18:11
Can some tell me where my formula is going wrong please can some please tell what wrong with my dsum =DSum("[Amount6a6fs]","[Sales Analysis]","[Posting Date Period] = '" & [cbMonth] & "' And [Revenue Stream Division] = 'Postage'" And "'([customer no] = 'IC0008' or [customer no] = 'C01105' or [customer no] = 'C00785' or [customer no] = 'C01388' or [customer no]... 24 May 2010 10:08
Progress Bar In Report I'm using access 2007 Tasks templates database. In the report task assigned by to, is it possible to add/replace %complete by "progress bar %" instead by number percentage. Thanks ... 24 May 2010 12:21
Modify Northwind Dear All, In northwind database that comes with access 2003, how can I make a form for purchase / received inventory just like customer order, form for this purpose how many more table do I have to made I am also want to track the inventory in Transaction table for all the purchase & sales just as below: Tra... 24 May 2010 02:36
Question about recordsource Hi there What does the following mean? I have been told that I should fix the recordsource for my forms. What does it mean to use the table name or * select * from tablename? Where do I put this inofmration? I'm uncertain of how to proceed with this request. Thank you in advance for your help. ... 24 May 2010 00:29
Compact Database I've read and seen tons of theories about how to compact an active database via VBA code for AC2003. The following code works for me. Public Function QuitAccess() Select Case MsgBox("Do you really want to close the MDS system?", vbYesNo Or vbQuestion Or vbDefaultButton2, "Please Confirm!") Case vbYes ... 26 May 2010 23:33
Building search/filter criteria I am designing a form where I can search the disbursement info by selecting 1 or more payment stages and 1 or more fund source. From what the user select, build the where clause and pass it as a record source to a subform. I have 2 listboxes, 1 button for Search and 1 sub form for display result. My problem is how... 24 May 2010 01:33
Access runtime and activation If you distribute an Access application with runtime using say OFFICE XP Developers Edition - does the client's computer have to activate Access? ... 23 May 2010 20:09 |