A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Search Forums
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Showing results 1 to 20 of 20
Search took 0.02 seconds.
Search: Posts made by: Jörn Bosse[_3_]
Forum: Setting Up & Running Reports June 7th, 2010, 04:37 PM Posted to microsoft.public.access.reports
Replies: 1
Views: 1,865
Posted By Jörn Bosse[_3_]
stLinkcriteria no longer working (since 2007 upgrade)

Well,

the code seems fine if the criteria really is a string.
Did you already tried to create a new form with the same recordsource?

Regards
Jörn

Am 07.06.2010 17:28, schrieb arathra:
We have...
Forum: Using Forms June 7th, 2010, 02:34 AM Posted to microsoft.public.access.forms
Replies: 1
Views: 2,097
Posted By Jörn Bosse[_3_]
Default font for forms in Access 2007

Am 07.06.2010 02:56, schrieb gg:
How do you set a default font for a form or a report in Access 2007?. Mine
is always Calibri 11. Changing each time is tedious. I have looked at
several...
Forum: Running & Setting Up Queries June 7th, 2010, 01:06 AM Posted to microsoft.public.access.queries
Replies: 2
Views: 800
Posted By Jörn Bosse[_3_]
calculating average days

Hi,

i would do this in the query by using the DateDiff-Function.
Take a look at this link:
http://www.techonthenet.com/access/functions/date/datediff.php

Regards
Jörn
Forum: New Users June 6th, 2010, 05:22 PM Posted to microsoft.public.access.gettingstarted
Replies: 3
Views: 2,603
Posted By Jörn Bosse[_3_]
Export in cvs format

Hey,

well first you have to create a manual export and save this export
secification. I bet you mean csv-format and not cvs-format.
If you want to user your code, you have to change the...
Forum: New Users June 6th, 2010, 12:36 PM Posted to microsoft.public.access.gettingstarted
Replies: 3
Views: 2,603
Posted By Jörn Bosse[_3_]
Export in cvs format

Am 06.06.2010 09:09, schrieb Luciano:
Hi
I already do export some reports en queries in to an
.xls/rtf/tst/pdf-format. But my webmaster want it exported in cvs format. Is
this possible?

Hi...
Forum: Database Design June 6th, 2010, 12:33 PM Posted to microsoft.public.access.tablesdbdesign
Replies: 1
Views: 2,291
Posted By Jörn Bosse[_3_]
i have a good 'schema, where do i go from here?

Well,

now you should start creating forms. You may start with the forms for
members. Creating a new one/editing onformation/deleting members.
The you do the same thing with the courses and sessions...
Forum: General Discussion June 5th, 2010, 04:30 PM Posted to microsoft.public.access
Replies: 2
Views: 1,660
Posted By Jörn Bosse[_3_]
Where is the startup manager in 2007

Hi there,

why don´t you create a macro named Autoexec. It will do everything you
want when you start your database.

Regards
Jörn


Am 05.06.2010 17:11, schrieb JS5:
Forum: Database Design June 5th, 2010, 12:35 PM Posted to microsoft.public.access.tablesdbdesign
Replies: 9
Views: 1,975
Posted By Jörn Bosse[_3_]
Help needed with table design/layout for newbie

Hi,

thats looks fine. But i would add a location to the sessions table and
for the members maybe a date of birth. But the rest is really ok.
You did a gread job so far.

Jörn


Am 05.06.2010...
Forum: Database Design June 4th, 2010, 11:44 PM Posted to microsoft.public.access.tablesdbdesign
Replies: 9
Views: 1,975
Posted By Jörn Bosse[_3_]
Help needed with table design/layout for newbie

Yep that looks fine. Remember if you need a field in comination with a
user and sessions, you have to put it in that table.
Any more questions?

Jörn


Am 04.06.2010 23:47, schrieb jase118:
Jörn...
Forum: Running & Setting Up Queries June 4th, 2010, 11:10 PM Posted to microsoft.public.access.queries
Replies: 2
Views: 417
Posted By Jörn Bosse[_3_]
A field (string) is into other field (string)

Am 05.06.2010 00:03, schrieb Victor2020:
Using 2 tables I want to get the rows that match where the content of the
field (string) is equal or is into other field (string) from other table.

