Search results

Thanks for you swift intervention. My error message is simple "#Error

Good Day all. My mainform is "CourseDays" and subform is "CoursesSubForm". The "CoursesSubForm" data source is a table "Courses" which contains a field "Subject". I add a calculated field on the mainform to count the number of records in the subform. This is my code...

Good day all. My problem is in the extract from my program below. The procedure call "Call RearrangeCoordinates(RearrangeCoords(), ReturnCoords())" return a message "Type mismatched: Array or user-defined type expected" Are there any views as to why the message is being displayed? Private Sub...

Good day all. A report field data is sourced from a query which displays its values as a string eg "George Renee", however in the reports it displays data as a number eg 42. It is true that the query field obtains its data from a table which gets its data through lookup Wizard. I really...

Thanks for the info. But just what is CDO and can you recommend any 3rd Party software?

Thanks for the info. But what is CDO and can you recommend any 3rd party software

Good Day all, I am writing a procedure to generate and send emails to various persons by one mouse click. Each person is to receive a unique document. My problem is that Outlook pauses me for every mail, making the process a manual one. I want all the emails to go by one mouse button...

Thanks Galaxiom. That is good advise and information. I know it is close to working but there is some little problem; I am getting a runtime syntax error notice. Here is what I entered: Private Sub Command201_Click() Dim curDatabase As dao.Database Dim rs As dao.Recordset...

Good Day, I am writhing a module which requires a line of 2 of code querying on 2 fields. I am fine with the query on 1 field but is having some challenges on the 2. I would be grateful for some assistance. Here is the working code: Dim curDatabase As dao.Database Dim rs As...

Thanks this solved my problem

Good morning All, I would like to know what criteria is used to return records based on a field with data type attachment. I am using "IsNull" and "IsEmpty" but neither of these work.

Thanks. You must be some sort of expert. This was solved in 1 shot.

Good evening all, My table field is data type NUMBER. It contains values 1,2,3,4 and some blank values. I want my query to return all records excluding those with the 3 and 4 values. This is my query entry: <3 This returns records with 1 and 2 only but excludes the blanks which I...

ok thanks for the advice.

Thanks everything is working squeaky Clean. Only one thing: I now have to go back to several of my previous programs that are working and change up the code to make them shorter and more efficient. Thanks again. bye

The message highlights the line which starts with: set rs3 = CurrentDatabase........

Thanks. Very Good information. I have applied it but however I am still having an error message saying " too few Parameters. Expected 2. My new code is as follows: Private Sub Command34_Click() Dim curDatabase As Dao.Database Dim rs3 As Dao.Recordset Set...

Private Sub Command34_Click() Dim curDatabase As Database Dim q As Date Dim t As Recordset Dim rs3 As Recordset Set curDatabase = CurrentDb Set rs3 = curDatabase.OpenRecordset("Select * from [tblSignin]") p = Form_frmSignin.txtUser q =...

Good morning all. I am trying to filter a recordset with a variable q. The field in the table associated with the record set is of data type Date/time. I assigned data types String and Date to q but both cases generates the error message " Data type mismatched in expression". I would...

Good afternoon all. I have two table: "Year Range" has field "Year List" of data type Text "Stat" has field "Year" of data type Text also The data source for the "Year" field is the "Year List" and this data is access via the lookup wizard. The problem is that on attempting to...