Search results for query: *

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.

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

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

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

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

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

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

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

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.

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

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.

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

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

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

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

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

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

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

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

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