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 linked a speadsheet in an app and opened it and noticed I had some #Num! cells. I guess that called to my attention that there were number and...
11-04-2009 12:37 PM
Salad Go to last post
6 77
Any suggestion on the following would be greatly appreciated: I was working on a database in MS Access and I have encountered an issue I need your...
11-03-2009 07:17 AM
paii, Ron Go to last post
3 108
I know this group is for helping in use of the access but hoping to find some help on installing '97. Recently purchased laptop w\ XP Home. Have...
11-02-2009 04:17 PM
doncee Go to last post
7 105
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...
11-02-2009 01:50 PM
shanq Go to last post
1 72
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 -...
11-02-2009 10:46 AM
Salad Go to last post
13 134
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...
11-02-2009 05:42 AM
Arlette Go to last post
6 74
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
10-31-2009 11:42 PM
James A. Fortune Go to last post
5 95
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 10:54 PM
Tony Toews [MVP] Go to last post
32 303
"David W. Fenton" <XXXusenet (AT) dfenton (DOT) com.invalid> writes: Knock yourself out. -- Randy Yates % "Watching all the...
Randy Yates
10-31-2009 06:32 PM
Randy Yates Go to last post
11 262
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 02:36 PM
David W. Fenton Go to last post
12 202
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 01:04 PM
Phil Stanton Go to last post
2 116
Using A2003. I'm using the coding below to look up AmountReceived for a certain date: strExpr = "AmountReceived" strDomain =...
10-30-2009 09:13 AM
emanning Go to last post
2 118
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 09: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...
10-28-2009 07:14 PM
Salad Go to last post
4 57
Hi all, I want to dump some data in XLS without the table header information. Information on the docmd.TransferSpreadsheet Action is telling me...
10-28-2009 04:21 AM
Mat Go to last post
2 89
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 07: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...
10-27-2009 06:03 PM
sara Go to last post
27 185
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...
10-27-2009 09:08 AM
Gordon Go to last post
2 70
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 06: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 11:28 AM
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...
10-26-2009 07: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...
10-26-2009 04:02 AM
Phil Stanton Go to last post
1 75
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...
10-24-2009 06:15 PM
Chuck Grimsby Go to last post
6 69
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 06:02 PM
Chuck Grimsby Go to last post
4 87
I need some advice on the design for a sales lead database. I have 4 tables (salespersons/products/postcode area covered/sales leads). Each...
10-23-2009 06:15 PM
Gordon Go to last post
7 134
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 02:26 PM
James A. Fortune Go to last post
5 75
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...
10-23-2009 11:33 AM
paii, Ron Go to last post
8 70
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...
10-23-2009 10:28 AM
Karl Go to last post
2 68
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...
10-22-2009 08:51 PM
Lou O Go to last post
6 93
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 08: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...
10-22-2009 08:01 PM
Allen Browne Go to last post
14 115
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...
10-22-2009 04:34 PM
Odd Go to last post
2 91
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...
10-22-2009 10:26 AM
Vincent Go to last post
3 71
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...
10-22-2009 09: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 07:17 PM
Stinky Pete Go to last post
3 134
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 03:38 AM
franc sutherland Go to last post
6 109
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...
10-19-2009 06:46 PM
rquintal@sympatico.ca Go to last post
1 104
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...
10-19-2009 06:33 PM
sara Go to last post
16 313
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 11:26 AM
fredg Go to last post
1 48
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,...
10-19-2009 10:01 AM
Milhouse Van Houten Go to last post
16 169
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 09:01 PM
Bob Darlington Go to last post
3 98
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 04:48 PM
Phil Stanton Go to last post
4 98
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...
10-16-2009 01:14 PM
MGFoster Go to last post
1 73
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...
10-16-2009 01:10 PM
Salad Go to last post
1 75
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...
10-16-2009 11:59 AM
bontemps Go to last post
2 104
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 11:11 AM
Jim Devenish Go to last post
4 74
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...
10-16-2009 08:46 AM
Bob Go to last post
2 72
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...
10-15-2009 05:47 PM
PW Go to last post
4 87
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 =...
10-15-2009 03:28 PM
Trevor Go to last post
5 75
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...
10-15-2009 11:07 AM
timmg Go to last post
1 51
Post New Thread

Display Options
Showing threads 2451 to 2500 of 35234
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 - 2015, Jelsoft Enterprises Ltd.