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 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 148
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 07:50 PM
Ron Go to last post
3 142
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...
musicloverlch
12-09-2009 05:52 PM
Rick Brandt Go to last post
1 121
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 123
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...
emanning
12-09-2009 03:27 PM
Rich P Go to last post
1 114
anyone know how to open a report preview and automatically move to the last page from a command button on a form (ac07)? thanks!
doughboy
12-09-2009 04:22 AM
Doughboy Go to last post
3 171
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,...
Gilgamesh
12-09-2009 04:22 AM
Rich P Go to last post
5 130
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...
emanning
12-08-2009 03:18 PM
emanning Go to last post
9 256
simplied code Dim wrk As DAO.Workspace Dim rs As DAO.Recordset Dim db As DAO.Database Set wrk = DBEngine.Workspaces(0) Set db =...
Roger
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...
Sylvia
12-08-2009 01:58 PM
Salad Go to last post
4 158
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 133
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...
Jeff
12-08-2009 10:29 AM
Roger Go to last post
3 127
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...
Darragh
12-07-2009 07:31 PM
Darragh Go to last post
5 166
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...
Simon
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 |...
s
12-06-2009 10:16 PM
s Go to last post
6 110
"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 90
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...
BamaBlast
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,...
Simon
12-06-2009 10:01 AM
Simon Go to last post
2 99
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...
gorsoft@hotmail.com
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...
Roger
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,...
Utah_Jackson
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...
flymo
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 ...
Martin
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
I have created a report that lists students in a class. The report can have any where from 3 to 25 students. After the students are printed I want...
Momo4
12-02-2009 07:48 PM
Momo4kids Go to last post
1 90
I am trying to create a custom QAT ribbon and I'm almost there..... I have created the XML code below in USysRibbon table and it seems to work...
zuckermanf@gmail.com
12-02-2009 12:18 PM
zuckermanf@gmail.com Go to last post
1 97
I have a form & subform, both based on queries that use functions to return the values, so they run quite slowly ( about 5 seconds each) The subform...
Phil Stanton
12-02-2009 11:54 AM
Phil Stanton Go to last post
2 138
dear All, I am trying to enlarge a text field from 100 to 200 characters. I get the error message 'Can't change the data type', 'not enough disk...
John Fox
12-02-2009 03:31 AM
John Fox Go to last post
5 103
I have a form with one text box on it (Simple example) The code OnOpen is Private Sub Form_Open(Cancel As Integer) Me.Controls(0).ControlSource =...
Phil Stanton
12-01-2009 10:42 AM
Phil Stanton Go to last post
7 120
Using this method of creating a user login form: http://www.databasedev.co.uk/login.html is it possible to capture the username and have that...
Dominic
12-01-2009 08:30 AM
Dominic Go to last post
2 107
I was wondering how a field might be updated in a form. This example is pretty stupid but let's say you had an employee form with a termination date...
Salad
12-01-2009 05:46 AM
Albert D. Kallal Go to last post
3 114
Still using AK2, I have a BE/FE database. Most of the tables are in the BE, but I have a few control tables in the FE. Until recently the FE...
Phil Stanton
12-01-2009 03:19 AM
Phil Stanton Go to last post
3 106
I have some questions on A2010 table design and wonder if you csn shed any light on them. I created a blank web database and then a table. One can...
Salad
12-01-2009 02:23 AM
Salad Go to last post
2 190
Just started using Access 2010 web forms. Am I correct that with web forms, we lose the ability to drag and drop a control into any...
Bob Alston
11-30-2009 06:39 PM
Bob Alston Go to last post
2 116
"James A. Fortune" <CDMAPoster (AT) FortuneJames (DOT) com> wrote in news:a8dd5ff2-b5de-41ac-b10b-708a9060b9f2 (AT) f10g2000vbl (DOT)...
Bob Alston
11-30-2009 04:42 PM
James A. Fortune Go to last post
26 224
"Salad" <oil (AT) vinegar (DOT) com> wrote There is 2 args, the 1st one is the variable you want set, and the 2nd arg is the...
Salad
11-30-2009 04:23 PM
David W. Fenton Go to last post
19 206
On Nov 27, 1:23*pm, "Ken Snell " <kthsneisll... (AT) ncoomcastt (DOT) renaetl> wrote: Hi Ken:
jeromez
11-30-2009 01:23 PM
jeromez Go to last post
16 198
I want to cocatenate the address line for a report so that it appears in a row with no spaces. The query has this: Address: & ", " & & ", " & &...
gorsoft@hotmail.com
11-30-2009 09:09 AM
gorsoft@hotmail.com Go to last post
4 80
So I have been creating classes for various controls in access and moving code that was on my forms to the classes. It's been fun and helped simplify...
Mat
11-30-2009 12:38 AM
Mat Go to last post
5 99
I'm using Access 2002 to create a snapshot using: DoCmd.OutputTo acOutputReport, strReport, "SnapshotFormat(*.snp)", strSnapshotFile It works fine...
Bob Darlington
11-29-2009 07:39 PM
Bob Darlington Go to last post
6 54
Post New Thread

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