Microsoft Access

• Microsoft Access Questions

• • behind the 8 ball !

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

    By poolsharks

  • M`I,5-P ersecution - MI 5 are Afraid to Admi t The...

    MI5 are Afraid to Admit They're Behind the. PersecutionMI5 have issued a formal. denial of any i...

    By ieieifvif_yahoo_com

  • 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

• • data modeling tools

    hello all!does anyone, or has anyone, used a data modeling tool for Access 2007database design?i nee...

    By alfaista, 7 Comments

  • Data mismatch

    Ok I'm new at writing functions so be patient with me...I created thisfunction but when I try to...

    By melissa, 4 Comments

  • Extra large blank gap

    Hi all,There is a extra height blank gap between the first and the second group,but to other groups ...

    By clara, 1 Comments

  • 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

• Microsoft Access: is the Category's subject.It's has 450 questions,this is No.23 pages.
• SQL command LIKE and ADO
• Hi,I ran into this odd problem when trying to make a query in Excel VBA with ADO. When using SQL clause:"SELECT * FROM Table" : everything works fine and records are found.But when using:"SELECT * FROM Table WHERE Name LIKE 'test*'" no records are found. The odd thing is when I copy t...
• jnyman, Sat, 13 Mar 2010 04:03:00 GMT, 533 bytes, 8 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, Sat, 13 Mar 2010 03:43:00 GMT, 526 bytes, 5 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, Sat, 13 Mar 2010 03:42:00 GMT, 483 bytes, 3 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, Sat, 13 Mar 2010 03:34:00 GMT, 318 bytes, 3 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, Sat, 13 Mar 2010 03:31:00 GMT, 15,235 bytes
• 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, Sat, 13 Mar 2010 03:31:00 GMT, 311 bytes
• How To Manage Links In A Database
• i have a access data base dump in my system and i need to manage the links. how can i do this?...
• kiranvooda, Sat, 13 Mar 2010 03:31:00 GMT, 94 bytes, 1 Answer
• 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, Sat, 13 Mar 2010 03:31:00 GMT, 606 bytes, 1 Answer
• Data not carrying over from Form to Table
• I have 2 expressions that I am using on a form to find certain data. How doI get the table to show that data.Here are the expressions:=IIf(IsNull([Complete Date]),Date()-[Order Date],[Complete Date]-[Order Date])&=[Orig Appraised Value]-[Reviewed Value]The problem that I am having is writing que...
• caseyp, Sat, 13 Mar 2010 03:30:00 GMT, 631 bytes, 3 Answer
• Extra page in a report
• I have a report and after the 1st page, I get a blank page, then after the3rd page, I get a blank page and so on throughout the whole report. Help...
• mkb, Fri, 12 Mar 2010 13:14:00 GMT, 154 bytes, 2 Answer
• SQL Commands
• I do have the following problem:I would like to combine several commands in SQL with one command button onmy Form.a) Run an append query to append data to a tableb) Run another append query to append data to the SAME table as in a)c) Print a report which is based on that tabled) Run a delete que...
• amateur, Fri, 12 Mar 2010 12:39:00 GMT, 1,641 bytes, 3 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
• 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
• 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
• 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
• 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
• «««1314151617181920212223