Recent content by kerrance76

Sorry i should have said, this is being built into an excel spreadsheet as i cant fit all the fields in access, i have a button in access that opens this file. 1. It stops at the auto filter then returns to the start of the combobox sub and runs again I have it in the change event because that...

Hi I have an access application with a linked excel file, there are to many fields to build a form in access so i am trying to implement a few custom search boxes using combo boxes, the code i am using is Private Sub cboJobNumberSearch_Change() Txt = cboJobNumberSearch If Not Txt = "Job...

in the template move the data sheet subform you will see a text box here, do you have this in your example

OK thanks for the quick reply I'll look at another way of correcting any errors

Hi Is there a simple way of selecting a record from a table by row number, or filtering a recordset by row number? I have a CSV file imported with transferText into tblImports, which creates an error file, the error file has a row number for any errors, I would like to select these rows from...

Hi no that is all sorted now, the cascade delete and update worked ok on the join they were specified for (InvoiceNo) using Roy's code, i am now reading up on ADO so that i can use it for the rest of this project. Thanks for looking

Sorry i've taken so long to reply, been away for a few days, The error i was getting was error 3289, syntax error in constraint clause, which i get even with only the delete clause entered. I have never created a connection using ADO before, but after copying your code and adding an Active X...

Thanks but i still get the same error

Hello i am moving a database to a different system and have been told to write several functions for it. I have written the code below for setting up a new database but am having problems setting the delete and update cascades in strSQL5. I've tried everything i can think of but keep getting...

Thanks for the reply i guess thats what I'll need to do as well, thanks again

Hello I am building an application with an email function and would like to be able to attach reports to some of these emails. The place where the app will be installed has its own email servers and as the users all use different mail systems, either outlook, pegasus, webmail or thunderbird i...

Hi I've tried adding this after the current code and also before the last line but no difference, i have now added a call to a global sub routine which filters a few records and the option group updates ok but i'm still confused as to why it doesnt work as it was

Hello I have a form with a 6 page tab control, on one of these pages i have a continuous subform with an option group and 3 toggle buttons in the header. The main form has a combo box, populated by sql. wth the following code in the after update Dim rst As Recordset Set rst = Me.RecordsetClone...

Hello I have a continuous sub form that has approx 25 fields on it, each row has a module title field and then 24 attendance fields, this form is a sub form of a student form. I am trying to find a way to scroll the attendance fields while keeping the module title field in place. I know this...

sorry for my delay in replying i have been thinking about your reply. I have a link table between student and modules tables with week 1 - 24 as some of the fields, if I've got this right i can enter the 'year' start date in another table, which will be September or October, then i can get the...