Recent content by thrainpa

Okay so, I've got as far as: Private Sub Form_Error(DataErr As Integer, Response As Integer) If DataErr = 3022 Then Response = acDataErrContinue RunCommand acCmdRecordsGoToNew Call FunctionName End If End Sub But because there is data on the form it is trying...

-- EDIT -- Yes the primary key is an autonumber. If you mean front-end back-end style system then yes it is. It is set to No Locks. ( Sorry it took so long for a decent reply i had to look those 2 terms up. )

Hi, basically i have a form for making new users on our system and at first I used the access default system for subforms, where the Primary Key field shows (New) until something is entered into another field in the form and it automatically then creates said new record. My problem is that...

I apologise if I should have made a new thread for this but since it is related I thought it should go here. Firstly, I made a form that loads up the value of a textbox (there are 2) in the report. By putting something like this in the OnLoad section of the form: Me.TextBox1.Value =...

Hi, In my project I use reports to build and print out letters, but someone noted that after generation there is no easy way to make changes to the report. I tried going into 'Layout' View but some of the code queries the database via SQL and going into layout mode breaks it. Is there another...

Sorry I'm afraid I can't.

Thank you, but no, I am not aware I have used any page feature, this report was never meant to be printed.

Yes, sorry I didn't clarify; And here is where I find out that is the worst thing to do hehe. :P

Decipher? I'm sorry I don't get what you mean, if you meant how did I figure that it was doing the whole thing twice then basically I run a Debug.Print at the start of the functions to see how many times they run. The functions are called in the report itself in their fields. I know that report...

Hi, I call some functions from a report but this report seems to have an issue; It runs all functions in correct order, twice. Is there anyone who can tell me why it is doing this and how i can prevent it? The functions are public and are being called from a common module.

Don't get me wrong, the GROUP BY method worked but there was an unintended side effect to it; since the SQL statement was for a combo box, regardless of the column widths, the first column would have to be the control source, which means if the SQL statement in rowsource (column 2) returns null...

One copy of each function, both with different names, as they do different things, they are in no way connected. I'm sorry if I didn't make this clear. Just to make sure I'm clear too, in the working example, the function returns to a single source (A report in the format of a letter to return...

Thank you very much for your help but I have discovered a seperate working method to my problem. All contributors to this thread and my knowledge will be thanked. :3

It is in the code behind the report, I will try putting it in a common module then but then thing is, the other report I in which the function works has said function in the code behind the report. :s

This issue has been resolved elsewhere, but thanks go to plog for his help and insight. I'm trying to run a query as a rowsource in a combo box as SELECT Table.[Field1], Sum(Table.Field2) AS Total_Sum FROM Table WHERE (((Table.[Field3])=[Number])); If I remove 'sum()' then the box shows the...