Please help me...a newbie here.... I having been working two days on a project, thought I was almost done until I tried to create a report using a...

shawnews

11-12-2006 05:43 PM
shawnews

Can someone help me with creating code that will look for DAO recordsets in modules and then check to see if the recordset is also closed in the...

rdemyan via AccessMonster.com

11-12-2006 11:52 AM
rdemyan via AccessMonster.com

hi all ! i have created a list box of names for a form . the problem is my client wants to use it with a touch screen system , so the list box is...

brino

11-12-2006 06:11 AM
Lyle Fairfield

i have a list box that i would ike to select a name and enter what is selected into another field on the form.i have tried to put the list box value...

brino

11-12-2006 05:47 AM
Rick Brandt

I have a simple form with 4 command buttons and 1 label. The label is sometimes visible and sometimes not. When it is visible I want it to be...

Iain Bishop

11-12-2006 01:38 AM
Iain Bishop

Thanks .... This is on a network where the database is in an area where the user can read only. I want the user to be able to save the Excel file...

JohnM

11-12-2006 12:29 AM
JohnM

i have a list box that i would ike to select a name and enter what is selected into another field on the form.i have tried to put the list box value...

brino

11-11-2006 10:29 PM
Larry Linson

Dear reader, How to print an e-mail address if the address is stored in a datatype Hyperlink field. If I use the Hyperlink field in a report than...

Simon

11-11-2006 10:13 PM
Ed Robichaud

Hi: Can any one please tell me how do i separate city state and zip. I ask this question in previous post. But when the city name is in two words it...

colleen1980@gmail.com

11-11-2006 10:09 PM
missinglinq via AccessMonster.com

I know that the .ldb file should show the users currently logged into a database. However, when a user logs out I cannot detect any change in the...

Les Desser

11-11-2006 07:36 PM
Les Desser

Dear reader, My AddNewRecord procedure looks as follows: Private Sub AddNewRecord (strFormName As String) On Error GoTo ErrorHandler:

Simon

11-11-2006 04:03 PM
Larry Linson

Hi How can I extract the first name from the full name where each name is separated by spaces? Thanks Regards

John

11-11-2006 03:58 PM
Larry Linson

hi friends, i am really surprized the way access behaves in date fields i mean it's all ok when you have us time zone or us servers but if you...

hardik

11-11-2006 12:29 PM
Rick Brandt

Hi is there anyone out there that can help me with MS Access??? I am new to Access and have a project that requires me to create a form with a list...

charissav@gmail.com

11-10-2006 10:11 PM
Tom van Stiphout

What I'm trying to do is set a players division according to their age. So if age is 8, update division to junior, if age is 9, update division to...

davidevan

11-10-2006 09:44 PM
pietlinden@hotmail.com

Hello, Do you know how to schedule a weekly export of one table to a text file from access 2000 on windows xp? Thanks, Eyal

Zviozdi@gmail.com

11-10-2006 09:39 PM
pietlinden@hotmail.com

i'm sure this is simple to do, but i can't find the answer in the search engines. i have an access db with 400,000 records. i produce queries of...

BFoxDDS

11-10-2006 09:34 PM
Keith Hutchison

Hi: Can any one please tell me how to i export data thru VBA code as same when i right click on any table and then it ask me to export data as comma...

colleen1980@gmail.com

11-10-2006 09:32 PM
pietlinden@hotmail.com

Hi, Is there any way to execute a function by using it's pointer? The reason I want to do this is: I have a control on a form that I have wrapped...

Pachydermitis

11-10-2006 06:06 PM
Pachydermitis

What is a good way, in VBA, to automate the linking of table links to excel spreadsheets that reside in the same path as the database file that would...

ChasW

11-10-2006 04:01 PM
salad

I need to set up a query that will pick out records for the current winter season. I.e., each season runs from October 1 until March 31. The catch...

Robert

11-10-2006 01:27 PM
CDMAPoster@FortuneJames.com

I am wanting to play a prank on someone. Is there a way to send an email and make it look like it came from someone else. Thanks for help or a group...

deercreek

11-10-2006 11:31 AM
pietlinden@hotmail.com

My database is a FE/BE Access 2000 database installed on 3 XP workstations. Each user has a different model of label printing machine attached to...

Paul H

11-10-2006 11:25 AM
Albert D. Kallal

I'm developing an MS Access application that creates and executes stored procedures on a Teradata system using SQL Pass Through queries. I want the...

nolanmadson@gmail.com

11-10-2006 11:10 AM
Gord

Check out: www.Brandon-Lands.com

Brandon

11-10-2006 10:39 AM
Geoff G

I have run into a sudden problem and thought I'd see if anyone else has ran into this. Out of nowhere (sort-of) I am not able to access the...

