Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. taiwai94

    Using VB to validate data in Subforms

    Thank-you for your help but I think I have managed to get it working - looks like I may have over-complicated it (?). I used... If Parent!AssessmentOffered <> 53 Or IsNull(Parent!AssessmentOffered) Then ...and this works in both cases. Thanks for your help though.
  2. taiwai94

    Using VB to validate data in Subforms

    Sorry again, having a Friday meltdown, the subform in both cases is FFamiliesMembersAppsAssess (where the VB is triggered) and is as follows: FFamilies -> FFamiliesMembers -> FFamiliesMembersApps -> FFamiliesMembersAppsAssess and FCourses -> FCoursesApplications -> FFamiliesMembersAppsAssess
  3. taiwai94

    Using VB to validate data in Subforms

    Sorry, forgot to add, the VB code is triggered from the subform which would be: FFamilies -> FFamiliesMembers -> FFamiliesMembersApplications and FCourses -> FCoursesApplications respectively, thanks.
  4. taiwai94

    Using VB to validate data in Subforms

    Hello MazeWorX, Thanks for that but it didn't work when I tried it through both the FCourses or FFamilies forms. What I'm trying to do is to have only one if/eval statement that works for 2 different scenarios which are: ------------------------------------------------------ If...
  5. taiwai94

    Using VB to validate data in Subforms

    Hello, I've spent two days rummaging through the internet to try to find an a scenario similar to mine, but looks as if only being an amateur in VB isn't helping either. I have started putting a database for the service I work for - courses for parents to help them regain control of their...
  6. taiwai94

    Disabling all Exit options on Access

    jkl0, Thanks for that little bit of code, it works wonders except for one small bug. Obviously, the message prevents access from being shut down. On the database, I have a button which when pressed runs a marco which runs the Quit command. Since applying the code, this database button is the...
  7. taiwai94

    Disabling all Exit options on Access

    Hello, I found an interesting thread but unfortunately it has been archived so I can not ask my question there. For some time, I have been looking for a way to disable all exit optionson Access, except for a button on my database menu bar, which is the only a user should exit. The original...
  8. taiwai94

    Over-riding Startup Options

    BuilderSpec, I have tried searching but the results I get aren't quite what I'm looking for. Does anyone know how to do this? Regards, Taiwai94
  9. taiwai94

    Over-riding Startup Options

    Hi mp9, I realise holding down the Shift key over-rides all options at startup but I mean while in the middle of the database. A button that you can press that re-enables all toolbars and menus while you are already in the database.
  10. taiwai94

    Over-riding Startup Options

    Hello, I maintain and develop an access database at work. To prevent user tampering of this database, in the [Tools]->[Startup] options, I have disabled all tool bars, menus, etc. However, I want to have a macro-driven button that will over-ride this. If the authorised admin user is in the...
  11. taiwai94

    How to prevent &quot;17.0&quot; from rounding to &quot;17&quot; in a table?

    With regards to rounding: Is it possible to use a field to define the rounding of another field in a query? For example, in a query, field B is rounded to the number of decimal places specified in field A? Can this be done, or something similiar? Thanks.
  12. taiwai94

    Force user logout from an access database at a specific time

    I currently maintain an access database that I have made. At a certain time in the day, I need exclusive access to the database to run some reports. Obviously I can't have exclusive access until all other users have logged out. Is it possible to have something in the database that at a certain...
  13. taiwai94

    Access Reports with barcodes?

    Hi again, I have found the "Free 3 of 9" fonts and I have created a code, printed it and then tried to scan it using a laser. The laser scanner just ignores the barcode that I printed. To compare, I found a barcode that works. The barcode scans without a problem and reads as CN040805057258...
  14. taiwai94

    Access Reports with barcodes?

    addy, thanks for the info re: barcode fonts. Do you know who is the best person/company to obtain these from, and how much they cost approx? Thanks for your info! David
  15. taiwai94

    Access Reports with barcodes?

    Hello, I work in the warehousing/distribution section of a large company. In the warehouse, items are picked, boxed up and shipped out to whoever. For shipping out stuff, we have several couriers, TNT for the UK, DHL for all over Europe and 2 specifically for Spain. We have machines...
  16. taiwai94

    How to prevent &quot;17.0&quot; from rounding to &quot;17&quot; in a table?

    Hi lameid, I'm not too worried about the performance as this access database will only ever be used by one person at any one time on any one PC (more specifically, me on my own PC). Accuracy may not make a difference in access, but these numbers represent scientific data in which 121 and 121.0...
  17. taiwai94

    How to prevent &quot;17.0&quot; from rounding to &quot;17&quot; in a table?

    SilentAiche, What you have proposed seems to work. Convert the table field to text to overcome the decimal place problem. In a query, using the expression "QueryField: [TableField]*1" will "convert" the text back to numerical behaviour. This does mean that the query has 2 fields - one with the...
  18. taiwai94

    How to prevent &quot;17.0&quot; from rounding to &quot;17&quot; in a table?

    earthandfire, If I were to change the field in question to text, then what you see is exactly what you get, but within the table it is no longer possible to sort the field with regards to numerical values, i.e. in a text field 100 comes before 2 etc. Is there anyway to store the numbers in a...
  19. taiwai94

    How to prevent &quot;17.0&quot; from rounding to &quot;17&quot; in a table?

    Hi PHV, The problem is such a variety of numbers, such as some numbers having no decimal places and others having one, two or several. The numbers need to appear in Access exactly as they are ie, 3770 must appear as 3770 and not 3770.0, 121.0 as 121.0 and not 121, 53.57 as 53.57 and not...
  20. taiwai94

    How to prevent &quot;17.0&quot; from rounding to &quot;17&quot; in a table?

    I have created a table to store various values some of which are numbers. The field in question is setup as follows: Data Type = Number Field Size = Decimal Precision = 28 Scale = 14 Decimal Places = Auto This field stores numbers of a scientific origin, and as far as I know, the above setup...

Part and Inventory Search

Back
Top