Search results

We have a form in our database that I would like to add a button to which opens another form when you click on it. I can get the button to open the other form however if I try and edit anything on the form the message "This Recordset is not updateable" appears in the bottom left hand corner of...

Hi all, Could anyone tell me how to make a text-box field on a form display a zero? We have a form linked to a table on our jobs database and I need the ProposedFinalBillAmount field on the form to display a zero. The field on the table displays 0.00 which is fine, however the form clears a...

Hi all, We have a report in our job database which lists all of the jobs currently booked in; it sorts each record based on the date it was booked in. I would now like to create some additional reports, for example all jobs booked in over 60 days ago. Is it possible to add selection...

Hi all. I have a text box on a form which allows users to enter comments in to a record. The field is a standard short-text field but I was wondering if there is any way to configure the field on the form so that if the user hovers their mouse over it then it would display the entire contents...

We have almost finished testing our database and will be looking to go live with it soon. In terms of preparing the database for end user access (approx. 50 people on and off) is it best practice to leave the database in .accdb format and for users to load it via Access on their own...

We have an Access database with various forms, reports etc. I would like an email to be sent out automatically each week which contains a PDF version of a report as an attachment. It would need to run automatically according to a schedule rather than requiring input from a user. We use...

I have a report in my database which uses a query as the record source. The query has a parameter called [Manager Initials] - when the user types in the manager's initials the report runs and shows the details specific for that manager. I would like to create a form (or most likely set up a...

I have a checkbox on a form called 'Close Job'. I would like to prevent this checkbox from being checked/ticked unless a date has been entered in the 'Actual Billed Date' field which is also on the report. Can this be done? The icing on the cake would be for the form to display a popup...

I have a button on a form which is configured to display a separate form to view budget details when it is clicked on: This works well however I only want the button to be visible if there is a 'Yes' in the 'Has Budget?' field on the form. The name of the button is ViewBudget and the control...

Hi all. I was wondering if anyone could help me with this... I have a form based on a table called 'Budget'. The form contains combo boxes which look up a list of staff names via a query. The same query also contains hourly rates for each staff member. What I am trying to achieve is when a...

I have a query on my Access database which selects the Staff Reference, Hourly Rate and Hourly Rate Effective Date from a Staff table. Each staff member gets a new hourly rate each year and therefore for each staff member there are mutiple rows containing details of the hourly rates for the...

I'm having problems trying to figure out what mechanism to use in order to add a row to a particular table whilst maintaining a link to a corresponding record in another table. tblJob New jobs are entered in to this table via a 'New Job' form. Users select a client reference from a dropdown...