Search results

I have 2 listboxes which contain records from a table What I would like to do is perform a query based on multi selected values from the 2 listboxes For example ListBox 1 List Box 2 Accepted Monday Declined Tuesday Sumbitted Wednesday So if I multi s :confused...

It could be 4.4 days

After performing a date calculationI keep getting the following format even though I have set the format property & the input mask to short date on the table and the form! 09/08/2004 18:00:00 I think the problem arises as I am sometimes prforming a calculation with a decimal place in such as...

Thanks Thanks Buddy!

In my query grid I have the following expression Like "*" & [Forms]![frmLogEntry]![Combo442] & [Forms]![frmLogEntry]![Text75] & [Forms]![frmLogEntry]![Text77] & [Forms]![frmLogEntry]![Text78] & [Forms]![frmLogEntry]![Text79] & [Forms]![frmLogEntry]![Text80] & [Forms]![frmLogEntry]![Text81] &...

Could someone please help me and tell me why this wont work! Private Sub Command973_Click() If Forms!frmLogEntry!Text71 Is Null Then Forms!frmLogEntry!Text71 = Me.Text535 Else End If End Sub Thanks v much!

No it's the data, sorry Toon Army!

I have a table that contains customer records, in that table there could be say 100 records, of many could have a value that is repeated For Example 25 = Red 25 = Blue 10 = Green 40 = Yellow I dont know if I'm been thick here or waht, but what I would like to do is design a query that...

Thanks Thanks 4 the solution - it got us going in the right direction!

We have a mathematical eqaution that needs to be converted into a query. Basically there are 4 parts to the eqaution which are based on a personal loan / hp agreement Balance (B) - ie the amount borrowed Term (N) - the number of months the loan is over Annual Rate (F) - the cost per...

Thanks mate, works a treat HNY Again!!!!

Im sure the answer to this is dead simple, but I cant seem to engage my brain at the moment. What I want to do is open up a form and show only records that match today. Here is the code I have attemted to use, but I think it's wrong! Dim stDocName As String Dim stLinkCriteria As String...

Having a real problem today, cant seem to get my reports to print on the network printer!!! 1. When i try to view the report in design view, I get the following error message "There was a problem retrieving printer information for this object,The object may have been sent to a printer that is...

Can I have just one more....then I'll leave u in peace!! TrueBR: [BaseRate]+[SchUplift]+[5yrUplift] If 5yr uplift is <49 then 5yr uplift is zero? I'll swot up on this function, just had a long day and the brain is about to explode!!! Thanks Andy

Sorry to be a pain in the ass! Can you help me with this one? 5yrComm: ([Advance]*((([Rate]-[TrueBR])*[DIC])/100)*([5yrTerm]/12))/100 I would like to set this to zero if Check56 is False! Thanks Again Mate

Thanks mate! This will be a very useful function to me!!!

In the design grid of my query I have a calculation that possibly could return a minus figure. What I would like to do is set a condition that would automatically return the value as zero, should the result be negative. I know I can do this in code, but need to do it on the design grid of the...

I have a form which has 2 subforms planted on it. When I change a record on the main form, it should kick in an update on the subform, but doesnt. The subform and the main form are not linked in any way as the control that triggers the update is unbound Any suggestions please?

In Code I am opennin a report by using the I]DoCmd.Openform "rptName", acPreview[/I] command, but just wonered if I could automatically reverse the action and close it as well without having to click the close button Regards Andy

Here is my problem: I have a date field (eg 01/10/1999) I can calculate the number of days from today i.e "=Date()-Date Field" result = 1889 days I can work out how many years ago that was i.e 1889 /365.25 = 5.204 i can also work out how many monhs ago that was i.e 1889 / 30.25 =62.446 but...