Hi, I have a field called 'Transaction ID' but I can not use it in VBA because I get the error message 'COMPILE ERROR: expected: end of statement' ....

Nick J

03-27-2005 04:24 PM
Bob Quintal

Greetings, I am working on importing some info from excel to Access and have run into a problem. There are some entries in the ZipCode field that...

Tarvos{k}

03-27-2005 04:22 PM
Bob Quintal

Hopefully an easy one? Have created a Form with numerous ComboBoxes. On hitting OK on the form this calls up a Query which has all the...

Andy

03-27-2005 03:25 PM
pietlinden@hotmail.com

I have a table for all my combox boxes. ID: AutoNumber ComboName: text ComboValue: text with no duplicates I have create a query based on this...

dmkeith2@hotmail.com

03-27-2005 12:31 PM
dmkeith2@hotmail.com

I'm building a tracking system and I'm having some problems. I thought this was relatively easy, but.... I have the following tables and fields...

dskillingstad@gmail.com

03-27-2005 12:23 PM
Tom van Stiphout

Normally when I run a query, each record is displayed in a row, and the colums contain the field titles. Is there a way to switch this and have each...

RR

03-27-2005 12:04 PM
RR

Vorrei suggerire una funzione completa per la differenza fra due date. (questo è codice freeware, niente di illegale) La funzione seguente permette...

UBI

03-27-2005 09:09 AM
UBI

A newbie question here: I'm linking to a MySQL backend table with a million+ records, where two fields are of type datetime. However Access...

pholck@gmail.com

03-27-2005 05:24 AM
pholck@gmail.com

In MS Access 2000, the text attributes in the properties panel for a label or text control do not include any shadowed, embossed or etched...

newbie

03-27-2005 05:22 AM
Van T. Dinh

I'm sure this has been discussed here, and probably recently, but I noticed it on the msdn website: "DAO provides access to JET (Access) databases....

DFS

03-26-2005 10:05 PM
Larry Linson

Hi, I have been struggling with this problem for two days. My development PC is running Windows XP/Office 97. The work stations are running Windows...

SD

03-26-2005 08:56 PM
Allen Browne

Hello Everyone, Is there a way to hit "ENTER"(or any other key) on the keyboard and trigger a sepcific button? I heard something about the onKeyDown...

Giloosh

03-26-2005 06:33 PM
Giloosh

I did put password into my Ms Access project (code and procedure), so whenever i need to change my coding or modify procedure, it will prompt me...

danieltan@time.net.my

03-26-2005 05:57 PM
dmkeith2@hotmail.com

Sorry to be so persistent but would really liek to get an answer to this. If OLE object in a report is null, I can hide it with the visible...

Brian Keanie

03-26-2005 02:53 PM
Stephen Lebans

My database did not open because this was missing. I was able to restore from a backup, but what is it???

Steve

03-26-2005 10:32 AM
Steve

I plan to add a PrintMe column (Yes/No) to my main table so that only certain records will be printed. How do I change the values back to No when I...

dmkeith2@hotmail.com

03-26-2005 10:28 AM
dmkeith2@hotmail.com

I have been able to set up a Find Record Button on my switchboard to take me to a form with the correct case number by using a parameter query and...

Randy

03-26-2005 10:01 AM
Strasser

Help! Can anyone tell me where the default system.mdw is located? I made a new Workgroup Information File and joined it now I want to join rejoin...

Barry Edmund Wright

03-26-2005 07:05 AM
Rick Brandt

Hi! The default ListBox control in ms access 2000 can't show the gridlines. I could "fake" it by setting the listbox Special effect to 'Flat' and...

Geir Baardsen

03-26-2005 05:58 AM
Douglas J. Steele

Hi! 1. I wonder if there is a possibility to open a BackEnd.Db from the opening form, the form e.g.: frmOrders, in the FrontEnd.Db, when...

Geir Baardsen

03-26-2005 01:43 AM
Geir Baardsen

How do I display a "0" instead of it returning "#ERROR" in a query where I have division. Also have negative numbers returned on some values, but...

noname

03-25-2005 11:33 PM
Madhivanan

Hi, I have been struggling with this problem for two days. My development PC is running Windows XP/Office 97. The work stations are running Windows...

SD

03-25-2005 08:49 PM
SD

I have a table where the key field is an autonumber. The highest number was about 900, and there are several gaps in the sequence. This database...

heather e blair

03-25-2005 05:46 PM
jimfortune@compumarc.com

Hi, I'm somewhat of a novice at Access, and I have no experience programming whatsoever. I'm attempting to calculate the statistical median in a...

nick.vitone@gmail.com

03-25-2005 05:17 PM
jimfortune@compumarc.com

I can build a table which acts like a tree structure in Access97 A table has referential relationship with itself. A column 'NodeNo' (the keycol) ...

Jim Bunton

