Search results

I currently have an unnormalized table that consists of individuals (employee profiles) which currently has a field for attachments. I am using the "attachments" for photographs of each employee however I dont want to maintain photographs for former employees, or if I do not forever. I was told...

Thank you everyone for the help, its much appreciated. I used the Date() in my start and end date and it gives the data I am looking for. I would however like to take this one step further and make any data whos end time has passed, it also goes away. For example: Start Time: 02/21/2013...

Thank you John. So far this is all "study" material followed by trial and error and then trying to diagnose why it does what it does. How would i implement it further that if the no button is pushed it opens a new window indicating "process Canceled". Here is what I was thinking but it...

I am trying to learn some aspects of vba and based on reading some things and pure trial and error, I dont think i'm getting very far. I'm really jumping the gun as i have a class next month. In any case, can anyone help me out with this. The intention for this is when i click a button on a...

In my data table, i have a "time" field whos format is "short time" (Military format). The primary user of the database is not all too avid with military conversion, I know its an easy conversion but; well i'll leave it at that. Because we are a 24 hour facility I want to keep the time in...

Just noticed the additional replies since I last checked. I noticed the reply from BrianWarnock as I was dozing off last night so I applied the Date() criteria to "enddate" today and it does exactly what I am looking for. Thank you gentlemen for the outside insite as I have no clue as to how I...

What I am looking for is all data associated to today and any data that started yesterday and continues past midnight. For example if a job started tonight at 9pm and runs through tomorrow at 7am, it shows on the new date since it went past midnight.

I have a query that reports jobs occuring today, which is working awesome so far. I'd like to expand on my current data and also show any jobs that started yesterday that go beyond midnight which are still in effect and end today. Currently I have all the data I want to show with criteria of...

I have a Yes and no check box on a form answering a simple yes or no answer to a question. When i open the form, both check boxes are defaulted with a grey box. What I would like to do is have these boxes clear when I open the form and generate a check mark when I choose one or the other. The...

Perfect, I was overanalyzing it and adding too much. Thank you very much for the help. Much appreciated.

I've attached a copy of the form i am working on to illistrate my issue.

As mentioned above this form is an unbound so everything is set within itself. Where should I put this code. I placed it in the default value of the week number but its throwing an error: Runtime Error 13 "type mismatch"

I have an unbound form that a user will fill in a start date; end date; and "week number" to generate criteria for unrelated queries to run a report. Currently, I have the Start Date as the user entering the desired date and then then "end date" autofilling upon entering 6 days later than the...

Sounds pretty accurate. The data for this report is dependant on the week number which is indicated in a form text box. There is other data on the main form which is also dependant on the text box; however typically always has data in it, if not that equals 0 as its calculating numbers. The data...

Looks like i'm half way there. The query I have has ID, ReportDate, "Week Number" calculated by WeekNumber: Format([ReportDate1],"ww"), and Systems which is the data that I need reported. The week number has a criteria pointing at a text box in another form, how would I introduce the Dcount...

I am building a report which contains a subreport, the subreport may not always contain data in which case it just doesnt show up createing a huge gap in my "real report". What I was wondering, is there a way to make "Null" returns report "nothing to report" if that is the case. If data does...

I tried to "Thank" you on your last post; however for some reason it would not work, kept forwarding me to a secondary page indicating I could not do what I wa trying to do because I wasnt logged in. In any case, I am in fact logged in and would like to thank you for the reccomendation. What you...

I am trying to build a report that will be generated weekly showing data of cases over a specific week number (User will type in week number in a form). What I am trying to do is create a query that I can place on the top of the report showing the physical start and ending day of the week the...

Mr. Warnock, The intention was not to double post as you presume to be the case. The initial thread was referencing a criteria string I was using in attempt to get data over a period of three years. Current year and last year was working fine, when attempting to get the second year back, it...

I think you are right. What I was trying to do was get my report without having to create so many queries to put together all the data required to implement the report. In Some cases, i've got almost 12 fields in a query which is gather data from other queries as i have to break my data up...