I have just sat up a database that has 2 - 10 users at any given time. Everything is running smooth, however when someone's computer goes into...

Snoopy33

12-04-2007 10:33 AM
Snoopy33

Hi, I've been looking at the above API, which does indeed bring up the OpenFile dialogue and place it into an unbound text box, but i am having so...

redpears007@hotmail.com

12-04-2007 03:11 AM
Keith Wilby

Greetings. I have a form with a subform. Main form is attached to table of branches of our company, and sub form is attached to an orders table. Two...

Cagdas Ozgenc

12-03-2007 09:24 PM
Tom van Stiphout

Dear Sir Join our site and enjoy with all service and Offers we present for you and wait more from us, if any subject admired you, write...

mfetoh777@gmail.com

12-03-2007 01:45 PM
mfetoh777@gmail.com

Dear Sir Join our site and enjoy with all service and Offers we present for you and wait more from us, if any subject admired you, write...

mfetoh777@gmail.com

12-03-2007 01:44 PM
mfetoh777@gmail.com

Hi there, I hope someone can offer up a suggestion with regards to this problem. I have two user sites, running Citrix (Metaframe 4.0) on...

neil.albrock

12-03-2007 01:21 PM
Tony Toews [MVP]

I'm hoping that someone here can give me some assistance with a database I'm trying to set up. My skills in Access are fairly basic, and I'm trying...

Jeffrey Davis

12-03-2007 08:24 AM
Salad

I have frmMinutes with all fields diabled on load except for an option group that I use to toggle on the correct fields depending on option chosen. ...

maceslin@gmail.com

12-02-2007 07:35 PM
maceslin@gmail.com

Hi, What is the SQL to count the number of null values in a specific column in a table? I knw this must be simple but I've been Googling this for a...

leegold58

12-02-2007 01:22 PM
Sky

I have query1 where I set a date range. Query2 is a crosstab query and is based on query1. I don't want the queries to be saved in the mdb but I do...

12-02-2007 03:49 AM

..:: Unix and Linux Hacking and Security ::. 1. Unix - Vulnerabilities and Advisories -- Tutorials and Papers -- Specific Exploits and...

Anaya.Stratton.group.com@gmail.com

12-02-2007 12:43 AM
Anaya.Stratton.group.com@gmail.com

Hi, I use access 2000 on WinXP In an MsAccess module I've a variable which contains an ascii text which could form a valid RTF document. Now I want...

insomniux

12-01-2007 10:54 PM
Neil

I have created a <filename>.db1 (where <filename> is the name given to the database) Access database that is being used in multi-user mode. When the...

Don Calloway

12-01-2007 09:06 PM
Tony Toews [MVP]

I have query1 and query2. Query2 is based on query1. I would like to build those queries in a string in VBA and then execute them. In query2 there is...

12-01-2007 07:02 PM

Hi, I have database with four users. Users were created by user-level security wizzard. How can I (as admin) know who is using the database and...

zdenko

12-01-2007 05:07 PM
Bob Quintal

Hi, I am new to using Microsoft Acces, I know I need to use some VBA code to do this job. Not sure where to start is someone could put me in...

MrCedars

12-01-2007 01:31 PM
Salad

I think I already know the answer to this but... Is there a way, in the Query Design Grid tool, to create a make table query that prompts the user...

Fester Bestertester

12-01-2007 01:13 PM
Rick Brandt

eselk (AT) surfbest (DOT) net wrote: I only have a gig mem on my machine so I errored out on 25K records. Where In is quite fast. Just remember...

eselk@surfbest.net

12-01-2007 12:11 PM
Salad

Images stored in our database (stored as filenames but held elsewhere) will form part of a long report. It is critical that when the report prints...

anthony

12-01-2007 10:45 AM
anthony

http://www.wowmmocom.com http://www.wowmmocom.com The Lord of the Rings (EU)--Belegaer - 10 $: 10.49 The Lord of the Rings (EU)--Evernight - 10 $:...

juliemmo@hotmail.com

12-01-2007 07:34 AM
juliemmo@hotmail.com

I'm embarrassed to ask this. I have a form with a bound object frame which displays an embedded bitmap stored in the table that the form is based on....

anthony

12-01-2007 03:12 AM
anthony

