Search results

3 years later....I'll bump this thread, I'm having the same problem. Has anyone solved this? I've been using CData's ODBC Link, but for whatever reason it's giving me fits. I'd like to find another solution. I don't have Outlook.

The following article describes how holding a lock on a linked table helps speed up the application. Does this still apply to linked tables that are SQL server based? http://www.fmsinc.com/MicrosoftAccess/Performance/LinkedDatabase.html If so, how would you modify the above code to hold a...

Thanks Lightwave, I've settled on remaining with Access. I have an install disc for A2013, and am sticking with that for at least the next few years. I also have an FMS Ultimate suite license for 2013. Between them, I'm happy with my desktop development. The next phase for me will...

Hi RuralGuy, I thought that was what changing the .accdb, to .accdr did. Nevertheless, I did follow the example, and created a shortcut with the /runtime switch. It runs fine on my computer.

Not sure why, but I have an application that works fine on my computer (Access 2013), but when I open it on another computer (access 2013 runtime), it shows #Error in the field values on the second page on a report that it creates a PDF of then emails programmatically. The thing I find most...

Thanks Plog, that's exactly what I ended up with.

I'd like to create a quick application for Customer leads management. This will likely be a temporary application. I will import about 500-1000 contact records into it. Every X days, it will email x number of these contacts (only 1 time). It will also create a mailing label for that contact...

Plog, Thank you for your quick response. I thought the question was obvious....what's wrong & how do I fix it. My apologies, next time I'll be more specific. Is there a better way to view a cross tab within a form then the subform control?

I have a crosstab query that displays correct results on it's own when opened as it's own tab, in datasheet view. I want to use this in another form. When I place it in subform/subreport control's datasource on that form (inside a tab control if it matters), it doesn't display correctly. The...

It's a Opensource VBE Add in apparently....Just curious. http://rubberduckvba.com

It seems like you need to go in at night or some other time when the office is closed, split the existing db, then link your new FE to the existing BE. (I'd make a copy first!)

Doc_Man, Thanks for the rundown. It is great to get a summary of how these systems actually work. I'm still on the fence. I think with my current tools and setup, I'd probably be fine moving forward as is. I certainly don't want to slow down my workflow, as my development time is always...

I tend to think so...I bought the developer suite for Access 2010 about 2 years ago, and just recently updated to the ultimate suite for Access 2013. I'm still sorting through all the new features I have available to me, but I really like the Access Startup, Sourcebook, and Analyzer. The...

Hi Boyd, Sorry for the delayed response. No, I'm not going to be selling any software. (At least not yet) But I have several small applications I've built that our company relies on daily. The largest has about 6,000 lines of VBA code. I'm really just looking for known best practices at...

Haha, no just a very happy customer. But here's my situation. I'm a General Manager in a small company. I wear many "hats" throughout the day. My development time in Access is just a small part of what I do, maybe 15-20% of my workload. Even though I've been working in Access for years...

I have the sourcebook. I got it as part of the developer's suite. I like their products so much I updated to 2013 ultimate suite. There are two things I really like about the sourcebook. One is obvious; the code. It really comes down to why reinvent the wheel? I've found the classes, and...

I like it, thanks guys!!

I have a program I made that has morphed into two versions; One for the office, one for the shop floor. I've been maintaining these separately, but for the sake of maintenance, I'd like to pull them together again. They are very similar; The office version sees a bit more information that...

So, I've been reading about how source code is a great idea for developers in general, including Access projects. FMS shows a link on their site about it here: https://www.fmsinc.com/MicrosoftAccess/taking-over/index.html about half way down the page. The thing is, I believe VSS is now...

CJ, Thank you very much for your response. You hit the nail on the head for me. We are a very small company, 10 employees total, with 3 in the office. I'm the General Manager, and wear many hats day to day, from engineering, purchasing, supervisor, etc. I have a good ERP system, and a good...