See all records entered

Amelia · Jul 23, 2009

Can you help me and tell me what to fix in my form? I have a form set up but
once I enter a record in the form and exit the form and then go back to the
form I can not see the record I just entered. I can see it added it to my
table, but I can not see it in the form view. I have the "continous form"
selected. Is this not what I want or is there somewhere else I need to set a
property to be able to see these forms?

I hope that makes sense, please help!

Amelia · Jul 23, 2009

I have that propery set to "no" and I still can not see my other records. Any
other suggestions?

Gina Whipp · Jul 23, 2009

Amelia,

What do you see when you open the RecordSource of your form?

Also, where is the scroll bar? If you have your form set to go to new
record then it will be scrolled down to the bottom and you will need to
scroll up to see your other records.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

Amelia · Jul 23, 2009

I have seen this code and tried this also:

Private Sub Form_Load()
If Not Me.NewRecord Then
RunCommand acCmdRecordsGoToNew
End If
End Sub

This is not working either. I am at a lost!! Please help!

Amelia · Jul 23, 2009

I get a new form to fill in. There is a scroll bar on the right side, but
that is only to scroll down my current record. I do not see any previously
entered records. On the bottom where it says how many records, it says
"Record: 1 of 1" and the first and last record arrows I am able to use but
not the previous and next arrow. Also the first and last arrows don't go
anywhere.

I am able to add a record, then add a new record and be able to scroll
through the records I add in one sitting. But if I close out of the database
and then go back to add additional records and/or scroll through previous
records I am unable to see the previous records then.

Gina Whipp · Jul 23, 2009

Look at your scroll bar and try to move it up, you should then see your old
records...

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

Gina Whipp · Jul 23, 2009

Amelia,

Okay then what is the RecordSource of your form and do you have any filters
applied?

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

Amelia · Jul 23, 2009

No, it only scrolls about 1/2" to see the rest of the current form I am on. I
do not see any previous records. I use to be able to see them and then as I
was working on it that option went away. I have compared it to properties of
other forms that I have set so I can see the previous records and they are
all set the same. So I don't know what to do.

Amelia · Jul 23, 2009

this is the record source: SELECT Invoices.[Qty 1], Invoices.[Fee 1], [qty
1]*[fee 1] AS [Total 1], Invoices.[Qty 2], Invoices.[Fee 2], [qty 2]*[fee 2]
AS [Total 2], Invoices.[Qty 3], Invoices.[Fee 3], [qty 3]*[fee 3] AS [Total
3], Invoices.[Qty 4], Invoices.[Fee 4], [qty 4]*[fee 4] AS [Total 4], [total
1]+[total 2]+[total 3]+[total 4] AS Subtotal, IIf([tax
exempt]=True,0,[subtotal]*0.065) AS Tax, [subtotal]+[tax] AS [Total Due],
Invoices.[Invoice Number], Invoices.PID,

I did have a filter earlier and then I cleared it thinking this was causing
me not to view the other records. But so far nothing has changed. Another
thing that is strange is I have a form called "Reciepts" and I have a command
button that goes back to the invoices, and when I click the command button it
asks me for the invoice number like I want it to do, but it goes to a blank
form even though I know the invoice exists. So I will need to look into that
and see if that is causing some of my headaches.

Gina Whipp · Jul 23, 2009

Amelia,

This does not appear to the RecordSource of the form OR parts of are
missing. It should end with a semi-colon *;* and I do not see that. Please
open the form in Design View, go to Properties and at the top where it say
ReordSource copy/paste that here.

Also, I will say that you have sommited spreadsheet with Access. It seems
as though your table is set up like and Excel spreadhseet. But we are going
to work with what we have. BUT that is something you may want to seriously
consider reviewing and redo your tables.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

Amelia said:
this is the record source: SELECT Invoices.[Qty 1], Invoices.[Fee 1], [qty
1]*[fee 1] AS [Total 1], Invoices.[Qty 2], Invoices.[Fee 2], [qty 2]*[fee
2]
AS [Total 2], Invoices.[Qty 3], Invoices.[Fee 3], [qty 3]*[fee 3] AS
[Total
3], Invoices.[Qty 4], Invoices.[Fee 4], [qty 4]*[fee 4] AS [Total 4],
[total
1]+[total 2]+[total 3]+[total 4] AS Subtotal, IIf([tax
exempt]=True,0,[subtotal]*0.065) AS Tax, [subtotal]+[tax] AS [Total Due],
Invoices.[Invoice Number], Invoices.PID,

