Search results

sorry it comes up run tome error 94 invalid use of null it then highlights :theId = ctl.Column(0, v) sorry ive been chucked in the deep end im drowning

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

sorry bad bad day no excuses, will keep on searching ta any way

why wont my DB reconise this script

ta col, ANy idea why the command button errors at: theId = ctl.Column(0, v) im trying to select a date in a list box from expr query you gave me have this script below but keeps erroring at the above script. any ideas what it is...

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

sorry yes sorted the J And S thing appricated in regard to the number thing i have a number of records enterd in april at the end of the month i need to print anything that i have entered or updated in that month, they have to be in number order so 100565 could be the start. i have run a...

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

Col, last question (honest) i have created a monthly report based on number (eg 100565) i also need this report based on a issued date. I.e anything issued in april, all the dates in april but in the original number order. can edit my exsisting report to do this, can you point in the wright...

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

colin i tried that in the update querys (under16 and over16) it didnt change the main query then i tried it in the main query and that returned no records. sorry lost again

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

it highlights .Backcolor Private Sub Form_Load() Dim today As Date today = Now() If Me.Text41 <= Now() Then Let Me.LicenseOutOfDate.BackColor = 255 Let Me.LicenseOutOfDate = "Licence Out of Date" End If If Me.Text41 > Now() Then Let Me.LicenseOutOfDate.BackColor = 65280 Let...

see attached need archive on a second page and the rest of the info on a main page

ok i no hardly anything about forms, searched the forum no luck. i have a number of fields in a mainform (created through a wizard) i have no discovered that i have run out of room on the page (Detail Page i think) so i would likr to add a another page/form within the mainform. not sure how...

hi have a page with all my main fields, now i would like to create a sub form and put some of these fields on it. i tried copy and pasting but a few of the scripts show errors. im not sure hoe i can transfer exsisting fields onto a subform, im guessing ive done this the wrong way round...

sorry my fault on frm, surname i have taken out once newbie anything else wrong

any idea whats wrong with the following expression SELECT frmForm.NewID, frmForm.Forename, frmForm.Surename FROM frmForm WHERE (((frmForm.Archive)=No)) ORDER BY frmForm.Surename, frmForm.Surename;

the button is supposed to archive certain data, but just returns that error message