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

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

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

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

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

Can anyone answer questions on how to set permissions for Access services in Sharepoint? I posted questions to the Sharepoint 2919 forum but have...

Bob Alston

12-10-2009 05:51 PM
Bob Alston

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

Hi all, I think I've annoyed Jet as much as possible, and may need to resort to VBA to write my crosstab. So I'm sure others have tackled...

Jeff

12-10-2009 08:11 AM
Jeff

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

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

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

If one looks at the headers for newsgroups in a newsgroup's emails in your newsreader, one can easily see how message threads work and how they find...

Salad

12-09-2009 01:25 PM
Salad

Anyone know how to set the permissions for different levels of users? See my question here that has not yet been answered by...

Bob Alston

12-09-2009 11:45 AM
Bob Alston

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

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

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

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

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

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

In an earlier post I mentioned that I was successful in creating a multi-boot environment in which I successfully installed Sharepoint 2010 beta and...

Bob Alston

12-08-2009 11:28 AM
Bob Alston

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

Hi Everyone, I am working on a block of code to automate some file downloads using IE. I am able to get to the download part no worries, but I am...

The Frog

12-08-2009 08:01 AM
The Frog

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

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-07-2009 03:12 PM
Roger

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

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

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

Thanks for posting Bob. I'm not sure he enhanced his case by arguing that the problem with Access is when a second user tries to access the same...

Allen Browne

12-06-2009 09:56 PM
Allen Browne

A nice article: http://dmoffat.wordpress.com/ Scroll down to "Performance Over A VPN Is Very Good in Access 2010 Hybrid App" The next article...

Bob Alston

12-06-2009 05:12 PM
Bob Alston

"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

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

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

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

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

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

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

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-04-2009 04:46 PM
Simon

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

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

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

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

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

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

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

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

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

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

praktikum ausland , arbeitsamt jobboerse , Innenarchitekt Innenarchitektin , karriere ausland , www ausland jobs , jobs und praktika im ausland ,...

karin gr4uberin

12-02-2009 04:28 AM
karin gr4uberin

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

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