Search results

Hi clever ones I am trying to mark a students database. The database has a start form with vba ( I have checked the code and it is ok) On completion of the logon form it runs this code DoCmd.Close acForm, Me.Name DoCmd.OpenForm "frmStartMenu" The frmStartMenu does exist but it does not load. I...

Hi Clever Ones I have a customer form which I fill using a combo and this works ok. Within the form I have a Jobs subform which basically only holds JobID* CustomerID CarID Both CustomerID and CarID are foreign keys I also have a jobDetails Subform. This is the line data for the job and...

Hi there I am trying to create a query that will use four tables. Each table is joined in a one to many relationship. The scenario is using ticket sales for west end shows. here is a copy of my query SELECT tblCustomer.Title, tblCustomer.[First Name], tblCustomer.[Last Name]...

Hi clever ones Just started teaching in a shool and found this issue. Students using MS Access 07 when trying to import data from a CSV or Text file get an object error. Sorry I haven't got the complete wording here as working from home. Has anyone come across this and is there a fix. The...

Hi All I have just noticed some strange behaviour in access. I hava and asp page which gets two dates which are then used in a sql statement to refresh a page. The end of the statement deals with a between clause like this WHERE tbl_Movements.date_of_Movement Between #12/03/2007# AND...

Here is the problem I have a tblOrders that has 1800 records with 31 fields primary key tblOrder which is a number. Periodically users export data from SAP into a spreadsheet, which are changes to the original data but may not contain the exact same fields as the master tblOrders. The data...