Search results

Sometimes I love having to plow through tons of other people's completely undocumented code. If Err.Number <> 2295 Then Debug.Print Err.Number & " - " & Err.Description Else Debug.Print "Something happened. I don't know what. No one tells me anything. " & _ "Here I am...

In the VB editor, click on Tools | References. Make sure that the appropriate Data Access library is referenced. I looked at your sample and saw ADO 2.1 was referenced; did you change this or is that the original setting? In case you're wondering, something similar happened to me at the...

Ok. After a long weekend and several cups of coffee I think I have a workaround. To restate the problem simply, an Access project that references a second project cannot use uninstantiated classes from the second project. You can't initialize the class from the first project because it cannot...

Hi all... I've a frustrating situation at the moment. I inherited an architecture that consisted of various access-based applications that used common functionality from modules located in another database. This common database was linked as a reference in the VBE. This is using AccXP. What...

Just a nitpick with that statement; its not so much that DAO is the default database access object as it is that MS decided to enable it alongside ADO in new projects. http://support.microsoft.com/default.aspx?scid=kb;en-us;825796 Anyway, back on topic - plan, get input, plan some more, get...

Make this book your bible. I picked it up a few months after I left a company where a project I worked on had failed. In going through the quiz in Chapter 2 I found that the project scored around 36 points on a hundred point scale.

1. Copy the .mdb to your desktop or another folder where you have full permissions. 2. Attempt to compact. 3. When that fails, go to each table and attempt to sort. When you get that error again, you'll have found your corrupted table/record. If you are lucky, you should be able to find...

I'd imagine you'd use a shell command along with this. Does your VB program launch Access and then do other stuff, or do you need to wait for Access to finish before moving on?

Try: MonthName(Month(datevalue))

Nothing to stress about, unless the printed results are just really screwed up on the new printer. Access does not have a print renderer. Instead, it uses the print driver/renderer from either the default or specified printer on the machine that the report is created on. You will commonly get...

Hi all, I'm looking for an intermediate to advanced Access/database/programming concepts test to give to job candidates. I took one myself around two years ago that was actually fairly challenging, but I've had a difficult time finding one since. The google searches I've done so far turn up...

You could try this... create a lookup table with a key field and the acceptable ranges if you are going to continue with the year/year format. Link back to the original table after creating a new foreign key field or converting the data in that table to match the new lookup IDs. Convert the...

The Format method converts the date to a string, which tends to confuse things. Try CDate(Format([datefield], "Short Date")). The net effect is that you get "06/09/2004 00:00:00AM" but the time will not be displayed.

Hi all, Here's a solution to a problem I had been encountering. I was creating a cover letter for a mailing in Access rather than using a Word mail merge. I obtained the company logo from the Word document using a simple cut&paste, and the sample page worked great. However, when the report...

My methodology for designing an interface is to use paper first. Define the data that you need the user to input, and see which parts of it you can infer, default or otherwise not require the user to actually have to type in. Next step is to isolate the essential fields and ensure they are...

I don't really see how that would help, quite honestly, and in fact, one field out of the dozen actually does make a user defined function call to generate its single character string output. The problem is that an Access query that contains any logic or function call beyond setting a label...

You can try a few things here, although the changes, if they do work will need to be set on each machine. 1. Tools | Options | General tab : Turn off all Autocorrect features 2. Start a new access database that does not use your workgroup security model. Place the backend in the same location...

Hi all, I've run into a problem exporting data to dBase V format from an Access query. Normally, my solution would be to change the export format, but right now that isn't an option. The process I'm describing works as such: I pull data from a SQL Server database, fold, spindle and mutilate...