Search results

ok did what you suggested, moved it to before update cant cancel it it doesnt have a cancel button just an ok button, i have searched the forum for the last 2 hours, but still lost.

hi, the below scrip was taken from another forum member. i have put this in the Forms / error VBA but i still a little lost i have set 3 fields to be indexed not to allow duplicate information (Forename, Surename, DOB) i was then advised to error trap so it would highlight that i have...

this record set is not updateable Me.TimeSpan = Now() - CDate(Me.ArchiveDate)

not sure i understand when i archive the information it should take todays date

please see below script error, im' a little lost CDate(Me.ArchiveDate) = invalid use of null Private Sub Form_Activate() Me.TimeSpan = Now() - End Sub

hi , see below for the current code to find a duplicate surname (this works Fine) now that ive properly thought it through what i need to do is insert a surename and if (by Chance) when i insert the Date of Birth if this is the same highlight it as a duplicate record. However if these people...

sorry i dont i just want to stop a duplicate record if they both forename and surename match, and then have the option to add a duplicate if by chance two people do have the same name.

hi i have a form with various fields, on this form i have an archive button that places certain fields in an archive form. however this does not remove the information from the main form. pls see attached any ideas, as some will know i'm a newbie

pls can someone point me in the right direction have searched through the forums. i have two fields Forename & surename i need to prevent duplicate records if the forename and surename match another record.

Hi, I have a main query with numerous records in, i have another query with archive records in. is there a way of hiding (or removing) archive records from the main query. have searched, please can somone point me in the right direction

i have spash screen that runs for about 10 seconds, would like to reduce to about 4 seconds any ideas seee script below. Option Compare Database Option Explicit Private Sub Form_Close() DoCmd.OpenForm "Switchboard" End Sub Private Sub Form_Timer() On Error GoTo Err_Form_Timer DoCmd.Close...

well it works the expiry date returns a date of 1 year form the issue date any ideas about editing

I have a issue date and an expiry date feilds, the below script in my query is to automatically increase the date by one year, this works fine but i would like to be able to back date the script if necassary. i have checked the properties and the field is not locked. but it wont let me...

i have a six digit roling number, (100565) i have a totals query trying to add the amount of entries are in this query, however i need a criteria for it to look for a six digit number unless i have this criteria it returns 1 for 100565, and 1 for 100566 and so on any ideas searching db now

sorry neil not sure how to go aboyt the totoals query, its probably the ansewer but i am totally in the dark. is just a case of creating a new "totals query" pick the fields i want to add up etc

hi i have a number of query's (Current memberships, out of date memberships etc) all via a certain area/town. i am trying to find out total figures (how many members how many non members, how many in certain area/town. these need to be updated continuoulsy. do not no how to approach i ahve...

i am trying to count the number of records based in a query can some one send me in the right direction

sorry my fault, this is the code below, it now errors on: Resume Exit_Save_Monthly_Report_Click: error time 20 resume without error before the error a box comes up that say "ok" End If DoCmd.OutputTo acOutputReport, "MD Form", "Microsoft Excel Workbook(*.xls)", "C:\Documents and...

DoCmd.OutputTo acOutputReport, "MD Form",".xls" "C:\Documents and Settings\KevanAlderton.THERMOSHIELD\Desktop", True any ideas what is wrong ?? many thanks

im way out of my depth, thanks trying