Search results

delete Query How do i Specify the table containing the records that I want to delete?

IIF works as long as I dont try to do it from within the same query thank you all for your help

Brain thank you for asking about the field name, Iv done that a fee times here in the middle of the night

the first is, the [selected date ] from a form -[entry date of object field] most come out + but for those who's [entry date] starts later in the month in question thiers comes out as a -

the field name is an alias, I created in the query to create a number from two different dates.

Ok, tried, when running it thinks that the [fieldname] is a parameter and askes me to enter parameter value....

I can not have any negitive numbers show up in my field so I need to round up and negitives to "0"

they are text feilds

Ok, iv droped the reformaing. it is giving me records for only that fall inbetween the months and not the years.... so if I input 01/01/14 and 01/31/15 it gives the all records for the 1st month of 14 and 15.... If I input 2/2/2014 and 10/2/2014 it gives me all the dates between there for 14...

Ok while in the query how should it look? the field name is 'shortdates" With out useing the Left, 10 how should I format it into US FORMAT? thank you

it is stored as a long date but I am Using the "left([Date]),10) and it is in the mm/dd/yyyy

Help! I have a report with an inbeded query. I am running a between [start date] and [finish Date] this worked fine last year but now it only wants to show dates for this year. is there somthing that I am missing?

Re: Force shut down ("kill switch/trigger") Please do tell about the "kill switch/trigger" so that I may build that into furture systems. Thank you

I am in need of updating a table in my system but can not due to a coworker having this data system open on thier pc that is in a locked office. Is there a way I can log them off the back office or force thier access to shut down? Thank you Stan

I wonder what I screwed up, i'll give it another run.... thank you for your help

yes in fact what it is looking for is the tables "AutoNumber" In the form it will be the last one added, but if is null then I need to have it return all Numbers in that field. Does this change things. I was about to give up and just create two reports each with its own Query (I hate creating...

Public Function locateincidentnumber() As String If CurrentProject.AllForms([Forms]![frm-Staff-Client Information Navigation Panel]![frm-Staff-CIR Form]).IsLoaded Then locateincidentnumber = [Forms]![frm-Staff-Client Information Navigation Panel]![frm-Staff-CIR Form].[Form]![Incident...

What I have and what I am trying to do is to build into one Query the ability to show that current record just entered from a form field and it that form is closed to open all records in the table. it is an attempt to use one report that has the query build into it instead of creating two reports.

IIf(CurrentProject.AllForms("frmMyForm").IsLoaded,[Forms]![frmMyForm]![MyCtl],"*") opens up a "enter parameter value" box????

@stan, I think it would prompt for a Enter Parameter Value if the Form is Closed.. So you should consider moving to a User Defined function maybe? The function would test if a Form is opened or closed.. If open return the values, return all.. Sounds interesting, how would that look?