Search results

  1. C

    Subform lock up issue on tab

    looks like i have everyone stumped on this one. Anyone want to give a guess?
  2. C

    Subform lock up issue on tab

    you are right CJ, i need to be more clear. i put in the wrong term when explaining this. Instead of "Control Box" it should have said "Option Group" and "Option Group Buttons". This is what happens when you start your day at 2am with little to no sleep. the only code i use on the Option...
  3. C

    Subform lock up issue on tab

    Hi Everyone, I've built a form that uses a Tab Control. In one of the tabs i have a subform and a control box with toggle buttons that are side by side (not overlapping). every time i click the subform it only clicks once and then i can not do anything else on it until i click one of the...
  4. C

    Make max size limit for OLE object

    This fixed it. it works great on the import and blocking now. Now what i'm having trouble with is that it is not saving it as a bitmap image so it will not show up on the form now. the file i'm saving is already a bitmap image so i just need the import to recognize it. is there any...
  5. C

    Make max size limit for OLE object

    This is exactly what i'm looking for. the only problem is that I run into an error when i run the code: Run-Time error: 13 type Mismatch and the code stops on: .InitialFileName = pvPath if it helps the OLE object in access is connected to a datatype "Image" in the SQL server backend.
  6. C

    Make max size limit for OLE object

    Hi Everyone, I need to make it so that a user can input photos into a OLE object field on one of my forms but i want to make sure they do not put too large of a file in it. is there a way to block files that i deem are to large (example anything larger then 1MB) in the access form that will...
  7. C

    VBA Update Query in Access 2016 to update SQL Server.

    Hi Ridders, yes this is a SQL field with a datetime datatype. James, your recommendation worked flawlessly. thank you both for your help.
  8. C

    VBA Update Query in Access 2016 to update SQL Server.

    I also tried: TimeStamp = CDate('" & Now() & "') but it did not work.
  9. C

    VBA Update Query in Access 2016 to update SQL Server.

    Also, to help provide more info on this issue, if i run ether of the following SQL statements directly in my SQL server, it will update with no problems: UPDATE tblPRF SET PRStatus = N'com', AsscName = N'dav', TimeStamp = '05/12/18' WHERE (PRF_ID = 62713) UPDATE...
  10. C

    VBA Update Query in Access 2016 to update SQL Server.

    I also tried this: TimeStamp = # " & FormatDateTime(Me.ADJ_DATE, vbGeneralDate) & " # but it did not work as well.
  11. C

    VBA Update Query in Access 2016 to update SQL Server.

    HI Everyone, Does anyone have any sugestions on how to update a date/time fuild on SQL server using access VBA. Here is what i have: Dim updTblPrf As String updTblPrf = "UPDATE tblPRF " _ & "Set PRStatus = 'Complete', TimeStamp = convert(datetime, '" & Now() & "'), AsscName = '"...
  12. C

    Closing a Recordset from another sub

    Thank you for both the insight and clarification of what my database is doing behind the scenes. This fixed my issue and I am able to move forward. Being self-taught, I find these insights extremely valuable and I will not forget them. In addition, on my next project I will follow all your...
  13. C

    Closing a Recordset from another sub

    Thank you Frothingslosh for the explanation and a appreciate all you and all of the time your co posters put into this problem. you have given me a lot to think about and i will look at this as a viable solution. i guess the only thing i don't understand is that if a recordset closes when you...
  14. C

    Closing a Recordset from another sub

    Hi static, I’m not sure, I thought I was but I must be off. I will take a look at that. Thank you for pointing that out. ridders, I disagree with you, the proof is black and white on this thread, and I’m done debating this with you. NOW please stop posting on this thread unless you have...
  15. C

    Closing a Recordset from another sub

    Hi Minty, when you and ridders are making a joke at my expense (as seen in post #16 and #17) especially after I have been banging my head on this issue for a month now, it does not leave a good test in the mouth. I appreciate your follow up, recommendations along with the link and your...
  16. C

    Closing a Recordset from another sub

    Thank you Doc i appreciate your feedback. ridders, i disagree. Also, I thought you killed your connections to this thread.
  17. C

    Closing a Recordset from another sub

    Thank you Doc and Static for your feedback and advice. Being new to trying to code a backend in using a Dynamic vs Static approach is something new to me. Being under a deadline to produce this Database does not give me the luxury to redo all of my code, so i'm stuck with the way it is. I...
  18. C

    Closing a Recordset from another sub

    Hi ridders. to answer your question on # 8, no it does not show up there and nor do i want it to. if i was to use it that way i would need to create a link in the ODBC Data Sources and link all the tables i need in this front-end DB (In which i do not have admen rights to do so, nor do i want...
  19. C

    Closing a Recordset from another sub

    i guess the only thing i'm asking for now is how do i close all open recordsets / open database connections with one peace of code that i can call at any time.
  20. C

    Closing a Recordset from another sub

    Hi Everyone. it looks like i have sparked quite the converstaion over this. if it helps this is where i have declared the recordset is coming from in a sepreate module. Public Function sqlDB() As Database Static mCurrSqlDb As Database If mCurrSqlDb Is Nothing Then Set...
Top Bottom