Search results for query: *

All, A good article on the subject of bang vs. dot: http://www.advisor.com/Articles.nsf/aid/BAROA06 Cheers

Do you mean the dot syntax in the VB window? Do you have the reference for "Microsoft ADO Ext. 2.7 for DDL and Security" checked? If not, check it. Also, do you have your options (from code window only) set to Editor, Auto List Members? If not, check that.

jason, shouldn't you be using the Column property?

Sorry to take so long in responding. I haven't come across that error before but I did find an MS Knowledge Base article (number 128195) that deals with it: http://support.microsoft.com/default.aspx?scid=kb;en-us;128195 Hope it helps.

Thanks for replying. Actually both those are unchecked. I'm going to contact microsoft about it. Hope it's not indicative of some pending disaster.

I've searched high and low for some reference to what this thing is but have found nothing. I have three queries in my database. I'll be working in a form that is based on a query and more or less everything is fine. After using the forms, if I then go to the query window there's this...

Is there an alternative to DLookup? I seem to remember reading somewhere that DLookup was antiquated and that newer versions of Access have a new way of doing the same thing. Also, can DLookup's use variables? I have the following but it doesn't work because there is more than one field on...

In design view of your form, click on the tabcontrol to select it, then right click and select "insert sheet." That should do it.

I might be misunderstanding you but it sounds like all you need to do is add to your code a line like: Me.tbxname.ControlSource = SQL If that doesn't work, it might be that you need your string SQL to be a global variable. As it is, I'm not sure where your variable is declared. Oh and by the...

Edski and Eupher, Thanks so much! Two perfect tickets. Edski, I'm not sure how to post the relationship diagram on the forum. Can you tell me how to do it? I've been thinking and tinkering more around question 2 and wonder if there are two autonumbers (primary keys) from two different...

I have a database of tenants for various buildings. When a user needs to add a new tenant to a building they have to select the exact building from a combobox then that building (using its ID number as a global variable, intProjectID) opens the "Add new tenants" form filtered for just...

I think I'm really missing something fundamental here. I have a few tables that are just about as normalized as they can be. They are tblTenants, tblApartments, tblVoucherStatus, tblNotices, and tblDates. Each tenant has an apartment (they may move from one apartment to the other in this same...

Thanks for the input. Funny thing though, isn't it? What good is the formatting yyyy if you still have to key in mm and dd? Or change the data type to integer when really it's a year. In the end, I guess it makes no difference. I'm just a wee bit nitpicky. Anyway, point taken - thanks...

I have a field YearFiled in a table. The data type is Date/Time and I want the format to simply be yyyy. I put that in the field's format property but every time I enter a date, say 1973, it tells me what I've entered isn't valid for the field. Can anyone tell me what I might be doing wrong here?

Bill, Thanks for your advice. Thankfully, I'm not getting the Type Mistmatch error 13 anymore. But I am getting the Data Type Mismatch error (more manageable than error13). Again, the debugger highlights the rs.FindFirst line. I'm going to fiddle around with it more (tomorrow, can do no...

I posted the question a few threads down, Thread705-421739. To reiterate the question.... I have a combobox on a form that is used to search for the record that matches the selection in the combobox. I originally set it up using the combobox wizard which inserts the following code behind the...

I keep running into Type Mismatch error 13 (is this really a bug in the program?) when I try to use the standard combobox code to find a record based on the selection in the combobox but add in a line to turn off any pre-existing filters. The code is: Dim rs As Object Me.FilterOn = False...

Have AccessWeb bookmarked already but didn't check there first. Thanks -- as always, good advice! lastout (the game's not over till it's over)

It's not clear to me why you want to exchange Null for zero. They are different but is there a particular use you have in mind for zero that null can't do just as well? If so, please describe. The fields in your tables that contain null values -- are they all the same data type (all numbers)...

I have three related questions: 1. When you open a form that contains a subform, does Access consider the subform "open" as well, I mean in the sense that it goes through the load and open procedures? 2. If you open a form that contains a subform, how do you refer to that subform...