Recent content by cage4000

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

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...

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...

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...

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.

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...

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

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

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...

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

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 = '"...

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...

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...

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...

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...