Hello, I'm looking for video instruction on Access 2007. Is the package marketed by TrainSignal helpful? Can anyone recommend a video based upon...

Graeme

Today 05:55 AM
Jens Schilling

I had an existing report but very slow to open. This is a payroll program. Here's what I did. On this report will display all the employees by...

Jake Abella

Today 01:13 AM
Jake Abella

I'm using the DCount function in VBA. I need some other pair of eyes to locate my problem in the WHERE clause portion. Below is one statement of the...

whiz

Today 01:00 AM
Allen Browne

I generally set this to true for all fields other than fields that I specify as required. Considering the default value is false I am wondering if...

Mat

Yesterday 11:19 PM
Albert D. Kallal

In a bill of materials table I have references like C1, C2 ... C10, C11..C100 etc. Sorting the ref. field looks like this C1 C10 C100 C11 ... C19 C2

Lars P. Magnussen

Yesterday 05:23 PM
hbinc

Hi all, When opening a form there appears to me to be two ways to do so: Option 1: docmd.openform "Form1" Option 2: dim frm as Form set frm = New...

Mat

Yesterday 01:52 PM
David W. Fenton

I need to print checks from an Access 2000 database (can be updated if needed). If someone is doing this, can you share information on how you handle...

Karl

Yesterday 10:13 AM
Karl

Any help will be appreciated greatly. How to use Microsoft Visual Basic to make a form from an existing table? A sample of such VB program will be...

Barry

Yesterday 09:36 AM
Barry

Hi NG Access2003 I have a database, which include displayed an image in a form ... The pictures are too large (mb) ... I want them in new sizes, and...

bsn

03-12-2010 05:25 PM
bsn

"Albert D. Kallal" <PleaseNOOOsPAMmkallal (AT) msn (DOT) com> wrote in news:aoGln.9196$NH1.429 (AT) newsfe14 (DOT) iad: Java and JavaScript are two...

Salad

03-12-2010 11:06 AM
David W. Fenton

For systems you build, when presenting forms where data can be viewed and, for authorized users, edited. Do you present the form in read only mode...

Bob Alston

03-12-2010 10:41 AM
hbinc

Hi Everyone, I am trying to decide how to approach a design problem. The scenario is that there is a data warehouse using Oracle that contains...

The Frog

03-12-2010 09:57 AM
Roger

Might be an easy question, but how do I return all records which have empty cells for the specified FIELD Example: Name School Home ...

Chris

03-11-2010 10:10 AM
Rich P

