Search results

I am having real problems trying to sort out the syntax for the coding, I thought I have rewritten the code to reflect the guidance given, but I keep getting "type declaration character does not match the declared data type" so something is obviously still incorrect Could you just confirm the...

I am really sorry to sound an idiot, but I dont know what to put into the first set of code to pass blnDisplay as a string so that the module will run.

Thank you for your speedy replies, much appreciated. I am checking my code to get the correct syntax, but meanwhile could you please explain what bldDisplay does. It was already in the code which I found. Will it be alright to just delete it from the module code or will that cause me other...

CreateOrdersEmail is the name of the routine in the module which sends the email. Sub CreateOrdersEmail(strMsgAddress As Variant, strSubject As Variant, strBody As Variant, blnDisplay As Boolean) Dim objOutlook As Outlook.Application Dim objOutlookMsg As Outlook.MailItem...

I have an order form and I want users to be able to email selected information from this form to the supplier when they have completed the order entry, I have found some code which I have adapted, but when I click on the command button to run this code I get Argument Not Optional with the name...

Thank you for all for your replies and I apologise for not replying earlier but other demands have kept me away. Brian - not sure what you mean or whether I have done it correctly. After typing a date in my table and running the query, I then returned to the table and highlighted the date and...

Thank you for your replies. I have tried is not null, but when I tested this it came back with the error. A question though. If data is entered into a field and then deleted is it a null field? As is not null was working but then seemed to stop working and I wondered if it was because I...

I have three fields, coursestartdate, courseplannedenddate and a calculated field which uses both date fields. Doc6Overdue: IIf(DateAdd("d",(([courseplannedenddate]-[coursestartdate])/5),[coursestartdate])<=Date(),"overdue","notoverdue"). This query works well and correctly gives overdue...

Thank you for your comment about nested ifs. I had experimented but I could not get the iserror part of the if problem sorted so your first solution was so clean and simple that I used that instead. Many thanks for your help

Thank you so much - such a easy solution! I have tested it out and everything works a treat. Much obliged for your time. Marion

I have the field shown below in a query which is now working properly and correctly putting either Overdue or Not Overdue in a new field. I am then searching on this field to obtain any overdue records. This is all fine. Reviewdate1...

What SuperStars! You were correct. I have now input a record completely from scratch and my fields are now completed. Jal also responded to my post and pointed out that I may not see the default entries straight away, but I would if I then returned to the record and this is indeed...

This may be where the problem is. I am using a combo box which is selecting a record based on a value i select. This is from tblclient Private Sub cboSelectClient_AfterUpdate() DoCmd.SearchForRecord , "", acFirst, "[ClientLearnerNum] = " & Str(Nz(Screen.ActiveControl, 0)) End Sub So...

This is what I thought but I am not getting any default values in the box. I have tried checking the default value is set and then deleting and reinserting the field into the tab but I still do not get a default value. I am using Access 2007 if case this makes a difference. Could it be the...

What a SuperStar! Many thanks, this now works a treat. Much obliged for your time. Marion

My tblstatus which is the lookuptable just has one field called status into which I have typed three records, Yes, No and N/A. Does this help?

I have a form which has four tabs on it. Each tab is referencing fields in a table, but most of the fields are set as combo boxes. The combo boxes link to a lookup table (tblstatus)which give the choices of Yes,No or N/A. (was advised that this was better than lookupwizard). This appears to be...

I have a form (frminputupdatecourseinfo) that has four tabs on it. On the first tab (Enrolment Info) I have a combo box that is referencing a lookup table (tblSubject). I have set this field (subjectiD) so that if the subject does not exist in the drop down list the user can double click to...

I am created a calculated field which is working and correctly indicating either overdue or notoverdue when I run the query, but when I try and then put "overdue" in the criteria line of the query I get the message Data mismatch in Criteria Expression. Reviewdate1...