Am using StrStorage.dll & DynaPDF.dll (Lebans tools) for creating PDF's. At most sites, there are no glitches. However, I have a problem at one...

MLH

11-18-2006 08:01 AM
MLH

Dear readers, Is there some one who knows the solution of the problem caused by the reference libraries in the VBA code. If you run an application...

Simon

11-18-2006 07:25 AM
Simon

Dear readers, Is there some one who knows the solution of the problem caused by the reference libraries in the VBA code. If you run an application...

Simon

11-18-2006 06:39 AM
ruralguy via AccessMonster.com

Dear readers, Is there some one who knows the solution of the problem caused by the reference libraries in the VBA code. If you run an application...

Simon

11-18-2006 05:26 AM
Allen Browne

hi all! i want to create group text for showing my invoice number. the invoice no. is created by 3 parts. 1st part: autonumber increasing at each new...

luanhoxung

11-18-2006 02:04 AM
luanhoxung@yahoo.com

This message is for Stephen Lebans and all users using the clsControlData in ContinuousFormsCurrentRowVer7.mdb. First of all many thanks for writing...

JUM

11-17-2006 11:56 PM
Stephen Lebans

Hi, I have the following task to be done in VC++ 6.0. I have a tab delimited text file that needs to be imported into a MS Access table. The table is...

Pradeep

11-17-2006 06:51 PM
Granny Spitz via AccessMonster.com

Hmmmm....I'm not sure what I should ask. Will there be any connection between Access 2007 and .Net technologies?

salad

11-17-2006 06:36 PM
tom7744@mailinator.com

I have to run a lot of append queries. I have data in tables in old databases that has to be appended to tables in a new database. I made a new...

Henrootje

11-17-2006 05:17 PM
Kc-Mass

I have a table called Payroll and and form called Application. When SocialSecurityNo is entered on the form, I want to search Payroll in the field...

Ryker

11-17-2006 04:44 PM
Ryker

I've written an utility that enables me to send SMTP mail from MS Access using DDE and a custom VBA object.. I've got a client who is unable to...

Keith Hutchison

11-17-2006 03:59 PM
Keith Hutchison

Hi again, This time i have an excel file stored as a OLE object field in a table, and im trying to export it as an excel file as...

Mike

11-17-2006 02:43 PM
pietlinden@hotmail.com

How do i change the whole databse to readonly thru code. Thanks.

colleen1980@gmail.com

11-17-2006 02:18 PM
pietlinden@hotmail.com

I have an Access database that was designed with Office1995 version. It has a Sub which has array in it and it doesn't seem working with MS Office...

ruomingxu via AccessMonster.com

11-17-2006 01:59 PM
Larry Linson

How do i change the whole databse to readonly thru code. Thanks.

colleen1980@gmail.com

11-17-2006 01:19 PM
Tom van Stiphout

How can I, without using Replication technology, append a table in my master database from data in another database? I have several field offices...

Parasyke

11-17-2006 11:30 AM
Tom van Stiphout

What is my best option for enabling users to copy and paste an entire recordset, but allowing them to change the value of the "one" record in...

Slez via AccessMonster.com

11-17-2006 11:26 AM
Tom van Stiphout

Hi I have a report which has several sub reports. The total page numbers are incorrect, usually out by 1 page. So down the end of the report would...

Vayse

11-17-2006 11:05 AM
Vayse

I use this line DoCmd.SelectObject acTable, "tblAdmin", True when I want to display database window. Often- times, working on a remote mde via a...

MLH

11-17-2006 08:54 AM
MLH

In a standard A97 installation, opening a procedure and clicking the right mouse button enables one to select Build... from the shortcut menu. For...

MLH

11-17-2006 08:29 AM
MLH

Draconian, I agree, but the default out of the "Microsoft box" is 90 minutes. I'd say that makes it their problem. -- Danny J....

Danny J. Lesandrini

11-17-2006 07:11 AM
Danny J. Lesandrini

Hello I am using MSACCESS 2000 I can hide Tables from appearing in the Database Window with the following code: For Each tbldef in...

G Gerard

11-17-2006 03:10 AM
RoyVidar

I have a table "tblSprayApplication" in a project for a nursery. Each record refers to a single spray application across the nursery, recording which...

Regnab

11-17-2006 12:34 AM
Regnab

Hi everyone, I found the Access reports too limited to do what i wanted so i created a module to export a crosstab query to an excel file, and then...

Mike

11-17-2006 12:07 AM
Wayne Gillespie

I have a Continuous form in Access 2000. The form contains a date field and the user has requested( demanded nicely) that they want the date field to...

James

11-16-2006 11:47 PM
Wayne Gillespie

Am trying to open an Adobe .pdf file from Access2000. I use the following code: Shell "C:\Program Files\Adobe\Acrobat 6.0\Acrobat\Acrobat.exe /c...

