Search results

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...

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...

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...

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...

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...

Hello thank you for reading my question I am setting up a database for a training centre, part of this includes registration The academic year I am working with runs over 36 weeks with 24 teaching weeks, 2 x 3 week holidays, 2 x 1 week reading weeks and the final 2 weeks for exams. I aim to...