Hi Folks I have a user selection form with multiple combo box fields which are to make a selection to build criteria for a report. I have just...

Ceebaby via AccessMonster.com

04-09-2008 09:51 AM
timmg

Online matrimony is a service available on internet for those who are seeking brides and bridegrooms. The matrimonial websites contains the profiles...

raja

04-09-2008 12:45 AM
Larry Linson

I've set up a Union query and when I run it I get asked to enter a parameter value for one of the fields, not sure why and when I enter a value it...

hopciti

04-09-2008 12:23 AM
hopciti

I was just browsing through the following MS page: http://msdn2.microsoft.com/en-us/library/bb421308.aspx and was stunned to read: "Casual and...

Paul H

04-08-2008 11:22 PM
Tony Toews [MVP]

Hi all I'm new to the newsgroup and fairly new to Access so excuse any naivety please. In my database one of the tables is client info, on the form...

hopciti

04-08-2008 11:22 PM
Salad

I have several simple continuous forms in my Access 2007 database that are bound to tables that contain lookup lists. If I open one of these forms,...

Wayne

04-08-2008 10:36 PM
Wayne

Hi, Are the following lines of code the same, or is there a difference? Dim strVariable1, strVariable2, strVariable3 as String Dim strVariable1...

biganthony via AccessMonster.com

04-08-2008 09:59 PM
biganthony via AccessMonster.com

Hi.... I am learning about read only. I set read only but except one field that need to be edit. I am not going to figure it all night...

learning_codes@hotmail.com

04-08-2008 09:18 PM
lyle fairfield

i have a table with a yes/no field call "Edited". i have a button that runs code to set the "Edited" field of a selected record to "yes". the code...

fredloh@gmail.com

04-08-2008 05:02 PM
Larry Linson

I have seen no solution to this issue and was wondering if anyone had one. I am trying to disable the close button in the upper-right corner of the...

Vincent

04-08-2008 12:50 PM
Gert De Meulenaere

Hi all i have code which loops through table and deletes the duplicate records. This code does it for one table. How do i change it so it goes...

farouqdin@hotmail.com

04-08-2008 11:28 AM
Stuart McCall

Hello, I have been working with visual basic for a while but this is something I have never understood. I have some code in a VB6 application that...

Dsperry101 via AccessMonster.com

04-08-2008 11:01 AM
Salad

Is it possible to run Access 2000 .mde file on a PC that has only Access 2007 runtime installed?

Skeptik

04-08-2008 09:10 AM
Tom van Stiphout

How can I change the following query in order to give the user the precision choice rather than hard coded to 10 decimal places? SELECT...

colmkav

04-08-2008 08:49 AM
Tom van Stiphout

I have the situation where I have a lot of large databases that use a lot of the same functions. These prove very difficult to maintain and so I was...

pcatton@gmail.com

04-08-2008 08:45 AM
Tom van Stiphout

myDBA is software making the case for a new day in reporting. myDBA works by grouping important numbers together to allow individuals from large and...

myDBA4.com

04-07-2008 09:36 PM
Larry Linson

I have a Main form with a subform named Payments. I have a button on the main form named NewPaymentEntry that opens a small popup form to enter a...

Presto

04-07-2008 08:24 PM
Presto

When entering data into a continuous form in A2003, if I click the "New Record" button on the navigation bar, the form scrolls and places the new...

Wayne

04-07-2008 07:24 PM
DFS

Hello, again. What a great resource for us beginners is this forum! I've got another question...Even though the record selectors and navigation...

g_k_harrison@yahoo.com

04-07-2008 06:44 PM
Stuart McCall

I'm building a bookings database for trucks that among other things captures the TruckName, LoadDate, LoadTime, UnloadDate and UnloadTime. Is there...

Wayne

04-07-2008 06:43 PM
Wayne

Hi. I have a button - Command9 with the Click event to run this code on a form called frmSelforDel. Dim SQL1 As String DoCmd.SetWarnings False SQL1...

g_k_harrison@yahoo.com

04-07-2008 06:21 PM
g_k_harrison@yahoo.com

I know this should be simple, but in a sub-routine that's printing a large batch of reports, how do you code the routine to look for an escape key...

ARC

04-07-2008 05:46 PM
Rich P

Experts, Can you have "Or" allowed in the expression of a IFF Function? The following function works perfectly: IIf(="A",0,1) But I can't get it...

Shiller

04-07-2008 04:36 PM
Shiller

I created an application in Access 2007. One of the features required by the client is to create an .mdb file with one table in it for their use...

Tim Dunne

04-07-2008 03:32 PM
Tim Dunne

Is it a bug? Or is it a miracle? I had a problem that didn't make sense a couple of days ago that I found humorous and I thought I'd share it with...

Salad

04-07-2008 02:58 PM
Guillermo_Lopez

