Search results

Woohoo! Ooh! That works! Thank you *so* much! I just wish I understood all of that stuff... But thank you!!! --Sara

Please bear with me... I'm not great with Access, and I'm completely dumb with VBA. I'm completely VBA Illiterate. That said, I'm trying to do a search thing with a combo box in a pop-up form. I got the form from hayley and have been trying to convert it for my needs. It comes up fine, and...

Rich - Thanks, I'm exploring that Microsoft stuff right now. Hopefully it has what I need. If not, maybe it'll help me figure something out. Col - The e-mail has been sent. I'd love some code. :D The more stuff, the merrier! --Sara

I'm trying to re-vamp my forms to make them easier for the user, and less to look at. Right now I have a three-tab crowded form. What I would like is a one-page form that has command buttons which open another form where they can view and edit other information on the case. For example, the...

Well, I just tried that. I made the changes, hit save a few times, hit save as and saved it with another name in my database, left, came back, and nothing. I think Access hates me. Or maybe I hate Access. No that's not true, we just don't understand each other. It's a mistake to hate what...

I guess if you meant exporting it, you would have talked about the whole database. No, I haven't tried copying it. I'll do that now.

do you mean copying it within the database or exporting it to somewhere else?

still not working... Okay, so I've tried making the cells in my table HUGE, and I've tried saving the datasheet changes like 8 times in three different ways before getting out and coming back in, but every time I get the same result. Now look how mad I am! :mad: <--accurate pic. of me at this...

Thanks anyway, Shep. I appreciate your help. :)

I don't know... there doesn't seem to be anything relating to that that I can change in the Auto Correct window. I looked under Options, too. there is a default column width, but I don't want to change that, and there doesn't seem to be a way to disable it... I'm using Access 97, in case...

Thanks, but I've tired that, and it didn't work. I tried it again just now, just in case, and it still didn't work. The formatting stays only while i'm there. I can even go to form view and back and it stays, but as soon as I go away and try to come back or go into design view and back, it...

Why can't I get my Column Width to stay where I put it once I leave the datasheet view of my form? I'm sure I'm (as usual) missing something quite basic, but I don't know what. They all default to 15.6667. I tried dragging, double-clicking, and typing in the change manually. Thanks in...

I tried that... See, some of the data in the fields his left blank, and the Access Help said that using the * wouldn't cause a problem if soem of the fields conatain a null value... So I tried using the *, and I tried using the field name of my primary key, which is in every record... I'm just...

So there must be something I'm missing... I'm creating a report from a query, and in the page footer I want it to display the total of results from the query. I created a text box. For control source, I put =Count(*) and it comes back #Error... I got the equation from the help in Access, so...

I can try to do that... but I don't have a zip program on my pc. it's not huge... compacted and with one table, it's only 836kb... Let me know what you want me to do with that... --Sara

Hey there, You're definitely helping me work it out... but I have some more questions... bear with me, here... let me explain what I've got set up right now... Okay, everything is in one table. I have one main form for everything which is split into three pages using tabs. I have five...

PS Yeah, the new tickle date becomes the next day.

Hi, Colin Yes, every file is dealt with by the same secretary each time. I have thought about what would happen if one left... Couldn't we just add the new secretary and switch the names on the ticklers? The ticklers aren't the primary function of this database... it's for tracking all their...

Okay, here goes: (Is this something I can do?) My database tracks all of the files in my office. It stores basic info, like name, account number, addresses, case type, case history, etc. It also has a "tickler" system which gives each of the secretaries a list of files they should get to that...

disappears mighty quickly That's really quite cool. Is there any way to get that startup pic to hang around for more than half a second? --Sara