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...

Dominic

12-01-2009 08:30 AM
Dominic

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...

Salad

12-01-2009 05:46 AM
Albert D. Kallal

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

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...

Salad

12-01-2009 02:23 AM
Salad

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

"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

"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...

Salad

11-30-2009 04:23 PM
David W. Fenton

I have a database that has multiple users. The purpose of the database is for users to access data and export to excel. I seldom have to touch this...

Coll

11-30-2009 03:48 PM
Coll

On Nov 27, 1:23*pm, "Ken Snell " <kthsneisll... (AT) ncoomcastt (DOT) renaetl> wrote: Hi Ken:

jeromez

11-30-2009 01:23 PM
jeromez

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: & ", " & & ", " & &...

gorsoft@hotmail.com

11-30-2009 09:09 AM
gorsoft@hotmail.com

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...

Mat

11-30-2009 12:38 AM
Mat

I created a web form and dropped a command button onto the form. There is the ability to send an email via a macro. Can that be used on the web or...

Salad

11-29-2009 11:28 PM
Salad

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

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...

Tony

11-29-2009 09:54 AM
Salad

I have a main form for data entry with too many fields to show on one page so have created a tab page (12 in total) for each product type selected in...

gorsoft@hotmail.com

11-29-2009 06:41 AM
gorsoft@hotmail.com

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...

Salad

11-28-2009 06:01 AM
Albert D. Kallal

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...

fredg

11-28-2009 05:39 AM
Phil Stanton

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...

Salad

11-27-2009 02:32 PM
David W. Fenton

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

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...

emanning

11-26-2009 05:51 PM
hbinc

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...

Salad

11-26-2009 01:53 AM
Albert D. Kallal

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...

Ponty

11-25-2009 10:56 PM
Marshall Barton

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

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...

Salad

11-25-2009 04:46 PM
David W. Fenton

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...

bipin

11-25-2009 04:40 PM
bipin

There aren't any books out yet on A2010 so learning seems to be by trial by error, at least in my case. There are some vids on YouTube that provide...

Salad

11-25-2009 02:23 PM
Salad

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...

PW

11-24-2009 07:05 PM
PW

My current security process (with A2000) involves: BackEnd: - Autoexec macro with DoCmd.Quit - All tables hidden (prevents unauthorized...

zuckermanf@gmail.com

11-24-2009 11:07 AM
Sky

I need to connect to a SharePoint List in another domain from Microsoft Access 2007. When I click on the table it prompts me to put in my user ID and...

musicloverlch

11-24-2009 09:25 AM
musicloverlch

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...

isobadd

11-24-2009 12:34 AM
Salad

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...

Davo

11-23-2009 10:34 AM
Rich P

All, I'd like to create a switchboard that allows us to see room status.

steve1040

11-23-2009 07:44 AM
paii, Ron

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

Daedalus

11-23-2009 05:51 AM
BrianR

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

Dear reader, I now confronted with the following effect. There are three forms: Form-1 mainform, Form-2 sub and Form-3 sub in Form-2. Form-1...

Simon

11-21-2009 04:54 PM
Simon

"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

I have a form with 2 subforms – one displaying invoice headers, the other showing the relevant invoice item lines for the selected invoice header....

gorsoft@hotmail.com

11-21-2009 11:14 AM
Marshall Barton

Dear reader, I now confronted with the following effect. There are three forms: Form-1 mainform, Form-2 sub and Form-3 sub in Form-2. Form-1...

Simon

11-21-2009 08:52 AM
Simon

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]

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...

Mat

11-18-2009 07:22 PM
Mat

Hey, Windows Server 2008 standard Remote desktop on a access 2003 database having linked tabels sometimes (!) triggers diskerror opening a linked...

Filips Benoit

11-18-2009 01:07 PM
Filips Benoit

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]

We at Nob Hill Software are working on a new query tool: http://www.nobhillsoft.com/MarieAlix.aspx?HeardVia=ptut You can read all about it on...

Mia

11-18-2009 09:36 AM
Mia

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

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...

PW

11-17-2009 03:16 PM
PW

I want Access to read the fresh part of an email but not the old replied content. What i mean is I want Access to only read the 'fresh' part of...

shanq

11-17-2009 08:38 AM
shanq

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...

kalle

11-17-2009 08:16 AM
paii, Ron

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]

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

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...

Daedalus

11-16-2009 02:04 PM
hbinc