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     
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 04:31 AM
Keith Wilby Go to last post
31 385
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 01: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 06: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 03: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 04:24 AM
Roman Trojan Go to last post
3 107
Anyone having same issue?
Rob Smiler
01-07-2010 09:27 PM
Tom van Stiphout Go to last post
2 111
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 08: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 11: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 04: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 09:04 PM
Salad Go to last post
10 226
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 10:10 AM
Ryker Go to last post
2 130
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 02: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 06:14 PM
Bob Darlington Go to last post
6 482
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 01:20 PM
J-P-W Go to last post
12 224
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 02: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 06: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 03:07 PM
Tom van Stiphout Go to last post
3 183
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 02: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 07:13 PM
David W. Fenton Go to last post
15 225
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 05:56 PM
Bob Darlington Go to last post
2 134
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 07:09 AM
Phil Go to last post
2 127
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 10:32 PM
Arvin Meyer [MVP] Go to last post
19 218
The following code calcuates the difference in work days between two dates: Function BusinessDays(PosHireDate, RepDate) As Long BusinessDays =...
jeromez
12-24-2009 08:29 AM
jeromez Go to last post
2 128
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 04: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 03:40 AM
Prakash Go to last post
2 131
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 01:58 AM
Salad Go to last post
11 225
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 07:11 PM
PW Go to last post
9 278
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 02:49 AM
Tony Toews [MVP] Go to last post
9 162
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 11:34 AM
Krzysztof Naworyta Go to last post
4 142
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 09:41 AM
Richard Cooke Go to last post
3 168
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 03: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 12:51 PM
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 01: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 04:28 AM
Filips Benoit Go to last post
6 196
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 08:42 PM
Mat Go to last post
10 206
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 06:35 PM
Roger Go to last post
1 105
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 11:18 AM
Karl Go to last post
10 216
* 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 09: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 01: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 06:00 PM
James A. Fortune Go to last post
1 247
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 04: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 10: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 08: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 01: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 11: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 10:47 PM
Momo4kids Go to last post
5 149
I have a textbox whose control source is a string expression parsed from (other) bound controls on the form. After the user enters new values in...
Ron
12-10-2009 08:50 PM
Ron Go to last post
3 143
Dear All, Opening Qry_CrossTab_1MonsterLocatie from cmd in FRM_MONSTER_LOCATIES triggers error: Microsoft Jet database engine does not...
Filips Benoit
12-10-2009 01:57 PM
Filips Benoit Go to last post
1 127
I am sending 500 e-mails from Access with customized PDFs and Excel worksheets and I want to bold one line in the e-mail. How would I do that and...
musicloverlch
12-09-2009 06:52 PM
Rick Brandt Go to last post
1 122
Those of you who are interested in using the Access database front end to sharepoint and allowing users to download the database and use it may be...
Bob Alston
12-09-2009 04:52 PM
David W. Fenton Go to last post
3 124
Post New Thread

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