You...
Forum: Database Design June 4th, 2010, 10:26 PM Posted to microsoft.public.access.tablesdbdesign
Replies: 9
Views: 1,975
Posted By Jörn Bosse[_3_]
Help needed with table design/layout for newbie

When you setup relations, the fields need the same type: both integer
values. As it seems, your tblSessionMembers is the table to create the
m:n-relationship between members and sessions. Thats why...
Forum: Using Forms June 4th, 2010, 10:05 PM Posted to microsoft.public.access.forms
Replies: 1
Views: 1,676
Posted By Jörn Bosse[_3_]
Conditional Formatting

Hi,

try those links:
http://www.lebans.com/conditionalformatting.htm
http://www.lebans.com/formatbycriteria.htm

these are the most recent ways to solve your quest.

Regards
Jörn
Forum: General Discussion June 4th, 2010, 08:33 PM Posted to microsoft.public.access
Replies: 2
Views: 411
Posted By Jörn Bosse[_3_]
Calculating number of days from input.

Am 04.06.2010 21:17, schrieb Dave:
How do you calculate the number of days from the original date the the record
was recorded.

for example

You have a text box the has three options 90...
Forum: General Discussion June 4th, 2010, 08:28 AM Posted to microsoft.public.access
Replies: 8
Views: 435
Posted By Jörn Bosse[_3_]
Finding a record through a form

Am 04.06.2010 01:26, schrieb Leza S.:
In response to your questions:

1. Regarding name of textbox, I don't have a textbox. I was using a field
pulled
from the table.
2. No query...
Forum: General Discussion June 3rd, 2010, 09:40 PM Posted to microsoft.public.access
Replies: 2
Views: 334
Posted By Jörn Bosse[_3_]
Calculating time

Am 03.06.2010 21:23, schrieb Dave:
I have a single table database that has a drop down box of 60 days, 90 days,
and 180 days.

I want to calculate to time from the date of entry in the...
Forum: General Discussion June 3rd, 2010, 09:26 PM Posted to microsoft.public.access
Replies: 8
Views: 435
Posted By Jörn Bosse[_3_]
Finding a record through a form

Am 03.06.2010 21:57, schrieb Leza S.:
Thanks, Jorn, I tried this and although it worked, it pops up a parameter
search dialog box, which I do not want. I want to be able to type the ID
number...
Forum: General Discussion June 3rd, 2010, 07:18 PM Posted to microsoft.public.access
Replies: 3
Views: 509
Posted By Jörn Bosse[_3_]
Display a message box "this entry is a duplicate"

Am 03.06.2010 19:32, schrieb Tina:
How can I display a message box on a form if the shipment number is a
duplicate? I need a message box to pop up when user attempts to tab out of
the...
Forum: General Discussion June 3rd, 2010, 01:25 AM Posted to microsoft.public.access
Replies: 8
Views: 435
Posted By Jörn Bosse[_3_]
Finding a record through a form

Hi,

create a button with this code:

DoCmd.OpenForm "FormName", acNormal, , "ID = " & Me.YourTXTfield,
acFormReadOnly

instead of Formname you have du write the name of your Form. And instead
of...
Forum: General Discussion June 3rd, 2010, 01:18 AM Posted to microsoft.public.access
Replies: 3
Views: 322
Posted By Jörn Bosse[_3_]
One field, multiples entries

Am 03.06.2010 01:09, schrieb Patrick Stubbin:
Many eyars ago I used a database language called "PICK", this enabled you to
have a field with multiples entries in one record of a table. I read
...
Forum: General Discussion June 2nd, 2010, 12:47 AM Posted to microsoft.public.access
Replies: 2
Views: 371
Posted By Jörn Bosse[_3_]
User without license

Am 02.06.2010 01:16, schrieb Whitney:
How can I have multiple people enter data into an Access databse, without
paying for a license for every person. We have limited licenses, but I need
about...
Showing results 1 to 20 of 20

 
Forum Jump

All times are GMT +1. The time now is 06:36 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
Copyright 2004-2018 OfficeFrustration.
The comments are property of their posters.