Search results

Thanks - I'll have a scout around on the web too :)

Hi - I have a FE/BE Access 2000 database that is currently used by my department to record details of events etc at the company where I work. I have realise that it would be useful for other depoartments in the building to be able to query the database - the best way would be to give them a...

Cracked it OK - after some poking around I think I've cracked it - for anyone who may be interested, here's what I did: 1. Made a new module and made a Public variable called Referrer_ID 2. Changed the code on the button that launches the second form to include the line: Referrer_ID =...

complications Thanks Pat for your help. Unfortunately , I have run into further complications when trying to apply this code to a seperate form. I have three forms which all need to launch the same subform. is there any way that I can have some code on the subform that reads like...

Thanks Thanks for that - sometimes the answer is hidden in plain sight. :)

i have an IIF statement that runs to check the contents of a form before it is updated. I was wondering if it is possible to check if no field on the form has a value? Basically, i want to add to my IIF statemnt so that a user doesn't get trapped by my validation rules firing if they have...

clarification I think that the problem is that the second form needs to act like a subform. I don't want it to ever appear on the first form though, as the subform contains a lot of data. Can I somehow set up the second form to act as a popup form when the button on the first form is pressed? G

Hi I've got 2 forms set up, in such a way as a user can click on a button on the first form, and it opens the second form showing data related to the first form. This works ok. When a user tries to add in an extra record in the second form, there is a primary key violation error because the...

Thank you very much indeed! It works perfectly - I'm going to take some time to study the changes that you made, so that i can understand the errors that my code was making. I'm still new to vba - this board has really helped me out though! Thanks again G

I've got some code as follows **************************************************** Sub Form_BeforeUpdate(Cancel As Integer) If IsNull(Me.Lead_Partner) And IsNull(Me.Details_Descriptions) Then MsgBox "Please enter the Lead Partner's name and some information in the Details and...

Some users are complaining (not without reason, I might add) that the error messages that Access throws up are too complicated to understand. From searching the forum, i've found a useful piece of code to use for custom error messages. Could anyone please tell me where to find a list of error...

Thanks!

Hi I've got a custom menu bar to launch forms and reports, as well as 2 append queries. At the moment, I use openquery macros (in conjunction with the Sertwarnings command) to launch the append queries. This works OK, unless the user presses cancel on the query, where I get an ugly macro halt...

doh! i've just realised that i could just open the back end and modify the table directly. :) I must think before speaking!

I need to add a column to a table in my split database - what is the best way to go about this? I have an unsplit version of the database - do I need to edit this, then import the data from the existing db and roll the whole thing out again? I'm hoping not! G

Perfect Thanks you! :D

My database is used to track the firm's activities - I use different forms for each different type of activity to simplify data entry. Many of my forms contain a subform that allows users to input the names of employees involved in a given activity - The subform looks up users from the Users...

Thanks for your reply. To be honest i've done very little VB, so I think that the first option may be a bit of a struggle, although it is the only option that seems to do exactly what i want. I think that I may be in more of a mood to attempt this on Monday morning though, as it's ten to five...

A couple of the forms on my database have a lot of fields and/or a subform. To smarten up the look of these forms, I would like to have either a) tabs that allow me to split the form into 2/3 'pages' b) a button that takes you to more fields. this would let users look at a page on a form...

Hi I have never used VB before, so could someone tell me, in foolproof steps if possible, if I can create a single piece of code that can control record select buttons in a form. Using a previous example of code from the forum, I was able to control buttons on a form, but would like to be able...