Recent content by jesus_hairdo

We have a database which has a series of personal records in it. For each record there are an unknown number of images. What i would like to do is to print out all of the records and images in the correct order. So we would have record1 + all of the images for record 1, then record 2 + all of...

I have done this in a module on its own, and it *seems* to have accepted it, tho i'm not sure if the module has actually been processed. At the moment all of the code is under, Microsoft Access Class Objects->Form_Table1. Would this be better as a module ?? or failing that, is there a way that...

erm. looks like i spoke too soon. I'm getting the same error again. this is the full my code, Option Compare Database Option Explicit global boolSave as Boolean ---------------- Private Sub Form_BeforeUpdate(Cancel As Integer) boolSave = False If (Not boolSave) Then...

Great, seems to work fine now. Much appreciated Cheers Jamie

this is what i did. cheers Option Compare Database Option Explicit global boolSave as Boolean -------------------------------- Private Sub Form_BeforeUpdate(Cancel As Integer) Dim boolSave As Boolean boolSave = False If (Not boolSave) Then undo_check_msg =...

I've just tried putting the global declaration as you said, but i get an error "Compile error, Constants, fixed-length strings, arrays, user-defined types and Declare statements not allowed as Public members of object modules." WTF ?? cheers Jamie

Thanks guys (i found Me.Undo, just after i posted

Yeah i know this is a dumb question but how do i declare a public variable, ie where do i put it and what is the exact syntax, i want to declare a variable something like, 'Public save as boolean' then set it to False. A secondary problem I have is that i want to undo all changes on a form thru...

i have a form with 2 combo boxes in. combo68 is a category chooser, and combo70 holds the a value from that category. (eg combo68= odd number, combo70=3) What i want to do is to have combo70 dynamically change the choices depending on the category chosen in combo68. i can get this to work for a...

Thanks that works well if you are viewing an existing record. For a new record I want it to say "select category first" rather than have an empty combo box (as the select query returns no values) cheers

I have 2 combo boxes on a form, when a value from box 1 (called Combo68) is selected this changes the values in box2 (called Combo70). (or more correctly changes the source sql script). using this code, ----------------- Private Sub Combo68_AfterUpdate() Me.Combo70.RowSourceType =...

any chance of a bit of coding of this, (i'm very new to VBA, this would be only my 3rd use of VBA so still not used to syntax) cheers

Wat i want to do is on my main menu form have a button that when you click initiates the Merge it With MSWord wizard. How would i go about doing this, if its even possible Thanks Jamie

cheers for that, sounds like just the job. thanks Jamie

OK cheers, i'll give it a go & let you know how i get on, (i've only really done any vba once before so quite new to it, done other scripting tho !)