Mike

11-16-2006 11:37 PM
Mike

How would I put dashes into a number? I have numbers like 1233450983 that need to have dashes in them like 1-2334-5098-3. How can I add the dashes...

JA

11-16-2006 10:30 PM
JA

Hello In many procedures I use the Set statement to set a variable MyDb to DBEngine,Workspaces(0).Databases(0) Example In Module 1 Public MyDb...

G Gerard

11-16-2006 10:02 PM
Lyle Fairfield

Hi, I'm using Form and a subform control within that form. Main form is getting data from one table(Buildings) and subform is getting data...

Shals

11-16-2006 09:06 PM
kingston via AccessMonster.com

Hi all, I've read that the message argument in SendObject allows a max of 255 characters. Is this correct? If so, doesn't this render SendObject...

Penny

11-16-2006 08:59 PM
Rick Brandt

Hi. This is my situation: Backend: Oracle 8i Frontend: MS Access 2k (ODBC driver support LOBs) Q: How insert (upload) a CLOB (pdf or doc file) to...

Gox

11-16-2006 07:10 PM
Gord

I have a report that I want to print for a product specification sheet with a photo of the product. I have the photos stored in a separate folder...

Parasyke

11-16-2006 06:53 PM
Phil Stanton

I am Access newbie looking for some guidance in putting together a query that can output a table of max values in a given column grouped by a couple...

brob

11-16-2006 04:40 PM
brob

Ok...I'll first describe briefly what I've done. Working from a paper form with over 200 fields - broken into 10 areas, I created a database with 10...

shawnews

11-16-2006 04:39 PM
Tom van Stiphout

Dear NG - I'm very new to Access and reports are completely foreign to me. I was hoping that I could get some general guidance on how to proceed...

Takeadoe

11-16-2006 03:23 PM
Takeadoe

Hi I'm working with joins, and i have made this DB http://www.blackend.dk/061302_Elementlist.mdb Problem is my T_Signals tabel. For every input, i...

Ulrik

11-16-2006 02:48 PM
pietlinden@hotmail.com

I'm trying to set up a contact list in MS Access 97. I've looked through a reference book and the program's help screens, but the light bulb isn't...

Robert J. Bonn

11-16-2006 02:42 PM
John Welch

I've produced an Access application for a client. For one report, text gets cut-off at the right margin when we print the report. It does this only...

TC

11-16-2006 02:40 PM
Stephen Lebans

I'm working on a .NET project and I need a single query to return a result set from three related tables in Access 2003, and I'm having trouble...

mmitchell_houston

11-16-2006 02:24 PM
Tim Marshall

When I enter a date in the textbox on my subform, such as 11/22/30...expecting the textbox to show the date 11/22/2030...instead the date 11/22/1930...

jmarr02s

11-16-2006 01:52 PM
Fred Zuckerman

Hi! I am a comeback database developer using MS Access (last time was 1998). I kindly ask for your recommendation of a good book(s) that can be...

AA

11-16-2006 01:25 PM
deluxeinformation@gmail.com

I have a problem with recordset/SQL statement. The following is the code. Private Sub Command1_Click() Dim SqlQuery As String Dim RcdSet As...

ruomingxu

11-16-2006 01:16 PM
Phil Latio

I changed the name of a field in one of my tables (before you all scold me, don't, I won't ever, ever, ever do it again!) and then changed all of...

Jimmy

11-16-2006 01:12 PM
rkc

I have a form that the user enters some information on and then clicks a button to save the record. I do with the following line: DoCmd.DoMenuItem...

SBC News Groups

11-16-2006 01:09 PM
SBC News Groups

I have a parts inventory table that contains a catergory, qty, part # , and a description field. It is updated by a form that either adds to or...

jzint

11-16-2006 10:33 AM
Allen Browne

Hi, My combobox has 684 items, (controlled from a separate table). However, the item I select does not populate in the combobox field? If fills...

abattista@aapt.net.au

11-16-2006 09:51 AM
Chuck

I need to alert my users upon attempt to enter a hiring request (on a form) to not hire due to grade level of candidate. Candidate grade level is in...

Hph

11-16-2006 05:07 AM
lesperancer@natpro.com

I have two questions regarding emailing from Access. My first question relates to how many email addresses is too much. I have a client who wants to...

Tim Hunter

11-16-2006 02:19 AM
henk@telenet.be

I am trying to find a common way to create a table that works in access97 as well as it does in access2000. Here is a snippet that works in...

ChasW

11-16-2006 01:46 AM
ChasW

On Thu, 02 Nov 2006 09:36:47 -0600, "David W. Fenton" <XXXusenet (AT) dfenton (DOT) com.invalid> wrote: Typical buggy Access! On an AfterUpdate...

PW

11-15-2006 11:22 PM
PW