Search results

Almost ready to throw in the towel I've tried really hard to learn VB.NET and gain it as a skill set. I'm starting to lose faith that this is a good direction for a part time programmer (<5 hours per week). I've worked for months now, working through an online tutorial, and a vb.net...

I noticed that in this link below, they focus on templates and sharepoint/web stuff. https://support.office.com/en-us/article/What-s-new-in-Access-2016-76454345-f85d-47af-ace1-98a456cb3496 I guess I'm happy nothing is deprecated...

SkyCraw, Did you resolve this? I'm starting to feel like VB.NET just isn't worth the extra effort....

almost there....I need this code to fire every time the parent record changes on the form. what form event fires to accomplish this?

Hey everyone, Thanks to all who responded. I've got this to work now. This thread is what I was missing: https://www.syncfusion.com/faq/1144/i-get-the-error-system-comobject-when-using-recordset For the benefit of the forum, here's my working code: Private Sub FillAttachments()...

Thank you CJ, your search came up with some I hadn't. Following one of the examples I came up with the following code: Dim dbe As New DBEngine Dim db As Database = dbe.OpenDatabase("S:\Gary\MS Access\ACS Engineering Changes\ACS Engineering Changes_beVS.accdb") Dim sSQL As...

I've decided to try and learn VB.net, using VS community 2015. After running through some of the example apps such as Picture Viewer, etc. I decided to take my simplest access application and try and duplicate it in VS. This app has only 3 tables, minimal VBA code, and keeps track of our...

Those are the main fields yes, but I've included two more fields, a comments and a timestamp.

I have an application I'm creating to track engineering changes. It has a junction table, joining a "tags" table, and the "events" table. I need a search function that will allow them to search for events that are tied to specific tags the user chooses to search. So, to clarify, the user...

Much better than what I was hoping for....Thank you Plog!!

OK, I was looking for a Listbox....got it now. Plog, I'm interested in your approach. If I understand correctly, I could create a continuous form from my junction table, add it to my main form by linking the ID's, then simply add the tags that make sense right there? Wow, seems easy...

:banghead: This seems so simple. I'm trying to create a form with two visual "Boxes, and a button in the middle. The left Box pulls the available "Tags" out of a table, then the user can select what ones apply to this particular record. Choosing the button "Pushes" the selection over to...

I've volunteered to look into building a database to house data for a boy scout pinewood derby event. I'm looking forward to the challenge, but the one thing that'll be completely new to me is trying to interface with some kind of timer coming off the track. Does anyone know how or what can...

Has anyone had any luck connecting to these databases? Our Engineering software creates them for each work order it produces, and I'd like to pull information out of them. It's an MS SQL Compact edition file. I would likely prefer to connect via VBA, as the connection will be dynamic in my...

Jdraw, I'm sure you don't remember, but you were one of the first people to help me hone my VBA skills on here. It was much appreciated! Anyways, here's a thread following my challenges and finally resolution on the CDO method(?)...

Ok, I've got it straightened out now. I needed to go into my gmail settings and allow less secure apps. I also had some trouble with the code above. For it to work for me, I needed to change it to as shown below...

Gemma, Thanks for your suggestion...To be honest, I still have no idea what caused the issue. I can say this; I changed my "SendEmail" Function in both programs from an outlook automation to using the CDO method, and they are running fine...I'm pretty sure it had nothing to do with Task...

Fenhow, Is this still working for you? I'm trying to email directly through my access app like this in gmail, but I'm getting an error, and gmail is telling me this is not a "modern" application so it won't accept it. I'm running access 2010. Did you need to add any references? I've...

For the record, I'm still having issues with this. For weeks, both programs have been happily running as they should. Yesterday, I went in and made a quick change to app#2 (changed an email address in the code). app#2 has been saved as just a .accdb file, and I continued with that. Just...

Minty, We're using SQL Express now for our Engineering Data...The ERP is actually Sybase, but we connect fine using ODBC. What is IIS? (googling now)