Group:  Microsoft Access » microsoft.public.access

Geek News

Threads Replies Last Post
1410 Pages: 1  2  3  4  5  6  7  8  9  10  11  12  13  14  15  16  17  18  19  20  21  22  23  24  25  26  27  28  29  30  >>  
free error
while free from malloc'memory. system error...
2 12/23/2008 5:09:15 PM
Display Warning if Record Locking
I am writing a bog standard A2003 FE database for a small insurance broker that have 7 PCs linked to a BE file on a Server PC. The main form is bound to tblClients with a subform bound to tblPolicies. I'm told by the user that it is quite likely that two (or more) users could try and amend the same policy record at the same time. For this reason I have set the Record Locks property on both ...
17 12/23/2008 3:40:11 PM
notification
I used to be able to email participants in an app't but somehow that ability has disappeared...
2 12/23/2008 3:15:51 PM
Change and update OLEObject on form.
Hi All I am trying to change the Excel workbook that my OLEObject on a form displays: Private Sub Form_Load() With Me.oleExcelChart ' SourceDoc is currently "W:\Public\83.xls" Debug.Print .SourceDoc .SourceDoc = "W:\Public\XX.xls" Debug.Print .SourceDoc ' ## how can I get the OLEobject to repaint/redisplay/ change?! End With End Sub ...
1 12/23/2008 1:59:56 PM
Query Problem
I hope someone can help with a query problem I have… I have the following table structure: fldTransactionID fldStatus fldStatusDate fldTransactionAmt fldLastTransactionDate This table is populated as follows: 11537481 CREATED 10/11/2008 1992.00 11/11/2008 11537481 DISTRIBUTED 21/11/2008 1992.00 20/11/2008 11537481 ON_CARD 30/11/2008 1992.0...
2 12/23/2008 1:48:49 PM
Adding a field to a report
We moved our application to Access 2007. I am new to developing in 2007. I have an existing report that utilizes a query. I need to add another field to this report. I go into the query, add the field, close and save, but it does not appear in my field list in design form of the report. Is there a setting I am missing so I can modify report queries? Thanks for any advice/help! J...
3 12/23/2008 1:41:02 PM
using forms
I am trying to allow a textbox in a subform in a form to accept input from the keyboard. At the moment it obstinately refuses to react to keyboard entry. As far as I can see the textbox is enabled and unlocked and the form allows edits. Please can anyone suggest what else might be wrong and what I should do to make this textbox editable. Many thanks -- john...
2 12/23/2008 1:08:20 PM
CancelFilter ?
Hello, I am in a form that i filtered when i opened it. Now i want to see all the record. What should i do ? -- תודה רבה...
3 12/23/2008 12:54:01 PM
Access 2007 Hyperlinks
I have a full user database and end user version with hidden menu commands etc. In the full version right clicking on a hyperlink field gives various hyperlink options, such as Edit Hyperlink etc. but in the user version right clicking the hyperlink field only gives the Add to Favourites option. How do I hide the menu options but still allow the end user to insert or edit their own hyp...
1 12/23/2008 11:50:19 AM
Access trial activation
This may seem simple but it isn't for me. I just want to purchase the trial version of access that was installed with my MS offcie small business version. how do i do that. thanks...
2 12/23/2008 10:18:05 AM
Capturing windows messages
Hi I am sending windows message from a vb.net app to an access application using the PostMessage function which is defined as; Private Declare Function PostMessage Lib "user32.dll" Alias "PostMessageA" (ByVal hwnd As Integer, ByVal wMsg As Integer, ByVal wParam As Integer, ByVal lParam As Integer) As Integer My question is, how can I capture the message in my access app? Basically I...
4 12/23/2008 9:20:15 AM
Can my '07 Access or Excel compare values, then calculate them?
G'day folks, and happy Holidays. Man I'm glad I found you! I've been reading, searching and educating myself about my database for a few days now. And I'm making progress. Although I have been using Office for years. I have been experiencing a glitch for quite some time now... I'm using Office '07 on a good fresh install and it's working very well. What I'm trying to do; I need...
12 12/23/2008 9:19:18 AM
gert
...
1 12/23/2008 8:10:24 AM
Checking if Record Selector has the Focus
Is there a better way to check if the Record Selector has the focus? Here is how I would do it: if "Me.ActiveControl.Name" gives the error 2474 the no controls has the focus, so it must be the Record Selector. I need the Record Selector but want to prevent copy/paste from it. (I would then EmptyClipBoard) Any suggestion will be appreciated, Thanks, Michael ...
4 12/23/2008 6:17:01 AM
Split 2003 to 2007 should I convert
I designed a large database in 2000 which is split and secure. I was easily able to convert it to 2003 when our office upgraded. No everyone but me is running 2007. I can't figure out how to turn my 2003 database into a 2007. In a year, we will be switching to a different program. Is it worth it to even bother trying to switch? If I don't, will I be stuck with 2003 so that I can ma...
6 12/23/2008 5:09:43 AM
tnewman@usagencies.com
Terri What is the remote email address to access email? I can't get into my VPN tonight. Thanks Sabrina Green ...
1 12/23/2008 4:18:10 AM
Linked table manager - Replicated Database
I have a database, let's call it DB1 (Access 2000), that has been replicated in the past, and whats left is just the replicated copy of it, with no design master to be found. Now, some of the tables on this database are links to tables on another database (DB2) that i have. my problem is that i can't re-design it because it's a replica. I've tried "Recover Design Master" and got this er...
5 12/23/2008 3:13:47 AM
Retention Period
Éste es un mensaje de varias partes en formato MIME. ------=_NextPart_000_0018_01C96170.84C73910 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi! I need to change the "Retention Period" of a Replica.... URGENT = PLEASE!!!! Thanks! ------=_NextPart_000_0018_01C96170.84C73910 Content-Type: text/html; charset="iso-8859-1" Content-T...
5 12/23/2008 3:11:24 AM
Seek method after split database
I know there's a way to use the seek method after splitting the database. I've seen advice like this: "Keep in mind that Seek only works on table-type recordsets. Once you split the database in front-end and back-end, you need to have a global database object that refers to the back-end. Then you can continue to use Seek. " But I'm having trouble setting up the connection string and th...
5 12/23/2008 3:07:41 AM
Attached tables & performance question
From a performance standpoint, does it make any sense to "delete" infrequently used attached tables and only reattach them using code if they are needed for a specific form or function? My commercial application is quite large and has over 45 attached tables and it takes sometime to initially open on some of my client's systems running over a LAN. The application is split properly between ...
9 12/23/2008 2:59:04 AM
Report to auto open
I have database that has reports that show people that have expired 60 days after their start date. I would like these reports to open automatic when the database is opened only if their is people on the reports. I there a way to do this?...
4 12/23/2008 2:47:58 AM
Filter Problem
I am trying to create a filter query for a report but iy does not filter the results. I have a database with people that has to be updated 60 days from their start date. I want a filter to filter out the people who have start days were 60 days ago. I also need this in a report that will auto open when the database is first opened. But, I only need the report to auto open if there are pe...
2 12/23/2008 2:23:05 AM
FromAndriy
www ...
1 12/23/2008 2:59:38 PM
FromAndriy
qqq ...
1 12/23/2008 3:01:09 PM
reset combo box
how do you reset a combo box to its default value using a btn_click? cboEnglish.defaultvalue = ?...
2 12/23/2008 5:03:02 PM
1410 Pages: 1  2  3  4  5  6  7  8  9  10  11  12  13  14  15  16  17  18  19  20  21  22  23  24  25  26  27  28  29  30  >>  

Home | Search | Terms | Imprint Contact
Newsgroups Reader - provided by WiredBox.Net