Rational Repairs

11-10-2006 09:00 AM
Rational Repairs

I just wasted a long time figuring out this and I figure if I post it might save someone some pain! Jet (DAO) will allow you to to use nested...

BillCo

11-10-2006 08:36 AM
bas

Hi all. I don't want to sound like a complete idiot here, but I'm somewhat limited in my coding knowledge, and I need some advice and help. I'm...

SeanCly10@gmail.com

11-10-2006 06:37 AM
Terry Kreft

In my subforms (in Access 2003) the mousewheel will only roll down in my subforms if there is not so many records. If a subform - (continous form)...

HC

11-10-2006 04:39 AM
HC

hi all ! i have a time field in a form and its in 24 hour time. i need to be able to bring up a message when the user does not enter anything in this...

brino

11-10-2006 02:20 AM
Keith Wilby

I'm sure this has been asked before but I can't find any postings. I have a table that has weekly inspections for multiple buildings. What I need to...

Jim

11-09-2006 08:36 PM
tina

Hi, In my application users have the ability to upload large pdf files from their laptop to our servers. To move the files I use the Name...

paulmac106@gmail.com

11-09-2006 08:18 PM
Tom van Stiphout

Hi: Data in my table is in that format. How to i separate date with time. 11/9/2006 10:10:46 AM Thank You.

colleen1980@gmail.com

11-09-2006 07:58 PM
Larry Linson

"David F Cox" <nospam (AT) please (DOT) com> wrote How would that be displayed in a non HTML reader like OE? I think I'd be tempted to upload my...

Keith Wilby

11-09-2006 06:47 PM
Neil

Hi everyone, I've got an ADO AddNew update query in VBA. Some of the fields may be empty and I want to know if there is an easier way than writing...

andraandjeff@gmail.com

11-09-2006 05:31 PM
chris.nebinger@gmail.com

Here's what I'm trying to do: I want to type in a combo box (search for a Contact) and if that contact is not in the list, pop up a message...

abprules

11-09-2006 03:55 PM
chris.nebinger@gmail.com

Hi ! I have a form that displays several records. The record contains a bound object frame. Onclick I execute some simple code to change teh...

Andy

11-09-2006 03:22 PM
Andy

I am developing an inventory database. The warehouse operator has an "Edit Inventory" form where he makes changes to incoming quantities. He can...

igendreau

11-09-2006 12:10 PM
veaux@aol.com

David W. Fenton wrote: but I can't remember for sure and my contact there isn't at her desk right now. I'm going to have her try to get the IT...

Jan

11-09-2006 11:50 AM
Jan

I am trying to have a button that launches a word mail merge document thats already linked to my database. when i hit the button, word opens with the...

Deus402

11-09-2006 10:53 AM
Deus402

I am trying to have a button that launches a word mail merge document thats already linked to my database. when i hit the button, word opens with the...

Deus402

11-09-2006 10:49 AM
Deus402

Hi All, I have writen a value to the registry. What I want to know is, is there a way that I can check that value? Thanks in advance. Nick

Nick 'The Database Guy'

11-09-2006 10:39 AM
Nick 'The Database Guy'

I have 2 tables, Placement Details, with Name, Placement, weekly cost, monthly cost, Projected yearly cost and full yearly cost, Effective and End...

Elainie

11-09-2006 09:13 AM
Keith Wilby

currently am builing a access ordering system. I was going to use autonumber as the order number but have heard that it is not recomended to do...

Simon

11-09-2006 08:46 AM
Keith Wilby

Hello, I have designed an access database, but it doesn't have any security or passwords. I would like to set it up so that I am the only one who...

kiplinghfx22

11-09-2006 08:01 AM
kiplinghfx22

Hi, I'm fairly new to Access, and I'm trying to put a validation control in to ensure that a date entry can only be a fixed day of the week (a...

andrewmuncey@gmail.com

11-09-2006 07:28 AM
Ron2006

I'm kind of looking for some guidance in respect of this obstacle I'm up against - please let me expand; I have an option group with three options...

Phil Latio

11-09-2006 06:07 AM
Phil Latio

just wasted a long time figuring out this and I figure if I post it might save someone some pain! Jet (DAO) will allow you to to use nested...

BillCo

11-09-2006 04:44 AM
BillCo

oh man I looked at that thing for an hr and never did see that If Not IsNull(DLookup("", "tblDemographic", " = '" & Me.Text9 & "'")) what is weird...

sparks

11-09-2006 03:47 AM
Anthos

Hi i have read about the user level security in MS access. But i would like to find out how it is possible to secure a database application. I have...

chuaby@hotmail.com

11-09-2006 02:26 AM
Keith Wilby