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 report, used for various purposes and on the OnOpen event of the report, I set various label controls in the report header to Visible =...
Phil
01-11-2010 04:06 PM
Phil Go to last post
10 206
If I create a new query with the following criteria all works fine: Like "IE*" Or Like "UK*" And <> "UK - Service Desk UK/Ireland" And <> "UK - IT ...
Lynx101
01-11-2010 08:20 AM
Keith Wilby Go to last post
3 129
Hi All I need to update a 'local' table with a value coming from a SQLServer-table accessed via a passtrough-query. So I join my 'local' table with...
Daedalus
01-11-2010 05:59 AM
Roger Go to last post
3 138
Some time ago, Albert Kallah wrote that with Access 2010 it was possible to store access 2010 data on Sharepoint 2010 but still run the Access client...
Bob Alston
01-11-2010 04:00 AM
Keith Wilby Go to last post
47 427
Hi I can't find the proper way to use a common dialog box (file selection) on one of my forms, though I'm sure it can not be too difficult. So I...
Daedalus
01-11-2010 03:31 AM
Keith Wilby Go to last post
31 392
Does anyone know how to open an extern file from a formular? I have a formular with a field containing a filename related to a pdf file in a...
Finn
01-10-2010 12:21 PM
Finn Go to last post
4 128
I have a string like: "C:\MyFolder\MyApp\abc.mdb" What function can delete every character behind the last \ ? It should work regardless of the...
Lars Brownies
01-08-2010 05:44 PM
Lars Brownies Go to last post
2 121
Anyone out there testing Access 2010 capabilities with sharepoint 2010? I am particularly interested in the capabilities to allow you to upload an...
Bob Alston
01-08-2010 02:53 PM
Bob Alston Go to last post
2 121
I have connection to Access database and a name of a view Dim Conn As New System.Data.OleDb.OleDbConnection Conn.ConnectionString = "..." Dim...
Roman Trojan
01-08-2010 03:24 AM
Roman Trojan Go to last post
3 109
Anyone having same issue?
Rob Smiler
01-07-2010 08:27 PM
Tom van Stiphout Go to last post
2 112
I'm using Access 2002 and have been getting the subject message more recently lately. In the most recent case, I was (for the first time) able to...
Bob Darlington
01-07-2010 07:40 PM
Bob Darlington Go to last post
2 111
Hello, I have a problem within the form where I have date with default value 'Date()' which is formatted as week ('ww') showing week number. It was...
avi
01-07-2010 10:18 AM
Michiel Rapati-Kekkonen Go to last post
11 197
Hi I'd like to retrieve the timestamp of .jpg-files. The only thing I found was that this info is stored in the exif-data of the files, but I can't...
Daedalus
01-07-2010 03:40 AM
Allen Browne Go to last post
5 175
Good Morning All!! I have used a practice for years that is suddenly not working. If I need a parameter for a report, I use an input box to get the...
Matthew Wells
01-06-2010 08:04 PM
Salad Go to last post
10 229
I have a form and a subform. The main form has order id field which is an autonumber type. The subform also has order id field which is a number...
Ryker
01-05-2010 09:10 AM
Ryker Go to last post
2 131
Hi, In AccessXP a have a form with a combobox on it, it's recordsource is SELECT tblCandidates.LName, tblCandidates.FName, tblCandidates.ColUniNme,...
bobh
01-04-2010 01:21 PM
bobh Go to last post
5 150
Using Word merge from Access 2002 has just started generating the following error: 'word cannot start the converter mswrd632 wpc.(5132)' Has been...
Bob Darlington
01-03-2010 05:14 PM
Bob Darlington Go to last post
6 506
Hi, A client has a very important business critical database system, but are after greater performance. Currently they have two front end versions...
J-P-W
01-03-2010 12:20 PM
J-P-W Go to last post
12 225
If I compact & repair a FE AK2 database I normally get no problems. If I set the option to compact & repair it on close, I frequently get an error...
Phil
01-02-2010 01:03 PM
Tom van Stiphout Go to last post
1 94
Does anybody know how to change and apply a theme to a database? I can see the theme formatting but cannot figure out how to apply a new theme and...
Yuval Nir
12-30-2009 05:26 PM
Yuval Nir Go to last post
2 142
I launch Outlook form MS Access 2003 using the code under the double line. When I send the first email it works fine. But if I send another email...
robboll
12-30-2009 02:07 PM
Tom van Stiphout Go to last post
3 185
Using Access 2010, I need the Treeview control & ListImage control. They appear OK in the Insert ActiveX menu as version 6, but when I try to insert...
Phil
12-30-2009 01:22 PM
Phil Go to last post
2 134
I have come across www.fontstuff.com by Martin Green. He seems to be a gifted teacher (so I recommend the site for some things like using SQL in the...
Strasser
12-29-2009 06:13 PM
David W. Fenton Go to last post
15 227
My application uses A2002 with up to 8 concurrent users with record level locking on open. The site is remote from my office. From time to time, one...
Bob Darlington
12-28-2009 04:56 PM
Bob Darlington Go to last post
2 136
Access 2010 & Windows 7. Can anyone give me the code to open the Font dialog box and the Colour dialog box. What APIs do I need Many Thanks Phil
Phil
12-28-2009 06:09 AM
Phil Go to last post
2 128
I have the following query, that has been in use for 3 years that extracts GL positing from a Jet/Access97 table that has existed for 10 years....
paii, Ron
12-24-2009 09:32 PM
Arvin Meyer [MVP] Go to last post
19 221
The following code calcuates the difference in work days between two dates: Function BusinessDays(PosHireDate, RepDate) As Long BusinessDays =...
jeromez
12-24-2009 07:29 AM
jeromez Go to last post
2 129
Dear All, I copyed 3 access2003 databases to my laptop, all 3 having 1 form that's exactly the same. In that form 1 combobox ( the same in all 3...
Filips Benoit
12-23-2009 03:08 AM
Filips Benoit Go to last post
7 172
I have 2 buttons on a form. Both buttons invoke the same report named "BS". In my report header I have a label depicting the report header. If...
Prakash
12-23-2009 02:40 AM
Prakash Go to last post
2 132
I have a form containing the following code in the Current Event. However, sometimes (only sometimes) it throws up an error message on the "If =...
Prakash
12-23-2009 12:58 AM
Salad Go to last post
11 227
Hi, We have a client complaining that every time they start up their MDE, they are getting the "Unsafe Expressions" security warnings. And one of...
PW
12-22-2009 06:11 PM
PW Go to last post
9 312
Let's say all users have A2003 and A2007. I guess by using the following it should always start A2003 for the app. ;this is the expected default...
Salad
12-22-2009 01:49 AM
Tony Toews [MVP] Go to last post
9 163
In a class form I am doing the following. Public Property Set Form(FrmIn As Access.Form) Set frm = FrmIn frm.OnGotFocus = "" frm.BeforeUpdate =...
Mat
12-21-2009 10:34 AM
Krzysztof Naworyta Go to last post
4 143
Hi I have a form that start on open i would like to show the current date in Day(text), date(number), month(text), year(number) i'e Monday, 7,...
kevcar40
12-21-2009 08:41 AM
Richard Cooke Go to last post
3 169
I have the following code that is used to determine a person's age as of the run date. I'm receiving an error message in my query related to this...
Coll
12-21-2009 02:49 AM
Allen Browne Go to last post
1 134
I have two dates: StartDate = 11/09/2009 ReportDate = 11/30/2009 I know that days elapsed is simply: - = 21 Days
jeromez
12-19-2009 11:51 AM
jeromez Go to last post
2 122
I am convertin from AK2 to A2010. VBA routines which opened Windows explorer to find files or folders no longer work (unsurprisingly) Can anyone help...
Phil
12-17-2009 12:19 PM
Phil Go to last post
12 194
CDO
Dear All, using function below without attachment send an email with an attachment like ATT?????.dat. What can i do about this. Thanks, Filips
Filips Benoit
12-17-2009 03:28 AM
Filips Benoit Go to last post
6 198
When I open the form normally, ie: From the database window, the combo box works correctly. The query behind the combo box references a field on the...
Mat
12-16-2009 07:42 PM
Mat Go to last post
10 209
I have a report (reportA) with sorting / grouping by 'description' and that works fine if I include reportA as a subreport in reportB the reportB...
Roger
12-16-2009 05:35 PM
Roger Go to last post
1 106
I don't even know why I am asking again but surely someone here has been successful exporting Access data (2003 in our case) **TO** Quickbooks? My...
PW
12-15-2009 10:18 AM
Karl Go to last post
10 219
* Begginner I have just created my 2nd ever database. The database was built in Access 2003 using the 2000 file structure. I have split the...
BamaBlast
12-15-2009 08:14 AM
BamaBlast Go to last post
3 107
Hi all. I'm not sure if this is possible, but can one use a combo box lookup for a value being currently inserted in the same tuple in an...
Darragh
12-15-2009 12:46 AM
Darragh Go to last post
4 118
This might be of help to some people. I have been producing some PDF reports lately directly from Access using the basic techniques found...
James A. Fortune
12-14-2009 05:00 PM
James A. Fortune Go to last post
1 271
In the code to define and run UserList it starts out like Sub ShowUserRosterMultipleUsers() Dim cn As New ADODB.Connection Dim cn2 As New...
Salad
12-12-2009 03:01 PM
David W. Fenton Go to last post
4 130
Using Access 2010 Beta; just wondering if Intellesense is available in the VBA editor when writing procedures (it's not working in my install). I...
Joseph Macari
12-12-2009 09:45 AM
Joseph Macari Go to last post
2 125
I have an application that keeps track of payments. Those payments can be applied to various fees. I am trying to figure out how to create a report...
Bill
12-12-2009 07:14 AM
Roger Go to last post
2 144
Is it possible to have defaults with lookups? Sorry, not sure how to explain this without an...
Astley Le Jasper
12-11-2009 12:10 PM
Salad Go to last post
12 194
Hello, I have a table of reports and the functions that must run before the report is opened. Set db = DBEngine(0)(0) sSQL = "SELECT DISTINCTROW...
bipin
12-10-2009 10:12 PM
Tom van Stiphout Go to last post
1 130
I am using a function that I found in Microsoft Support Article ID: 210350. It allows you to"Print a Constant Number of Lines Per Group". The...
Momo4kids
12-10-2009 09:47 PM
Momo4kids Go to last post
5 149
Post New Thread

Display Options
Showing threads 2301 to 2350 of 35234
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 - 2015, Jelsoft Enterprises Ltd.