Microsoft Access - Records in Table Disappearing...HELP!
Asked By Miss Jones on 11-May-12 03:39 PM
I have a very simple form where users enter information. The only way to access the form is through the switchboard and each form is opened in Add Mode. The Startup options are such that users can do nothing but enter information and close the form. Since the fields are bound to a table, the data entered saves to the table whether users hit the Save button or not (I just put it there because it gave the appearance of closure). Once the user has entered their information, they can go back to the switchboard and choose the option that allows them to do a name search for all records they've entered. This option on the switchboard is linked to a report that pulls from a very simple query of the table. My problem is that users are saying they completed a form, but it's not showing anywhere - not the name search report or the table. I thought this was caused by user error, so I asked them to print the screen after they enter their information on the form (it has a field that shows the date/time a box on the form is clicked). One employee did me one better - she did a name search immediately after completing a form. It shows the record. However, when I do a name search a couple of hours later, it doesn't show the record. I verified with the table - there is no longer a record of that form. How is this possible? Our employer has regional offices in multiple locations; the database is stored on a network. Does this have anything to do with why table records are totally falling off the map?
Shan P replied to Miss Jones on 11-May-12 05:43 PM
It would be what you're speculating. What is the database being used? What is the switchboard application your employees are using? Is it a desktop application or a website that they use?
Shan P replied to Shan P on 11-May-12 05:43 PM
"It would be" - I meant "it could be"
Pat Hartman replied to Miss Jones on 20-May-12 04:37 PM
It is difficult to guess without actually seing the database but some things to look at:
1. Are all required fields being populated including any foreign keys? For example, if you are entering orders and your app allows the order to be saved without a customerID then you would never find that order via the customer search.
2. Have you actually opened the table and looked for the record? If the PK is an autonumber, sort descending by it to see the most recently entered record.
3. You can't use a form in DataEntry view for searching since it will only show records that were added since the form was last opened.
4. Check the criteria being used for the report.
5. If the queries contain joins, they may need to be left joins to bring up records that have no match in the many-side table. Using our order entry example again. An inner join of Customer to Order will only return customers that have placed orders. If you want ALL customers, you need to use a left join.
Hi everyone I am currently trying to write an update query in Microsoft Access. I am looking to update two fields in my 'User' table: Last completed module Last update query. Could anyone please help me? Thank you in advance! Sorry, I forgot to add that I only want the 'Last completed module' to be updated if that field in try out what you've suggested, and hopefully that will work! keywords: moduledate, Update query Access Hi, Microsoft Access, Raw Data table, database description: Update query Access Hi everyone I am currently trying
I need help in Microsoft access 2007. I am asked to create a database for employees to enter records for the is created for employees to click it for them to direct into form A to add their records. However, I am facing a problem that when employees want to add record into the form it says duplicate entries. How Do I eliminate this problem that
I need to translate the excel sumproduct to an access database. The formula in Excel is = +SUMPRODUCT(H4:H57, G4:G57) / SUM(G4:G57). Can someone break this down into lay terms and suggest how to calculate in Access. I am writing a weighted average yield on a portfolio. You would ideally use x SELECT SUM(fieldname) where fieldname in (value1, value2, value3. . . . ) And one more way is to add the Excel Object library to the references and still continue using the excel functions. Toos SUM(Amount) AS WeightedAvgYield FROM Portfolio; Thanks Jonathan! keywords: WorksheetFunctionExcel, SUMPRODUCT, SUM, Excel Object library, Microsoft Access description: Convert Excel's Sumproduct to Access I need to translate the excel sumproduct to
i have tables items, order and bill. . i want and grand total should display on main form. . guide me In the order details subform, add a new unbound control in the footer of the form. Set the control source for to something like: = Sum(yourfieldname) And give the control a meaningful name such as txtSumPrice. Add an unbound control to the main form. Set the control source for this control to to a new record to see the mainform control update with the new subtotal. keywords: Microsoft Access, Sum, control source, grand total description: total of rows in access i have tables items, order and bill. . i want that when user select any item
I am attempting to use the count if command Extremely Satisfied', 'Somewhat Satisfied', Null)). However, I have two more criteria that i need to add to the same column. Agree and Strongly Agree. How do i combine these two statements Disagree. That way it worked. I will try out your suggestion as well. keywords: GroupBy, Microsoft Access, query in Access, Null description: Count if query in Access I am attempting to use the count if command in my query. In this format
I have two tables, one called Main and one when the column Override is null what is the syntax for this? I tried to add it in the criteria but this does not work and whenever I try and add an iif statement into the field box but also no success use case in for END Searched CASE expression: CASE WHEN Boolean_expression THEN result_expression [ . . .n ] [ ELSE else_result_expression ] END http: / / msdn.microsoft.com / en-us / library / ms181765.aspx hi, for this you need to use iif in Qty] > 10, "large", "small") here is the like for your help http: / / www.techonthenet.com / access / functions / advanced / iif.php hope this will help keywords: CASE expression, Update Query in Access, Microsoft Access, Update, Main, Boolean expression description: How to use an If statement in an
I am creating a report in Excel from Access VBA and want to add a logo at the top of the sheet I have used the following code which Excel.Picture Dim PicLocation As String Set xlApp = CreateObject("Excel.Application") Set xlBook = xlApp.Workbooks.Add xlBook.Application.Visible = True Set xlSheet = xlBook.Worksheets.Add strSheet = "InvoicesTotals" xlSheet.Name = strSheet xlSheet.Activate PicLocation = "C: \ Picture \ Logo.jpg" If Dir(PicLocation on Windows 7 Thanking you in advance Regards Keith I am not an expert in Access. But I can say that this could be the problem Set myPict = .Parent.Pictures.Insert
I am having trouble with an IF statement in Access 2007. Here is what I have: If ([Qtr 1 Start Date] Between #2 / 1 / 2008 builder and it keeps saying to many arguments. Anyway - I ultimately have 12 quarters to add to this statement. If this needs to be in VBA Code in Access - do I create the code in my query? Thanks, Lori baumgartner_L@kids.wustl.edu You Insert Code. Then I pasted the IF statement in. Then what do I do? keywords: Access 2007, VBA, Insert, Subtotal, Qtr description: IF THEN ELSE in Access I am having trouble with an IF statement in Access 2007. Here is what I
Hello, I have a excel sheet which has three respective col like -John, 40, 12-0ct-2011 I have a created a table in access with similar headings. Whenever I enter the data in excel under respective columns I want it to export to access table which i have created in access. Trick is that whenever i enter a data today in excel it will be exported to access table, but when i enter the data tomorow i want a new record to be created in access table and there shld not be overwriting of the existing record in access table. The
I have been trying to distribute my database to several computers which do not have access. My research told me that i should use the package solution and send Access Runtime along with it. The machines without access open to a blank window and asks if i would like to open the database an ACCDR to work with Runtime. Hi Kenneth, You can open an mdb file without access. I found this MDB Browser and Editor 2.3 at http: / / download.cnet.com / MDB