Search results for query: *

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

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...

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

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 <>...

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 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...

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...

hi When i try to save a nested query Access shuts down. The queries run fine and give results, its only when i go to save them. I am using Access 2002 on Windows XP with 512MB RAM. They work fine on my home machine using Access 2000. Any suggestions? Thanks Lou

hi I have a large complicated report using many queries/sub reports. When i try to print this i get an error: There was a font initialization error I'm using Arial for all text. I've searched for information but cannot find anything. Can anyone tell me why this is happening? Thanks Lou

Hi I have the following query: SELECT Ethnicity, Count(Ethnicity) as Total FROM qryEth GROUP BY Ethnicity; How can i deal with null values? The combo box contains 15 items and i only want to show those that are not null. The output from this query = 0 White 10 Mixed 2 I...

hi Do I need to set any references to use the DateAdd function? I'm trying to use the following code which i cant see anything wrong with PrevDate = DateAdd(m, 6, Me.txtDate) however i'm receiving an error stating that 'm' is a variable not defined. I've started using a new pc and wondered...

Hi I'm wondering if anyone can give me any information on the pro's and cons of setting database to compact on close. Thanks Lou

hi I have an after update event on a field in a continuous form which makes another field visible depending on its contents. However it makes the field visible on all records. I tried putting this in the Form_Current event but it still doesn't work. Any suggestions? Lou

hiya I'm trying to extract the first part of a postcode (before a space) for each record in a query result (alternatively in a table and create query later on these results). i have the following code which works for a single string but how do I do it for each record? Dim strPostcode as...

hi I am getting a runtime error 6 when I try to run a report. Then in the status bar say its formatting page and press ctl+break to break, this however doesn't work. How do I find out where the problem and enter error handling to prevent it from happening again? Ta Lou

Hi I need to create a report using only the last entry in a child table of a 1 to * relationship. How to I reference these? Thanks Louise

Hi I was wondering if its possible to use an AND/OR type thing in vb within an If statement? eg If this is True and/or this is True then do this End If Lou

Hi I've looked at the numerous age calculation threads but I'm not sure how to use them to suit my problem. I have a QBF form where you can search by an age range selected from a combo-box. In my table I have DOB. On the form I have an unbound field with a calculation to calculate age and age...