Search results

Hi Bit of a general query to start off with. Has anyone used MS Access and Macromedia Director together? I would like to be able to 'spit out' a result from a Director file (better still a SHockwave file) to an MS Access database. The Director file would run on a CD-ROM and is a piece of...

I wonder exactly what you want from your combo list. 1. Do you want users to be able to select from a list of common values, but not limit the user to those values? This would enable users to add new items to the field, but not to the drop down list? 2. Do you want users to be able to add...

Why not use a module and then call upon it? ---------------------------------------------------------- Function Age(varDOB As Variant, Optional varAsOf As Variant) As Variant 'Purpose: Return the Age in years. 'Arguments: varDOB = Date Of Birth ' varAsOf = the date to calculate the age at, or...

Hi Krisleech Have you thought about setting your database file to Access 2000 file format (this is actually the default in Access XP/2002). Your development will be 99.99% the same from then onwards ... but your database will already be suitable for people with Access 2000. From Access 2002...

Which flavour/version of Access are you using? If you are using 2000 or XP/2002 have you checked that you have the corrected references selected? You'll need: Microsoft DAO 3.6 Object Library in your list of References. HTH Rich

Hi David I think you may be better off redesigning your table structure - if one record needs to display multiple instances of values from a field, then it sounds like a one-to-many relationship (2 tables). This would mean that you could put a linked subform on your form, which would display...

Hi again Just put the same VBA code in the Forms 'On Open' property. That should sort it. HTH Rich

Hi Use a form for the parameter dialogue box. Create a form, could be quite small, that has a combo box on it. This combo box draws on the list of the five locations (via a small lookup table usually - though you can 'hard code' in the values if you know they will never change). In you...

Hi Yes I am sure you can do what you want ... with a bit of VB(A) coding. You will have to put code in the 'After Update' event of the tick box that wll make the 'Details' part become unavailable (this will mean making 'whatever.enabled=false'). Naturally you will have to check via an...

I konw you have an answer already that may work ... but you can select on a form the option of only 'Cycling' - i.e. tabbing through the current record/form. It's a property within the Form object - Cycle - and from memory there are three possibilities - Current Record/All Records/Current Page...

Hi Geoff Is all the code exactly the same apart from the next/previous/show all part? Is all of this code only going to be used on this form (and not for other forms)? Assumming "Yes" for both then ... create a new Private Sub (call it whatever you like within reason - Private Sub...

Hi Sam In your Student table you shouldn't have any IDs of subjects (as these aren't elements of the entity 'Student'). Similarly, you should not have any IDs for Students in your Subjects table (as students are not part of the entity 'Subject'). Instead you need to have, as suggested above...

Hi samevans and RV I must be honest ... the question confuses me a little ... but so does the answer given! A single table cannot have a many to many relationship. Two tables cannot, in Access, have a many to many relationship (the only choices when relating one table to another are: One to...

Hi bruceylp I think you are talking about the navigation buttons, not record selector (which appear on the left of a form/subform). The navigation controls/buttons allow you to move to next, previous, last, first and a specified record number. Unfortunately I don't think it is possible to...

Hi Paul By alongside I did mean across the whole width of the report (this was unclear, sorry). This makes sense as if the report is going to shrink then it must be across the whole width of the report (if the left hand side shrank and the right didn't, then things would be skew-whiff further...

Hi Rich Well ... now I am getting into the nitty-gritty stuff (as much to do with "business defined rules" as database design work). Much of what I have described to Paul is based on the databases I have designed for English language schools (EFL) - a School Administration Database. Often in...

Hi Paul It does work .... believe me it does! I have addresses on mail merge letters that can vary between 3 and 7 lines long ... and the blank lines don't appear (so the address looks normal/natural). I would get rid of any borders around the text boxes ... not necessary. Then locate each...

Hi Paul Sorry, I obviously followed your original post too literally ... "I don't need specifics I just need guidance on how I lay it all out ... " OK - what I do is have a field that indicates the staus of the Quotation/Invoice (eg. 1 = Quotation, 2 = Invoice with an Options Group display...

Hi Ian I did understand that your criteria was in a query that was used to open a form. However, it would seem that your report also runs from this same query (or this query is combined with other tables and/or queries to supply data for the report). The date put in for this parameter request...

Hi Paul Rich@ITTC here (not "Rich" ... confusing, I know!). For the text boxes concerned set the Can Shrink property to Yes (you can also set the Can Grow property to Yes to avoid data being truncated). HTH Rich Gorvin