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     
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 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...
10-22-2009 10: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...
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 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 03: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...
10-19-2009 06: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...
10-19-2009 06:33 PM
sara Go to last post
16 261
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 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,...
10-19-2009 10:01 AM
Milhouse Van Houten Go to last post
16 137
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 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 04: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...
10-16-2009 01: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...
10-16-2009 01: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...
10-16-2009 11:59 AM
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 11:11 AM
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...
10-16-2009 08: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...
10-15-2009 05: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 =...
10-15-2009 03: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...
10-15-2009 11:07 AM
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...
10-15-2009 10: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...
10-14-2009 11:42 PM
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"...
10-14-2009 05:55 PM
Marshall Barton Go to last post
3 60
Using A2003. I've got a 2-page report with several totals in the report footer. The totals preview and print just fine when printing both pages but...
10-14-2009 03:48 PM
emanning Go to last post
2 61
In previous version os Access, there was a Duplicate command on the Edit menu. It could also be called by hitting Ctrl-D. If you were in form or...
10-14-2009 03:34 PM
Marshall Barton Go to last post
1 76
For the moment, Google Search is finding old posts. Thanks Google. Does anyone sell a searchable archive of this NG? If not, it's ironic that no...
James A. Fortune
10-14-2009 12:50 PM
bobh Go to last post
1 54
I keep getting this error Run time error 2501 This SendObject action was canceled. This is my code: Private Sub cmdMailTicket_Click() On Error...
10-14-2009 12:19 PM
shanq Go to last post
4 56
I'm working on a legacy app that uses separate date and time fields. Yet, they should probably be combined -- especially now that I need to do a...
10-13-2009 08:04 PM
Jeff Norville Go to last post
1 70
I am trying to apply conditional formatting. i have to use code since i have 10 different conditions. basically, i want to change the color of the...
Gaby Sandoval
10-13-2009 08:43 AM
Marshall Barton Go to last post
4 69
Is there a way of forcing the Wizards to write code rather than macros?
10-12-2009 10:04 AM
anthony Go to last post
2 90
I have a table set up like this ClassID (pk) ClassName ParentClassID And of course another like this ItemID (PK) ClassID (FK)
10-12-2009 09:57 AM
Phil Stanton Go to last post
7 78
I have some clients (there are about six team members) working on an Access 2003 Front End which is connected by a WAN to an Access 2003 Back End...
10-12-2009 08:14 AM
James A. Fortune Go to last post
26 158
Hello I use this code to change visible true/false of some controles in my workbook. I get SheetName, ShapeName and true/false (0 or -1) from...
10-11-2009 04:45 PM
fredg Go to last post
1 59
Dear reader, By linking tables to a back-end database on a server as the database is already linked to an other front-end I have the experience that...
10-10-2009 08:48 AM
AKN_39 Go to last post
1 75
How do I disguise what users are entering in a text box? I want to have a password field but not have whatever is typed to appear...
10-09-2009 09:16 PM
PW Go to last post
2 73
I have worked on a lot of databases but never had to worry much on security. Now they want a database that Admin(me) can see everything and...
10-09-2009 02:49 PM
Albert D. Kallal Go to last post
2 78
I keep getting an error: run-time error '2185' "you can't reference a property or method for a control unless the control has the focus." There is...
10-09-2009 01:13 PM
shanq Go to last post
1 44
hi folks, long time no see but still slogging away, thanks to the Cravens and Brownes and particularly Seaches of this world .... One of those...
10-08-2009 05:33 PM
Allen Browne Go to last post
5 99
I've found several posts regarding the Maximum number of allowable fields in Access97 (which is 255), but I've been unable to find the same...
10-08-2009 01:34 PM
Takeadoe Go to last post
2 65
I created a form that contains 1 subform ( lets call it lvl 1 subform) in which I created another subform( lvl 2 subform). lvl 1 subform acts like a...
10-07-2009 10:17 PM
shanq Go to last post
4 84
Using A2003. I've created an update query to update a row in a table. The SQL to update the table is here: UPDATE tblPeople INNER JOIN...
10-07-2009 10:17 AM
Rich P Go to last post
5 62
I put a new directory and an undated database2( 2 for reference) in our network directory. When someone opens database1 they see a previous version...
10-07-2009 09:31 AM
sparks@home.com Go to last post
3 58
Now I have a Treeview form set up, works great. I can view parents and children, but only view. Now I want to expand the function a little bit. I...
10-07-2009 03:59 AM
hbinc Go to last post
3 59
How do you hide or edit Record button in Form? http://www.mypicx.com/uploadimg/41128670_10052009_1.bmp Thanks, Shanq
10-06-2009 09:56 AM
Krzysztof Naworyta Go to last post
3 66
Hi, I have a program that prints on Cheques (Check). The problem now is that they have to type in the Value in numbers and words. I want to be able...
10-06-2009 04:49 AM
Hank Go to last post
5 65
Hello, I'm trying to use Microsoft Access 2007 in Windows XP SP2 to access a certain real estates website and extract certain transaction records...
10-06-2009 12:26 AM
lyle fairfield Go to last post
2 60
Hi, I have a employee database and it tracks time off. Occasionally employees change their last names (marriage) is there a way to have the...
10-05-2009 09:17 PM
DeZZar Go to last post
4 78
hi, i've an application in converted into ac2003 and mad in Ac2000. It did work without a problem for several months after conversion....
10-05-2009 03:59 PM
Georg Go to last post
2 66
Hi, I know in VB you can create an group of controls with the name's txtBox(0), txtBox(1), txtBox(2) ..etc is this same type of naming convention...
10-05-2009 02:32 PM
hbinc Go to last post
7 103
I want to try to use the SQL upsizing wizard in Access2007 so I downloaded and installed SQL server express (with .NET framework etc). SQL took a...
Lou O
10-05-2009 07:58 AM
Lou O Go to last post
4 77
I tried to return a value to main form by using control like"Forms! ! " but it didn't work. should I use Afterupdate? Thanks, Shanq
10-04-2009 08:25 AM
Roger Go to last post
3 93
Post New Thread

Display Options
Showing threads 2451 to 2500 of 35204
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.