Search results for query: *

Thanks guys, I'll give it a go. Will i need drivers for cd rom or anything? If so is there an easy way of finding out what ones i need? I got an XP home disk with my laptop which has since died a death. I'll never use it again (unless i get a new HDD, power supply and battery!!!) I assumed i...

Hi I recently bought a pc from a friend which it now appears has a counterfeit copy of XP Pro on it. I am now crapping myself (and pretty annoyed with said friend!) I have a copy of XP home which I can put on but have absolutely no idea where to start. I'm not too hot with this type of thing...

Hi After spending ages pulling my hair out over this, i post a message then fix it. I have set format to Fixed and decimal places to 1. I have had to do this on both the report and query but it works. Thanks Lou

hi I am using the following in a SELECT query to try and round to 1 decimal place. Avg(Round([SocFun],1)) However, it is not working. I have also tried using the properties of the query and the properties of the text field in the report. Nothing seems to work. Any ideas Ta Lou

Yes sorry my mistake when changing the form names to supposedly make it easier to read. stLinkCriteria = "[ClientID]=" & Me![ClientID] DoCmd.OpenForm "frmLinked", , , stLinkCriteria If Forms!frmLinked!ClientID = 0 Then Forms!frmLinked!ClientID = Forms!frmMain!ClientID End If

hi I'm having trouble with using a linked form instead of a sub form on a 1 to many relationship. Then linked form can be accessed from various other forms. When it opens the linked form, if there are no records the clientID is 0. I tried the code behind the button to open the linked form...

MP9 Thanks, that worked a treat. It doesnt' explain why one worked and others didn't, I also have 2 other reports done in the exact same way which work perfectly :-S Louise

Hi I have a report with 6 columns. At the bottom of these colums I have fields which total each. I have done this in the Detail_Format section in vba using the code format: txtTotal = ([FieldName1]+[Fieldname2]+[FieldName3]) This works perfectly fine for the first column but in subsequent...

Hi This might sound like a really stupid qustion but how do I set a data type to boolean? I've searched for info on this to no avail. Thanks Lou

Thanks Gol4 I set the default value of the ID field in the child form to that of the ID in the parent form. The code within the if statement was supposed to set the RefID to that of the parent form. When a record didn't exist in the sub form for that particular record it opened with zero as...

hi I'm out of space on my form and would like to open my continuous subform as a popup instead. What is the best way to do this? I tried using the following code: strCriteria = "[RefID]= " & Me.[RefID] DoCmd.OpenForm "frmSub", , , strCriteria If Forms!frmParent!RefID <>...

Thanks Stewart, that works a treat! I had used the formatting, though wasn't sure how to Format dtWkEnd. Is this the way you should always format dates regardless of settings? ie mm/dd/yyyy. I'm having problems with a couple of databases switching round the dates when i format them. In the...

hiya Dates are driving me insane! I want to search between two dates that the user enters on a form. I then want to save the results from this query into a table, including one of the dates entered. My code is as follows: Dim dtWkEnd as date dtWkEnd = me.txtTo "INSERT INTO tblHighRpt...

Hi I tried both of your suggestions, unfortunately neither worked. However both work if i replace [Forms]![frmRptMenu]![txtYear] with an actual year. I have checked the form and field names are spelt correctly so I dont know what else to try. thanks Lou

Hi I want to return records where the year of a date in each record matches a year the user enters on a form. I have the following where clause: WHERE (DatePart("yyyy",[tblClient.DateA])=[forms]![frmRptMenu].[form]![txtYear]) I get no records returned although this works if i just enter the...

AceMan You're right that does give the same problem. I dont have anything like DoCmd.Save or save acCommandSaveRecord and the only assignment to any textbox is in an afterUpdate event (the only event the form has) of another field which sets its value to the same as what the user enters. I've...

AceMan You're right that does give the same problem. I dont have anything like DoCmd.Save or save acCommandSaveRecord and the only assignment to any textbox is in an afterUpdate event (the only event the form has) of another field which sets its value to the same as what the user enters. lou

Hi Roy The form is bound and is using an autonumber for the PK. I cannot find what line triggers the message. I've tried error handling for error 3020 but cant get it to prevent it. I think the easy option is to do as you suggested and use docmd.gotorecord,,acnewrec Thanks Lou

Thanks guys but I really need to have the form open at a blank record. Lou

Hi I have form that opens in FormAdd mode but if the user decides not to add a record it adds a blank one. Then if the user chooses to open this record and delete it or even just close it again, i get the error: Update or Cancel Update withour AddNew or Edit How can i either handle this...