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

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

  • 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

• Microsoft Access: is the Category's subject.It's has 450 questions,this is No.23 pages.
• 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
• 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
• 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
• «««1314151617181920212223