| | Rating Thread /
Thread Starter | Last Post  | Replies | Views |
 |  | I have a pass through query I created. It creates the QueryDef just fine, but if it already exists, it errors out. My query is going to be dynamic,...
mcolson
|
09-02-2011 06:42 PM
a a r o n . k e m p f @gmail.com [MCITP: DBA]  | 2 | 3 |
| | | I have a form with a background image and a number of image controls
superimposed over the background. The position of these images are defined...
Phil
|
09-02-2011 02:44 PM
Peter's Software | 5 | 6 |
 | | I have an Access 2003 report with the requirement that the height of
all the controls in the detail section automatically grow or shrink to
match the...
brucedodds
|
09-02-2011 01:52 PM
brucedodds | 15 | 16 |
| | | the following is used in access2007 (mdb) and it successfully loads a
QAT ribbon
the same function runs, without error, in access2010 (accdb),...
Roger
|
09-01-2011 11:23 PM
Roger | 1 | 2 |
| | | I've been away from access for a while, and my brain has locked up. I
have a form, (mimicking a paper form) that has many checkboxes
indicated the...
The T
|
09-01-2011 10:48 PM
James A. Fortune | 1 | 2 |
| | | What on earth is wrong here
Sub AppendData(TheDate As Date, TimeField As String, Watts As Integer)
Dim MyDb As Database
Dim DailySet As...
Phil
|
09-01-2011 04:33 PM
David-W-Fenton | 6 | 7 |
| | | They have an excel spreadsheet with 200 variables and 200
descriptions
I can import this into access to have it for work.
I need to make a new...
sparks
|
09-01-2011 01:39 PM
Access Developer | 7 | 8 |
| | | CEO of Yellowfin's talks at 'The New World of Data' conference on the
tactical use of big data
Video Link
http://www.youtube.com/watch?v=5VK11WBco2Q
Jan
|
09-01-2011 09:54 AM
Jan | 0 | 1 |
| | | I have an Access 2003 database with a SQL 2005 backend. I have
created a new table in SQL and refreshed the link in Access but the
new table will...
FireyColin
|
08-31-2011 06:57 AM
FireyColin | 2 | 3 |
| | | the following code segment fails on the update line when intN = 7,
with the error below
Dim rs4 As ADODB.Recordset
for intn = 1 to 10
set rs4 =...
Roger
|
08-30-2011 06:12 AM
Roger | 14 | 15 |
| | | I've imported my 2002 mdb into a 2010 accdb and started to reformat the
forms using different colours etc available through the themes using...
Bob Darlington
|
08-29-2011 02:50 AM
Bob Darlington | 0 | 1 |
| | | I like datasheets.
In Access I usually create a main form and in its header it typically
contains a logo along with checkboxes, dropdowns, date...
Patrick Finucane
|
08-28-2011 05:32 PM
Patrick Finucane | 0 | 1 |
| | | I have an excel pivot that links to an Access table. My problem is
that if any user has the excel open, I cannot refresh the access
table. Is there...
debbie
|
08-27-2011 12:58 AM
Tom van Stiphout | 1 | 2 |
| | | Hi all,
When you first place a new command button in Access 2010, with themes
turned on, it has a nice 3-d effect with some color gradient...
franc sutherland
|
08-25-2011 06:17 AM
franc sutherland | 2 | 3 |
| | | It was originally done in access 2003 and works fine.
now it does not work in access 2007 and after an update it will not
work in access 2003...
sparks
|
08-25-2011 05:10 AM
Phil | 18 | 19 |
| | | Hi everyone,
I am about to upgrade my hardware and software, and would like to know
what I really need to develop and sell Office2010 solutions. Do I...
The Frog
|
08-25-2011 01:04 AM
Tony Toews | 38 | 39 |
| | | Hi NG...
I try to make a file with CreateFile
It works fine - but...
When i make this line :
MyFile.WriteLine ("copy " & Folder & Filename & " " &...
bsn
|
08-24-2011 11:14 PM
Tony Toews | 28 | 29 |
| | | I used Access from version 2 to 97 and came here often, even posted
stuff. Great group.
Just dropped in for a look, amazed to see that the regs don't...
FarAway@LongAgo
|
08-24-2011 11:10 PM
Tony Toews | 1 | 2 |
| | | Please read the FAQ for this newsgroup at
http://www.mvps.org/access/netiquette.htm, where you will find that
advertising such as you posted (aka...
Access Developer
|
08-24-2011 12:19 PM
Access Developer | 0 | 1 |
| | | I am launching a mail merge process from within Access 97, using the
following code on a form button onclick event (both the database and
the mail...
Gina
|
08-24-2011 07:55 AM
Gina | 3 | 4 |
| | | I would like to find the end of month dates for each month between a given date range. For instance if the user of my database entered a start date...
Matt
|
08-23-2011 08:17 PM
Bob Barrows | 5 | 6 |
| | | Helo All,
I have been fussing around with a crosstab query - works fine.
I need to drop into a table in the same format as it is being...
flymo
|
08-23-2011 12:19 PM
flymo | 1 | 2 |
| | | Hi! In Access 2007: I'm getting the following message executing the
query below. The From clause specifies a query that has no where
criteria...
w
|
08-22-2011 01:27 AM
Access Developer | 5 | 6 |
| | | I am trying to convert an Access 2010 BE Db (Tables only, no fancy calculated
fields or data macros) into Access 2003 format. I use the Save &...
Phil
|
08-21-2011 07:58 PM
Access Developer | 13 | 14 |
| | | Hello,
I am new here and I hope I can find help to my rather serious problem.
'Rather serious' because I am now working with test data and I...
John
|
08-21-2011 07:48 PM
Access Developer | 2 | 3 |
| | | Using Access 2010 themes, I've found that I can use command buttons as
background shapes in my forms.
It's been working fine on my XP box and Win 7...
Bob Darlington
|
08-20-2011 11:00 PM
Bob Darlington | 6 | 7 |
| | | I've got a table with a field for 'birthdate'
I want to create a calculated field for 'age'
this expression...
Roger
|
08-19-2011 06:46 PM
Phil | 5 | 6 |
| | | This is further information on my posting about converting Access 2010 to
Access 2003 I have just removed and re-installed Office 2010 32 bit on...
Phil
|
08-19-2011 05:58 PM
David-W-Fenton | 6 | 7 |
| | | HI All,
In AccessXP I'm trying to use the IsHyperlink property of a textbox on
a form without success. Maybe I'm confused about how it works but...
bobh
|
08-16-2011 02:34 PM
bobh | 0 | 1 |
| | | 9 tips for Mobile BI success
Full...
Jan
|
08-14-2011 10:49 AM
Access Developer | 1 | 2 |
| | | How to calculate form field
Please any body know how to design a form with calculation on a field.
How can I format the table field to get result...
Lanka Danweem
|
08-14-2011 01:29 AM
Access Developer | 13 | 14 |
| | | 2 computers the one running Windows XP has a database running in
C:\Documents and Settings\Phil\MyDocuments\Access\MDB 2010.
The computer running...
Phil
|
08-13-2011 05:35 PM
David-W-Fenton | 5 | 6 |
| | | Hello All
I am using Duane Hookums excellent recurring database file and I have
modified quite a bit.
I have come across a basic problem - the...
flymo
|
08-12-2011 06:02 PM
Patrick Finucane | 1 | 2 |
| | | I am using Access 2000 on a Windows XP laptop. I have a command button
that opens a Windows dialog box and prompts you to "please choose a
file". The...
AndyT
|
08-12-2011 01:54 PM
AndyT | 7 | 8 |
| | | When I click on a new report I want the Print Preview Tab to become
visible AND have the focus.
I can't find a way in vba to put the focus on the...
christianlott1@yahoo.com
|
08-12-2011 01:48 PM
christianlott1@yahoo.com | 7 | 8 |
| | | I'm using a multiselect list box in Access 2010 and trying to set the
'Selected' value for a list row using:
With me!lstCont
.SetFocus
mCurrentIndex...
Bob Darlington
|
08-09-2011 06:33 PM
Douglas J. Steele | 1 | 2 |
| | | "monir 619" <monir619 (AT) gmail (DOT) com> wrote
Why do you think this would be of interest to us here? Do you think we have
nothing of higher...
Access Developer
|
08-09-2011 01:38 PM
Access Developer | 4 | 5 |
| | | Have been researching this for some time now, and I'm hoping someone
out there can help me.
I have an Access 97 database with Front End and Back End...
Jana
|
08-07-2011 04:21 PM
David-W-Fenton | 4 | 5 |
| | | hp dv6 t pavillion reviews
It's consistently showtime with the HP Pavilion dv6 t. Powered by a second-generation Intel Core i5 CPU with 6GB of...
monir 619
|
08-06-2011 04:55 PM
Tony Toews | 1 | 2 |
| | | We have a database that was split and has a backend on the server.
I asked why there were no relationships in it.
they said that it was not needed...
sparks
|
08-06-2011 04:54 PM
Tony Toews | 4 | 5 |
| | | Anyone know of any good & FREE tutorials for use of Access 2--3 pivot
tables? Looking for something to make available for end users.
I have given...
BobAlston
|
08-05-2011 05:39 PM
Arvin Meyer | 2 | 3 |
| | | I have a form with a treeview in it. I use the treeview to select the
product I want, showing me data on the selected node. I am using code
from a...
WhathaveIdone?
|
08-04-2011 02:54 PM
WhathaveIdone? | 7 | 8 |
| | | Access 2010 --- table1: (t_Students) with ID, Fname, Lname --- table
2: (t_Classes) with ClassNumber, ClassName --- table 3:
(t_StudentClasses) with...
Deac
|
08-03-2011 07:05 PM
Access Developer | 3 | 4 |
| | | I am using Access 2010. I have two programs, a barcode program and an
analysis program that link to the data file where all the tables are
located. I...
Bob B.
|
08-03-2011 02:36 PM
Access Developer | 1 | 2 |
| | | Is there anyway I can tell BEFORE I type something into a field that the record is locked by someone else?
Thanks,
Laura
musicloverlch
|
08-03-2011 01:29 PM
Patrick Finucane | 2 | 3 |
| | | using access2007 to connect to tables in sql server 2005
up to now I've been using the ;sql server' odbc driver
recently, another odbc driver 'sql...
Roger
|
08-02-2011 06:29 PM
Albert D. Kallal | 6 | 7 |
| | | ms access 2007
append data from multiple tables in one db to multiple tables in
another db and replace all foreign keys with new foreign key...
davjoh123@yahoo.com
|
08-02-2011 12:55 PM
davjoh123@yahoo.com | 0 | 1 |
| | | Have just installed Office SP1 and a perfectly stable Db now keeps crashing.
I thought Decompile had fixed it, but the Db seems to open OK the first...
Phil
|
08-01-2011 05:13 PM
David-W-Fenton | 7 | 8 |
| | | Can anyone reccommend a program that will transfer a BE database (Tables &
Relationships only) to MySQL For that matter does MySQL handle...
Phil
|
08-01-2011 11:42 AM
The Frog | 3 | 4 |
| | | I'm using Access 2010.
I want to use VBA to change the back color of labels in the footer of all
continuous forms in my application.
Using:
For Each...
Bob Darlington
|
07-31-2011 08:48 PM
Bob Darlington | 5 | 6 |
