dbTalk Databases Forums  

Sponsored Links


comp.databases.ms-access comp.databases.ms-access


Discuss in the comp.databases.ms-access forum.



Post New Thread
Threads in Forum : comp.databases.ms-access Forum Tools
  Rating Thread / Thread Starter Last Post Reverse Sort Order    Replies         Views     
I'm linking Access to Outlook, the system automatically generated a link table called "inbox" which I can't modify anything inside, seems like a...
shanq
11-02-2009 02:50 PM
shanq Go to last post
1 69
I have a form which has 2 dropdowns that the user needs to select. One is on Year and the other "Active or not". The 2nd dropdown has 3 options -...
Arlette
11-02-2009 11:46 AM
Salad Go to last post
13 129
I have a search screen in MS Access 2003, with a unbound text box to put in the parameter to search. I need to have all the text boxes in the...
Arlette
11-02-2009 06:42 AM
Arlette Go to last post
6 67
I am using Access 2007 and am puzzled by the form and report design tab. No matter what I do the gridlines group remains greyed out (disabled) Has...
Lou O
11-01-2009 12:42 AM
James A. Fortune Go to last post
5 90
Hi Everyone, I am trying to find out if anyone has had any issues with Access applications / Jet databases on 64bit Windows platforms. I am...
The Frog
10-31-2009 11:54 PM
Tony Toews [MVP] Go to last post
32 285
"David W. Fenton" <XXXusenet (AT) dfenton (DOT) com.invalid> writes: Knock yourself out. -- Randy Yates % "Watching all the...
Randy Yates
10-31-2009 07:32 PM
Randy Yates Go to last post
11 235
Usually a subform's recordsource grabs ALL records it needs and then the filter established by the Link Master/Child fields is applied. However, the...
Randy Yates
10-30-2009 03:36 PM
David W. Fenton Go to last post
12 166
I am trying to email a personal invoice to our members. I can generate a PDF file of the invoice OK for each person and I can email them something as...
Phil Stanton
10-30-2009 02:04 PM
Phil Stanton Go to last post
2 113
Using A2003. I'm using the coding below to look up AmountReceived for a certain date: strExpr = "AmountReceived" strDomain =...
emanning
10-30-2009 10:13 AM
emanning Go to last post
2 98
I have a Color picker to lookup color numbers to be kept in fields - I give access to the Color Picker via a button, whn the user has selected a...
Malcolm Hind
10-30-2009 10:04 AM
Steve Go to last post
4 73
I have a form listing Part Number and Part Desciption. PartNo is a small field and description is a wide field. So I wanted my heading to look...
Salad
10-28-2009 08:14 PM
Salad Go to last post
4 52
Hi all, I want to dump some data in XLS without the table header information. Information on the docmd.TransferSpreadsheet Action is telling me...
Mat
10-28-2009 05:21 AM
Mat Go to last post
2 86
I am trying to create an SQL statement in code to insert a record with 30 fields into another table with the same properties. The problem is that...
Lou O
10-27-2009 08:43 PM
Lou O Go to last post
2 77
Hi - I am trying to get a report that will show 12 months of data for a Department (or less if fewer than 12 months are on file), BUT the user is...
sara
10-27-2009 07:03 PM
sara Go to last post
27 170
I'm trying to update a table using as criteria selections made on a form with a combo box and a multi select listbox (lstproducts). The combo box...
Gordon
10-27-2009 10:08 AM
Gordon Go to last post
2 66
A new user loaded my program onto her computer and began entering data. A number of macros had already run successfully before she got to one that...
Tomahawk Lady
10-27-2009 07:24 AM
Tomahawk Lady Go to last post
1 43
I've set the record source of a subform to be a SELECT TOP N query. The problem is that Access appears to perform the TOP N before the implied WHERE...
Randy Yates
10-26-2009 12:28 PM
Krzysztof Naworyta Go to last post
3 67
I am wondering what methodology you use, if you use FindFirst, to find exact matches in a string. If one uses linked tables, one can't use...
Salad
10-26-2009 08:26 AM
hbinc Go to last post
3 81
Dear reader, In a datasheet form you have the possibility to set the field property Enabled to No. With this property you lock the field to...
Simon
10-26-2009 05:02 AM
Phil Stanton Go to last post
1 73
Hi, This must be a problem which lots of people get on a daily basis, but so far I haven't been able to find a solution. I am using Access 2003 as a...
Bobby
10-24-2009 07:15 PM
Chuck Grimsby Go to last post
6 66
I have HTML color codes stored in fields - how do I convert these to accurate Access color codes that can be used to set background colors to Access...
Malcolm Hind
10-24-2009 07:02 PM
Chuck Grimsby Go to last post
4 78
I need some advice on the design for a sales lead database. I have 4 tables (salespersons/products/postcode area covered/sales leads). Each...
Gordon
10-23-2009 07:15 PM
Gordon Go to last post
7 125
Perhaps some will find the following useful. With more and more date fields showing up on forms lately, I decided to try to come up with a better...
James A. Fortune
10-23-2009 03:26 PM
James A. Fortune Go to last post
5 69
I have a Report that contains a column of percentages (one at the end of each of the six rows). I have the Percentages Total textbox at the bottom...
zufie
10-23-2009 12:33 PM
paii, Ron Go to last post
8 62
I have an A2000 mdb that works OK on one computer. I have transferred the mdb to a second computer and all is good except that when I click the...
Karl
10-23-2009 11:28 AM
Karl Go to last post
2 64
HI All, My company is switching from Groupwise to Outlook 2007 and so I need to change/test all my applications that have email functionality...
bobh
10-22-2009 09:51 PM
Lou O Go to last post
6 87
Hi I am interfacing an Access database to an SMS gateway and wanted to display the length of the SMS body as the user inputs it. I have tried to...
John Paterson
10-22-2009 09:36 PM
Lou O Go to last post
1 58
Hi, I have been trawling round the net trying to find an answer to this, but all the solutions I have found so far have given me errors. I have a...
Kroaky
10-22-2009 09:01 PM
Allen Browne Go to last post
14 114
Hello, I have a continuous subform within a form. Behind a button on the form, I included validation checks to ensure that various fields (on both...
Odd
10-22-2009 05:34 PM
Odd Go to last post
2 90
I am working with an ocx control, that refuses to be instantiated directly through code. So, I thought I would employ a little "workaround." I...
Vincent
10-22-2009 11:26 AM
Vincent Go to last post
3 69
We have an MDB that will need to impersonate a system user rather than the user using it. IT will assign the security groups surrounding...
Bob
10-22-2009 10:44 AM
Bob Go to last post
4 80
Hi everyone, I'm trying to write a past append qry and as this is the first time I've had a go at it, I think I am way off the mark. I've got two...
Stinky Pete
10-21-2009 08:17 PM
Stinky Pete Go to last post
3 128
Hi, I am using the dynaPDF solution for printing reports to PDF documents. On my own machine using the full Access 2003 it works fine. However, on a...
franc sutherland
10-20-2009 04:38 AM
franc sutherland Go to last post
6 94
Access 2003 Listbox.AddItem w / 5 Columns Is Incredibly Slow As one can see from the function / code below I create a recordset with 5 returned...
JustBoo
10-19-2009 07:46 PM
rquintal@sympatico.ca Go to last post
1 74
Hi - I haven't done anything in Access in a few years now and I'm blocked! I hope someone can help. I have data in a table: Key AccountNumber...
sara
10-19-2009 07:33 PM
sara Go to last post
16 264
I have a CrossTab query that needs to use some values from a Form in its Where clause: TRANSFORM Sum(ContractProfitsTaken.ProfitTaken) AS...
Jim Devenish
10-19-2009 12:26 PM
fredg Go to last post
1 47
After upgrading to 2007 i get a Query is too complex error on one of my queries. Here is the SQL statement. SELECT ProjectSnapshot.WBSID,...
koturtle
10-19-2009 11:01 AM
Milhouse Van Houten Go to last post
16 141
I have a problem with an Access 2002 db deployed in an Access 2003 environment. I can change the permissions for tables for individual users, but not...
Bob Darlington
10-18-2009 10:01 PM
Bob Darlington Go to last post
3 92
I am using an external linked GIF file as the picture on an image control Does anyone know the code to print this image (probably to the...
Phil Stanton
10-16-2009 05:48 PM
Phil Stanton Go to last post
4 88
I'm trying to export a query to excel file using VBA. I can export the data only once, successfully. The code runs fine every 1st time after reopen...
shanq
10-16-2009 02:14 PM
MGFoster Go to last post
1 68
Hi, I have a purchase order table that has a yes/no tick which triggers an add as asset form. At this point other detail such as serial number of...
don
10-16-2009 02:10 PM
Salad Go to last post
1 74
Access 2007 running on Windows XP. Report is a multipage letter format and Access is not handling paging correctly when a text field, which can span...
bontemps
10-16-2009 12:59 PM
bontemps Go to last post
2 98
I have a table containing profits taken (transferred) from contracts. There is either zero or one entry per month for a contract. The day of the...
Jim Devenish
10-16-2009 12:11 PM
Jim Devenish Go to last post
4 70
Access 2003 SP3, Windows XP Pro, FE/BEs on a LAN. The Macro Security Level is set to low in our applications. An interesting find that may prove...
Bob
10-16-2009 09:46 AM
Bob Go to last post
2 69
Hi, Instead of hard coding the actual name of the menu, how would I scan through a table or query replacing the references in the following code...
PW
10-15-2009 06:47 PM
PW Go to last post
4 85
Hello All I have the following code which I am using to dynamically change sub- reports on a master report. Do Until rs.EOF ReportToPrint =...
Trevor
10-15-2009 04:28 PM
Trevor Go to last post
5 73
I self taught myself enough to create a database for keeping track of stock transactions some time ago. It's worked fine for probably more than year...
Gord
10-15-2009 12:07 PM
timmg Go to last post
1 51
In AccessXP I use the following vba code to email a message thru GroupWise, the company I work for is changing to Outlook and I need to re-write this...
bobh
10-15-2009 11:09 AM
bobh Go to last post
2 103
Hello, I'd like to put security type tables in a small separate database instead of where the rest of the data is located (in case either...
PW
10-15-2009 12:42 AM
Tom van Stiphout Go to last post
1 73
Hi Everybody Access 2007 I have a form based on a query that does NOT include the primary key autonumber And I am trying to use the "Duplicate"...
bobdydd
10-14-2009 06:55 PM
Marshall Barton Go to last post
3 60
Post New Thread

Display Options
Showing threads 2451 to 2500 of 35231
Sorted By Sort Order
From The
Forum Tools Search this Forum
Search this Forum :

Advanced Search

New posts New posts More than 15 replies or 150 views Hot thread with new posts
No new posts No new posts More than 15 replies or 150 views Hot thread with no new posts
Closed Thread Thread is closed  
 
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off


Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.