Microsoft Access

• Microsoft Access Questions

• • Data not being display in Access Report via an ODB...

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

    By davids

  • FAQ! for Date: 20030917 - New Users Look Here! [La...

    An HTML version of this document is available at:http://www.mvps.org/access/netiquette.htmFeeling le...

    By faqposter_cdma_invalid

  • External Table Error Message

    I imported an Excel table into Access 2000. I now get an error messagesaying "external table is not ...

    By chrissieg

  • M`I,5-Persecu tion ` bugging a nd counter- surveil...

    -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=--= MI5: bugging. and counter-surveillance -=-=-=-=-=-=-=-...

    By ifvivieie_hotmail_com

  • behind the 8 ball !

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

    By poolsharks

• • 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 pa...

    By mkb, 2 Comments

  • SQL Commands

    I do have the following problem:I would like to combine several commands in SQL with one command but...

    By amateur, 3 Comments

  • Data not always available for crosstab report

    I have created a crosstab query/report based on "No of Applications permonth" with the "Application ...

    By stevec, 1 Comments

  • Blocking past dates from being entered

    Hey All..Ive been working away on a database that would accept ski lessonregistrations.I would ideal...

    By trialerror, 1 Comments

  • Block all controls of a FORM and a SUBFORM through...

    Hello to all!How can I block all controls of a FORM and a SUBFORM through a commandbutton?Thanks!Uto...

    By utopian, 3 Comments

• Microsoft Access: is the Category's subject.It's has 450 questions,this is No.23 pages.
• !! HELP THE CHILDRENS !!!!!4
• http://free.x3.hu/charity...
• alfabetagammadelta, Mon, 15 Mar 2010 16:58:00 GMT, 89 bytes
• Recommendation for a book: VBA/Access Forms
• Hi all,I was wondering if someone can help me. I teach a database class atNanyang Technological University, Singapore and am looking for a VBA(Access) textbook to complement the database material I teach. Thisbook should have the following characteristics:(1) Preferred: NOT be an introductory pr...
• aehchua_ntu_edu_sg, Mon, 15 Mar 2010 11:55:00 GMT, 3,752 bytes, 9 Answer
• Data Model Help
• I'm building a medical case management database in which the patient will beasked a series of questions to assess their current situation, withadditional questions asked depending on their answers.The two main tables are:MEMBERSPK - MemberIDCASES (each member can have multiple cases)PK - Cas...
• timtafflinger, Mon, 15 Mar 2010 11:54:00 GMT, 1,204 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, Mon, 15 Mar 2010 07:37:00 GMT, 15,235 bytes
• Extra Pages
• Hello,My report has 13 pages of the same thing and I can't figure out why. I havemy report set to letter landscape 9.875 x 5.95 with .25 margin for header,footer, left, and right. I notice if I remove the source control from thereport I have just one page. As soon as I put the source control...
• markjackson, Mon, 15 Mar 2010 06:40:00 GMT, 522 bytes, 2 Answer
• FAQ! for Date: 20030919 - 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, Sun, 14 Mar 2010 19:16:00 GMT, 15,243 bytes
• 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, Sun, 14 Mar 2010 17:15:00 GMT, 631 bytes, 3 Answer
• data not entered into mdb
• Hello,I have a table of 30,000+ records in it. We have a script that reads ininfo and then writes the info into the table. New info will not get added tothe table. Tried repair and compact without success. If we remove recordsfrom the table, then new information will be added.What am I missing h...
• flee, Sun, 14 Mar 2010 14:02:00 GMT, 342 bytes, 3 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, Sun, 14 Mar 2010 13:30:00 GMT, 6,159 bytes
• Blocking Access from linking tables...
• Good morning...I have an Access front end that uses SQL Server linked tables. SQL Serveruses Windows authentication. I have one Windows group that all Access usersare a member of. I added that group to SQL Server logins and gave itpublic, datareader, and datawriter rights to the one database tha...
• matthewwells, Sun, 14 Mar 2010 13:30:00 GMT, 1,187 bytes, 2 Answer
• Machine Activty Log Table design issues
• I have a number of checklists for my machineryi have attached a couple of check sheets I have attached my table structure and an example of my check list in XLS formati need to track which of these checks are being carried out each week..I have created 3 tables so far, 1 called tLine and 1 calle...
• chimp8471, Sun, 14 Mar 2010 10:01:00 GMT, 1,922 bytes, 4 Answer
• Data not in table
• Hello,I have a large database with tables and forms for data entry. With some of my forms, the data I enter show up in the corresponding table. The problem I'm having is this: some of the forms, when data is entered into them, the data do not show in their table; I hope I'm making sens...
• vickie57, Sun, 14 Mar 2010 08:07:00 GMT, 353 bytes, 4 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, Sun, 14 Mar 2010 08:03:00 GMT, 483 bytes, 3 Answer
• block records
• I have a form master, that you/they count three guides where each one ofthese guides, possesses a subform linked to the main form. This a mistake orblockade that I don't get to detect happening than it is treated. When twousers register in the same guide and in the same subform, each one in...
• frankdulk, Sat, 13 Mar 2010 21:33:00 GMT, 746 bytes
• how to make the access 2000 non unicode data?
• acyually i am trying to make my database not unicode i want it a localcode 1256anyone know how to make it access2000 or access 2003 , and how toconvert a database from unicode to 1256 code...
• aua_usama_yahoo_com, Sat, 13 Mar 2010 21:25:00 GMT, 208 bytes
• 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 15:01:00 GMT, 533 bytes, 8 Answer
• Blocking form changes
• HiI have a main form with a sub form (Subform1). The sub form only has a tabcontrol on it and then each tab in turn has a sub form on it. I am trying toblock one of the sub forms on the tab control, so I have tried this;Forms![Main]![SubForm1].Form![SubSubForm1].Form.AllowEdits = FalseBut this h...
• john, Sat, 13 Mar 2010 10:06:00 GMT, 359 bytes, 2 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
• 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
• 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
• «««1314151617181920212223