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 25 of 100
Search took 0.59 seconds.
Search: Posts made by: forest8
Forum: General Discussion June 6th, 2010, 03:56 AM Posted to microsoft.public.access
Replies: 2
Views: 2,997
Posted By forest8
Adding Microsoft ActiveX Data Objects 6.0 Library

I don't understand. What am i supposed to do?

"Banana" wrote:

On 6/4/10 7:07 PM, forest8 wrote:
Hi there

I am working on an Access database with another person.

Apparently I...
Forum: General Discussion June 5th, 2010, 03:07 AM Posted to microsoft.public.access
Replies: 2
Views: 2,997
Posted By forest8
Adding Microsoft ActiveX Data Objects 6.0 Library

Hi there

I am working on an Access database with another person.

Apparently I need to add "Microsoft ActiveX Data Objects 6.0 Library"
because he made references to this library.

How do I find...
Forum: General Discussion May 31st, 2010, 09:34 PM Posted to microsoft.public.access
Replies: 1
Views: 397
Posted By forest8
#Name? error in Formula

Hi there

As I mentioned in the subject line, I am currently getting a @Name? error in
a formula.

The formula I have...
Forum: General Discussion May 28th, 2010, 06:07 AM Posted to microsoft.public.access
Replies: 3
Views: 255
Posted By forest8
Help with this Search button

Hi there

I made tje suggested change and I now see both the first name and last name
in the search.

But I have two questions:

1. The names aren't alphabetically. Is it possible to have the names...
Forum: General Discussion May 28th, 2010, 02:25 AM Posted to microsoft.public.access
Replies: 3
Views: 255
Posted By forest8
Help with this Search button

Hi

I have a database of students.

I have created a search box (through an unbound box).

I have the following in the rowsource:

Row Source: SELECT DISTINCT [First Name] FROM T_Participants ORDER...
Forum: General Discussion May 24th, 2010, 04:18 AM Posted to microsoft.public.access
Replies: 1
Views: 183
Posted By forest8
Question about recordsource

Hi there

What does the following mean?

I have been told that I should fix the recordsource for my forms.

What does it mean to use the table name or * select * from tablename?

Where do I put this...
Forum: General Discussion May 22nd, 2010, 04:52 AM Posted to microsoft.public.access
Replies: 2
Views: 218
Posted By forest8
Convert a field from long integer to Autonumber

Hi there

In my database, there is field called Student_ID which is a long integer
field which someone has created manually.

I want to have all new students to have IDs that are autonumbers.

Is it...
Forum: General Discussion May 20th, 2010, 06:24 AM Posted to microsoft.public.access
Replies: 2
Views: 231
Posted By forest8
Need to normalize some tables after database has been split

Hi there

I realize that I have to normalize some of my tables in my database but I
have split the database.

My question is, what is the best way to do this?

All these tables have been referenced...
Forum: New Users May 5th, 2010, 04:19 PM Posted to microsoft.public.access.gettingstarted
Replies: 2
Views: 321
Posted By forest8
Error message when adding a new record

Hi

This is the situation:

In my database, my user has added a record for a new student. When she
pressed save, the following message appeared:

“The record cannot be deleted or changed because...
Forum: General Discussion April 24th, 2010, 04:41 PM Posted to microsoft.public.access
Replies: 2
Views: 74
Posted By forest8
Didn't convert FE to mde is that an issue?

Thank you for the response and the reinsurance.

After making the changes, I will ensure that I create a mde.


"John W. Vinson" wrote:

On Fri, 23 Apr 2010 22:51:01 -0700, forest8
...
Forum: General Discussion April 24th, 2010, 06:51 AM Posted to microsoft.public.access
Replies: 2
Views: 74
Posted By forest8
Didn't convert FE to mde is that an issue?

Hi

After splitting my database I didn't covert the FE to a mde. Is that an issue?

If it is, how do I fix it?

I also have to made some changes to the database. If I make changes to the
backend,...
Forum: General Discussion April 21st, 2010, 08:56 PM Posted to microsoft.public.access
Replies: 5
Views: 132
Posted By forest8
Updating a split database

Hi again

I won't be able to get my split database from my users until the
administrator returns from holidays.

Can I work on my version of the database (BE and FE) and then somehow add to
the...
Forum: General Discussion April 19th, 2010, 05:52 AM Posted to microsoft.public.access
Replies: 5
Views: 132
Posted By forest8
Updating a split database

Hi there

