Search results

Has anyone got an idea why the following is happening. When using docmd.sendobject I have had an irritating problem that whilst it works perfectly with outlook it won't use outlook express despite OE being the default mapi programme ( windows XP and 2003) . After spending a couple of hours...

I have a form which allows users to create a report by specifying various criteria to be included/excluded. The report is then created using "docmd.openreport" using a where condition based on the users selections. I would like to print the where condition on the report for reference and cant...

I want to create a query and exclude fields which contain a certain string however I cant get this to work. I have tried NOT "Against" , NOT LIKE "Against" , <>"Against" ( "Against" being the relavent string) but all with the same result ie the datasheet view returns no records desipte there...

I have a question related to declaring variables in code related to forms. I want to share a variable between two sets of code on two seperate forms. I have made a declaration "Public GstrType As String" in the general declarations area of one of the forms but it does not seem to work, I get a...

I have an issue with a database layout and I am not sure which is the best way to proceed. The problem is in an invoice part of a db . When a service is delivered, say 2 hours of a technicians time, it has to be assigned to a particular tech. No problem when there is only one tech however...

I have a little problem that is driving me crazy although I am sure the answers simple I run the following code SQLstatement = "SELECT TblIssues.Issues, TblIssues.[record number] FROM TblIssues WHERE (((TblIssues.[record number])=[Forms]![frmEnterIssues]![txtRecordNumber]));" Set db1 =...

There's probably an obvious answer to this but I can't spot it. I have a form with a sub form the data in the sub form is from a table at the many end of a one to many relationship with the table upon which the main form is based. When the form opens I want the sub form to go to a new record...

I want to add a column to an existing table using the sql statement Alter table. The new column needs to be a yes/no type. The following code almost works but it only sets the column to a general logical type not specifically the yes/no check box . DoCmd.RunSQL "Alter Table TblIssues Add [" &...