Search results

reading a couple of other threads im beginning to understand where this is going wrong. the code im using is this: Option Compare Database Option Explicit Public Function Audit_TrailJobInfoDSView() On Error GoTo Err_Audit_TrailJobInfoDSView 'ACC2000: How to Create an Audit Trail of Record...

this is the advantage of another pair of eyes on some of these problems, it works well in adding what the field has been changed to into the audit field, however i would need it to record it both the before and after data held is the field. could this be done via copying the info as part of a...

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

Many thanks for the help with this one. The conversion guide was very useful.

Many thanks for the help with this one. the conversion guide above was very useful.

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

Many thanks for the help Looking through it i can see where i was going wrong. it is the differnece in the syntax between numeric and text strings that i had wrong. i was trying to work on the numeric data i was returning rather than basing it on the text i was comparing.

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

Thought id cover all angles. The lookup is using a query "qryJobfamilylink" with the following fields: Score (Number) JobFamily_ID (between 1 and 7/ name of family) FamilyLevel (Text) So the query looks like this 180 - 1/Operational - Level 1 185 - 1/Operational - Level 2 185 - 2/Admin -...

hmmm this is now confusing me. I have tried working with the Dlookup one above, it appears to work ok (it doesnt return an error) however it only gives me a value of -1 in the level field. I have tried switching some of the names and details but still not getting it to work. Dlookup isnt going...

almost there Hi Ted Have been trying to work on the on the first option (i have changed the layout of the table to try and simplify it a bit). Playing with the criteria above i have it running nearly as it should except it is still producing an error linked to the syntax. it will bring up a...

Ted Many thanks for the reply. If ive got this right the "[TotalDispensed]" relates to the field on the table i want to look up, the "RxHistory" is the name of the table and the "[PxPracNo] is the field on the query that im using as my criteria. However im slightly unsure of what the second...

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

sory, was working on theory initially. code im using is : DoCmd.OpenForm "FrmJobInfo", acFormDS, , Me.JERef = [Forms]![FrmFactorScores]![JERef], acFormEdit, acWindowNormal I have tried using the " " around parts based on other examples, but get an error message each time...

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

Sorry didnt make things clear. Start over (renamed the items), hope this explains better. I currently have 1 form working working off a query (QryMainForm). on the query i have a number of records for each service unit. i have a combo box (SuName) which i currently use to filter the form based...

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