No announcements
Filter
:
All Threads
All Threads
Answered
Unanswered
Proposed Answers
General Discussion
No Replies
Helpful
Has Code
All Languages
-
Unanswered0Votes
how to delete all duplicate rows in access
hi i have this table: Fname | Lname | Age --------------------------- AA | BB ...10 Replies | 91 Views | E_gold - Friday, July 05, 2013 4:15 PM | Last Reply Ken Sheridan - 41 minutes ago -
Unanswered0Votes
FE on WinXP machine and BE on Win8.
I cannot for the life of me get the LinkedTableManager to link my ac2002 FE to the ac2002 BE when the FE is on a WinXP machine and the BE is on a Win8 machine. I can open the BE on the Win8 machine ...11 Replies | 98 Views | RuralGuy99 - Thursday, July 04, 2013 6:32 PM | Last Reply RuralGuy99 - 1 hour 6 minutes ago -
Answered7Votes
What is unstructured data?
Hello all, Does anybody know what the unstructured data is? Can you please bring an ...14 Replies | 172 Views | GGGGGNNNNN - Wednesday, July 03, 2013 4:31 AM | Last Reply GGGGGNNNNN - 2 hours 55 minutes ago -
Unanswered0Votes
Running Sum Adding Missing Months
Hi, I'm trying to run a cross tab running sum query in Access 2010 with the row headings equal to months and State_County and the column headings would be numbers of cases of ...21 Replies | 523 Views | CycleBrian - Thursday, July 04, 2013 4:31 AM | Last Reply CycleBrian - 4 hours 51 minutes ago -
Unanswered0Votes
"unrecognized database format"
Hey guys, i am developing a small program and i am using access database accdb. everything was working fine until today, i added a calculated field and as i reach the very first ...1 Replies | 50 Views | Ayman_mo - 8 hours 49 minutes ago | Last Reply Tom van Stiphout (MVP) - 5 hours 25 minutes ago -
Answered0Votes
What is the proper way to delete an Event Macro ?
This just occurred to me. I've always deleted 'Event' fired macros this way... - While looking at the Event Tab of the Properties Window - ... -
Unanswered0Votes
Access Not Filtering Report Correctly
My Access Project when filtering from a form's VBA command... Private Sub btnSPreview_Click() Dim Criteria As String ...14 Replies | 126 Views | Justin.ITPro - Wednesday, July 03, 2013 12:25 AM | Last Reply Justin.ITPro - 8 hours 11 minutes ago -
Answered0Votes
How To Get Around Textbox Design Bug?
I am using a textbox in Access 2007 to display a list of the Outlook rules defined by the user. According to the Access 2007 specifications ...1 Replies | 65 Views | saberman - 19 hours 16 minutes ago | Last Reply saberman - 18 hours 17 minutes ago -
Proposed0Votes
Access 2013 Can't Create New dB's
I installed Office 2013 Pro on a clean install of Win8 Pro. I am unable to create or open existing databases. When I try to create a blank database, I get the error: "Cannot ...5 Replies | 328 Views | rdagger - Wednesday, May 22, 2013 7:33 PM | Last Reply AlexSteinwachs - 21 hours 20 minutes ago -
Unanswered1Votes
Access 2010 - SQL Update Syntax
Hi, I'm a little confused on how to accomplish an update query. I'm working in Access 2010. I have a table "tblTest" with 6 fields ( A, B, C, etc ). There ...10 Replies | 96 Views | Mikevaprofile - Friday, July 05, 2013 5:08 PM | Last Reply Van Dinh - 21 hours 36 minutes ago -
Unanswered0Votes
Error trap entire document at once.
Can I error trap the entire document at once? I'm very lazy and don't like to put the error trap on every Sub. Thanks in advance! Access ...5 Replies | 78 Views | UpTide - Friday, July 05, 2013 7:37 PM | Last Reply Chris A O'Brien - 22 hours 30 minutes ago -
Unanswered2Votes
Make controls disappear and resize form
I have a form frmInsertion that has a lot of controls on it to mirror the paper that it was designed from. On one portion there are controls related to complications that I would like to disappear ...28 Replies | 217 Views | Dinodeserter (Chris) - Friday, June 28, 2013 7:52 PM | Last Reply Dinodeserter (Chris) - Friday, July 05, 2013 10:38 PM -
Unanswered0Votes
Adding column of datatype “Number” with Field size “Decimal”
In access i want to add a column of datatype "Number" with Field size "Decimal" also i want to set precision to specific value. I can do this manually by using GUI in MS access. ...2 Replies | 115 Views | IT researcher - Thursday, July 04, 2013 9:41 AM | Last Reply Dirk Goldgar MVP - Friday, July 05, 2013 10:28 PM -
Unanswered0Votes
VBA Conditional Statement and the Object Required Error
Hi I'm trying to run a vba statement like this Private Sub cmdBatchUpdate_Click() If Me.txt3fieldA Is Not Null ...2 Replies | 62 Views | Mikevaprofile - Friday, July 05, 2013 10:02 PM | Last Reply Dirk Goldgar MVP - Friday, July 05, 2013 10:12 PM -
Unanswered0Votes
How to run a Macro when new record added ? (Record Added Event ??)
Given a single table shown on a single form in 'Continuous' View The user scrolls to the bottom and enters a new record Is there a way to trigger a macro at this ...4 Replies | 89 Views | Mel_3 - Friday, July 05, 2013 8:45 PM | Last Reply Mel_3 - Friday, July 05, 2013 9:20 PM -
Answered0Votes
Connection from one database to another database
Hi All, I have 2 Access 2010 Databases one called "QA.accdb" this database holds data in a table called "LTM Form". in the second ...5 Replies | 80 Views | cezar1308 - Friday, July 05, 2013 5:29 PM | Last Reply cezar1308 - Friday, July 05, 2013 8:18 PM -
Unanswered0Votes
SetFocus to SubForm control
I have a solution that hosts 2 subforms on a main form, only one subform is visible at any given time. I have created my own navigation buttons, on the main form, which I enable and disable ...24 Replies | 153 Views | JonWayn - Friday, July 05, 2013 2:56 AM | Last Reply Imb-hb - Friday, July 05, 2013 8:05 PM -
Unanswered0Votes
Use string as code.
I have a where clause in a DLookup function that is a variable. This variable is assigned with another Dlookup function I would rather not put the second Dlookup on every single primary ...6 Replies | 80 Views | UpTide - Friday, July 05, 2013 4:42 PM | Last Reply Dirk Goldgar MVP - Friday, July 05, 2013 7:24 PM -
Unanswered0Votes
Product key problems
Hi can anyone help I had MS Access 2010 installed on three computers. I uninstalled it from one of them, so that I could free up a proct key for use on another ...2 Replies | 51 Views | docmandocman - Friday, July 05, 2013 5:27 PM | Last Reply Dirk Goldgar MVP - Friday, July 05, 2013 5:41 PM -
Unanswered2Votes
Runtime error 52 when using dir function
I'm trying to delete a file in a network location. Sometimes the file is there, sometimes it's not, so I'm using the following code: strPath = "\\network drive\My ...10 Replies | 115 Views | Will Knapp - Tuesday, July 02, 2013 2:19 PM | Last Reply Dirk Goldgar MVP - Friday, July 05, 2013 3:57 PM - Items 1 to 20 of 13783 Next ›