Search results

Hi I am currently trying to add an audit trail into a database (using the code from these forums). Its working fine when used on a specific table, however i need to adapt the code slightly to record the changes made on a different form in the same place. I have 2 forms Main form...

Hi I am currently working on developing a mail merge process for some letters that need to be sent out. I have a list of Jobs with each one being assigned to a specific group (there are 20 groups in total). I also have a table with a list of people linked to these jobs, as each job can have...

Hi I am having a problem with getting this one to work. I am trying to combine the values from 2 fields into 1 (one of these is a textbox, and the other is a combobox). The problem is with the combobox side. My combobox (called Name) has 2 columns (ID and Title). I can get it to merge the ID...

Hi Having a few problems with this one. I have form (in datasheet view) driven by a query QryCombPoint (the query combines data from 2 other queries QryMain, QryAVGPoint). QryCombPoint contains the fields Ref Name Course Points AvgofCurrentPoint MinofMinpoint MaxofMaxPoint The CurrentPoint...

I have been working with a simple Dlookup to return a value based on the data held in a specific field. I am now trying to develop this further and need some help. I have a query "QryMainForm" that brings together fields from 2 tables "TblFS" (fields: Ref, score 1, score 2) and "TblFamily"...

This one is annoying me now. I am trying to work out hiding a column on the opening of a new form but cant seem to get the VBA side working the way i need it to. The scenario is: I have one form open (in datasheet view), within one of the fields (field2) on this field i have an ON ENTER event...

Hi I am using the after update function on one of the fields in my first form to trigger the opening and filtering of a second form. I have 2 parts to this that i am trying to do. Working from one form i am trying to open a second form and apply a filter based on a field from the first form...

Hi Have a bit of an odd problem with the DB im using at work. I have 1 DB on a shared drive that is accessed by 4 of us from our desktop PC's (password protected via 1 password that we all use - no separate logins). The problem comes that we make changes to the data, exit via an exit button...

still quite new to VBA code so dont know if this is possible. I have a combo box i use to filter a form using the after update action. What i want to do is to also use this to set the record source for another combo box as well. I can make the code run indiviudally, but can only run one or the...

Hi Tried searching but couldnt see anything on the same lines. Pretty much as the title. I am currently trying to set up a couple of autoexports (have the actual export code sorted, will export in format and to a location hard coded into vb). What i want to do though is to get the code to take...

Hi Am slightly new to access and am working on some features in my db. What i am trying to do it to group a number of entries in a field under a genreic term so that my query returns all entries in the group rather than each on seperatly. I currently have the tables set up like: Tbl1 Formane...