I recently upgraded a 2003 mdb to a 2007 accdb. There is one form in this accdb that causes 2007 to crash after it closes and compacts. (the...

emanning

03-11-2010 08:48 AM
Allen Browne

Using A2007. I've got an accdb that links reasons given for treatment refusal to a list of patients. Currently the reasons are numbered 1 thru 70. ...

emanning

03-10-2010 05:39 PM
Salad

we are running access97 through citix as a softgrid package we have a specific continuous that, for some users, refreshes itself so slowly that you...

Roger

03-10-2010 01:37 PM
David W. Fenton

I am attempting to reduce the number of harddisk writes I make into a mdb file. Currently, I insert roughly 10,000 rows of data on a daily basis...

Bob Barker

03-10-2010 01:02 PM
Bob Barker

I have re-written this stupid dlookup a million times and it always says #Error and I am going crazy. Please help. I have an Integer field called...

musicloverlch

03-10-2010 10:44 AM
fredg

I've got a query returning dept employee details which is used to create a report, where I'm grouping on department and employee the groupings each...

Roger

03-09-2010 09:59 AM
Salad

I have a continuous form where the first field in the form is a serial number. It starts with 1 and increments each time a new record is added. I...

clk

03-09-2010 09:17 AM
James A. Fortune

Hi All, First, I did a search here but didn't find anything that was prudent so, In AccessXP I have a continuous form setup as a filter by form...

bobh

03-08-2010 08:22 AM
bobh

Hi, I want to print only a string but I can't find the method. My code is: Dim s as String Dim p As Printer For Each p In Printers

Marc

03-08-2010 01:54 AM
Marc

In my department, we have new employees who get the departmental A2k3 application thru a "Q Setup" Install program. When the app is being installed...

isobadd

03-08-2010 12:08 AM
Salad

I downloaded InetTransferLib.mda add in by Dev Ashish. I want to use it with Access 2007 but could not load the library using add in manager. The...

Lou O

03-06-2010 07:57 PM
Lou O

I have recently converted an Access 2000 database to Access 2007 and I am now having problems switching between edited records. DB has multiple forms...

alches

03-06-2010 07:39 PM
Albert D. Kallal

Do you provide all source code (MDB) to client where you have custom developed software? Let's say you custom built software in Access/VBA and then...

Bob Alston

03-06-2010 03:04 AM
Jim Devenish

Hi all, Is there a possibility to auto-restart an application (e.g. when an error occurs ??) Explanation: I have a unattended application (24 x 7)...

Arno R

03-05-2010 01:39 PM
Arno R

Strange issue with lock files. Database is split front end with multiple back ends. When users log out of the database, the following situation...

John von Colditz

03-05-2010 08:40 AM
John von Colditz

How do I hide or turn off the "Acrobat" Tab in access 2007 using codeing in access when I start an database(.mdb) and it opens a custom form.. The...

slc@cfl.rr.com

03-05-2010 07:10 AM
slc@cfl.rr.com

I'm trying to make all my foreign currency fields invisible if the field "Forex?" is selected as "No". Can this be done without VB? I tried writing...

Parag

03-04-2010 06:37 PM
Phil

I have 2 virtuall identical Dbs in AK2, 1 called Clubs and the other Donations. If I make MDE files of both of them and open a form called...

Phil

03-04-2010 06:12 PM
Phil

Using vbscript w/ MsAccess, I am trying to update a column that is a numeric data type, where i have one sql statement in my script that works...

chumley

03-04-2010 02:21 PM
Rich P

Hi Everyone, Just wanting some feedback or ideas on approaching a problem. What I would like to do is to migrate an Access FE away from and Access...

The Frog

03-04-2010 08:25 AM
The Frog

Any suggestions for training, tutorials or books for access system administrator training? I built a system for a nonprofit here. He has about 40...

Bob Alston

03-03-2010 10:46 AM
Bob Alston

Hi All, I have lost the source of my MDE project and I was wondering if it is possible to Reverse Engineering the MDE file to the MDB... surfing...

Vit

03-03-2010 10:11 AM
Lars Brownies

Hi all, Some background: we have a windows application (c#) that locate in the system try. that simple application is a basically shortcuts manger...

teldan

03-03-2010 09:47 AM
James A. Fortune

I opened a query in an Access 2003 db that I haven't used in a while. In the design view, I can see all the tables, but I can't see the "field list"...

Coll

03-03-2010 08:10 AM
Coll

G'day Everyone, I have a couple if situations in my database where data is being entered into a subforms. There is two similar situations I'm...

elias

03-02-2010 09:30 PM
Tom van Stiphout

I have had a problem with WU and my Vista driven laptop. I wonder if a kind MVP would point me at an appropriate NG where I can describe the problem...

Peter James

03-02-2010 10:39 AM
Peter James

I have several charts on a report and at the moment each chart has an improvised "title" immediately above it that is in actual fact a textbox that...

Wayne

03-01-2010 09:55 PM
Wayne

Hello I have a MS Access 2003 db - back end and front end on a drive called I: in our department. Some staff had letter "I" used for...

Galka

03-01-2010 09:01 PM
StevoAUST

I am not aware of such but if there is such, maybe someone will enlighten me. I only know of vba code - which I have - to show who is connected. ...

Bob Alston

03-01-2010 07:13 PM
(PeteCresswell)

I have a database that is used to track defective parts being returned from our customers. These parts have a warranty of 15 months from...

Del

03-01-2010 06:10 PM
Del

Hi, As I move away from Access97 and towards Access2007 and beyond, I have to replace some of my well-worn developer tools. One that I really like...

RonG

03-01-2010 04:56 PM
Sky

hi i have several textboxes on a form txtdate (unbound) control source =date() and formatted as yyyy only the year required txtholddate (bound)...

kevcar40

03-01-2010 02:08 PM
kevcar40

Hi All, In AccessXP I have a continious form bound to a table that has 3 fields, the first field name Question and the second field name is QAns...

bobh

03-01-2010 01:14 PM
Salad

I have a database that is used to track defective parts being returned from our customers. These parts have a warranty of 15 months from...

Del

03-01-2010 12:55 PM
paii, Ron

Hi All, I need to use MS Access to monitor a folder and create a task if a new file is received in any sub folder or sub sub folder of the...

musicloverlch

03-01-2010 10:51 AM
bobh

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

Mia

03-01-2010 07:38 AM
Mia

Do you know that you can find solar cells for less than 1 USD per Watt on www.ebay.com ? Regards.

..

02-28-2010 04:13 AM
..