User Profile

Collapse

Profile Sidebar

Collapse
time2hike
time2hike
Last Activity: Jul 7 '17, 07:01 PM
Joined: Mar 25 '12
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts

  • time2hike
    started a topic Loading sub forms on tab control main form

    Loading sub forms on tab control main form

    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...
    See more | Go to post

  • Thank you! That makes sense.
    See more | Go to post

    Leave a comment:


  • time2hike
    started a topic Recordset RecordCount returning Error 6 Overflow

    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...
    See more | Go to post

  • time2hike
    replied to Errors when database is .accdr
    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?...
    See more | Go to post

    Leave a comment:


  • time2hike
    started a topic Errors when database is .accdr

    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...
    See more | Go to post

  • 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...
    See more | Go to post

    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...
    See more | Go to post

  • Rabbit, thank you for the explanation. I appreciate knowing the answer and understanding what I was doing wrong.
    See more | Go to post

    Leave a comment:


  • Thank you, jforbes. That did it.
    See more | Go to post

    Leave a comment:


  • time2hike
    started a topic Countdown Time Left before Idle Minutes Timeout

    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...
    See more | Go to post

  • time2hike
    started a topic Typing Entry in Access Combo Box

    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"...
    See more | Go to post

  • 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...
    See more | Go to post

    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
    ...
    See more | Go to post
    Last edited by time2hike; Apr 8 '14, 05:52 PM. Reason: Reply to post

    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...
    See more | Go to post

  • time2hike
    replied to Identify Computer UserName in Access VBA
    ZMBD that worked! Thank you.
    See more | Go to post

    Leave a comment:


  • time2hike
    started a topic Identify Computer UserName in Access VBA

    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...
    See more | Go to post
    Last edited by time2hike; Mar 13 '14, 01:51 PM. Reason: Spelling

  • 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?
    See more | Go to post

    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 Double
    ...
    See more | Go to post

    Leave 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!
    See more | Go to post

    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)...
    See more | Go to post

    Leave a comment:

No activity results to display
Show More
Working...