Hi I have just started to make a Bill of Material Program (BOM) for my self using Microsoft Access 2003. I am looking to make a recipe database. The...

kadidarm@hotmail.com

12-09-2004 03:49 AM
kris Adidarma

Hi, I am creating an application in access 97, so coding in vba. I am at the stage of sending values to my external machine, but am stuck at...

al

12-09-2004 03:02 AM
al

Below is my code to delete a record in a continuous form. I can't figure out any reason but sometimes (another) record gets deleted instead of where...

Prakash

12-09-2004 12:54 AM
Prakash

Is the GUID generated by the .NET System.Guid.NewGuid() function compatible with Access' Replication ID field type? Dave

headware

12-09-2004 12:36 AM
dkland@cox.net

Dear fellow Access 2000 users: I have a table where there are 5 columns and thousands of rows of data. Every so often, there is missing data in the...

No Spam

12-09-2004 12:33 AM
David Seeto via AccessMonster.com

Hi, All I have created ADP application with Access2003. I run into a problem when apply Server filter by form. After I applied Server fiter by form,...

kai

12-08-2004 11:12 PM
kai

Dear Marshall: I have an identical problem. Being a beginner not versed in SQL or any other programming language, I often have trouble adapting a...

benignor

12-08-2004 10:31 PM
Allen Browne

I have a form in a .adp with some values on it that are derived from a lookup I would like to click a Command Button and Add the Data in the...

ABinBoston

12-08-2004 10:26 PM
ABinBoston

Hi, I have Access97 and am trying to add MicroSoft's web browser control. When I try to display or modify it, I get a "there is no object for this...

samhunt90@hotmail.com

12-08-2004 09:20 PM
samhunt90@hotmail.com

I hope this will make sense. I'm trying to filter the records in a table based on records in a 2nd table. The trick is, I can't use a query. I'm...

Brian

12-08-2004 09:17 PM
Salad

Can anybody help please Has anybody got any VBA routines to copy controls on a REPORT (Not a form) to the clipboard. There are somewhat complicated...

Phil Stanton

12-08-2004 09:06 PM
Salad

I am developing a application using this fields as required by the company. 1. Date Login 2. Time IN 3. Time OUT My question is how to produce the...

rock72

12-08-2004 08:55 PM
Salad

This is going to be a really stupid question, but I am having a problem with the percent format in a control on a form. My end goal is that I want...

Nothing

12-08-2004 08:39 PM
Nothing

I am opening a text file with an ODBC connection. I want to append all the text data to a table. Going row by row and field by field takes too long....

Craig.Lee@ppmenergy.com

12-08-2004 08:26 PM
Salad

here is the layout i have so far. what i am unsure about is the hierarchy of USER->EMPLOYEE and ORDER->CATERING. Although a user can be an employee...

dutone@hotmail.com

12-08-2004 07:45 PM
dutone@hotmail.com

I am developing a application using this fields as required by the company. 1. Date Login 2. Time IN 3. Time OUT My question is how to produce the...

rock72

12-08-2004 07:10 PM
rock72

I am developing a application using this fields as required by the company. 1. Date Login 2. Time IN 3. Time OUT My question is how to produce the...

rock72

12-08-2004 07:10 PM
rock72

I recently installed Stephan Lebans calendar control into an application. Only problem is that it always launches at the extreme right of the...

Andrew Chanter

12-08-2004 07:06 PM
Stephen Lebans

Eh, probably not the most specific subject line... But, I've got a number of fields in which I need to do things like remove the first 4 characters,...

Adam

12-08-2004 04:24 PM
Adam

I posted this yesterday but perhaps I wasn't clear enough. I have a table called History with 4 fields "Week" "Employee" "Project" and "Hours" Each...

New2Access

12-08-2004 04:16 PM
SirPoonga

I just installed an Adobe open type font. It is available in other Office programs (e.g., Excel and Word), but it's not available in Access. Anyone...

John

12-08-2004 03:13 PM
John

I am new to Access and especially to forms and code. I have a form in each of 5 databases that allows the user to enter the date and then...

sara

12-08-2004 02:09 PM
sara

Let say I have a form called "frmMachineSpecs" witht wo subforms, "frmSpecs" and "frmMachines". Both subforms are in datasheet view. The first...

kevin.jonas@gmail.com

12-08-2004 02:02 PM
SirPoonga

What is the line of code to select the first record of a subform? I have a form with two subforms. What you select in one subform controls what is...

kevin.jonas@gmail.com

12-08-2004 12:34 PM
SirPoonga

Hi, I have a database that contains only one table. This table contains highly confidential/unique information that, if viewed or copied as a whole,...

ronchito

12-08-2004 11:16 AM
ronchito

I'm importing a text file and would prefer that it create a new row in the access table for each row in the text file. However, it is sporadically...

rdpacer@yahoo.com

12-08-2004 10:17 AM
Scott Simonson

Dear All, Is it possible? I searched all net and the access help file, didn't find a solution. Please give some suggestion. Paul

Paul T. RONG

12-08-2004 08:24 AM
Peter Russell

I want to avoid INSERT INTO command. This command creates too hassle for proper syntax. How can I use set rs =...

kailash@humsay.com

12-08-2004 07:31 AM
Darryl Kerkeslager

Can anyone see anything wrong with this SQL string? REF is a long integer field and DATE is a text field. strSQL = "INSERT INTO PHOTOSAccess (REF,...

jonhanks

12-08-2004 04:31 AM
jonhanks

I'm trying to copy a table and its structure from DBase into Access. One of the fields is a primary key and contains numbers from 0 to 20000 and...

jonhanks

12-08-2004 03:35 AM
jonhanks

A KB article "http://support.microsoft.com/default.aspx?scid=kb;en-us;209599" tells that the maximum number of records that a table may hold if the...

yf

12-08-2004 03:15 AM
Steve Jorgensen

Hi. I need to use WebBRowser as HTML Editor. I set designMode = "On" The control Work, but if i need to insert a NEW LINE i can only do it with...

ALESSANDRO Baraldi

12-08-2004 02:58 AM
ALESSANDRO Baraldi

I'm fairly new to access and VB. I have a form which contains several text boxes and an insert record command button. The button is supposed to...

jonhanks

12-08-2004 02:45 AM
Keith Wilby

Hi all, I've constructed a database that handles data concerning the "flow" of tooling in a factory. The problem is in receiving back the concerned...

Eagle

12-08-2004 02:16 AM
Trevor Best

Saw your note about an Access add-on you created for context sensitive help. Does it provide help for more than just forms? I mean does it provide...

Bob

12-08-2004 01:11 AM
Nick Coe \(UK\)

Hi, i have a SqlWindows Program which made a connection to a MS Access Database about ODBC. I can get all datas with a select about one table. But...

Bibi

12-07-2004 11:51 PM
VOIA

Hi Could someone please help I wish to do a Filter by selection in a runtime application. An example vba code would be most appreciated. Thank...

Joe Bugeja

12-07-2004 09:17 PM
Joe Bugeja

Hi, I have a form with a couple of calculated fields. I want to put some code into the 'Form-Load' event to set various object states on the form,...

david@scene-double.co.uk

12-07-2004 09:16 PM
Steve Jorgensen

I am fairly novice at VB and access in particular and I am having problems trying store a date into database field. This is the scenario I am faced...

Flipmode

12-07-2004 08:11 PM
Salad

Hello, I am fighting a losing battle with Access's Image control. At one time it was able to load TIF images that my users were viewing. I...

Scott Simonson

12-07-2004 07:59 PM
Scott Simonson

Hi all, I've been trying to install the runtime environment for Access 97 on the Citrix server for two access 97 applications that will be...

Gitika

12-07-2004 07:30 PM
Dimitri Furman

How do I find the dates of the Sunday and Saturday of a week if I have the week number of a selected year? Thanks! Jerry

Jerry

12-07-2004 07:10 PM
jimfortune@compumarc.com

Access 2000 I have a text field that data was imported into. Now I have a field that has SSN's in different formats. (123-45-6789 and...

mtech1@yadtel.net

12-07-2004 06:40 PM
Dave M

I have an adp connected to a SQL Server. When I add a record to a bound form, the control bound to the autonumber primary key field...

Andrew Chanter

12-07-2004 06:34 PM
Andrew Chanter

My first time to this group so please be kind. Anyway I have this questionnaire that has two parts (2 tables). I created a form for each of the...

psydork

12-07-2004 06:13 PM
David Schofield

I'm querying a Mas90 db via ADO in Access. The following SQL gives me the error "Invalid Operand for Operator: =" "SELECT * from GL_DetailPosting...

jayj0nes@yahoo.com

12-07-2004 05:41 PM
Rick Brandt

I have WindowsXP Pro and saw somewhere that it contains IIS whereby if it is installed, ASP pages can be run locally. I would appreciate any...

Jerry

12-07-2004 05:01 PM
Jerry

I have had an application in MSAccess 2k for about year now without issues until recently. My users were using it in W98 without issue, but...

Scott Simonson

12-07-2004 04:38 PM
Scott Simonson

Hi anyone!!! I have an access database file which is corupted after a computer crash. I have tried a compact and repair which failed. I have...

Scott

12-07-2004 04:36 PM
pw

Hi, This is only happening to a couple of our clients. We have to have them e-mail us their data. Then we do a compact and repair and e-mail it...

pw

12-07-2004 04:35 PM
pw