Search results

Hello everybody, I have a table called Sponsors which lists the sponsors and the concerts each sponsor has sponsored over the past ten years. The only problem is that everything is on a single table, when it would be much more user friendly to look at if the data was arranged on a Form in a one...

Hello everybody. I have a database with a bunch of company names with their contact names, adresses etc. linked to a subform with details about correspondence made with each company. I was hoping to add some sort of code that searches automatically for a matching record based on what you start...

Need more help.. sorry Thank you both for the advice - I have inputted the code but it is not working. Problem 1 - I am using Access 2000 therefore I do not have an 'On Current' option, or at least I can't find it Problem 2 - I'm a complete idiot and I can't remember exactly how the syntax...

I have a combo box that works just fine that I wanted to add a little more pazazz to. What I was hoping to do was have a field that is normally hidden pop up (or reveal itself rather) if the user selects 'No' - this would allow the user to record a 'Reason' for the 'No' I understand I will...

I just discovered an interesting bug in the code I was using to find a record matching a control. I get a run time error (#3077) that states that there has been a "syntax error (missing operator) in expression." Here is a copy of the procedure that governs the combo box. Private Sub...

Is it possible to have a three-way cascading combo box? For a database for a small museum, I have a set of two cascading combo boxes, the first for a particular artifact's general category (like communication artifact, or a personal artifact etc) which affects the contents of the subcategory...

Hello. I've been working on an small museum artifact database and the main identifier of each object is the object's accession number. Before, this number was a long integer but it was later found that we needed more than the maximum number of figures that long integer would give. We selected...

Thanks Pat, that cleared things up. Cheers

I have a field on a form where the date is input. Right now, as a Medium Date field microsoft wants it dd/mm/yyyy and I was wondering how I could change that to mm/dd/yyyy? is there a way to use an input mask for that? it doesn't look like any other of the date choices would help. Thanks

Hello all... I have been working on a small museum Artifact database and am having problems with a form that is supposed to look up records of artifacts which are displayed in a subform. The user enters the donor's name, phone number etc. which is saved in a table, DonorTable. After the...

I have been working on a small museum Artifact database and am having problems with a form that is supposed to look up records which are displayed in a subform. The user eneter the donor's name, phone number etc. which is saved in a table. After the donor's details have been stored, the user...

Thanks Jim, worked like a charm! Cheers, Bachfile

Just wondering if it is possible to add scroll bars to a memo box that contains a lot of text information. Just curious whether this is possible because the user right now has to scroll down manually to find a certain insert. Thanks for any help you guys can offer. Cheers, Bachfile

Hey guys! Does anybody know how I could get all of the fields to update using VBA or some other method other than the one that DBL has suggested. Adding that extra box would be too much of a pain. There must be a way using programming to fix this somehow. Thanks for any help you can offer...

Thanks DBL, I'll give it an honest go at it - Just one quick question though - changes you make to the form in datasheet view - will they have an impact on the form view? Just wondering.... Thanks, Bachfile

Thanks! Thanks a lot for your suggestion - it works perfectly now One more question however - it would be EVEN better if all of the subcategory combo boxes would show their contents in the datasheet view as well - I know you submitted an example - Would you mind explaining what I might do...

I have two cascading combo boxes. They work - you select one Category from the first box and the SubCategory boxes update so you can only select the related subcatories. There is a small problem with this however - the subcategory box appears empty when I select a different record (e.g going...

Thanks Pat, everything works perfectly now. Cheers, Bachfile

Hi guys I have a "daily update" form for users to use after they have finished entering data etc. so that they're steps are retraceable. I made so instead of having separate records - I made it so that there was only one record, with all of the info provided being appended to a memo field that...

Thanks a lot Tim! That works perfectly now! Just one more thing. I wouldn't mind having the date and time entered automatically every time someone wants to enter an update. I've tried making a new command button with code to requery the time and date fields, but this doesn't work. The time and...