Search results

I have a form called MAIN_FORM2 on which there are the following subforms Company form based on a table called company Company_site_form based on a table called sites Job_lifts1_form based on tables called jobs and job_lifts. The forms work fine saving and displaying the data entered...

I am attempt to find the week number and/or the date of each Monday between two dates. My table called [jobs] has two date fields erect_date, end_date The end_date is calculated by entering erect_date and hire_period in days within the input form. What I wish to do is 1- check that end_date is...

I have a table called job_lifts which records who carried out a scaffolding job. Table Field names charge, rigger1, rigger2 , rigger3, labourer1, labourer2 , labourer3, riggers, labourers, rigger1_fee, rigger2_fee, rigger3_fee, labourer1_fee, labourer2_fee, labourer3_fee. The table is updated...

I have a db that currently requires the manual import of a csv file on a daily basis but I wish to try and automate the import. Books and advice give guidance on this where the file name is a known constant. The file I wish to import is created via a cronjob from an Oracle db and ftp'd to a...

Within a form I have a column displaying a percentage as an indication of performance. I wish to have either the text or the back colour change colour when the value is below a set value. No doubt there is a simply answer but I have not found it as yet so can someone save me hours of searching...

I have created a macro containing several queries which require the start and end dates to be imput for each query. I believe there is a way of creating an unbound control on a form that can accept the two variables and pass them to the macro thus preventing the need for repeated user input...

I have a report that can have upto 10 columns but on some occasions when the report is run there is no data in one or more of the columns which results in the report stopping with the error message The Microsoft Jet database engine does not recognise 'TRAFFIC' as a valid name or expression...