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

• • How to make this simple query?

    field- field-surname town-- --john NYjohn Vegasjohn Bostoneddie Bostoneddie New Orleanseddie NYburt...

    By eddiesmit, 6 Comments

  • Oracle Multi-Org DSN Connection

    I have tried several approaches in other threads but have not been successful.I am using pass-thru q...

    By ct25, 5 Comments

  • 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

• Microsoft Access: is the Category's subject.It's has 450 questions,this is No.23 pages.
• 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, Sun, 14 Mar 2010 00:53:00 GMT, 15,235 bytes
• 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
• 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, Sat, 13 Mar 2010 21:24:00 GMT, 15,243 bytes
• 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, Sat, 13 Mar 2010 21:24:00 GMT, 1,922 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, Sat, 13 Mar 2010 15:02:00 GMT, 483 bytes, 3 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, Sat, 13 Mar 2010 15:01:00 GMT, 353 bytes, 4 Answer
• 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
• 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
• «««1314151617181920212223