Greetings, I've been trying to optimize the performance of the queries in an Access 2007 front end that utilizes SQL server for all tables (linked)....

ysageev@gmail.com

04-07-2008 09:22 AM
Y

Hoi, In een formulier roep ik een module aan. Hoe kan ik de waarde van een variabele uit de module terughalen naar mijn formulier? Dank...

susan

04-07-2008 08:54 AM
Tom van Stiphout

I have a user defined type BoatDetails in a standard module Public Type BoatDetails BtID As String BtName As String BtClass As String End Type I am...

Phil Stanton

04-07-2008 06:13 AM
rkc

I am trying to make a golf scorecard. I have a Course Details table that provides facts about the course, using the CourseDetailsID as the PK. My...

troy_lee@comcast.net

04-07-2008 02:15 AM
Phil Stanton

Hi, I have created a 2002 access database for which I want to lock specific fields depending on the user. The database contains text, memo,yes/no,...

FJ

04-06-2008 09:22 PM
FJ

I'm hoping for some guidance here! The problem is this: I am running Access 97 under Vista, everything works great except I have a macro that does...

Beau Coup

04-06-2008 06:15 PM
Tony Toews [MVP]

I have not played with 'Type's before, but want to use the same code to combine Boat IDs, Boat Names and Class of boat where one person has more than...

Phil Stanton

04-06-2008 03:09 PM
rkc

When i send a report as a pdf and prompt for editing, I then send the email, an additional window then opens behind How can I prevent this window...

ixusit@googlemail.com

04-06-2008 02:12 PM
Tony Toews [MVP]

I have a shared Access mdb that was originally written in A2000. The database is large, around 40 tables, 40 forms (many with multiple sub-forms),...

Randy Shore

04-06-2008 12:52 AM
SmartbizAustralia

Hi. I am stumped. I have a form that when opened via logic (VBA OpenForm) the screen appears to flash but the form does not appear. I've traced and...

Susan Bricker

04-05-2008 08:36 PM
Salad

Hi, i've created a linked table in my access database (with DoCmd.TransferDatabase). But how can i retrieve the info about that table? i'd like to...

Mido Moonlite

04-05-2008 05:59 PM
PW

Using Access 2003 front end; SQL Server 2005 Back end: I have a complex form that has lots of data fields including about thirty or so checkboxes...

Jim Mandala

04-05-2008 11:29 AM
Jim Mandala

On 3 Apr 2008 23:26:31 GMT, "David W. Fenton" <XXXusenet (AT) dfenton (DOT) com.invalid> wrote: Yes, I am quite sure... that your memory must have...

HH

04-04-2008 10:51 PM
DFS

Hi, I'm having an issue with Tony's Auto FE Updater I was hoping someone could help with. I need to use UNC instead of mapped drive letters her in...

bobh

04-04-2008 03:51 PM
bobh

Hi, Is it possible to back up the data.mdb file when the user exits the executable (.mde)? How would I do that? And also perform a compact and...

PW

04-04-2008 12:33 PM
PW

Hello. I need to search 6 different fields for a key word. The way I normally query data is in a single field with the critera: Like '*' & & '*'. ...

Alex Pavluck

04-04-2008 10:29 AM
Allen Browne

The short version; In short, given one date range (start and end dates) how can I find the period that overlaps with another date range? The long...

Deano

04-04-2008 02:41 AM
Albert D. Kallal

Hi, I have a table with a string field that can store numeric field. How do I make a query to compare this field with a numeric...

sigava77 via AccessMonster.com

04-03-2008 11:33 PM
Allen Browne

Hello, Somebody knows how to disable the combobox button in Access 2002. I want to prevent the list be displayed. Thanks.

CenturionX

04-03-2008 11:20 PM
Tom van Stiphout

I have an application that runs as a .mde, just fine with A2K and A2K3 but gets errors and won't start when trying to run it in A2K7. I haven't had...

Arch

04-03-2008 03:46 PM
Arch

I am trying to get a "Date entered" box to automatically fill when a tick box = true, without success so its over to the experts for some much needed...

paul.bentley@networkrail.co.uk

04-03-2008 03:44 PM
Salad

Hello There, I was just working on a project of creating a database for a relative that have alots of clients. His company managed the shares...

edmund_xue

04-03-2008 02:51 PM
CDMAPoster@fortunejames.com

So I've got a table full of orders. I have a query that counts the orders, no problem. Now I've also got a query that tells me if the order is due...

Scott269

04-03-2008 10:23 AM
Guillermo_Lopez

For the last 7 years we have been using a piece of software that's based on Access 2000. About two years ago I created several MS Word documents...

silvionr@gmail.com

04-03-2008 10:09 AM
silvionr@gmail.com

I am trying to instantiate an activex control directly from a class module. My declaration is as follows: Private WithEvents myPCCharge...

Vincent

04-03-2008 09:11 AM
Vincent