Search results

Very insightful...thank you

On the topic of indexing fields, what's the benefit of that? Why should I? I don't remember paying much attention to that when I set my tables up...not because I thought I shouldn't, I just didn't know that I should or not.

Bob, Thanks for all your help! You've helped me out a great deal numerous times and I really appreciate all your hard work to help the rest of us out. Happy Belated Birthday to you...

It worked...that's awesome!!! Thank you!

So in messing around with this, I've noticed that I can't make this change in 'layout view' but I can make the change in design view by right clicking on the text box and selecting Change To. Why is this? Btw...what do you mean by I have a Control on my form that is a textbox ControlType...

I was able to make a query with this attachment field for the images that brought up every record that had an attachment (image) in the field. That SQL makes sense, but I'm not sure where I would put that. Query? Table?? Please advise further...thank you!

On my form, I have a field that is a text box data type. I want to change it to a lookup field. Is this possible to change a specific text box on a form to a combo box? Thanks,

So here's what I did...not sure if it's the best route but it seemed to work. In my table [tblTransactionType], I have the following three fields. ID Type Income/Expense I got thinking about what my Primary Key should be. Well...if one of my types for the field (type) is "card sale," I...

I know it's small but it's a lil bit clearer...hopefully it helps. Btw...what's an indeterminate relationship type?? Good/Bad??

Hello, Thanks for the response. I want to remove the image itself. Would I do this in a query then?

K...but I'll have to wait till I get home. Thanks again for helping out...

[/COLOR] I could do a link, but it would be without referential integrity or update cascading fields. Would you ever recommend doing this? Thanks...

nope...it is a autonumber field to a text field. In my current database that I'm trying to change, it is set up as an autonumber field to a number field. Now it will be an autonumber field to a text field.

sorry...forgot the attachments!

of fields with the same data types. I am now getting this error. I've posted two screen shots of what I'm working on. The 1st picture (untitled) is of me working on my (backup database) to remove the lookup fields in my table. I have done that and now I'm trying to recreate the previous...

can somebody let me know if this is possible?? if any of you have ever done it???

nobody knows????

Guys, Is there a way to quickly delete hundreds of records that has an image attached in my image field for that record. I can query to show me all the records that do have an image, but I'm not finding where I can delete all the images at once. I've tried to do a delete query but it says...

Somebody told me to do an outside query...that has improved it for the time being but I'm still working on it.

I have considered tabs...that is definitely an option. I was also wondering about just putting a link in there to open up a new form to do that specific task. Main thing I'm wondering about is how to create a form that would be easiest for me to search through the thousands of cards I have in...