Search results

this post isn't to ask any specific question, but rather to discuss what you do to try to improve your code and your code writing. Mods please move it if necessary to whatever forum is most appropriate. I just finished reading the Kindle sample of the book "clean code". I, like most VBA...

I agree with the others....ask once. But I'll leave this tidbit for you to do with what you will. Look into CData ODBC connections. I use them for Gmail and Google Calendar, but I believe they have one looking into Drive.

Thanks Mark. I've had some trouble with Windows Scheduled Task, like when I log off for the day and it won't run at night. (It's currently on my work computer). Maybe this problem would disappear If I move the task to the server.

I have an application that I've been running through Windows scheduler, which looks at our local db, then query's results of new events it then throws up on our google calendar. I'm going to be making a few revisions to how it works, and just realized it may be beneficial to let it run 24/7...

Bump.... I'm curious if this is still an issue for others. I've found an article showing how to create and reference a .net DLL File, but don't know much about visual studio, so I'll need to really dig in to utilize this. Here's the article...

Agreed! I own that book too. It taught me more about actual programming than anything else so far. Well worth the price and the effort you'll put in.. Glad to hear the sourcebook worked out for you!

Good Idea Minty, I tried it, but nothing changed.

Hey Everyone, I've been struggling all day to get access to pull over a recordset in VBA from an sdf file (SQL CE 3.5) :banghead: Here's the code thus far: Public Function Connect(WorkOrderName As String) As Boolean ' Status: BROKEN, DOESN'T WORK. This was a development test to see...

I decided to brush up on some query fundamentals through a course on Lynda.com. I didn't know that a switch statement was available right in design view. In the past I would make a custom VBA function using a select case statement. This seems a bit quicker. I wonder how the performance...

I have a function that opens a recordset based on a query of products. There is never more than 30 or so records within this recordset, so I wasn't thinking of performance when I coded it. Anyways, it loops through the records, looking for any null values in a particular field, then warns the...

Very neat, thanks for sharing. I'd also like to recommend RubberDuck. Its an open source VBE add in I've been playing with for about a week now. Between it and my FMS code tools, VBE is starting to feel pretty powerful. I haven't dug into everything RubberDuck has yet, but I've found...

Frothingslosh, That's an excellent example! Thank you for sharing it. Your comments within the module cleared up many things for me. I still have a maintenance question though. Let's say you've set up your interface and have 4 classes using it. 6 months later you find out for whatever...

Just an update. I spent a portion of the weekend going over youtube videos on Classes, Polymorphism, and interfaces. Interfaces are pretty interesting. I could see one area in my work where they might be useful. I've created two export classes, one exports the data to an excel...

Thanks Jdraw, I'll have a look at that video as soon as I can. I'll post any feedback I have.

Thanks Mark for the Reply. It's going to take me some time to digest this, and understand it well enough to use it. I think I like the idea of just calling the Get property again to ensure it changed. Perhaps that adds some overhead though? This isn't a property that will get changed often...

Thanks for the quick response Mark. Here's my calling procedure Private Sub cmdReadyStatus_Click() On Error GoTo PROC_ERR 'change status Dim clWo As clsWorkOrder Set clWo = New clsWorkOrder clWo.WorkOrderID = Me.WoNbr clWo.StatusID = 3 'cleanup Set clWo = Nothing...

I'm trying to implement classes into my programs more. One of the things I'm struggling with is simple logic. How do you know when something is accomplished? A simple example of is a light switch. Typically I may have a function within a standard module to turn on said light switch. This...

Thanks CJ, that's what I was wondering. I definitely don't want to create anymore administrative work. I believe I'll just continue importing modules into the current project as I need them.

Sorry guys, I should have been more specific. I'm currently dropping in things wholesale like I think both of you are suggesting. In the back of my Access 2010 programmers reference by Wrox (Page 1106 for those of you that have it), they mention that you can add a reference to your own code...

I've been researching building a code library for reference in more than one project. For me, this is appealing, because I have several classes that could be used within several apps. Does anyone do this? Are there any caveats with this approach I should be aware of?