Recent content by Abby N

I’m having a problem displaying my charts in Access 2k. Anything greater than 3.4 inches, in either height or width, gets cut off. That size is far too small for most of the charts and graphs I’m trying to build. Can anyone help me get the charts working or recommend an add-in?

Eureka! It seems the TableDef object must be set to a variable before the connect property becomes writable. Here’s the code that worked for me: Set db = CurrentDb Set tdf = db.TableDefs("ImportData") With tdf .Connect = "Excel 5.0;HDR=YES;IMEX=2;DATABASE=" & strFileName .RefreshLink...

Yes, I "cheated." The string to which I'm attempting to set the connect property was derived by reading the existing property. The variable strFileName represents the new path. So, for example, the connect property originally read something like: "Excel 5.0;HDR=YES;IMEX=2;DATABASE=C:\10-01-03...

I've got an Access 2k database with a linked table connected to an Excel spreadsheet. Unfortunately the name of the Excel file changes daily (the name includes the date). Is there a programmatic way to update the path of a linked table? I'd like to avoid forcing my users to run the Linked Table...

<DateAdd("m",1,CDate("1/" & [forms]![renewalform]![month] & "/" & [forms]![renewalform]![year])) ~Abby

Hello Angello. This should do it. Include [Renewal] as a field in the query with this criterion. (It assumes an American date format. If you use the European format you'll need to adjust it.) <DateAdd("m",1,CDate([forms]![renewalform]![month] & "/1/" & [forms]![renewalform]![year])) Good Luck...

The CDbl function converts text to a double. Say you have a text field with a value of "10.5" and try to add 4.5. You'll get and error because "10.5" is text. However CDbl("10.5") + 4.5 = 15. In the equation I suggested to Robbin I included it because [preop sodium] as a text field was the most...

You can also do it with a union query. Here's an article that will show you how. Adding "All" to a listbox or combobox Hope it helps. ~Abby [This message has been edited by Abby N (edited 08-29-2001).]

Hi LQ. In my opinion there’s nothing wrong with the way you’re currently doing it. But, if you’d like to eliminate the code behind each control then this might do the trick. Place this code in the forms On Current and Before Update events. Then, whenever you exit a record whose data has changed...

Just sent it off. If you have any questions feel free to email me. ~Abby

Me.TabControlName.Pages(#).SetFocus Where '#' is the page index of the tab you wish to view. Keep in mind that tab controls start at 0. So, your first tab is pages(0), the second tab is page(1), ect... Good luck. ~Abby

Kevin, I agree wholeheartedly that the many-to-many relationship table structure is better. I wish I’d thought of it first. I was so intent on the form and query I never gave the table structure a second thought. I must be getting addlebrained in my old age. Going back and rereading my...

Kevin, well that was assertive. *g* You are absolutely correct that the multiple table method is the preferred way of handling this situation. Though multiple Boolean fields in a single table will work (albeit clumsily) and are much simpler to conceptualize for a beginner. Leadhilldog, what...

It doesn't seem silly at all. It's not like this stuff is particularly intuitive. Plus, helping people to learn is one of the main reasons I enjoy helping out on this board. Anyway, your problem is in the line: strSQL = "RelocateCharityG" I assume that is the name of the query you'd like to...

Odd. Lets start with the basics. First, try this: IIf(Cdbl([3 laboratory values]![preop sodium])<135 Or Cdbl([3 laboratory values]![preop sodium])>145,[3 laboratory values]![preop sodium],"-") If that doesn't work, would you mind answering these questions? 1) Is [3 laboratory values] a table...