My database has a main table with 'Workshop Jobs in Progress' information. The main table for this is to be setup and maintained by an administrator....

Samuel

12-02-2008 11:53 AM
Phil Stanton

Thank you for your time to answer. I am afraid I don't quite understand you suggestion. Could you explain it to me, please?

zyzolus

12-02-2008 11:37 AM
Roger

I can't get my MS Access table to return the correct result from this SQL query. Namely the query returns one calorie value greater than 50! Here's...

zufie

12-01-2008 02:55 PM
Rich P

Why do my Forms/Subforms in my MS Access Database not appear? All I see is the boxes where they should show?! What did I do wrong? Thanks, John

zufie

12-01-2008 10:36 AM
zufie

Hi, I have an Access 2003 app which I am developing on one pc (mine) and continually testing on another (the client's.) Both are running...

Jim Franklin

12-01-2008 09:40 AM
Jim Franklin

I have code that works for a Report from a selection form, but this code includes an OpenArgs=strDescrip in the Where Condition. As far as i can...

micarl@gmail.com

12-01-2008 09:13 AM
paii, Ron

There are 2 tables with fields shown below. *** tbl_Employees *** idEmployee (pk) last_name first_name *** tbl_Tasks *** idTask...

zyzolus

11-30-2008 01:54 PM
zyzolus

"David W. Fenton" <XXXusenet (AT) dfenton (DOT) com.invalid> wrote: Exactly. I'd also forgetten about adding that if the original poster wants to...

josette@shaw.ca

11-30-2008 10:56 AM
josette@shaw.ca

Wikipedia reports "The first version of Jet was developed in 1992, consisting of three modules which could be used to manipulate a database. Anyone...

MLH

11-30-2008 03:55 AM
MLH

Office 97 ODBC Driver Vulnerability Security Update Anyone recall issues running this update to office 97? Doesn't seem to wanna install on win xp...

MLH

11-30-2008 03:46 AM
MLH

I'm setting up users on a terminal services box (windows 2003) with an Access 2003 application. For each of these users, the first time they run the...

winterfish

11-28-2008 04:13 PM
winterfish

Has anyone got some code for reading which printer is the default, or simply setting the printer to default? Thanks John Fox

John Fox

11-28-2008 10:35 AM
John Fox

One of the fields in a query I'm trying to run is the following: iif(. IS NULL,'C',iif(instr(1,.,'-')>0,B,A)) AS ABC, Well, ABC winds up with...

eddo

11-28-2008 08:37 AM
ChrisHulan

I have a table of records that could be grouped by the field APN. This is one-to-many, with the 'many' being anwhere from 1 to about a hundred...

eddo

11-27-2008 05:26 PM
Bob Quintal

I'm using Access 2003 and my database is an MDB, not an ADP. SQL Server is not an option. I would like to programmatically create an ADO recordset...

Composer

11-27-2008 01:18 PM
rkc

I have a split application in A2k3 called "SIMS". We use it for a variety of tracking purposes throughout the various regions of the...

Earl Anderson

11-27-2008 06:52 AM
banem2@gmail.com

I am using the TransferText method to import a CSV file. Everything works fine, unless I make the argument 'True', in which case I get the error...

Nick 'The Database Guy'

11-27-2008 04:01 AM
Keith Wilby

Yes I know my question is off topic for this NG, but I trust some reader will come to my rescue. I have come a long way with my own understanding of...

Gina G

11-27-2008 01:59 AM
Peter James

Hi. My problem in simple terms is this: I have a 1 to many within a 1 to many. firstly I need to set a switch (1-12) based on a day-of-year value...

stuvw@bigpond.com

11-26-2008 11:11 PM
Kelii

I had a bug where the following code did not work when a error existed. if err <> 0 then Using the following fixed the problem if cint(err) <> 0...

paii, Ron

11-26-2008 10:23 PM
Tom van Stiphout

I have the following union query in Access that i need to create in SQL. The migration wizard tried but gave me the SQL statement below this...

kolsby@gmail.com

11-26-2008 01:16 PM
kolsby@gmail.com

I'm using Access 2000 . I want to populate a label with the filename of the mdb file that's runnimg and if possible the full path. Does anyone know...

RICHARD BROMBERG

11-26-2008 11:58 AM
RoyVidar

In access 97 there used to be an item you could put on the tool bar to list all items on the form. Click one and go to it if you could not find it on...

sparks

11-26-2008 04:06 AM
Allen Browne

HI I have a list of e-mail addresses, the list is concantinated in a text box along with the semi colon to seperate the e mail addresses strResult =...

kevcar40

11-26-2008 02:37 AM
jbguernsey

Is there a way to edit the autocomplete address list in Outook? I found the file (outlook.nk2) but it's akin to gibberish. There are incorrect...

Rosy

11-25-2008 06:50 PM
Tom van Stiphout

Using A2000, Three tables: Person, Allergy, PerAllergyMap. The map table records the many-many relation between persons and allergies. The main form...

Hugh N. Ross

11-25-2008 06:48 PM
Tom van Stiphout

strQuery = "Update ArtCenter set HorizontalCenter=@HorizontalCenter, VerticalCenter=@VerticalCenter" dbCommand =...

Mansi Shah

11-25-2008 06:21 PM
Tom van Stiphout

Dear reader, If I open the subForm not as a subForm than the even On Load checks only the first record and acts on all records in the...

Simon van Beek

11-25-2008 02:37 PM
sparks

I have a query that uses the following in the criteria line... Between DLookUp("","tbl_DateLastRun") And Date() It is disregarding the year. For...

Coll

11-25-2008 06:09 AM
banem2@gmail.com

Dear reader, If I open the subForm not as a subForm than the even On Load checks only the first record and acts on all records in the form. On...

Simon van Beek

11-25-2008 05:12 AM
Simon van Beek

Can some one tell me if they see any problem with the following line of code. I am trying the change the contolsource of a text box in a report to...

cwoll

11-24-2008 06:08 PM
Marshall Barton

Dear reader, In case I have a field in a Form I can change the content (value) in the field by typing a new value in the field. But in case the...

Simon van Beek

11-24-2008 04:26 PM
Rich P

Hi, This is my first post so forgive me if it is in the wrong place. I am trying use code in Access 97 that will go into a excel file (a CSV file)...

matt30987@gmail.com

11-24-2008 03:09 PM
MGFoster

Hello: I have a database residing on our server and have attached an icon on my desktop to that database. Most databases I have set up this way...

JP

11-24-2008 02:30 PM
JP

Hi, I am trying to do a database which will email out a form to users to get their name, service tag of PC, PC Name and what software they have on...

Phreake

11-24-2008 02:21 PM
Rich P

Hi, This might be a dumb question but i'm trying to pass a couple of arguments to a subroutine and keep getting an error message This: Sub...

jim

11-24-2008 01:59 PM
Zippy

Hi, In below query I want to return the DAT.MS by latest date. SELECT DAT., DAT.MS, DAT.Activity, DAT.User, DAT., DAT.Region, DAT.,...

Sinner

11-24-2008 12:23 PM
Rich P

If i am basing a selection on a record set can i send certain selected fields to that record set using a where condition? If i had this code, where...

micarl@gmail.com

11-24-2008 06:37 AM
micarl@gmail.com

I've had experience in the past with DBase and Foxpro and Visual Foxpro. I'm stuck working at a place which only has Access as their 'database...

11-24-2008 04:43 AM
eddo

Hello All, I am not sure whether my last post got through so I am sending again. I have the same problem as cddeb... (AT) gmail (DOT) com as...

Kev

11-23-2008 09:46 PM
Allen Browne

"David W. Fenton" <XXXusenet (AT) dfenton (DOT) com.invalid> wrote I thought I pointed out the several major issues when you move to a...

Robert S.

11-23-2008 04:38 PM
Tony Toews [MVP]

Hi all, I have a database being used by 30 people and is split between the backend and frontend. The database has the ability to send...

musicloverlch

11-23-2008 04:36 PM
Tony Toews [MVP]

I'm trying to two two things through Access to Outlook based on a query and selections made on a form. Firstly, i'd like to create an email based on...

micarl@gmail.com

11-23-2008 02:15 PM
micarl@gmail.com

Hi I need to report the aging of claims data for the usual periods ( 30,60,90 days). I have a crosstab query that produces the aging accurately. ...

kc_hingham@comcast.net

11-22-2008 11:23 PM
kc_hingham@comcast.net

Dear reader, I make same changes via VBA in a table. By editing the same table via a form I receive the massage:

Simon van Beek

11-22-2008 05:54 PM
Simon van Beek

Can anyone tellme how to read from a text file into a field on an access form please. I'm writing to a text file fine to log certain activity but...

Len Cuff

11-22-2008 01:42 PM
Salad

Hi, I have a field name 'USER' in tableMAIN. How do I replace the user names with corresponding user names. I can do that in xl using vlookup but...

Sinner

11-22-2008 10:46 AM
Salad

David W. Fenton wrote: FMYI: I don't want to offend and also don't want to start a flame war, here. But it seems that you having not much...

zmickle@gmail.com

11-22-2008 10:38 AM
Robert S.

Question: If the Division number changes in 1 table, it is suppose to automatically change in the other tables. If it don't change, what is the...

Ty

11-21-2008 10:03 PM
tina

I am learning SQL from a book and one of the exercises is to to insert multiple records in a MS Access table (Multiple- record append query/Insert...

zufie

11-21-2008 05:02 PM
Michael Gramelspacher