dbTalk Databases Forums  

Sponsored Links


comp.databases.ms-access comp.databases.ms-access


Discuss in the comp.databases.ms-access forum.



Post New Thread
Threads in Forum : comp.databases.ms-access Forum Tools
  Rating Thread / Thread Starter Last Post Reverse Sort Order    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] Go to last post
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 Go to last post
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 Go to last post
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 Go to last post
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 Go to last post
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 Go to last post
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 Go to last post
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 Go to last post
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 Go to last post
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 Go to last post
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 Go to last post
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 Go to last post
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 Go to last post
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 Go to last post
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 Go to last post
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 Go to last post
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 Go to last post
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 Go to last post
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 Go to last post
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 Go to last post
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 Go to last post
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 Go to last post
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 Go to last post
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 Go to last post
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 Go to last post
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 Go to last post
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 Go to last post
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 Go to last post
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 Go to last post
0 1
9 tips for Mobile BI success Full...
Jan
08-14-2011 10:49 AM
Access Developer Go to last post
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 Go to last post
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 Go to last post
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 Go to last post
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 Go to last post
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 Go to last post
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 Go to last post
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 Go to last post
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 Go to last post
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 Go to last post
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 Go to last post
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 Go to last post
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? Go to last post
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 Go to last post
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 Go to last post
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 Go to last post
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 Go to last post
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 Go to last post
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 Go to last post
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 Go to last post
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 Go to last post
5 6
Post New Thread

Display Options
Showing threads 251 to 300 of 40778
Sorted By Sort Order
From The
Forum Tools Search this Forum
Search this Forum :

Advanced Search

New posts New posts More than 15 replies or 150 views Hot thread with new posts
No new posts No new posts More than 15 replies or 150 views Hot thread with no new posts
Closed Thread Thread is closed  
 
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off


Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.