Search results

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)

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

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

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

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

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

last ever question, i need a long hloiday it errors on: theId = ctl.Column(0, v) Private Sub Monthly_MD_Report_Click() 'Run a report displaying only the records chosen 'by the user in the form's listbox. Dim v As Variant Dim Frm As Form Dim ctl As...

why wont my DB reconise this script

ok i have a list box with January through to december 2005 i have linked this to my issue date which is entered (long date) the command button is trying to print a report of just the records that i issued in acertain month, but it comes up with a script error (see script below) i think the...

ok i think i know what i need (searching the forums gave me the idea) i have query that generates a report, i need this report to be flitered monthly is it possible to have afield where i enter the month so when i press the monthly report button it just prints any entries in that month...

i have created a report based on number (eg 100565) Now i need this report to report only on the previous month. entries. (number entries) I.e anything issued in april, all the dates in april but in the original number order. 100565, 100566 etc can i edit my exsisting report to do this, can...

auto date no problem but just an automatic month ?? any ideas???

Dear all, i have searched /researched and looked at hundreds of posts, and no luck. Im litlle bit out of my depth, i have posted this before but just got confused. i have two update querys, the first one identifys if a persons age (by date of birth) is under 16 a check box identifys if...