03-25-2005 04:33 PM
bruce@aristotle.net

Where is the file that holds the icons in Access 2000? I'm suffering from the old "object variable or with block variable not set" problem and so I...

Deano

03-25-2005 04:26 PM
Deano

Hi, I've got a problem with a damaged access 2000 database. When I try to repair and compact the database, the process starts normaly, but then...

XXX

03-25-2005 04:10 PM
Tony Toews

I have coded MS Access 2002 to send a report via email using outlook. However, if outlook is already run, it will just sit there. I have checked...

perryche@yahoo.com

03-25-2005 03:37 PM
pietlinden@hotmail.com

I am STUCK! I have an Access2000 report; main report and subreport. The sub report is 2 columns, with a footer controlled by a value in a...

sara

03-25-2005 03:10 PM
sara

Got an Asus MB whose instruction book rates a strong B+... maybe an A. Got an Intel P4 with included cooling fan/heat sink, whose instruction...

(Pete Cresswell)

03-25-2005 12:47 PM
Trevor Best

Hello all. I just installed Oracle 10g developer tools on a machine running XP Pro and Office XP. Before this I had just the Oracle 9 client...

mcbill20@yahoo.com

03-25-2005 12:31 PM
Elaine

Hallo, ich muss eine Access200-DB in eine andere Sprache übersetzen. Die Idee ist, mit einer Schleife alle Formulare und Berichte durchlaufen zu...

Thomas Tawarritsch

03-25-2005 10:51 AM
Peter Doering

Hopefully this is a simple one to answer .... Designed a form with 2 combo boxes (surname & member). For some strange reason they both show Surnames...

Andy

03-25-2005 10:50 AM
Andy

Our company contracted with an outside consultant over a year ago to build a complex database application. The end product was put into production...

strvariant

03-25-2005 10:08 AM
Steve Jorgensen

I've been renaming the ALL high level objects in a database and searching out the dependent objects to change the references. This was all...

Bill Stock

03-25-2005 09:44 AM
Bill Stock

I am so aggravated and need any help I can get. I am using Access 2000 and am trying to sort multiple fields in a select query. My query is set up...

tesc@optonline.net

03-25-2005 09:32 AM
tesc@optonline.net

How many fields can I have in a query? I am working on a query and it just quit adding new field columns. Is there a limit? Maybe I need to split it...

noname

03-25-2005 09:25 AM
fredg

Hi...I would like to do the following...and add a component to it: You can use the domain aggregate functions provided with Access. For example, if...

Fatz

03-25-2005 07:35 AM
Alan Webb

I've got code that builds a DAO recordset from a table, and then pastes the recorset in a specified area in an Excel...

toddmoses26@hotmail.com

03-25-2005 07:24 AM
toddmoses26@hotmail.com

Hi...I would like to do the following...and add a component to it: You can use the domain aggregate functions provided with Access. For example, if...

Fatz

03-25-2005 07:23 AM
Rick Brandt

I have code that exports data to excel and formats it. I originally put it into the on click method; however, it has not gotten too large. I want to...

apgoodb@yahoo.com

03-25-2005 06:11 AM
MacDermott

Hi all, I have query about passing a parameter from form to a query. My situation is as follows: I have a query that pulls up some data from a...

rg

03-25-2005 05:54 AM
rg

I really need help, well Im working on some prog in access 2K, and one part of it is a place to store some documents doc, xls, cdr, bmp. How can I...

Boxer

03-24-2005 11:48 PM
kenfirch

I have a subform which is a continous form and displays the content of a table, with a subjext number, then a line of text, then a score. I have used...

fecket

03-24-2005 11:38 PM
Stephen Lebans

I have an Access application with the name: MyAppName® It has the "®" symbol (ChrW$(&H00AE)) at the end of it. If I remane the application without...

lauren quantrell

03-24-2005 11:37 PM
Stephen Lebans

Hi, I have an web app and I am using access 2002 and VB.net. I am using a data adapter to fill a dataset. I am retrieving product descriptions,...

sling blade

03-24-2005 09:24 PM
compassSoftware@gmail.com

I had the following error message: ******** START ************ "" The expression on Click you entered as the event property setting producedthe...

Javier Gomez

03-24-2005 08:30 PM
Javier Gomez

Hello. I have a HP6630 Computer, Windows Xp Professional, Office Xp Standard Edition and a standalone version of Microsoft Access 2000 sr1 on a...

alisae@idirect.com

03-24-2005 07:48 PM
alisae@idirect.com

I'm new to access and need some help. I have a form with a shipment destination at the top. I then have a subform that I enter boxes for that...

ChadDiesel

03-24-2005 05:39 PM
Phil Stanton

hi folks, in the course of my Access project (ACC2000) I created a temporary table which I deleted after it was no longer needed. now, each time...

Helmut Blass

03-24-2005 04:09 PM
paii, Ron