Search results

Hopefully a quick and easy one....forgive the stupid question, but I don't have quick access to a reference book. The 'Select Case' statement: I want to have a 'case is' for several cases with the same code, ie: case is = "a" or "b" or "c" or "D" lines of code lines of code...

Yeah, the "probably" stems from the fact that I'm adapting a database I put together before. I'm actually breaking away part of the original to start a new one in a different direction, so I'm just trying out a few thoughts, hence the vagueness. :D

Probably about 4 or 5.... guess I would use a 'case is' function?

Cheers, thanks Mile-o once again....

Hi folks I'm wanting to display, or not display, certain fields in a form dependent on the value of one of the fields. eg, if the value of field 1 is say "fred" then I want it to display fields 2 & 3, but either grey out or not show fields 4 & 5. If the value of field 1 is say "John", then...

Great stuff, thanks for that.

Hi folks I've put together a database, which I'm now storing on the company's server. I notice (unlike an excel worksheet) that more than one person can open it simultaneously on their workstations, and access the same records simultaneously. What happens if two people edit the same record...

devious Mile-O.....I like your way of thinking. For the moment, the maximise and pop-up selections are working an absolute treat....but I'm going to go through your code in a reluctant admission that perhaps I should 'dabble' in the dark side. Appreciate the help.

ah, I think that's it.....setting the form to pop-up....guys you are the best :D

Hi Mile-O At least I'm thinking on the right lines....I've already done that, but that wretched menu and blue bar are still at the top. That's the bit I'm trying to exterminate! Am I being optimistic? And yes, you're right about those damn 24hr books :D

Hi folks, I've searched previous topics in the forum, checked the Help file & still don't seem to be able to find an idiot-friendly answer to this. On startup, I want my opening form to fill the screen, ie to get rid of all the toolbars. I'm sure I remember doing this successfully years ago...

Just a general, conceptual, query regarding the overall capability of Access: I've just built a database which is expanding rapidly with lots of data. I've now got to build another database (and possibly 2 more after that) with information that could possibly be related to that in the...

Simple inelegant solution to mouse 'off' Came across this thread whilst searching for 'mouse over' problems that I have. I have since solved it using something not elegant, but simple, and thought I'd share it in case others are trying to do the same thing. Problem: I wanted to have a label...

Mile, you are wonderful m8.....I have spent 4 damn hours trying to get that right, now it works a treat. Oh the tribulations of teaching yourself Access! Appreciate it, thanks.

Can someone please see something obvious I'm obviously doing wrong somewhere but spent the last 4 damn hours trying to resolve. I have a form - "Search_Input_Form" containing a field - "SearchMe" I want to run the contents of what is put into that field through a query which searches...

Nope cancel that, I'm thick. I've cracked it thanks for the help!

Forgive me for being thick.... I tried that in the Control Source property, but didn't seem to work... Is that the right property, or should it be in the Format property?

Hi folks In a text field on a report, I want to be able to format the text so that I can add text to the field's 'incoming' text. (the field is text, not numeric) ie, in this instance I want to add the letter 'p' before the number that is contained in the field. (refers to page number) So...

Brilliant, thanks.

In the default property of a field in a form, I'm wanting the current date...easy: date(). In another field, though, I want the date less 7 days.... I seem to recall in Vb that u could stick parameters in date(...) but for some reason it doesn't seem to happen in Access. Anyone? Thanks.