Search results

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 !)

i have a form which contains 2 fields (both drop down boxes). What i want to do is for the 2nd field data to change depending on what is select in field 1. For example if field 1 was selected as even numbers , field 2 would just show even numbers, and if field 1 was odd numbers field 2 would...

not too sure if this is the correct forum for this, but here we go. I have a form which has a save record button on it. I want to have the form only save the record when manually saving. and to NOT save it when moving on to a new record or closing the form (ie disable Access's autosave...

oh don't worry i 'll still be on the boards. All i meant was that i think i have it sorted. Given that i've only used vba for 3 days i'm not sure i'm in a great position to help people, but if i can i certainly will. cheers Jamie

brilliant, thanks a lot. by jove i think i've got it. Thanks very much for all of your invaluable help, it is much appreciated. I hope to bother you no more. Jamie

does the Private Const strFilePath as String = "\\capt_kirk\conversion\data\caa" bit go in the module part before the sub h() (declarations section ) on a side note how do i do this, if file1="" or file2="", do i just use or, or is it | | like in php, or not even possible using vba? what if i...