I'm using VB6 to create a new record in a Access db. I'm doing so like this: INSERT INTO Customers (Name Prefix, First Name, Last Name, Name...

Jerry West

11-30-2007 07:56 PM
Jerry West

Hi All I have a query based on a single Table the has the following fields: Field 1: BoughtDate Field 2: SoldDate Sometimes the SoldDate is earlier...

bobdydd

11-30-2007 06:29 PM
bobdydd

Hi all: My problem is a little different than the earlier append table post. I have T1 with an autonum field as the primary key, and T2...

Filio

11-30-2007 05:19 PM
Filio

Mr Lebans. Could you help me ? We are trying to run your mdb to convert access reports to pdf but we can not, because an error happens. We are just...

inika301@gmail.com

11-30-2007 03:04 PM
Stephen Lebans

Hello all! Trying to create a report with a subreport. The subreport needs to run a query that returns a list of Home Grades with a Count per...

Andrew Meador

11-30-2007 02:38 PM
eselk@surfbest.net

My breakpoints don't work. Have, compacted, decompiled but no change. Also turned off AutoCorrect. Heeeeelp Jeff "More Access...

Jeff

11-30-2007 02:30 PM
Tony Toews [MVP]

Hi there, Have a couple of questions about applications developed using MSAccess. 1. Is there a way to run and use you application OUTSIDE of...

mike.arsenault@ivara.com

11-30-2007 01:37 PM
eselk@surfbest.net

Hi all, I am having a problem appending data to an existing table. I have two tables with identical fields and I want to append the data from...

wade.wall@gmail.com

11-30-2007 01:29 PM
wade.wall@gmail.com

I have an unbound form frmProdReview with an OK command button set to OpenQuery and a Cancel command button. On the form I have 3 controls txtDate,...

tbrogdon@gmail.com

11-30-2007 09:36 AM
tbrogdon@gmail.com

I want to embed some BMP files into an OLE field (called BMP) in an existing table using code. I've created the code that grabs the filename from the...

anthony

11-30-2007 09:23 AM
anthony

On Nov 29, 4:54 pm, fredg <fgutk... (AT) example (DOT) invalid> wrote: The table has a "SchoolYear" field, text, length of 4 e.g. 2007. The field...

Sheldon

11-30-2007 08:55 AM
Salad

In the thread "combining multiple address fields into 1 address field", Stuart (?) helped solve that problem. I then tried to set up a mail merge in...

H

11-30-2007 08:31 AM
Rick A.B.

Hi.Can anyone teach me how to put password on my form and appear when I open my database.Hope you can teach me.Thank you.

warba60@gmail.com

11-30-2007 08:03 AM
warba60@gmail.com

Hello everybody, I've got a bit of a situation that I could use some guidance with if possible. I work for an auditing firm where my users audit...

jsacrey@comcast.net

11-30-2007 07:54 AM
lyle

Hi I have a series of queries, I have a number of temp tables which I use as templates for my data. I start with 1. Delete the data in a temp...

nujcharee@googlemail.com

11-30-2007 03:49 AM
lyle

Uzytkownik "fredg" <fgutkind (AT) example (DOT) invalid> napisal w wiadomosci news:1okggqv4vbr8t.1qu1l91o8doeb.dlg (AT) 40tude (DOT) net...

BzyQ

11-30-2007 03:27 AM
BzyQ

I am trying to add specific form controls to a VBA collection, so that I can pass the entire collection to another function, and access...

Nunzio

11-29-2007 10:41 PM
Neil

Hi Neil, Add a column to your sql server table which will have the default value set to getdate(). In the Design view of the table go to the...

Rich P

11-29-2007 07:48 PM
Neil

Hello! What's the best way to make a button print *just* the selected (displayed) record of a subform, when that subform is currently part of a...

Dave

11-29-2007 05:08 PM
Ron2006

Hi All, One of a queries properities is 'recordset type' and it defaults to 'dynaset'. If I have a query which is just a select query is there...

bobh

11-29-2007 01:17 PM
bobh

Hi i have a list box on a form that fills with data based on the id field in that form. The problem im having is that the listbox wont let the user...

paulquinlan100@hotmail.com

11-29-2007 12:17 PM
paulquinlan100@hotmail.com

"David W. Fenton" <XXXusenet (AT) dfenton (DOT) com.invalid> wrote I did use XNews for a while a few years back, I think that and OE are much of a...

Neil

11-29-2007 10:46 AM
Keith Wilby

hi all, I am trying to setup a query that will count the folling for me I have the following data example That i have put over from a field i have...

Mrbanner

11-29-2007 08:15 AM
Salad

Adobe has WAY to many forums and I wasn't sure which was correct so thought I'd try here first. I'm trying to see if there is a product that will...

veaux@aol.com

11-29-2007 08:11 AM
veaux@aol.com

Hi, I have the following address fields in a table: flat_number house_name_or_number street village postal_town county postcode

H

11-29-2007 04:31 AM
H

Hello I have managed to map an FTP site as a drive on my computer ( I think - not sure if it is really mapped - although it appear with the rest of...

G Gerard

11-28-2007 08:11 PM
Albert D. Kallal

Hi All, I recently asked the DBA of the SQLServer database that I use to add a field and set the 'allow zero length strings' to No. after a couple...

bobh

11-28-2007 06:40 PM
lyle fairfield

Using a user dsn with Sybase 11 driver, I created a pass through query. When I run it, I get the following error msg: "Incorrect syntax near...

ragtopcaddy via AccessMonster.com

11-28-2007 05:29 PM
ragtopcaddy via AccessMonster.com

Hi All, I have a database that is used by many users. I want to monitor who uses what form and or clicks on certain buttons. Does anyone know of a...

mattc66 via AccessMonster.com

11-28-2007 05:01 PM
bobh