Search results for query: *

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...

I checked and the font is installed. I went and even changed the font in the report to Arial to see if it made a difference. Still saved with the same, unknown font as before. Not sure what the name of this font is or I would delete it from the workstation to see what it would do. This one has...

I will have to check. I assumed it would as it has the same ms office programs but I would have to look to be certain.

I have a report written with Times font. However when I use the "Save as PDF or XPS" from the tool ribbon, the PDF saves but in some other font. This is happening on only one computer workstation on the network. The other computers maintain the font when saving as a PDF. Any ideas? I cannot find...

Thanks for helping. Here is my code now with your suggestions. However I now receive an error, "Too few parameters. Expected 1." Did I do something wrong? Sub display_menu() Dim db As Database Dim sql As String Dim rst As Recordset Dim valid_user As Integer Set db = CurrentDb sql = "SELECT *...

I would like to have a user id checked. If the user id is in the table, then the user access number is changed to 2. If the user is not in the table, a message box appears stating they are not authorized. However I keep getting an error message stating, "Object doesn't support this property or...