Search results

All comments have been entered via Access...none have been imported.

I deleted all the "..." in my comments. Still a box shows.

I changed it refer to another field, and it showed it. but I changed it back to reference the memComments and its back to the square box. What could this be? Could the "..." be causing this? Affecting every record?

But would it do this for all records? even if it didn't contain a certian character. Yes, I can view the Comments in my Table, Query, and Form.

memo field has: Caption : Comments Default Value : =Null In the query, the Total row has "Group By" in all except for one...which is Expression to count days.

the data type is memo the type of control is a text box

I have a report based on a query. When I bring up my report, memComments, will not show up on the report...instead it shows a tiny square box. Any help is appreciated. Thanks!

The field size is Long Integer. Is that what you mean. Thanks!

I'm getting this message when I try to check Cascade UPdate and Delete. I have already a relationship between the two tables(One to One): "INvalid field definition "intID" in defition of index of relationship." intID is what connects my Customer table and Auto table. In the customer table...

Yes. Also... I have 3 tables: Customers, Dealers, Autos Dealer - Customer = intDealerNum (PK for Dealer Table) Customer - Autos = intID (PK for Customer Table) Thanks for the reply!

I have a form, its based on a query. That query contains an Autonumber(intID) from a Table(customers). I also have another table(dealers), that uses the ID number as well. Next to the dealer info, I can click the "+" and it'll show all customers pertaining to that dealer. I've seen some that...

That was it. Thanks! I have 2 tables...one based on a table and one on a query. I just got back from vacation. body is here at work, mind is still at the beach. :)

I have a form based on a table and I just added 3 fields to the table. When I go to the form to add these fields, they do not show up in the field list. I've also tried creating a textbox and going to the Data Tab and choosing the data source but those 3 new fields are still not showing up...

What I was looking for is a prompt. Like I have with my query. I have it where it asks you for the account number. It works and everything BUT it brings it up in a seperate window and in a datasheet view. I have been trying to get it where the query will pull up the record in the form...just...

Does anyone know of where I can find something on how to create a Find button? I don't want to use the one you can create through the command button wizard b/c its not what I want. I need it to do a search by one control. If I use the wizard Find button it will be a pain for the user, with...

In order to do all controls, would I do this... If .... End If OR If... End IF OR... or is OR not necessary. Thanks for your help!

I have the following fields: Name Contact Phone Fax The Name control will be a combo box that someone will pull up info by. When that info comes up(Contact, PHone, Fax) and it is outdated...then the user will change it. That's when I need the Updated control to be filled with the current...

I have a subform and when the controls on it are updated, changed from previous info, then I need a control(called dtmUpdate) to show the current date (=Date()). How would I go about doing this? Thank you

I created a form based on a query. When somenoe chose a certain number, I needed for it to fill in other fields once that number was chosen...that was accomplished...BUT...what if someone adds a number that is not in the list. I do have the Limit to LIst set to No. When I type in a number...

I have a Subform on my form. I am trying to get it to be filled in when someone does the following: Enters number into txtNum and then clicks on the OK cmd button. The form is based on a table called Cancel. The subform is based on a tabled called Deal The controls on the subform are as...