Search results

Converting an attachment field to an OLE column (in a child table) via code works fine unless the attachment is png. Sub b(Table As String, PK As String, Column As String, Form As String, FK As String, Field As String) Dim Recordset As DAO.Recordset2 Dim Attachments As...

I am using VB to pull some names from a PDF document and write them to the database where they do not yet exist. The query itself is: INSERT INTO Staging(Last_Name, First_Name, Birthdate) VALUES(?, ?, ?) The parameters are added and the query prepared. This works. Now i want to change it to...

I was asked to add a button that opens another form based on the current record. No problem. I just copied the button and code from another form that did the same thing. The user came back to tell me that the entire purpose of opening that second form was to click a button that opens the...

A form lists names with some data and three checkboxes. I've been asked to add totals to the footer for each of the checkbox columns. 2 of them are to display total unchecked for records that have a date. (It is not supposed to be able to be checked if there is no date.) The third checkbox is to...

Just thought i'd share and perhaps even ask for comment. I am beginning to work on someone else's Access program and have a lot to learn. Anyway, the request was to remove the label from a couple comboboxes and place default text in them instead. After some searching it seems this cannot be...

I have a VB.NET DLL that uses Async/Await in most of its calls due to using HttpClient (docs.microsoft.com/en-us/dotnet/api/system.net.http.httpclient) in many of its calls. I now want to call it from Access. After making the DLL COM visible and interopable, and registering it, the call from...

I've had this site come up in my searches before, but i finally have a question so i registered. Unlike other forums where i am wary if they are used or reliable, here there was no such concern. I am not an Access programmer specifically, though i love databases, design, and queries.