Search results

The error is on creating a new record Thanks Jon K - you're right ProjectDetailsID is numeric. I replaced my SQL statment with the one(s) you suggested. Both Work well as queries but when run as code I get the error: Run-time error 3021 No current record which is exactly what I'm trying to...

Print.Debug a debug.print MySQL results in the following SELECT IIf(IsNull(ProjectDetails!ProjectType),NA,[ProjectDetails]![ProjectType]) AS ProjectType1, ProjectDetails.ProjectDetailsID FROM ProjectDetails GROUP BY IIf(IsNull([ProjectDetails]![ProjectType]),NA,[ProjectDetails]![ProjectType])...

Hi all, I have an SQL statement that is giving me some trouble. I've had to re-write it from a working piece of code as I discovered that when the I was opening a new record I got an error. Having written the SQL and checked the it in a query I thought it would work but, transfering it to...

Thanks namliam Fantastic that works a treat thanks namliam

Text box rather than listbox I've had a look, but it doesn't seen possible to pass the output to a textbox rather than a list box. Does any ideas?

Hi There I've written some SQL that selects a particular "Type of Project" the SQL is valid and works. Butr I'm not sure how to assign the outcome to an unbound textbox on a form. I'm thinking its the RunSQL command but I'm confused as to how. MySQL = "SELECT ProjectDetails.ProjectType" & _...

Result! Thats fantastic! - thought I was being a bit slow there for a while. Thanks for help Missinglinq Lex

Hi All I've set the 'cycle' property to current record - and this works well for the tab key. - BUT the wheel on my scroll mouse still moves the record to a new blank record. Is there any way to disable this effect? Thanks Lee

Thanks Chris Thanks Chris, I'll give a go Lex

Thanks Pat Thanks for your help Pat, your right - I'm using snapshots instead. Lex

Hi All I've got about 50 reports to print out in one go, currently I'm using the following code: Private Sub Print_Click() On Error GoTo Err_Print_Click Dim stDocName As String stDocName = "Average Length Of Time" DoCmd.OpenReport stDocName, acNormal Exit_Print_Click: Exit...

Hi All I've created a report style that I've used in all my reports (called prince). I'm really happy with it's lay out an style etc., in the preview mode in access. I've just added a button to print our the report the file, but most of the formating is lost. The code I've used is: Private...

Re: Datasheet controls Try opening the subform on it's own and go into design view and then setting the visible properties to false then save the form. Then open your main form with the subform in and try that. Sorry Andy that doesn't work in Datasheet mode - but thanks for the reply. I have...

Hi All I have a form that has a subform. The subform is in datasheet view, is it possible to hide some of the columns (controls)?. I want to hide the Primary and foreign keys etc from the user. I have put them in to enable me to synchronise the forms. The visible properties (along with a...

Re: User-defined type not defined Oh I see - sorry bit of a newbie, I set the reference to Microsoft DAO 3.6 Library. - It does work work noe thanks Lex

Re: 'User-defined Type Not Defined' Sorry, I'm not sure what you mean? Yep - That does it - thanks, been looking at it far too long with out a coffee! Many Thanks Lex

Hi I'm a getting a 'User-defined Type Not Defined' Error in the following code snip: HideStartupForm_Err: Const conPropertyNotFound = 3270 If Err = conPropertyNotFound Then Dim db As DAO.Database ' DAO <---- HERE IS THE ERROR Dim prop As Property Set db =...

How would you do it? I have to admit that I don't really know how. I havw written queries before but this is more advanced than my normal stuff. I tried using the IIF() and Msgbox() functions but to no avail. Can you advise how? Sorry and Thanks Lex

I have a subform (Subform) within a form (Form). The subform holds a date control that records when a report has been received (RecdReport). The sub report is in datasheet mode (as the number of reports is on going). I need to be to display a pop up box if the report has not been received by...

Thanks Pat Thanks Pat thats great. Lex