I've searched through the access forum and found several possible ways to do
this but I thought I'd ask for confirmation.

I have split my database and distributed to my users but I need...
Forum: New Users April 12th, 2010, 08:45 AM Posted to microsoft.public.access.gettingstarted
Replies: 2
Views: 343
Posted By forest8
Can't split a database

Hi there

I am currently trying to split my database for my users (since there are 10
of them) but I am getting an error message.

It says the following:

Database Splitter
The database engine...
Forum: New Users April 11th, 2010, 03:40 PM Posted to microsoft.public.access.gettingstarted
Replies: 10
Views: 358
Posted By forest8
Printing a single record from a tab control subform

The value in the Link Master/Child properties is the Students_ID.

If I don't try to print a single record, I could see the report/subreport.
When I try to isolate a single record, the report...
Forum: New Users April 11th, 2010, 03:19 AM Posted to microsoft.public.access.gettingstarted
Replies: 2
Views: 318
Posted By forest8
Changing the page setup for printing

Hi there

Currently, when my report prints, it is in landscape.

How can I change it so that it prints portrait and is reduced 75%?

Is it possible to set this up in a macro?

Thank you
Forum: New Users April 11th, 2010, 02:03 AM Posted to microsoft.public.access.gettingstarted
Replies: 10
Views: 358
Posted By forest8
Printing a single record from a tab control subform

Hi there

I'm having another issue with this. As I mentioned earlier, my report is
based on a report and subreport.

When I see my report for a single record, it's only showing the report
portion...
Forum: New Users April 10th, 2010, 12:36 PM Posted to microsoft.public.access.gettingstarted
Replies: 10
Views: 358
Posted By forest8
Printing a single record from a tab control subform

The primary keys are Autonumbers.

The Master and child fields are text. Is it possible to use the non-primary
keys as the basis of the "Where" statement?

Thanks

"Duane Hookom" wrote:

Learn the...
Forum: Setting Up & Running Reports April 10th, 2010, 06:14 AM Posted to microsoft.public.access.reports
Replies: 3
Views: 136
Posted By forest8
Having problems printing a single report

Should I be using the primary key or can I use any variable?

Thank you.


"Allen Browne" wrote:

It seems your student code field is a text field, not a number field. You
will therefore need to...
Forum: New Users April 10th, 2010, 06:12 AM Posted to microsoft.public.access.gettingstarted
Replies: 10
Views: 358
Posted By forest8
Printing a single record from a tab control subform

Hi

This is the code for the print function as an Event procedure. I'm not sure
what I'm missing.

Private Sub Print_Click()

Dim strDocName As String
Dim strWhere As String
strDocName = "R1-1...
Forum: Setting Up & Running Reports April 10th, 2010, 01:54 AM Posted to microsoft.public.access.reports
Replies: 3
Views: 136
Posted By forest8
Having problems printing a single report

Hi

This is the code I have entered in the event procedure to print a single
record.

Unfortunately, it's not working. How do I fix this code:

Private Sub Print_this_record_Click()

Dim strDocName...
Forum: New Users April 9th, 2010, 11:03 PM Posted to microsoft.public.access.gettingstarted
Replies: 10
Views: 358
Posted By forest8
Printing a single record from a tab control subform

Hi

I have created a Case Management Database of students. It consists of a main
form
and a subform. The main form consists of information that must be seen at
all times. since it consists of...
Forum: Setting Up & Running Reports April 9th, 2010, 05:23 AM Posted to microsoft.public.access.reports
Replies: 2
Views: 117
Posted By forest8
Create a report based on information from two forms

Hi there

After posting my very convoluted question, I discovered that a
report/subreport was the best way to go.

Since then, I have created six of my reports.

Thank you for answering my...
Forum: Setting Up & Running Reports April 9th, 2010, 02:11 AM Posted to microsoft.public.access.reports
Replies: 2
Views: 117
Posted By forest8
Create a report based on information from two forms

Hi

I need to create several reports which have the appearance of the forms in
my database.

The top half of the form/report contains information that must be on every
report so I created a base...
Forum: New Users April 9th, 2010, 01:24 AM Posted to microsoft.public.access.gettingstarted
Replies: 2
Views: 308
Posted By forest8
Split database before or after sending out

Hi there

I am about ready to send the Access Database to a friend who's asked me to
create a database for him.

Since I don't know how his network is set up, should I split the database
before I...
Showing results 1 to 25 of 100

 
Forum Jump

All times are GMT +1. The time now is 12:22 AM.


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