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 have a form with one text box on it (Simple example) The code OnOpen is Private Sub Form_Open(Cancel As Integer) Me.Controls(0).ControlSource =...
Phil Stanton
12-01-2009 10:42 AM
Phil Stanton Go to last post
7 120
Using this method of creating a user login form: http://www.databasedev.co.uk/login.html is it possible to capture the username and have that...
12-01-2009 08:30 AM
Dominic Go to last post
2 106
I was wondering how a field might be updated in a form. This example is pretty stupid but let's say you had an employee form with a termination date...
12-01-2009 05:46 AM
Albert D. Kallal Go to last post
3 112
Still using AK2, I have a BE/FE database. Most of the tables are in the BE, but I have a few control tables in the FE. Until recently the FE...
Phil Stanton
12-01-2009 03:19 AM
Phil Stanton Go to last post
3 105
I have some questions on A2010 table design and wonder if you csn shed any light on them. I created a blank web database and then a table. One can...
12-01-2009 02:23 AM
Salad Go to last post
2 186
Just started using Access 2010 web forms. Am I correct that with web forms, we lose the ability to drag and drop a control into any...
Bob Alston
11-30-2009 06:39 PM
Bob Alston Go to last post
2 116
"James A. Fortune" <CDMAPoster (AT) FortuneJames (DOT) com> wrote in news:a8dd5ff2-b5de-41ac-b10b-708a9060b9f2 (AT) f10g2000vbl (DOT)...
Bob Alston
11-30-2009 04:42 PM
James A. Fortune Go to last post
26 221
"Salad" <oil (AT) vinegar (DOT) com> wrote There is 2 args, the 1st one is the variable you want set, and the 2nd arg is the...
11-30-2009 04:23 PM
David W. Fenton Go to last post
19 203
On Nov 27, 1:23*pm, "Ken Snell " <kthsneisll... (AT) ncoomcastt (DOT) renaetl> wrote: Hi Ken:
11-30-2009 01:23 PM
jeromez Go to last post
16 197
I want to cocatenate the address line for a report so that it appears in a row with no spaces. The query has this: Address: & ", " & & ", " & &...
11-30-2009 09:09 AM
gorsoft@hotmail.com Go to last post
4 79
So I have been creating classes for various controls in access and moving code that was on my forms to the classes. It's been fun and helped simplify...
11-30-2009 12:38 AM
Mat Go to last post
5 99
I'm using Access 2002 to create a snapshot using: DoCmd.OutputTo acOutputReport, strReport, "SnapshotFormat(*.snp)", strSnapshotFile It works fine...
Bob Darlington
11-29-2009 07:39 PM
Bob Darlington Go to last post
6 54
Hi all I'm sure this is a basic schoolboy error but I'm trying to use Microsoft Access Horizons 4.00h to do some accounts for a charity I am working...
11-29-2009 09:54 AM
Salad Go to last post
3 150
Can one create a string using a macro in a web form? Let's says you had 3 depts; Finance, HR, Sales. You want to create a value 1 more than the...
11-28-2009 06:01 AM
Albert D. Kallal Go to last post
5 63
On Fri, 27 Nov 2009 23:52:00 -0000, Phil Stanton wrote: That's the main reason not to use single quotes as the text delimiter. Try doubling up...
11-28-2009 05:39 AM
Phil Stanton Go to last post
1 69
In the vid Albert has on A2010, http://www.youtube.com/watch?v=AU4mH0jPntI, he placed the temp of the area on the page. How is that done? He...
11-27-2009 02:32 PM
David W. Fenton Go to last post
16 192
I have historically used a lot of relations with enforced referential integrity and cascading deletes. Can someone tell me how to convert these into...
Bob Alston
11-27-2009 02:28 PM
David W. Fenton Go to last post
24 154
Using A2003. I'm just about to start major modifications on a mdb created in 2003. There is a lot of this type of code structure (below) throughout...
11-26-2009 05:51 PM
hbinc Go to last post
6 74
I'm not near the computer that has A2010 but I was wondering...how does on set a global var for a form? In VBA, at the form's top level we...
11-26-2009 01:53 AM
Albert D. Kallal Go to last post
1 66
Please Help I have created a form that has only an Unbound Text Box and a Control Button In addition I have created many forms each with a...
11-25-2009 10:56 PM
Marshall Barton Go to last post
3 80
I have been looking for information summarizing/detailing what is new in Access 2010. I recently found this. Fairly high level but may be useful to...
Bob Alston
11-25-2009 05:41 PM
Randy Yates Go to last post
2 78
I created an app from a template. It appears VBA isn't desired like a macro. In form Main of the Issues project the macro had something like If...
11-25-2009 04:46 PM
David W. Fenton Go to last post
7 111
Hi, When i add values on a for i have been using the following syntax: = Me("txtbox-6-1") + Me("txtbox-19-1") the result is inconsistant. for...
11-25-2009 04:40 PM
bipin Go to last post
3 73
Hi, I feel like such a newbie! Sorry! But I can not figure out why a checkbox in the detail section of a form reflects any change made to it but...
11-24-2009 07:05 PM
PW Go to last post
6 150
My current security process (with A2000) involves: BackEnd: - Autoexec macro with DoCmd.Quit - All tables hidden (prevents unauthorized...
11-24-2009 11:07 AM
Sky Go to last post
3 95
I have 23 users on a WAN in 3 wide-spread geopgraphical US regions- UpstateNY, DownstateNY and New England. There is code in an A2003 app to prompt...
11-24-2009 12:34 AM
Salad Go to last post
1 99
Hi all, I'm using Access 2002. I know that uploading images directly to an OLE field within the database itself is bad for bloating issues - and I...
11-23-2009 10:34 AM
Rich P Go to last post
11 137
All, I'd like to create a switchboard that allows us to see room status.
11-23-2009 07:44 AM
paii, Ron Go to last post
3 81
Hi I'm running SQL-server 2005, and when I try to backup, I don't see any networkdrive, only C: is available. Any suggestions ? Tanx in advance ! D
11-23-2009 05:51 AM
BrianR Go to last post
3 94
I have a very strange problem which is confusing me. For several months I have provided a reporting facility via my system which uses a query (which...
Riverboat Gambler
11-22-2009 03:26 AM
Riverboat Gambler Go to last post
14 103
"Albert D. Kallal" <PleaseNOOOsPAMmkallal (AT) msn (DOT) com> wrote in news:NpQNm.26766$cd7.1630 (AT) newsfe04 (DOT) iad: I am not convinced that...
Bob Alston
11-21-2009 04:31 PM
David W. Fenton Go to last post
51 458
I have a form with 2 subforms Ė one displaying invoice headers, the other showing the relevant invoice item lines for the selected invoice header....
11-21-2009 11:14 AM
Marshall Barton Go to last post
3 120
I'm writing a training manual for the database I designed. I'd like to include a print screen including the message bar which allows you to click on...
Tomahawk Lady
11-19-2009 11:29 AM
Tony Toews [MVP] Go to last post
1 73
Currently I am getting the error, "Cannot open any more tables". I was wondering if there was some code that I can run that counts how many tables...
11-18-2009 07:22 PM
Mat Go to last post
15 251
Enhancements - Stop the user from seeing the Access 2007 Security Warning - Certain content in this database has been disabled. Set Access 2007...
Tony Toews [MVP]
11-18-2009 12:41 PM
Tony Toews [MVP] Go to last post
1 75
Hello, AfterUpdate event of ComboBox is resulting in error 7965 it is exactly in line with: "Set Me.Recordset = rs" code below Private Sub...
Maciej Franciszkowski
11-18-2009 04:35 AM
Salad Go to last post
1 89
Hi, Now it is happening to another client all of a sudden. The last one had to reinstall XP to run our Access 2003 MDE. When they click on our...
11-17-2009 03:16 PM
PW Go to last post
3 154
Hi I have a database on a network that is located in a folder that only I have rights. It is all very well but we want the others to be able...
11-17-2009 08:16 AM
paii, Ron Go to last post
3 102
Hi, I am using Access 2003 under WinXP Pro with latest updates. I am developing an application where I utilize a Calendar object extensively:...
Tim Hunter
11-16-2009 11:57 PM
Tony Toews [MVP] Go to last post
1 55
In late May and early June, I posted a flurry of activity on my work on replacing the Office FileSearch object with a class module that replicates...
David W. Fenton
11-16-2009 08:42 PM
David W. Fenton Go to last post
3 72
Hi I'd like to know which place in a query-result a peticular row takes, in order to place it versus the other rows. I want to be able to see that...
11-16-2009 02:04 PM
hbinc Go to last post
3 77
I figured that people like Albert Kallal were the beta testers of Office 2010 but it appears there's going to be a "public beta" whatever that is. ...
11-16-2009 12:06 PM
Salad Go to last post
2 72
I am using the following line to export a select query to excel DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel97, "qryJobSpareExport",...
paii, Ron
11-14-2009 08:41 PM
Tony Toews [MVP] Go to last post
1 87
"James A. Fortune" <CDMAPoster (AT) FortuneJames (DOT) com> wrote: I wouldn't call Albert an extol troll. I've met Albert a number of times. Yes,...
Bob Alston
11-14-2009 04:10 PM
Tony Toews [MVP] Go to last post
39 269
Hi all I'm importing a txt-file to an SQL-server db via Access (linked files). I therefore use ado, with of course the addnew method of a recordset...
11-13-2009 02:43 AM
The Frog Go to last post
3 122
I have an autonumber field to generate a REF. I need to copy my table because of problem but when I do this I loose my auto-number ref, how can I...
11-13-2009 02:22 AM
hbinc Go to last post
3 83
Hi, Iím using access 2007. I would like to use one of my reports as the body of an outlook 2007 email message. Iím able to export the report as an...
11-12-2009 11:46 PM
Tom van Stiphout Go to last post
1 75
I have this pretty big dataset and output 70+ csvs to a charting program twice a year ... be lovely to loop through the dataset to output my text...
11-12-2009 06:25 PM
Chuck Grimsby Go to last post
2 63
I have tried several things but am not able to blank out the rowsource of a sub-form when the form closes. Please help. Its urgent.
11-11-2009 04:02 PM
Tony Toews [MVP] Go to last post
13 137
Thanks for any help on this. I have about 150 tables with the same datatypes and field names. I would like to, on a regular basis, create (or...
11-11-2009 09:31 AM
Salad Go to last post
6 63
Post New Thread

Display Options
Showing threads 2301 to 2350 of 35152
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.