Search results

I am trying to use the DSum function on a form, however if I try to use it with a fieldname that begins with a numeric character (eg; “2013Sales” ) it throws an error. If I change the fieldname (eg “Sales”) the error doesn’t occur, however the original field name works fine in other...

I have a datasheet Form that is based on a query. On the form I have 12 unbound text boxes that Sum data from other fields (=Sum([fieldname]). The form was working fine and then without any apparent reason the text boxes appeared with an “#Error” instead of a value. The data in the query...

Thanks that works great!

I have a calculated field in a query that generates a result that i need to display in forms/reports with the $ sign but zero decimal places (ie; rounded to the nearest $ value, $5). If i use the sql format currency function (format (n, "currency",0) it always displays the $ sign but with two...

Thanks Isskint, i'll try your suggestion...btw, Do you know if there is a way to detect the right-click>>Copy event?

I applied the code to a form save record changes to an audit table. The update log code works Ok - but it crashes if i try to add a new record by copying and pasting an existing record...so i need to somehow detect when a new record is being added and temporarily disable the code, then...

I have a db with a main form containing a subform that is linked using the master/child fields control. The main form recordsource is a Department table. The Department record is selected using a combo box. The related fields are the ID in the Depts table and the Dept ID in the course table...

I have a single form with a label. Sometimes the user wants to update the caption for the label - this carries through to the report heading etc. It's simple to get the user to change the caption using a button /InputBox, however when we close and re-open the Database it defaults back to the...

Thanks vbaInet - the form design is a single form - one record displayed at time. I don't know exactly the difference between locking the form & record but locking the form sounds a bit too restrictive. The objective is simply to ensure that the user is made aware/alerted before they edit...

Thanks nanscombe for your example. Thanks vbaInet i'll try your suggestion re the fields. What do you recommend as the best way to lock/unlock the form for editing using vba ie; using an event linked to a button on the form to change the form property so the user has to 'unlock' the form to edit...

Thanks to all the suggestions posted - i've been offline for a week but will test the ideas put forward. I understand the point from 'lagbolt' about (not) using the date as the pk - so would you recommend having a separate pk and just setting the date field to not allow duplicates or is there...

We’re using a single table to record daily data – the date field is set as the pk so only one record per date is allowed. If the user enters a date (when creating a new record) that already exists in the table what is the best way to a) avoid the Access error message about duplicate values and...

Help! I need some text boxes on my form to update their formats/values based on the data in the current record. The formatting of some of the controls on the form is based on the values of the current record (eg a negative value will change font to red). The code works fine when a new record is...

I’m looking for somehelp/advice on the best way to achieve the following . The database contains a single table to record daily sales data - only one record per date is allowed – so the date field is set as the pk. The user wants to enter sales data via a form for a specific date, using the...