Search results

Hi I have a main form with 2 linked subforms one showing targets and one in continuous forms view showing results, how can I get the results fields to be highlighted if values above or below values in equivalent target fields? I tried using conditional formatting but it doesnt work. regards John

Hi Searched but cant find the correct answer I have a main form, that contains the product details and two subforms that show targets and results. I have half a dozen different porduct types that have different criteria and rather than try and cram all the criteria on one subform I want to show...

Hi, I have googled but can't find a solution. I have a main form for each product that would like to contain 2 subforms one containing targets for each product and one for results. The Target subform will be fixed targets and the results subform will be for editing/adding results.. FrmMain...

Hi I have an issue two almost identical forms, with an unbound combobox being used to filter a form. The combobox recordsource is a query that pulls document types from the main table I have googled and tried all the suggestions the form is not locked, edits are allowed etc I have tried...

I have created a document database and want to pull a report of all upcoming documents that require review in the next month I have a query that works until I try to filter DocReview field is a number representing how long before review in months 1, 4 6 12 etc VerDate is the date of the latest...

I have a main form with a reference number(DocRef) NOT the record ID I set a command button to open a new form to add to a table linked to the main table but I can't get the Reference to come across I just get a #Name? error and unless I manually enter the DocRef it just creates a blank entry I...

Hi I have a form to display records but I cant get the filters I have set up to work consistently and revert when reset. The Form has a combo dropdown to select a type of record and a tickbox to select All if unchecked and only records marked as Active if checked they are not connected so any...

Hi I, I have a results spreadsheet emailed to me every week 2k rows and I want to be able to add each weeks data to a master sheet/book for analysis. I have searched a lot and found some code to do what I want as long as each sheet has the same format/columns, however occasionally there may be...

Hi I have XP pro sp3 with Office 2003 and the 2007 compatability pack installed, on my old pc this worked fine and .xlsx files would open from email instantly. However same setup on new laptop and if I try to open a xlsx file it will only let me save it as a xls, of course I can then open it...

When using the below query I get a dialog asking for the Retailer followed by a dialog asking for the retailer ref then a second or so pause before it asks again for the Retailer then the ref before finally completeing the query Used to work as expected until I added the wildcard section to...

I want to adapt a query written by another to include a CC to email address, but in the Query designer there are two tables shown that are not in the table listing Contacts_Opened By and Contacts_Assigned To I looked at the sql and tried to copy paste to add an extra one Contacts_CC To but keep...

hi guys tried the free ezy dashboard builder from aadconsulting but it fails to install with an error adding to registry message so 2 questions, 1 how can I fix it and 2 why does an addin have to alter the registry at all?

pcnt: Sum(IIf([GradeID]>=3,1,0))/Count(*)*100 I'm tryting to use this expression to give a precentage of GradeId above 3 for each employee ie Janet has 2 out of 11 to give a percentage of 18% howeve the above gives Janet 100% sql from the query below SELECT tblHandswabs.Surname...

how can I open a new form linked to a different table for data entry by entering a number into a control DispoNumber and using that number inside the new record? I can get the form to open using OnUpdate but not sure how to transfer the number

I use the following to send a .pdf to the required email and it works well, but is it possible to include a boolean yes/no field in the table that holds the data and change it from no to yes in VBA so I know when a record has been emailed? Private Sub SendEmailToAssignedTo_Click()...

I have a report (.jpg attached)some data in a table sorted by a couple of queries and I need to list by month and shift I also need to sort it by year but despite mucho searching I haven't been able to do it, so I would be grateful for any pointers/help here is the record source SELECT...

Hi All, I'm using A2003 and using Lebans excellent code I have managed to get as far as creating a pdf from a report and emailing it, but I am trying to give each one a unique name based on a field in the report This is my current code Dim strFilter As String strDocName = "Issue"...