Search results

Hi Folks My VB is rather rusty so would appreciate a quick bit of help... Aim: I want to save report 'M1' as a text file, to disk, with it's file name as the value in field 'Filename' from table 'Input'. The file name would also need to be appended with the suffix ".html". I've tried the...

Ok, before I finally nail my head to the desk with my stapler, I would really appreciate some help on this one. Summary: I am trying to produce a report that concatenates approx 100 text & memo fields into one long text string. Problem: The Text Box object seems to have a limit, so I can't fit...

Perhaps a silly question, but it's something I've encountered before and never really managed to do.... I want a drop down combo box that looks up data in a table. Selecting the desired value, then lets the rest of the form display all the other related fields to that value. That's fine, no...

I'm having a bit of a 'mare. I open a form from a button on another form, linking the two ID fields. However, when the new form appears, it is read-only. I cannot seem to make it editable, which is what I need....I think I've checked all the obvious parameters. Anyway, the code below is what...

Hi folks What's the code to maximise a form? I'm using code linked to the 'On Current' Event, which I want to ensure maximises the form when it opens. Is it anything to do with me.something? Appreciate the help! thanks

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...

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...

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...

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...

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...

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...

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.

Hi folks, hopefully a straightforward one: Simple database: one table, which includes several tick boxes as fields. These tick boxes appear in my report, (whether ticked or not) amongst other fields. However, when I convert/export to Word, it doesn't recognise the tick boxes and leaves the...