Search results

A quick question about DCount I have a table with field [Location], it contains data from a larger databases of where a job occured. I would like to make a count of the number of jobs in certain locations but the location format can change sometimes. Is there a way to specify a criteria...

Not sure if the IIF would work as Team 1,2 or 3 can be returned - the DLookup should work I'm assuming I've missed somthing in the formatting of the expression or something

I am attempting to update the field [Team] in tbldata using the [Team] field in tblteam. I have added the following expression into the Update To section in the query builder DLookUp("[Team]","tblteam","[Date]=[Date] And [Shift]=[Shift]") Basically tblteam has a [Date], [Shift] and [Team]...

Excellent. Thanks for that

Two stored fields and one calculated unbound text box. When I find the difference between working times like this: ([FinishTime] - [StartTime]) *24 , I should get a decimalised answer but where the answer is say 1.5hrs it only displays 1 in the unbound box How can I get it to acknowledge...

Thanks for your help

Hi Quick question. I have a form with field [Remaining] which contains the hh:mm:ss of time staff are owed in it. I want to populate two other fields from this one on a form. 1) [RemainingShift] needs to be the hours remaining as full shifts which are 7hrs56mins long 2) [RemainingCost] needs...

Me.TotalSamppe = IIf([TotalRecppe] < 1, "0", ([TotalCompppe] / [TotalRecppe]) * 100) I have used this live in some vb code for a while, not sure why but now its causing and overflow - can anyone tell me why this might be?? Thanks for any help

Tried recording - will do the Save As - what can I changei n the vba so it prompts the user for a filename rather than just saving

Would the record method work for things like Save As, I couldn't seem to get it to email either Any Ideas?

I usually use Access and can send object easily enough with vba but Excel I'm not sure about I want to write a macro for a command button on an excel sheet which needs to: Prompt user to Save As - if this can be done Email the sheet to a predefined email address CC the Staff Member who's...

Thanks Again!

Apologies should have mentioned there are multiple criteria as below, adding the or just bypasses the other criteria - what can i do? Me.CH = DCount("ResponseID", "tblResponses", "[StaffID]=[TOID] And [CheckPeriod]= [CheckPeriod] And [QuestionCategoryID]= 1 And [QuestionResponse]= 'Yes' or...

Many thanks thats sorted it

Hi Quick one in a DCount criteria expression I want to count one field if it contains a Yes or No answer - its a text field not a Yes/No I was trying [QuestionResponse] = 'Yes' or 'No'") Any help on what I'm doing wrong

I'm assuming that [DeliveryID] is the primary key in each table, in tblDescription create a primary key such as [DescriptionID] then create the relationship between the two [DeliveryID] fields. If you just use the command button wizard to create a button to open the popup based in the...

Hi I've seen a number of threads asking this type of question before and as far as I am aware it is generally a no no to make a field in a table dependent on another field in that table. If you have [HospitalID] as one of a set number of hospitals and the [PatientID] as a unique Autonumber...

Hi You could try changing your subform from Datasheet to Continuous Forms in the Form Properties box. Then I assume your report is working from a query, if this is the case simply add a command button in design view to the subform and use the wizard to select Print Report. Thne just click...

Hi Seems you have two options As you say you could setup a new table with a realtionship with tbl1 i.e. [CustomerID], then get the popup to open on exit, filtering by that field. Or a quick possibly not so good way would be to have your on exit event open the popup as does now then close...

I am using the following DCount which works fine until I add the last bit [QuestionCategoryID] = '1' this throws up a Data Mismatch - [QuestionCategoryID] is a Number field Me.CH = DCount("ResponseID", "tblResponses", "[StaffID]=[TOID] And [CheckPeriod]= [CheckPeriod] And [QuestionResponse]=...