Search results

nevermind...i found it on the server here at work BURIED in a bunch of dataaaaaaaaaaaaaaaaaaaaaa....woo hooo...

I'm looking for a URL to direct a customer to download the Snapshot Viewer...i checked past posts and they all directed me to the microsoft site...which doesn't have it as a download anymore...if anyone knows a place to get this it would be greatly appreciated Thanks!!!

Hi there...i am having trouble comparing time values in a query...the values are given from different subforms ... i am trying to make an "assigning" function form for referees...so i need to make sure that only referees that are available for a particular game appear on my selection form....i...

Thanks for the help but I ended up putting an additional field in my query to look like this: SortOrder: IIf([Release_Status]="R",1,IIf([Release_Status]="Y",2,3)) and set SortOrder as my grouping field with the [Status] field contained in it....Thanks for all the help!!!

hi there... i am formulating a report that needs to sorted based on each record's "Status"... the status can be either "R", "Y", or "G"...i have "Status" as a grouping category, but the problem is that I need it to go R, Y, then G...which is not in any alphabetical order...is there a way with...

Thanks for the help everyone! i did what pat posted and that worked great!!! Thanks again!

I am supposed to make a report based on a query that lists all records found between two dates...here is the problem though...one value is supposed to be inputted by the user (this date is the week ending date) the second date is supposed to be the first day of the week.... I need to know if...

Thanks Rich...that worked like a charm!!!

Hi All, I have a form with two subforms on it....when the main form activates I would like a command button that "adds a record" to execute automatically... the name of my main form is: frmmainfrm the name of my subform is: frmreleasesubform the name of my command button is: cmdaddrecord is...

i have a related question maybe someone could help out on...this is my first time working with subforms...i have one main form containing two subforms on it.... the main form is called: frmmainfrm one subform is called: frmreleasesubform I am using Access '97 and do not know the syntax to...

aaaa i get it now....thanks Travis!!!

Thanks Travis, but my question was a little bit understood (or I was too vague)...I want to create a Public Sub Routine that performs only the checking of controls for Null Values, there are several different Command Buttons that would call this function....I am checking to see if there is a...

Hey there...I have a form with several command buttons to perform various record functions...i am trying to structure a Public Sub Routine that checks the form's controls for null values and exits the command button's routine if there are any null values....I'm just wondering if this is possible...

I can get the values into the second form using the DLookUp function...but when this is done....the values overwrite data in the table "tblProjectList"...i need to have the information displayed, without overwriting existing data in the table...i cannot get just the one record that i am...

Hi there...I need to produce an application that allows users to enter in a project number on one form, then click a button to bring up a second, different form that contains additional information corresponding with the project number entered on the first form...they are both based on the same...

Hey nonrev...this is my first time replying to someone to try and help them so i might not be good at it...also, i'm a beginner at access so i would imagine my method is not too practical...but may get the job done....here we go... I'm not sure what an update query is, but you could run a query...

Hey nonrev...this is my first time replying to someone to try and help them so i might not be good at it...also, i'm a beginner at access so i would imagine my method is not too practical...but may get the job done....here we go... I'm not sure what an update query is, but you could run a query...

they are all good but i think lighter_triangle by Audrey goes best with the forum's colors n stuff...

o ok i gotcha...thanks everyone i figured it out!!! ;alfjds;lj

ok i'm a little confused as to what the count(*) does...does that count the number of total entries...or is it specific to count just each category separately?