I have run into a situation in my Access 2010 database that I don't understand. I have a form with many other forms on a Tab Control. The original issue was that the subtotals on a continuous form stopped loading. I have reworked the form and now have the subtotals loading on Form_Current using a DOA.Recordset. So, now the form looks beautiful but the data has become read-only.
Background: This database is an Access front end...
User Profile
Collapse
-
Loading sub forms on tab control main form
-
Thank you! That makes sense. -
Recordset RecordCount returning Error 6 Overflow
I have a command button that pulls an Adobe RecordSet and Exports the data to Excel. One of my users reports getting Error 6 Overflow when running the export for a particular criteria. I thought that it was because the recordset contained too many records, but when I look at the records for the criteria there is currently 44,461 records and Microsoft allows me to export these manually.
I stepped through the code and found that... -
Access 2010
This is an actual tabbed form (main form contains the tab pages and the sub-forms sit on the separate pages)
When I was cleaning up the code for the Form Load I noticed that I was missing the clean up for rst3 (close and set to nothing) I made that change and was able to update the check boxes in the .accdr database without getting the error. Does this make sense for the solution to the problem on the After Update?...Leave a comment:
-
Errors when database is .accdr
Background: I have a multiple user database that lives on a trusted network drive with the file extension set to .accdr
The form I am having problems with has multiple pages on the tab control and most of the pages have 1 or 2 sub-forms on the page. This is the form where the users make all of their updates to their data.
The Issue: Just recently when users update a check box on one of the sub-forms they are receiving this... -
Thanks Seth, I solved this by adding a text box that contains the Employee's name from the lookup table as a part of my base query, then making the combo box shrink to show only the drop down arrow part of the box and limited the combo box list to active employees. By putting combo box next to the text box the user is able to see them as if they were one field. When they open the Combo box list they are able to select an active employee and the...Leave a comment:
-
Combo Box I want to show Old Values but not when updating
In my database I have a form that allows the user to view and update data. I use combo boxes to standardize entry of the data. The issue that I have found with combo boxes is that when the data goes out of date, i.e. the Employee leaves, the user can no longer see the employee on the form. This has to do with the list values being limited to Active Employees.
What I want to do is show all of the employees on the form but only... -
Rabbit, thank you for the explanation. I appreciate knowing the answer and understanding what I was doing wrong.Leave a comment:
-
-
Countdown Time Left before Idle Minutes Timeout
I have used Microsoft's instructions https://support.microsoft.com/en-us/kb/128814 and your threads http://bytes.com/topic/access/answer...off-idle-users and http://bytes.com/topic/access/answer...ime-inactivity to create an Application Quit procedure that opens a warning form. The user has an option to reset the timer and continue working (command button) or to Exit the application (another... -
Typing Entry in Access Combo Box
Hi, I have used Access Combo boxes for years. Recently when I type in the combo box and a value loads Access is not overwriting the value if I keep typing. I am using both Access 2010 and 2013.
Example: one of the value on the list is "I don't know" the next value is "Interest". When I type "I" the "I don't know" value loads. When I go to type the "nt" to pull up "Interest"... -
Just to close the loop on this, I was able to resolve the issue by changing my wildcards to % and my Like to Alike. I know that I have to do this when I am pulling data from Oracle tables but, this data is being pulled from Access tables in a seperate backend database.
Does it make sense that we would need to use % instead of * to pull this data? Regardless of the sense this was the solution.
Thanks for looking at this...Leave a comment:
-
ZMDB,thanks for your reply.
1) the SQL from line 110 is:
...Code:SELECT tCPSubprojects.SubTotalGroup, tDvlpYr.Yr1, tDvlpYr.Yr2, tEmpPrjtHrs.VersionID AS Version, tEmpPrjtHrs.OrgID, [tEmpPrjtHrs]![OrgID] & IIf([ztlkpCPLowOrgCrossWalk]![LowOrgDescription] Is Null,Null,'-' & [ztlkpCPLowOrgCrossWalk]![LowOrgDescription]) AS Workgroup, tEmpPrjtHrs.PosnNmbr, tEmpPrjtHrs.EmpNmbr, tEmpPrjtHrs.Employee, IIf([tCPSubprojects]![SubTotalGroup]='OH
Leave a comment:
-
Recordset Returns No Records; SQL Returns Records
I am continuing to run into this issue so, I am hoping someone else has run into it and knows how to resolve it.
I have a command on a form that runs a SQL statment in a recordset and exports it to Excel. This works 99% of the time, the other 1% of the time the SQL statment loads records (1889 records) when run as an Access query but does not load records when opened as a recordset (rst.BOF=true And rst.EOF=true). I included the... -
-
Identify Computer UserName in Access VBA
Hi, I am struggling with creating a unique name for a series of table that are temporary tables enabling my report to load quickly and accurately. What I want to do is attach the Windows UserName to the end of the table name and have the reports run from that table.
My database is using Access 2010 running on Windows 7 and is accessed by users from the network. In most cases I don't run into file sharing issues but in this case... -
RockKandee, assuming that your table 3 contains the ID Field for Table 1 and 2 and that you are only trying to update data in Table 3 you should be able to have a continuous sub form that contains combo boxes for the selection of information from Table 1 or 2. Is this what you are doing?Leave a comment:
-
zmbd, I have scrubbed the Create Temp Table code to the best of my ability. It is successfully doing what I want it to do, and I think I am cleaning up all of my recordsets and connections correctly. Here is the current code:
...Code:Private Sub cmdCreateNew_Click() On Error GoTo Err_cmdCreateNew_Click 'Opens frmMngrSbprjtRptGrp Dim stErr As String Dim stFrm As String Dim dbRptOwnr As DoubleLeave a comment:
-
zmbd, I have started stepping through the code to add in closing record sets and connections to see if that resolves the issue, but I have to leave for the weekend so, it will be Monday before I can get back to this. Let me attempt to make these corrections and post the corrected code on Monday.
Thank you!Leave a comment:
-
zmbd, the code to create the temp table does the following things:
1. Test for required information to be available. (lines 30-41)
2. Check to see if the required information (GroupID) already exists in the base table; if GroupID exists then we check if the temp table has previously been created and delete the temp table if it exists. (Lines 43-55)
3. If the GroupID exists then we create the temp table and open form2 (Lines 56-90)...Leave a comment:
No activity results to display
Show More
Leave a comment: