Search results

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

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

Hi Everyone, i was not able to locate this question in the forms so i apologize if this was asked and answered in the past. I have a recordset that i open from my SQL Server that i load as the record source to my access form. I need the recordset to stay open while the form is open but once i...

Good afternoon you amazing Access geniusis! I've ran into a problem with trying to only add a record and not bring up the entire table with my Access Form using a recordset as the connection to the SQL Server. All i want to do is add records to the table. can anyone help me with this. here...

Greatings everyone, I'm looking to build my String with all the values of the field "DmgTypeNCom" from my recordset but i'm having no luck. The String should look like this: "Concealed" & ";" & "Dropping" & ";" & "Forklift" & ";" & "On Divert" & ";" but instead it only gives me the last...

Good Morning everone, i'm having a real problem figuring this one out. what i'm trying to do is run a query to update a table on the SQL Server but it keeps erroring out. i have 2 ways i'm trying to accomplish this. if you can help me with a solution for at least one of them it will fix my...

Hi Access forum peeps, i need your help. I'm trying to pull records I need from the SQL Server that I have pulled into a DAO.Recordset and save them to the local MS Access Table (Either via append or make table). Any help with this is most appreciated. I have been working on this issue for...

First let me say this is my first post at this form so please bear with me. I have always found the answers I needed here without posting so I want to do a big shout out to this community and how knowledgeable all of you are. Thank you for the years of support! Now to my question =) I’m...