Recent content by crisis2007

Thanks for pointing out my problem. I did change to a form to input the parameters and it works just fine now. Thanks!!!

I have searched around and have had no luck so far. Basically I created a chart using the same query as the main report. I have then inserted the chart as a subreport into the main report. I had hoped that the parameters "Between (StartDate) and (EndDate)" would take care of the query so that...

Looks like i might just change my method and place a filter on the list box to achieve what I want to do. The whole idea was to identify the dates closest to today easily from a long list of dates.

Thanks for lending your assistance MajP. I should have explained even further that there is an AfterUpdate event on the listbox that open a form pertaining to the date selected. So when I use the code you provided it opens the form and locks up. I just want the row in the list highlighted if it...

Ok I will give it a shot here - The Column Fields are: C_ActivityID (Bound Column) C_ActivityDate C_ActivityPrecinct C_ActivityTeam So 4 Columns Column widths: 0";0.9403";0";0.2" Row Source: SELECT T_C.C_ActivityID, T_C.C_ActivityDate, T_C.C_ActivityPrecinct, T_C.C_ActivityTeam FROM T_C...

Thanks for your help. It's a little complicated to explain but the column showing the dates is not the bound column. There is a unique ID column that is hidden in the listbox. I imagine that is why this is not working.

And I should have clarified, there will always be at least three values with the same dates. They will have different shift numbers on each of those same dates.

That is what I tried. Here is the code I use: Private Sub Form_Open(Cancel As Integer) Me.List0.Requery Me.List0 = Date End Sub The requery is necessary as new data fills the listbox when a new schedule is created. I am not sure if it is because of the requery or if it is due to the duplicated...

I have no idea if this is even possible: I have a listbox on a form. This listbox is populated with dates in the first column and shift numbers in the second such as below: 12/01/2012 1A 12/01/2012 1B 12/01/2012 1C 12/02/2012 1A 12/02/2012 1B 12/02/2012 1C 12/03/2012 1A...

Thank You!! I forgot to enter the column headings into the Column Headings property. That did the trick! Thanks again!!

This is driving me nuts! I cannot find what is wrong here. I have a crosstab query that works fine. I designed a report whose data comes from the same query that works if I have no parameters set to it. But when I put parameters in the query - the query itself works, but when I generate the...

Thanks for the advice lameid. But the computer ended up being changed out as it was getting old anyway. Once it was replaced, the problem went away. I still have no idea what was causing the problem. We did reinstall Office before changing out the old computer but it continued with the same font...

This only happens in Access. And I am still searching for other solutions too.

I am still having this issue despite everything I could think of. I have changed the front end out, changed the font in the corresponding report to Arial, re-installed Office / Access and the report still comes out with this unknown font. I have verified that Times New Roman and Arial fonts are...

Thanks for your replies. My code pulls the username from the workstation computer network id which it checks against my table of usernames. I do use their employee numbers as the primary key in my database. I think I probably should have named the field "username" rather than UserID as the...