Search results

Havent used excel for a while so I am a bit rustly on formulas. Im trying to create a running balance I have 2 cell that i need to add. This part is fine.. =SUM(J29,C30) . This equal 111. Now I need to subtract the J29,C30, which 5 to give me 116. I tried =Sum((J29,C30-J29,C30) but is didnt...

Hi Ive have used the wizard to search for duplicate record. after running the query i noticed that it picks up records where there is more than to duplicated. There a some record where there a 3 or 4 records I need to keep. The criteria in the query is as follows; In (SELECT [Name] FROM...

Hi there. I hope I have posted my question in the right section. I worked out how to import data into access but I am coming across a small problem. I have function the imports all the data and the heading from the excel sheet in an existing table. This works well except doesnt like certail...

I had a quick search but couldnt find what I was looking for , I have a date field called txtDateReceived and another date called txtDateAllocated. I have these date inorder to calculate the no of cases have been allocate greater than 3 days. I have notice that some staff are failed to record...

I cant recall where I have seen it but Im after some code that will display the number character left on an unbound txt field before a user reaches the allowable 255 characters in a bound text field. I try searching the forum but could not find anything. Any help how could do this would be...

Hi there, Im having troubles trying to figure out how to make a field add the following each time a new record is created. my field is a client file which looks likes this ; CLF2006/0002 I would like the characters "CLF" to allows show so that all the user needs to do is add the year and...

I have managed implement GHudsons Audit Trail into my Db but im have a little difficulty trying to get it to work when main form is open with subfrmMovements . I have the Audit trail sitting in this subform. Having said that I wouldnt have the faintest how to change the the values below to...

I found this cool appointment calendar but I cant seem to get it working. Im getting a few compile errors that I cant seem to fix. One of the missing ref is microsoft outlook that I dont need. Im using A2002. Any help would be appreciated.

Im using this piece of code to hide the switchboard while a login form appears on startup. The Switchboard still appears maximized in the background. I dont know that is happening when I have asked for the form to be hidden. '// function to shape form to bitmap fInitFormShape Me...

i wasnt sure which area of the forum to submit this question so I apologise. Ive created a word merge doc that gets its data from the relevant MakeTable in the back end. When we were using A97 is worked wonders but now it giving a little problem since we org has gone to Access2002. Ive checked...

I have a form which is used to search for a property. Lets call this frmSearch. When i select a property from the list, it open the relevant record on frmHistoryProperties which a subform that contain a list of tenants that have occupied that property. I was using the below method all on...

I took over an old DBs that is used to track tenants. The person who created it, no longer work for the dept . He created this query that calculates the days a property has been occupied. DaysOccupied: IIf(IsNull([DateOut]),DateDiff("d",[DateIn],Date()),DateDiff("d",[DateIn],[DateOut])) To...

I have a button that opens a report and in the report I have added a message if there is no records. How do turn off the message that is produced by access. Is an error handler involved, if so, how and where is it placed to stop the message popping up after the On_Nodata is run. 'button on...

I have a txtDateIn and txtDateOut and chkActive fields on a form. What im trying to do is make the chkActive field true if txtDateout is null. I tried the following but it not as neat as I would like. Basically when ever the dateout field is null I need the check box ticked and visa versa. I...

Im using a combo box and I want to open a word doc depending on what I have selected in my combo box. I did a quick search on the forum but didnt find anything. e.g Case Select If Me.cboRegion.value = "West" then Open word doc c:\letters\4weekletterWest.Doc If Me.cboRegion.value = "North"...

I have multiselect list box that hold emails addresses for contractors. There will times when an email address maybe obsolete therefore I need delete it. Ive search the forum on how to delete the selected item but I could find anything. I would like to delete the selected item via button on...

Im using the date diff function to count no of days for a datein and dateout. This part is straight foward but how get it to calculate those record where the is no date out? So where there is a null in date out I need it to count it from todays date.

Help I have a field calledd address field that contains the street name and suburb. Is there any way to remove the suburbs and add them to a field called suburnbs in the same table. When i first did the db I failed separate the address details so that I can do report by suburbs.

would someone be kind enough to convert this to A97. Thanks!

Im trying create a DB to book in tenants into our houses. I need to be able to do reports on who is currently in the houses and who have been booked. So effectively a house can have many tenants and bookings. the booking form should enable a user to select a tenant from the tenant table and add...