Hello all, Due to some users experiencing severe front end bloating (Normal compacted front end .accdr is 27MB's, FE can bloat to 80-90+Mb's in a...

ARC

08-22-2008 08:50 AM
ARC

Hi guys, I have written the following code to filter based on a selection from a dropdown box, and it works: Private Sub...

katie.liddle@hotmail.co.uk

08-22-2008 06:52 AM
lyle fairfield

I am looking for VBA code that will work with Access 2003 to enable dragging and dropping a file/folder name from Windows XP Explorer into an Access...

John

08-22-2008 02:12 AM
Mihai B

The is a simple example of code that worked in access 2003 but does not in access 2007. I have checked it with the debugger and the reason is the...

pballou

08-21-2008 09:12 PM
pballou

If able, can someone please help make a Where clause that strings together IDs in a multi-select listbox AND includes a date range. I wasn’t...

6afraidbecause789@gmail.com

08-21-2008 04:40 PM
6afraidbecause789@gmail.com

I have created a form that has a list box that displays information queried from a table. I then have a textbox under the form and three buttons...

iwasinnihon

08-21-2008 08:10 AM
Marshall Barton

I recently sought help about how to prevent some users from accessing certain toolbars. Stuart McCall provided good advice with: CommandBars("Menu...

Jim Devenish

08-20-2008 07:47 PM
Albert D. Kallal

Hello everybody, Is anyone able to give me some indications about how to develop an Access interface for an Oracle database ? I dispose of Access...

Gloops

08-20-2008 03:13 PM
Gloops

I need to attach (link) a table in SQL Server 2005 database to an Access 2.0 front-end database: On Access 2.0: Click File\Attach Table..., select...

Mourad

08-20-2008 12:58 PM
Rich P

On 16 Aug 2008 21:40:30 GMT, "David W. Fenton" <XXXusenet (AT) dfenton (DOT) com.invalid> wrote: Many ISPs do just that. -Tom.

PeterW

08-20-2008 04:52 AM
AccessVandal via AccessMonster.com

Hi Fred I found an example that solved the problem, quite simple. Sql = "Select * from ........" Solution is: Sql = "Select * from...

Clive Swan

08-20-2008 03:58 AM
Clive Swan

Hi All, Just wondering if anyone knows if there's a way to iterate through all members of a user-defined data type? I'd like to Debug.Print all...

planetthoughtful

08-19-2008 09:05 PM
rkc

Sorry to re-post this question but still having problems with relationships I am running duplicate databases on 2 machines, Ak2 SP3 and windows XP...

Phil Stanton

08-19-2008 04:22 PM
Phil Stanton

OK, I've been watching my DB grow and have known for a long time I would have to move the back end, but of course I waited until I started getting...

Edward Reid

08-19-2008 03:09 PM
Edward Reid

If I run the following in a CMD window (win xp) tree > mytree.txt then open it with some text editor, I get stuff that looks like this... Folder...

MLH

08-19-2008 12:45 PM
MLH

Anyone know of a way to do this through code?

dmh_test1@yahoo.com

08-19-2008 11:59 AM
dmh_test1@yahoo.com

I created a simple form that includes a hyperlink field which when clicked, launches any given pdf file saved in a multi-user network. The problem...

Ruben

08-19-2008 01:10 AM
tina

Weird issue. Need to change the connection (dsn less connection of course) to sql server from access 2007 because they blew away the security...

SmartbizAustralia

08-18-2008 10:27 PM
SmartbizAustralia

For lack of the proper expression, how do I excite a control to cause events to trigger. I have a date control and am using a calender form button to...

Greg (codepug@gmail.com)

08-18-2008 10:23 PM
Larry Linson

i am trying to get "ID" an incremental number that simply resets to 1 each month in my "table1" thanks, -- Message posted via...

drrajnishpatel via AccessMonster.com

08-18-2008 02:30 PM
drrajnishpatel via AccessMonster.com

I'm using the Access User-Level Security features with various users set up. I have a form/timer all set up to trigger an event after a period...

RussCRM

08-18-2008 01:40 PM
RussCRM

Hello, I have to create a database for daily shipments. I am entering information into the database like pro-forma number, store number (which will...

Fred's

08-18-2008 01:13 PM
Fred's

I am fairly new to MS Access and I am creating a simple database. I have created a form that has information from a three different tables displayed...

iwasinnihon

08-18-2008 01:00 PM
iwasinnihon

Hi I'm using the following code to open a recordset: Dim con As New ADODB.Connection Dim rstZone As New ADODB.Recordset, rstZone2 As...

paulquinlan100@hotmail.com

08-18-2008 08:33 AM
paulquinlan100@hotmail.com

Without explicitly typing each global var into code module for displaying, does VBA have any facility for determining what GV's are defined in a...

MLH

08-18-2008 08:30 AM
Tom van Stiphout

Hello, I have three fields that holds expiration dates in a text box. I would like to be able to change the back color property to red when the...

Kissi Asiedu

08-17-2008 03:13 PM
Linq Adams via AccessMonster.com

I know little about RSS feeds (am probably even using the wrong term) but am interested in setting up a database that has automatically updated...

Steve

08-16-2008 11:13 PM
CDMAPoster@fortunejames.com

How much did a collection of items cost at some date in the past? If anyone could help me with this, I would be most appreciative. I am learning VBA...

Strasser

08-16-2008 02:31 PM
Phil Stanton

I have a db with about 75 forms. I am trying to tidy it up and would like to print out a list of all the forms to help in the process. I have...

post@vincentoakley.com

08-16-2008 07:53 AM
lyle fairfield

I have a strange situation. I have a fairly large application that I have converted to Access 2007. I realize the "toolbar" structure has changed....

iansknowles@gmail.com

08-15-2008 09:46 PM
Tom van Stiphout

Solution Note: I am experimenting with an excellent popup calendar I found on the Allen Browne web site. I was receiving the following error (Error...

Greg (codepug@gmail.com)

08-15-2008 09:10 PM
Allen Browne

Ever seen this vb error in A97?

MLH

08-15-2008 03:11 PM
Salad

Re: Access 2003 I have a process that sends out emails to addresses (internally in our company). Form1 has all the main functionality/data, etc on...

RLN

08-15-2008 03:08 PM
Salad

Background Access 2003. MDB Front End. I am populating a list box with the names of queries in the system. I am searching for strings in the query...

JvC

08-15-2008 12:12 PM
Salad

Hello Group, I was having the same issue as described...

krissco

08-15-2008 11:46 AM
krissco

I have the code below under a button on a form. At this point am just testing how to send email from MS Access. Access is installed on a machine...

TD

08-15-2008 11:43 AM
lyle fairfield

Dear reader, After same changes it is required to requery (refresh) query in a sub form. The code below is not working:

Simon van Beek

08-15-2008 01:50 AM
Salad

I have a text box with the date "08/14/2008" in it. I want to press a button and automatically calculate and place the date 1-year before in another...

Greg (codepug@gmail.com)

08-14-2008 07:11 PM
Bob Quintal

Does anyone have a good routine for EMail address validation? The one that I use is fairly primitive, and I need to beef it up. I have downloaded...

JvC

08-14-2008 02:30 PM
JvC

I have a form 'FmMessages" and a form 'FmLeads'. 'FmMessages', through code, opens 'FmMessages" if it is not already open. It then sets focus on...

dee

08-14-2008 11:53 AM
Bruce

How do I rewrite this expression in a query replacing the absolute value, CV-SC-03-00896M, with a field name ? I can't come up with the proper...

Jking482

08-14-2008 11:47 AM
Salad

My app works fine on my PC but when run on another PC the problem happens. There is no data displayed in the combobox when it drops down on...

twoDbarcoder

08-14-2008 11:08 AM
twoDbarcoder

On Aug 13, 7:03*pm, "David W. Fenton" <XXXuse... (AT) dfenton (DOT) com.invalid> wrote: I'd also like every user to be local, have a SQL Server...

Brian Nelson

08-14-2008 08:39 AM
Brian Nelson

Since Access 2002 ADP forms and reports have allowed their recordset to be set to an ADO recordset. This is very powerful, although those not so...

maxhugen

08-14-2008 07:52 AM
lyle fairfield

Hi - Has anyone ever used toggle buttons to select items in a listbox? I'd like to put about 24 toggle buttons on an unbound form that select or...

6afraidbecause789@gmail.com

08-14-2008 04:01 AM
Phil Stanton

I’m working on setting a date range for filtering that is created OnClick of a button. I want to use the current date as the EndDate and the...

Greg (codepug@gmail.com)

08-13-2008 08:14 PM
Greg (codepug@gmail.com)

I am using MS Access 2007 and have an issue with writing queries against ODBC connected tables. After providing the appropriate ODBC connection...

david.triplett@kdlinc.com

08-13-2008 04:08 PM
Gloops

Hi All Please can anyone advise whether it is possible to display messages in the status bar. I have a number of update queries which will be run...

Laetitia

08-13-2008 03:23 PM
Laetitia

See: http://blogs.zdnet.com/microsoft/?p=1519 "Microsoft officials announced at TechEd South Africa on August 6 that SQL Server 2008 has been...

Chris O'C

08-13-2008 01:52 PM
Chris O'C via AccessMonster.com

I would like to know how to delete one or more database objects programmatically. For example, delete all forms, or all reports, ...etc. I'm using...

Mourad

08-13-2008 12:02 PM
JvC