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, We have a client complaining that every time they start up their MDE, they are getting the "Unsafe Expressions" security warnings. And one of...
12-22-2009 06:11 PM
PW Go to last post
9 275
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...
12-22-2009 01: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 =...
12-21-2009 10: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,...
12-21-2009 08: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...
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
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...
12-17-2009 12:19 PM
Phil Go to last post
12 194
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 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...
12-16-2009 07: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...
12-16-2009 05: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...
12-15-2009 10:18 AM
Karl Go to last post
10 215
* 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...
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...
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 241
In the code to define and run UserList it starts out like Sub ShowUserRosterMultipleUsers() Dim cn As New ADODB.Connection Dim cn2 As New...
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...
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...
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...
12-10-2009 09: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...
12-10-2009 07: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 12: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...
12-09-2009 05: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 03:52 PM
David W. Fenton Go to last post
3 124
Using A2007. I've got an excel spreadsheet that needs to be appended to 2 tables in an accdb. The 2 tables have a one-to-many relationship with...
12-09-2009 03:27 PM
Rich P Go to last post
1 115
anyone know how to open a report preview and automatically move to the last page from a command button on a form (ac07)? thanks!
12-09-2009 04:22 AM
Doughboy Go to last post
3 172
I have an Access table with columns like this: Exam Integer, Name Text, PassFail Text(1). The rows look like this: 2007, “Fred”, “P”; 2007,...
12-09-2009 04:22 AM
Rich P Go to last post
5 131
Using A2007. It's my first attempt at ADO. I've got an accdb with tables linked to SQL Server. I found code online to automatically relink tables...
12-08-2009 03:18 PM
emanning Go to last post
9 259
simplied code Dim wrk As DAO.Workspace Dim rs As DAO.Recordset Dim db As DAO.Database Set wrk = DBEngine.Workspaces(0) Set db =...
12-08-2009 02:49 PM
paii, Ron Go to last post
3 121
So, I use Access 2000 on a daily basis to manage a database of items. We did have everything networked so that the master database which resides on...
12-08-2009 01:58 PM
Salad Go to last post
4 159
Dear all, It would be practical if I could use the selection of records in the RecordSelectionBar the edit racords. Any idea on How ??? Filip
Filips Benoit
12-08-2009 12:00 PM
Salad Go to last post
4 134
I enjoyed reading Phil's table design review, and got high-centered on a similar issue this lovely Friday. This one is more simplistic (I hope) with...
12-08-2009 10:29 AM
Roger Go to last post
3 128
Hi all. While this question is more about design than about Access, I'm using Access to develop the solution and thus it is relevant. Just wondering...
12-07-2009 07:31 PM
Darragh Go to last post
5 167
Dear reader, When I opening a mdb the following message pops up. "Microsoft Office Access can't change the working directory to I:\" Under Tools...
12-07-2009 04:52 AM
J-P-W Go to last post
3 109
Please help me if you can, I am struggling to understand Access SQL joins With Normalized tables, how do I recall the text from 4 tables in the same...
Ken Ashton
12-06-2009 11:35 PM
Ken Ashton Go to last post
2 117
I have a table which is populated with fields as Year | Department number | Department Contact Person | Issues Faced | Steps taken to resolve them |...
12-06-2009 10:16 PM
s Go to last post
6 111
"Salad" <salad (AT) oilandvinegar (DOT) com> wrote that is very neat... In fact, if you start out a blank web form, I often drop in one text box...
Albert D. Kallal
12-06-2009 04:05 PM
Rick Brandt Go to last post
5 91
Does anyone know of any place where they are offering a beta version of the Sharepoint 2010 server so I can try out some of the new Access...
Bob Alston
12-06-2009 03:23 PM
David W. Fenton Go to last post
8 196
I would like to say that I am a beginner but I do not think that I am that advanced! This is my second Access database an i am having trouble with a...
12-06-2009 12:30 PM
BamaBlast Go to last post
4 125
Dear reader, With the following code you can transfer an Access report to the snapshot format: DoCmd.OutputTo acReport, stDocName, acFormatSNP,...
12-06-2009 10:01 AM
Simon Go to last post
2 100
Trying to publish an acces database to Access services using the free Microsoft Sharepoint live services. I ran the compatibility checker. No...
Bob Alston
12-05-2009 04:13 PM
Bob Alston Go to last post
3 113
I have a form button to add a new record. At the same time as the blank form opens I want to change the caption on the tab of the first page. The...
12-05-2009 01:10 PM
gorsoft@hotmail.com Go to last post
5 108
using access97, with a folder of PDF documents, one per item, created by the supplier and provided in pdf form I added an unbound object frame to my...
12-04-2009 05:03 PM
Roger Go to last post
2 107
I imagine this is a relatively simple matter, but it seems to be eluding me, so I turn to your vast knowledge for guidance (: I have a table...
Tim Olson
12-04-2009 12:16 PM
Tim Olson Go to last post
2 109
I want to take a date, add 90 days to it and then round that date down to the nearest Friday before the 90 day date. If the 90 day date is a Friday,...
12-04-2009 11:20 AM
James A. Fortune Go to last post
3 130
I'm stuck I have a table of Members Key MemberID Table of Boats Key BoatID Table of Storage Spaces (For the boats) Key SpaceID I need a table which...
Phil Stanton
12-04-2009 03:27 AM
Phil Stanton Go to last post
19 191
Hello Folks, After several months I needed to access and do some work on an older client database (2002-2003 version) I'm using XP and Access 2007...
12-03-2009 09:54 AM
flymo Go to last post
1 142
I have a database that contains these fields (among others): OrderNum Barcode StationNum ABC123 121212 3 G123 123456 ...
12-03-2009 07:55 AM
HS Hartkamp Go to last post
1 117
I have the following tables and fields in each table. Table: Customers CustomerID Company Table: Contacts ContactID CustomerID FirstNsmr LastName
Three Palms
12-03-2009 03:41 AM
ThreePalms Go to last post
2 121
I am trying to find just the (T) in a logical field in a database report. How do I write the expression in the expression builder box? JPC
John Callaway
12-03-2009 12:41 AM
zuckermanf@gmail.com Go to last post
1 99
Post New Thread

Display Options
Showing threads 2301 to 2350 of 35205
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.