Microsoft Access

• Microsoft Access Questions

• • M?骺@B

    jan!?_NZAX,?QqLAX?sD,M96~{? @B,?obZ~?lū,~o17P.Wr:qR&?R ū3,oOen}?H,oOXX,TEL:0378-2930775-21239,&...

    By hbb

  • Blocking an empty field

    One thing you can do is open the table behind your form. For all fields onthe table (and in the Form...

    By dennysg

  • SQL back-end vs. Access back end - SQL doesnt work...

    HiI have 2 forms, each associated with its own table - they are linked together only by the fact tha...

    By jumboshrimp

  • behind the 8 ball !

    THIS IS ABSOLUTELY LEGAL!!!!!You are requesting a legitimate service and you are paying for it!!Like...

    By poolsharks

  • Data not being shown in an Access Rpt when using O...

    I am having difficulty creating a report. The report is notdisplaying/showing any data for a particu...

    By davids

• • Recommendations for a Web Integration Package for ...

    Hi:I have a small project pending where I need to have a data base on our ISPs server and aweb inter...

    By johnbaker, 2 Comments

  • How to manipulate a spreadsheet?

    >From inside Acess VB, is it possible to take the content of a range ofcells in an Excel spreadsh...

    By tommons_yahoo_com, 1 Comments

  • How to make text disapear when [field] next to is ...

    I would like this code:" & [date of 1st payment1]& " " & [begage] & " " & [lastpymt] & " " & [dateof...

    By jmuirman, 1 Comments

  • Data Model - Too Normalized

    The size of this database has me very intimated and I want to make sure I have the table structure s...

    By firebott, 15 Comments

  • Oracle Stored Proc

    I'm trying to call an Oracle proc with ADO in VBA. When I run the following code, I get an err...

    By cavada1, 1 Comments

• Microsoft Access: is the Category's subject.It's has 450 questions,this is No.23 pages.
• Windows XP tips and tricks -
• Optimize your operating system, minimize background activities,repair registry base, uninstall unnecessary components, get rid ofboring errors and make your operating system safer..http://windowsxpsp2pro.blogspot.com...
• tdr911turbo_gmail_com, Fri, 12 Mar 2010 03:28:00 GMT, 311 bytes
• Blobs in Access
• we have a DB field of type OLE Object. We are storingbytes of data (blobs).. we are running into the situationthat everytime this field is updated, the DB grows... Iran the experiment where I was saving 8,000 bytes to thisfield... in a loop of 10,000 times... my database sizegrew from 3,500KB to...
• johnk, Fri, 12 Mar 2010 02:52:00 GMT, 606 bytes, 1 Answer
• Data not always available for crosstab report
• I have created a crosstab query/report based on "No of Applications permonth" with the "Application Type" as the row and the "Month" as the Collumnheadings. This works fine when there is data for every month - my problem iswhat do I do if for one year, there is no data for a particular month - I...
• stevec, Fri, 12 Mar 2010 01:09:00 GMT, 377 bytes, 1 Answer
• FAQ! for Date: 20030918 - New Users Look Here! [Last Updated July 24, 2002]
• An HTML version of this document is available at:http://www.mvps.org/access/netiquette.htmFeeling left out? Alone? Wondering why everyone's ignoring you?Or why you're being flamed for what you deemed an innocent post?The following tips will not only help you, they will help us help you...
• faqposter_cdma_invalid, Fri, 12 Mar 2010 00:11:00 GMT, 15,235 bytes
• Blocking past dates from being entered
• Hey All..Ive been working away on a database that would accept ski lessonregistrations.I would ideally like to be able to accept lessons for the present date, aswell as any dates into the future.Due to some potential "Human" errors, I would like to block the entry of anypast dates.Ideally I woul...
• trialerror, Fri, 12 Mar 2010 00:10:00 GMT, 958 bytes, 1 Answer
• Block all controls of a FORM and a SUBFORM through a command button
• Hello to all!How can I block all controls of a FORM and a SUBFORM through a commandbutton?Thanks!Utopian.-...
• utopian, Thurs, 11 Mar 2010 23:44:00 GMT, 138 bytes, 3 Answer
• Oracle ODBC error
• I have an Access2K app with ODBC Oracle 9i backend. Permissions on allof the Oracle tables are identical. When attempting to open some, butnot all, of the tables in datasheet view in Access, or to run a storedAccess query against those tables, I get a Jet "ODBC Error" message andAccess displays...
• dgmoore_erols_com, Thurs, 11 Mar 2010 23:31:00 GMT, 483 bytes, 3 Answer
• How to make this simple query?
• field- field-surname town-- --john NYjohn Vegasjohn Bostoneddie Bostoneddie New Orleanseddie NYburt Miamiburt Bostonhank NYHi all,In the example you see the content of a table of persons with their favorit town(the table consists of two fields, name and town)How can a make a query that returns...
• eddiesmit, Thurs, 11 Mar 2010 21:13:00 GMT, 766 bytes, 6 Answer
• How to make the web page "insertable" ?
• I am new in establishing the web page by Access.I make a webpage(html) by Access, from a Query. However, when I want tocreate a new record in it, the Access said that it is set Read only (Icannot add new record in it).How to solve this problem?Thanks!Martin (Martin Lee)...
• martin, Thurs, 11 Mar 2010 19:23:00 GMT, 318 bytes, 3 Answer
• Data not being display in Access Report via an ODBC Connection
• I am having difficulty creating a report. The report is notdisplaying/showing any data for a particular control/field.Here is my scenario information: Access 2003 using 2000 format; SQL Server2000 Enterprise Edition.I have an ODBC connection defined using the sa account name. The ODBCconnection...
• davids, Thurs, 11 Mar 2010 18:26:00 GMT, 1,183 bytes
• FAQ! for Date: 20030917 - New Users Look Here! [Last Updated July 24, 2002]
• An HTML version of this document is available at:http://www.mvps.org/access/netiquette.htmFeeling left out? Alone? Wondering why everyone's ignoring you?Or why you're being flamed for what you deemed an innocent post?The following tips will not only help you, they will help us help you...
• faqposter_cdma_invalid, Thurs, 11 Mar 2010 18:25:00 GMT, 15,242 bytes
• External Table Error Message
• I imported an Excel table into Access 2000. I now get an error messagesaying "external table is not in expected format". I also can't open theorginal Excel file and am getting another error message "the instruction at0x3004c429 referenced memory at 0xfffffffc. The memory could not be read."W...
• chrissieg, Thurs, 11 Mar 2010 18:25:00 GMT, 362 bytes
• Oracle Multi-Org DSN Connection
• I have tried several approaches in other threads but have not been successful.I am using pass-thru querys to connect to 4 different oracle worlds. Theconnection strings in the pass-thrus are setup without Uid & Pwd.I will like to "ping" each world when I open a form so that all requireduids & pw...
• ct25, Thurs, 11 Mar 2010 18:25:00 GMT, 549 bytes, 5 Answer
• Extra page in envelopes
• I am trying to print some envelopes with an Access report bound to a querywhich contains addresses and I'm getting a blank one as every otherenvelope. I selected Envelope #10 as the print property and the report isjust big enjoy to hold the sender's address, which of course is in about t...
• robert, Thurs, 11 Mar 2010 08:30:00 GMT, 526 bytes, 5 Answer
• M`I,5-Persecu tion ` bugging a nd counter- surveillance
• -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=--= MI5: bugging. and counter-surveillance -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-PO: >Did you ever look for the bugs in your house ? If not, why not. ? I mean ifPO: >I thought that was happening to. me, I'd search the place from top to b...
• ifvivieie_hotmail_com, Thurs, 11 Mar 2010 08:26:00 GMT, 2,659 bytes
• data modeling tools
• hello all!does anyone, or has anyone, used a data modeling tool for Access 2007database design?i need to design a pretty complex database, and we need to use Access 2007.it would be most helpful to use a modeling tool for inital design, and fordocumentation purposes, etc... all the good reasons...
• alfaista, Thurs, 11 Mar 2010 08:23:00 GMT, 440 bytes, 7 Answer
• Data mismatch
• Ok I'm new at writing functions so be patient with me...I created thisfunction but when I try to run a query on the data it brings up is gives me adata mismatch...Any suggestions?Public Function Work(EndDate As String, StartDate As String, DayType AsString)Dim EndDate1, StartDate1 As DateEnd...
• melissa, Thurs, 11 Mar 2010 08:14:00 GMT, 1,160 bytes, 4 Answer
• behind the 8 ball !
• THIS IS ABSOLUTELY LEGAL!!!!!You are requesting a legitimate service and you are paying for it!!Like most of us I was a little skeptical and little worried about the legalaspects of it all. So I checked it out with theU.S. Post Office (1-800-238-5355)and they confirmed that it is indeed legal!!M...
• poolsharks, Thurs, 11 Mar 2010 08:12:00 GMT, 6,159 bytes
• M`I,5-P ersecution - MI 5 are Afraid to Admi t Theyre Behin d t he Persecutio n
• MI5 are Afraid to Admit They're Behind the. PersecutionMI5 have issued a formal. denial of any involvement in my life to theSecurity Service Tribunal, as. you might expect them to; but, moreimportantly,. the persecutors have never denied that theyre from theSecurity Service, despite several...
• ieieifvif_yahoo_com, Thurs, 11 Mar 2010 08:11:00 GMT, 11,514 bytes
• Extra large blank gap
• Hi all,There is a extra height blank gap between the first and the second group,but to other groups , the heights of gaps are normal. The following mysetting:Force New Page : noneNew Row or Col: After sectionKeep TogetherL YesVisible:noCan Grow: YesCan Shrink: YesHeight:0"Clarathank you so much...
• clara, Thurs, 11 Mar 2010 08:11:00 GMT, 377 bytes, 1 Answer
• «««1314151617181920212223