I did have a filter earlier and then I cleared it thinking this was
causing
me not to view the other records. But so far nothing has changed. Another
thing that is strange is I have a form called "Reciepts" and I have a
command
button that goes back to the invoices, and when I click the command button
it
asks me for the invoice number like I want it to do, but it goes to a
blank
form even though I know the invoice exists. So I will need to look into
that
and see if that is causing some of my headaches.

Gina Whipp said:

Amelia,

Okay then what is the RecordSource of your form and do you have any
filters
applied?

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

Click to expand...

Doctor · Jul 24, 2009

Create a button on your form and put the code below into it. Then if you
click the button and all of your records appear, then your problem is that
you are somehow programattically setting your form to only create new
records. (Your code below in this post sets your form to only add new records.

Create a new button and call it Edit All. Here is the code.

Dim rst As DAO.Recordset, strSearch As String
If Me.Dirty Then
Me.Dirty = False
End If
On Error GoTo EditAll_Err
' Put me back in edit all mode and try to restore position
' Save a search string for the current row
' sub ID for whatever your Primary Key is called.
strSearch = "[ID] = " & Me![ID]
DoCmd.ShowAllRecords
If Len(strSearch) > 14 Then
Set rst = Me.RecordsetClone
rst.FindFirst strSearch
If Not rst.NoMatch Then
Me.Bookmark = rst.Bookmark
End If
rst.Close
Set rst = Nothing
End If

Amelia · Jul 24, 2009

I did copy and paste what was in my record source. And that is what it gave
me. I am not sure what you mean in your 2nd paragraph.

Gina Whipp said:
Amelia,

This does not appear to the RecordSource of the form OR parts of are
missing. It should end with a semi-colon *;* and I do not see that. Please
open the form in Design View, go to Properties and at the top where it say
ReordSource copy/paste that here.

Also, I will say that you have sommited spreadsheet with Access. It seems
as though your table is set up like and Excel spreadhseet. But we are going
to work with what we have. BUT that is something you may want to seriously
consider reviewing and redo your tables.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

Amelia said:

this is the record source: SELECT Invoices.[Qty 1], Invoices.[Fee 1], [qty
1]*[fee 1] AS [Total 1], Invoices.[Qty 2], Invoices.[Fee 2], [qty 2]*[fee
2]
AS [Total 2], Invoices.[Qty 3], Invoices.[Fee 3], [qty 3]*[fee 3] AS
[Total
3], Invoices.[Qty 4], Invoices.[Fee 4], [qty 4]*[fee 4] AS [Total 4],
[total
1]+[total 2]+[total 3]+[total 4] AS Subtotal, IIf([tax
exempt]=True,0,[subtotal]*0.065) AS Tax, [subtotal]+[tax] AS [Total Due],
Invoices.[Invoice Number], Invoices.PID,

I did have a filter earlier and then I cleared it thinking this was
causing
me not to view the other records. But so far nothing has changed. Another
thing that is strange is I have a form called "Reciepts" and I have a
command
button that goes back to the invoices, and when I click the command button
it
asks me for the invoice number like I want it to do, but it goes to a
blank
form even though I know the invoice exists. So I will need to look into
that
and see if that is causing some of my headaches.

Gina Whipp said:

Amelia,

Okay then what is the RecordSource of your form and do you have any
filters
applied?

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

I get a new form to fill in. There is a scroll bar on the right side,
but
that is only to scroll down my current record. I do not see any
previously
entered records. On the bottom where it says how many records, it says
"Record: 1 of 1" and the first and last record arrows I am able to use
but
not the previous and next arrow. Also the first and last arrows don't
go
anywhere.

I am able to add a record, then add a new record and be able to scroll
through the records I add in one sitting. But if I close out of the
database
and then go back to add additional records and/or scroll through
previous
records I am unable to see the previous records then.

:

Amelia,

What do you see when you open the RecordSource of your form?

Also, where is the scroll bar? If you have your form set to go to new
record then it will be scrolled down to the bottom and you will need
to
scroll up to see your other records.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

Can you help me and tell me what to fix in my form? I have a form
set
up
but
once I enter a record in the form and exit the form and then go back
to
the
form I can not see the record I just entered. I can see it added it
to
my
table, but I can not see it in the form view. I have the "continous
form"
selected. Is this not what I want or is there somewhere else I need
to
set
a
property to be able to see these forms?

I hope that makes sense, please help!

Click to expand...

Click to expand...

Amelia · Jul 24, 2009

I tried the code and it does not work. I am new at coding so you have to let
me know which areas I should replace with my field names.

Doctor said:
Create a button on your form and put the code below into it. Then if you
click the button and all of your records appear, then your problem is that
you are somehow programattically setting your form to only create new
records. (Your code below in this post sets your form to only add new records.

Create a new button and call it Edit All. Here is the code.

Dim rst As DAO.Recordset, strSearch As String
If Me.Dirty Then
Me.Dirty = False
End If
On Error GoTo EditAll_Err
' Put me back in edit all mode and try to restore position
' Save a search string for the current row
' sub ID for whatever your Primary Key is called.
strSearch = "[ID] = " & Me![ID]
DoCmd.ShowAllRecords
If Len(strSearch) > 14 Then
Set rst = Me.RecordsetClone
rst.FindFirst strSearch
If Not rst.NoMatch Then
Me.Bookmark = rst.Bookmark
End If
rst.Close
Set rst = Nothing
End If

Amelia said:

I have seen this code and tried this also:

Private Sub Form_Load()
If Not Me.NewRecord Then
RunCommand acCmdRecordsGoToNew
End If
End Sub

This is not working either. I am at a lost!! Please help!

Click to expand...

Amelia · Jul 24, 2009

I created a query and then changed that to be my record source. Now I can see
all of my previously entered records. But now my "new record" button is
grayed out. It will not let me create a new record.

Gina Whipp said:
Amelia,

This does not appear to the RecordSource of the form OR parts of are
missing. It should end with a semi-colon *;* and I do not see that. Please
open the form in Design View, go to Properties and at the top where it say
ReordSource copy/paste that here.

Also, I will say that you have sommited spreadsheet with Access. It seems
as though your table is set up like and Excel spreadhseet. But we are going
to work with what we have. BUT that is something you may want to seriously
consider reviewing and redo your tables.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

Amelia said:

this is the record source: SELECT Invoices.[Qty 1], Invoices.[Fee 1], [qty
1]*[fee 1] AS [Total 1], Invoices.[Qty 2], Invoices.[Fee 2], [qty 2]*[fee
2]
AS [Total 2], Invoices.[Qty 3], Invoices.[Fee 3], [qty 3]*[fee 3] AS
[Total
3], Invoices.[Qty 4], Invoices.[Fee 4], [qty 4]*[fee 4] AS [Total 4],
[total
1]+[total 2]+[total 3]+[total 4] AS Subtotal, IIf([tax
exempt]=True,0,[subtotal]*0.065) AS Tax, [subtotal]+[tax] AS [Total Due],
Invoices.[Invoice Number], Invoices.PID,

I did have a filter earlier and then I cleared it thinking this was
causing
me not to view the other records. But so far nothing has changed. Another
thing that is strange is I have a form called "Reciepts" and I have a
command
button that goes back to the invoices, and when I click the command button
it
asks me for the invoice number like I want it to do, but it goes to a
blank
form even though I know the invoice exists. So I will need to look into
that
and see if that is causing some of my headaches.

Gina Whipp said:

Amelia,

Okay then what is the RecordSource of your form and do you have any
filters
applied?

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

I get a new form to fill in. There is a scroll bar on the right side,
but
that is only to scroll down my current record. I do not see any
previously
entered records. On the bottom where it says how many records, it says
"Record: 1 of 1" and the first and last record arrows I am able to use
but
not the previous and next arrow. Also the first and last arrows don't
go
anywhere.

I am able to add a record, then add a new record and be able to scroll
through the records I add in one sitting. But if I close out of the
database
and then go back to add additional records and/or scroll through
previous
records I am unable to see the previous records then.

:

Amelia,

What do you see when you open the RecordSource of your form?

Also, where is the scroll bar? If you have your form set to go to new
record then it will be scrolled down to the bottom and you will need
to
scroll up to see your other records.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

Can you help me and tell me what to fix in my form? I have a form
set
up
but
once I enter a record in the form and exit the form and then go back
to
the
form I can not see the record I just entered. I can see it added it
to
my
table, but I can not see it in the form view. I have the "continous
form"
selected. Is this not what I want or is there somewhere else I need
to
set
a
property to be able to see these forms?

I hope that makes sense, please help!

Click to expand...

Click to expand...

Gina Whipp · Jul 24, 2009

Ameila,

Then there is a problem because that was not all the code. As I indicated
it should end in a semi-colon which means there is a piece missing. Okay
let's do this... Open your form in design view, press the build button
[...], a seperate window should open, once open you should see a query grid
window. In the upper left hand corner select SQL from the drop down and
then copy/paste that data here.

The second part indicates your data is not normalized. You should not have
fields in your table the look like Qty 1, Qty 2, Qty 3, etc... There should
be on field *qty* and it should be many to one Invoice. If that is stilll
unclear, perhaps reading the below will help...

Jeff Conrad's resources page:
http://www.accessmvp.com/JConrad/accessjunkie/resources.html

The Access Web resources page:
http://www.mvps.org/access/resources/index.html

A free tutorial written by Crystal (MS Access MVP):
http://allenbrowne.com/casu-22.html

MVP Allen Browne's tutorials:
http://allenbrowne.com/links.html#Tutorials

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

Amelia said:
I did copy and paste what was in my record source. And that is what it gave
me. I am not sure what you mean in your 2nd paragraph.

Gina Whipp said:

Amelia,

This does not appear to the RecordSource of the form OR parts of are
missing. It should end with a semi-colon *;* and I do not see that.
Please
open the form in Design View, go to Properties and at the top where it
say
ReordSource copy/paste that here.

Also, I will say that you have sommited spreadsheet with Access. It
seems
as though your table is set up like and Excel spreadhseet. But we are
going
to work with what we have. BUT that is something you may want to
seriously
consider reviewing and redo your tables.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

Amelia said:

this is the record source: SELECT Invoices.[Qty 1], Invoices.[Fee 1],
[qty
1]*[fee 1] AS [Total 1], Invoices.[Qty 2], Invoices.[Fee 2], [qty
2]*[fee
2]
AS [Total 2], Invoices.[Qty 3], Invoices.[Fee 3], [qty 3]*[fee 3] AS
[Total
3], Invoices.[Qty 4], Invoices.[Fee 4], [qty 4]*[fee 4] AS [Total 4],
[total
1]+[total 2]+[total 3]+[total 4] AS Subtotal, IIf([tax
exempt]=True,0,[subtotal]*0.065) AS Tax, [subtotal]+[tax] AS [Total
Due],
Invoices.[Invoice Number], Invoices.PID,

I did have a filter earlier and then I cleared it thinking this was
causing
me not to view the other records. But so far nothing has changed.
Another
thing that is strange is I have a form called "Reciepts" and I have a
command
button that goes back to the invoices, and when I click the command
button
it
asks me for the invoice number like I want it to do, but it goes to a
blank
form even though I know the invoice exists. So I will need to look into
that
and see if that is causing some of my headaches.

:

Amelia,

Okay then what is the RecordSource of your form and do you have any
filters
applied?

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

I get a new form to fill in. There is a scroll bar on the right side,
but
that is only to scroll down my current record. I do not see any
previously
entered records. On the bottom where it says how many records, it
says
"Record: 1 of 1" and the first and last record arrows I am able to
use
but
not the previous and next arrow. Also the first and last arrows
don't
go
anywhere.

I am able to add a record, then add a new record and be able to
scroll
through the records I add in one sitting. But if I close out of the
database
and then go back to add additional records and/or scroll through
previous
records I am unable to see the previous records then.

:

Amelia,

What do you see when you open the RecordSource of your form?

Also, where is the scroll bar? If you have your form set to go to
new
record then it will be scrolled down to the bottom and you will
need
to
scroll up to see your other records.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

Can you help me and tell me what to fix in my form? I have a form
set
up
but
once I enter a record in the form and exit the form and then go
back
to
the
form I can not see the record I just entered. I can see it added
it
to
my
table, but I can not see it in the form view. I have the
"continous
form"
selected. Is this not what I want or is there somewhere else I
need
to
set
a
property to be able to see these forms?

I hope that makes sense, please help!

Click to expand...

Click to expand...

Amelia · Jul 24, 2009

I finally got it. I changed the record source to a single query (only one
table) Then the field that needed to be updated from another table I added it
using the "add existing fields" and then changed that fields record source.

Thanks for the time and help!

Amelia said:
I created a query and then changed that to be my record source. Now I can see
all of my previously entered records. But now my "new record" button is
grayed out. It will not let me create a new record.

Gina Whipp said:

Amelia,

This does not appear to the RecordSource of the form OR parts of are
missing. It should end with a semi-colon *;* and I do not see that. Please
open the form in Design View, go to Properties and at the top where it say
ReordSource copy/paste that here.

Also, I will say that you have sommited spreadsheet with Access. It seems
as though your table is set up like and Excel spreadhseet. But we are going
to work with what we have. BUT that is something you may want to seriously
consider reviewing and redo your tables.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

Amelia said:

this is the record source: SELECT Invoices.[Qty 1], Invoices.[Fee 1], [qty
1]*[fee 1] AS [Total 1], Invoices.[Qty 2], Invoices.[Fee 2], [qty 2]*[fee
2]
AS [Total 2], Invoices.[Qty 3], Invoices.[Fee 3], [qty 3]*[fee 3] AS
[Total
3], Invoices.[Qty 4], Invoices.[Fee 4], [qty 4]*[fee 4] AS [Total 4],
[total
1]+[total 2]+[total 3]+[total 4] AS Subtotal, IIf([tax
exempt]=True,0,[subtotal]*0.065) AS Tax, [subtotal]+[tax] AS [Total Due],
Invoices.[Invoice Number], Invoices.PID,

I did have a filter earlier and then I cleared it thinking this was
causing
me not to view the other records. But so far nothing has changed. Another
thing that is strange is I have a form called "Reciepts" and I have a
command
button that goes back to the invoices, and when I click the command button
it
asks me for the invoice number like I want it to do, but it goes to a
blank
form even though I know the invoice exists. So I will need to look into
that
and see if that is causing some of my headaches.

:

Amelia,

Okay then what is the RecordSource of your form and do you have any
filters
applied?

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

I get a new form to fill in. There is a scroll bar on the right side,
but
that is only to scroll down my current record. I do not see any
previously
entered records. On the bottom where it says how many records, it says
"Record: 1 of 1" and the first and last record arrows I am able to use
but
not the previous and next arrow. Also the first and last arrows don't
go
anywhere.

I am able to add a record, then add a new record and be able to scroll
through the records I add in one sitting. But if I close out of the
database
and then go back to add additional records and/or scroll through
previous
records I am unable to see the previous records then.

:

Amelia,

What do you see when you open the RecordSource of your form?

Also, where is the scroll bar? If you have your form set to go to new
record then it will be scrolled down to the bottom and you will need
to
scroll up to see your other records.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

Can you help me and tell me what to fix in my form? I have a form
set
up
but
once I enter a record in the form and exit the form and then go back
to
the
form I can not see the record I just entered. I can see it added it
to
my
table, but I can not see it in the form view. I have the "continous
form"
selected. Is this not what I want or is there somewhere else I need
to
set
a
property to be able to see these forms?

I hope that makes sense, please help!

Click to expand...

Click to expand...

Gina Whipp · Jul 24, 2009

Amelia,

Then your new query is UNupdatable, you will need to fix the query.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

Amelia said:
I created a query and then changed that to be my record source. Now I can
see
all of my previously entered records. But now my "new record" button is
grayed out. It will not let me create a new record.

Gina Whipp said:

Amelia,

This does not appear to the RecordSource of the form OR parts of are
missing. It should end with a semi-colon *;* and I do not see that.
Please
open the form in Design View, go to Properties and at the top where it
say
ReordSource copy/paste that here.

Also, I will say that you have sommited spreadsheet with Access. It
seems
as though your table is set up like and Excel spreadhseet. But we are
going
to work with what we have. BUT that is something you may want to
seriously
consider reviewing and redo your tables.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

Amelia said:

this is the record source: SELECT Invoices.[Qty 1], Invoices.[Fee 1],
[qty
1]*[fee 1] AS [Total 1], Invoices.[Qty 2], Invoices.[Fee 2], [qty
2]*[fee
2]
AS [Total 2], Invoices.[Qty 3], Invoices.[Fee 3], [qty 3]*[fee 3] AS
[Total
3], Invoices.[Qty 4], Invoices.[Fee 4], [qty 4]*[fee 4] AS [Total 4],
[total
1]+[total 2]+[total 3]+[total 4] AS Subtotal, IIf([tax
exempt]=True,0,[subtotal]*0.065) AS Tax, [subtotal]+[tax] AS [Total
Due],
Invoices.[Invoice Number], Invoices.PID,

I did have a filter earlier and then I cleared it thinking this was
causing
me not to view the other records. But so far nothing has changed.
Another
thing that is strange is I have a form called "Reciepts" and I have a
command
button that goes back to the invoices, and when I click the command
button
it
asks me for the invoice number like I want it to do, but it goes to a
blank
form even though I know the invoice exists. So I will need to look into
that
and see if that is causing some of my headaches.

:

Amelia,

Okay then what is the RecordSource of your form and do you have any
filters
applied?

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

I get a new form to fill in. There is a scroll bar on the right side,
but
that is only to scroll down my current record. I do not see any
previously
entered records. On the bottom where it says how many records, it
says
"Record: 1 of 1" and the first and last record arrows I am able to
use
but
not the previous and next arrow. Also the first and last arrows
don't
go
anywhere.

I am able to add a record, then add a new record and be able to
scroll
through the records I add in one sitting. But if I close out of the
database
and then go back to add additional records and/or scroll through
previous
records I am unable to see the previous records then.

:

Amelia,

What do you see when you open the RecordSource of your form?

Also, where is the scroll bar? If you have your form set to go to
new
record then it will be scrolled down to the bottom and you will
need
to
scroll up to see your other records.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

Can you help me and tell me what to fix in my form? I have a form
set
up
but
once I enter a record in the form and exit the form and then go
back
to
the
form I can not see the record I just entered. I can see it added
it
to
my
table, but I can not see it in the form view. I have the
"continous
form"
selected. Is this not what I want or is there somewhere else I
need
to
set
a
property to be able to see these forms?

I hope that makes sense, please help!

Click to expand...

Click to expand...

Gina Whipp · Jul 24, 2009

You're welcome...

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

Amelia said:
I finally got it. I changed the record source to a single query (only one
table) Then the field that needed to be updated from another table I added
it
using the "add existing fields" and then changed that fields record
source.

Thanks for the time and help!

Amelia said:

I created a query and then changed that to be my record source. Now I can
see
all of my previously entered records. But now my "new record" button is
grayed out. It will not let me create a new record.

Gina Whipp said:

Amelia,

This does not appear to the RecordSource of the form OR parts of are
missing. It should end with a semi-colon *;* and I do not see that.
Please
open the form in Design View, go to Properties and at the top where it
say
ReordSource copy/paste that here.

Also, I will say that you have sommited spreadsheet with Access. It
seems
as though your table is set up like and Excel spreadhseet. But we are
going
to work with what we have. BUT that is something you may want to
seriously
consider reviewing and redo your tables.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

this is the record source: SELECT Invoices.[Qty 1], Invoices.[Fee 1],
[qty
1]*[fee 1] AS [Total 1], Invoices.[Qty 2], Invoices.[Fee 2], [qty
2]*[fee
2]
AS [Total 2], Invoices.[Qty 3], Invoices.[Fee 3], [qty 3]*[fee 3] AS
[Total
3], Invoices.[Qty 4], Invoices.[Fee 4], [qty 4]*[fee 4] AS [Total 4],
[total
1]+[total 2]+[total 3]+[total 4] AS Subtotal, IIf([tax
exempt]=True,0,[subtotal]*0.065) AS Tax, [subtotal]+[tax] AS [Total
Due],
Invoices.[Invoice Number], Invoices.PID,

I did have a filter earlier and then I cleared it thinking this was
causing
me not to view the other records. But so far nothing has changed.
Another
thing that is strange is I have a form called "Reciepts" and I have a
command
button that goes back to the invoices, and when I click the command
button
it
asks me for the invoice number like I want it to do, but it goes to a
blank
form even though I know the invoice exists. So I will need to look
into
that
and see if that is causing some of my headaches.

:

Amelia,

Okay then what is the RecordSource of your form and do you have any
filters
applied?

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

I get a new form to fill in. There is a scroll bar on the right
side,
but
that is only to scroll down my current record. I do not see any
previously
entered records. On the bottom where it says how many records, it
says
"Record: 1 of 1" and the first and last record arrows I am able to
use
but
not the previous and next arrow. Also the first and last arrows
don't
go
anywhere.

I am able to add a record, then add a new record and be able to
scroll
through the records I add in one sitting. But if I close out of
the
database
and then go back to add additional records and/or scroll through
previous
records I am unable to see the previous records then.

:

Amelia,

What do you see when you open the RecordSource of your form?

Also, where is the scroll bar? If you have your form set to go
to new
record then it will be scrolled down to the bottom and you will
need
to
scroll up to see your other records.

--
Gina Whipp

"I feel I have been denied critical, need to know,
information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

Can you help me and tell me what to fix in my form? I have a
form
set
up
but
once I enter a record in the form and exit the form and then go
back
to
the
form I can not see the record I just entered. I can see it
added it
to
my
table, but I can not see it in the form view. I have the
"continous
form"
selected. Is this not what I want or is there somewhere else I
need
to
set
a
property to be able to see these forms?

I hope that makes sense, please help!

Click to expand...

Click to expand...