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. |
|
|
|
Thread Tools | Display Modes |
#11
|
|||
|
|||
See all records entered
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" wrote in message news 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" wrote: 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" wrote in message ... 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" wrote: 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" wrote in message ... 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! |
#12
|
|||
|
|||
See all records entered
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" wrote: 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" wrote: I have that propery set to "no" and I still can not see my other records. Any other suggestions? "Linq Adams via AccessMonster.com" wrote: You must have the form's Data Entry Property set to Yes. Set it to No. You'll still be able to enter data, assuming AllowAdditions is set to Yes, and you'll be able to see your existing records, as well! Data Entry set to Yes means you can ***only*** enter new records. -- There's ALWAYS more than one way to skin a cat! Answers/posts based on Access 2000/2003 Message posted via http://www.accessmonster.com |
#13
|
|||
|
|||
See all records entered
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" wrote: 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" wrote in message news 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" wrote: 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" wrote in message ... 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" wrote: 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" wrote in message ... 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! |
#14
|
|||
|
|||
See all records entered
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" wrote: 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" wrote: 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" wrote: I have that propery set to "no" and I still can not see my other records. Any other suggestions? "Linq Adams via AccessMonster.com" wrote: You must have the form's Data Entry Property set to Yes. Set it to No. You'll still be able to enter data, assuming AllowAdditions is set to Yes, and you'll be able to see your existing records, as well! Data Entry set to Yes means you can ***only*** enter new records. -- There's ALWAYS more than one way to skin a cat! Answers/posts based on Access 2000/2003 Message posted via http://www.accessmonster.com |
#15
|
|||
|
|||
See all records entered
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" wrote: 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" wrote in message news 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" wrote: 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" wrote in message ... 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" wrote: 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" wrote in message ... 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! |
#16
|
|||
|
|||
See all records entered
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/acc...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" wrote in message ... 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" wrote: 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" wrote in message news 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" wrote: 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" wrote in message ... 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" wrote: 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" wrote in message ... 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! |
#17
|
|||
|
|||
See all records entered
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" wrote: 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" wrote: 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" wrote in message news 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" wrote: 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" wrote in message ... 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" wrote: 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" wrote in message ... 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! |
#18
|
|||
|
|||
See all records entered
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" wrote in message ... 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" wrote: 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" wrote in message news 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" wrote: 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" wrote in message ... 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" wrote: 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" wrote in message ... 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! |
#19
|
|||
|
|||
See all records entered
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" wrote in message ... 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" wrote: 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" wrote: 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" wrote in message news 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" wrote: 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" wrote in message ... 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" wrote: 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" wrote in message ... 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! |
|
Thread Tools | |
Display Modes | |
|
|