Recent content by Bhaughbb

That is kind of what we have, all the data is on our sqlserver, the .MDBs are just for reporting from out server. I'm trying to locate a solution as to why that computer can't access the .mdb files are are open by another user, even if the user is another remote desktop user logged in through...

I wasn't able to find a solution to my particular problem yet by searching so I am posting a new thread, apologies if this already exists elsewhere. About a week ago one of the computers in our office started getting an error message when trying to open any access .mdb file. The window title is...

I've got several access databases located on our file server. Numerous users throughout the office have access to open and view them as has been the case for several years. Since the beginning of the year we have started seeing a brand new issue occur every couple of months in a few of our...

Can't seem to find a solution to my problem here or in a few reference books I have on my shelf here at work. I inherited several access databases from my predecessor a while back and although I’ve fixed most of the pre-existing problems and re-programmed most of the queries and reports at this...

I thought so, just couldn't remember for sure. Time to look for another way to code this, I can't use any libraries that don't install with Access 2003 by default due to the lack of control over users' systems that I have. Would ADODB be a good choice?

Finally had time to get back to this project, That code looks useful but I'm suddenly hitting an error I've not had to deal with before, it's breaking when I try to define a variable as QueryDef. The exact line is's breaking on is: Dim str1Sql As QueryDef I can't use any libraries that...

I'd completely forgotten about those events in reports, I'll take a look and give it a try. Thanks! And in 6 months we get to throw these out and rebuild them in .Net .. the joys of stepped system changes.

OK, I just hit upon a major flaw wiht the approach I took to building this query in VBA. For my reports I had the code Private Sub SummaryButton_Click() Dim rptString As String Dim qryString As String rptString = "a-Sales Report - Summary" ' query field selection qryString = "SELECT...

I'll check those out, thanks!

I knew I needed some books and taking a course or two would definately be beneficial but I was hoping for more of specifics at least along the books line as to Titles that people have found most beneficial in teaching and or references for a new Sql Server Admin.

Unfortunately I'm a bit short on knowledge of VBA and only know enough to start being dangerous. I've spent 3 days researching these forums and several access programming books in an effort to solve my problem but have not been able to sucessfully apply code examples I've seen to my database. I...

Here's one quick solution, in the sql: WHERE (COL1 Is Null) or (COL2 Is Null) or (Col3 Is Null) etc...

In a recent performance review it was recomended that I keep learning new skills to improve my position in IT in the company I work for. In the weeks afterwards it's been heavily suggested I get very good at sql and sql server as we are trying to transition away from Access and go to a purely...

I'll give that a shot and share the results. When it errors it's flagging the 'Dim qryString...' line. What confuses me is I saved the code and ran it from the form to test the first couple times but now it fails. --edit-- The query fails when when I eliminate the single quotes that end up...

Always glad to help, now to figure out why it seems to have failed as a solution. It looked like a good idea. When I tested it after I came up with the idea on Friday morning it worked beautifully, fast and no flaws. Now I'm getting a "Compile error: Type mismatch" on the exact code that worked...