Search results for query: *

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

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

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

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

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

I have a form that pops up upon opening the application. It detects the username (using environ = ("Username"))and places that value in a text box. A button is clicked and through a look-up the code determines if the username is in a table and if that user name has appropriate access level. If...

I have been struggling with this for over an hour. I am trying to run an update query in vba but continuously receive a message that the syntax is incorrect. I suspect it has to do with the part about the current date. I am just not getting it. Any help is very appreciated! Dim strSQL As...

I have the following code on a button. I cannot figure out why I get a Type Mismatch error message when I try it. Can anyone see what is wrong with what I have here? I am just trying to save a report to PDF in the specified file. Eventually I am going to want it to take textbox values from the...

Hello - Just looking for some help on a little problem. I have a listbox that is populated with dates. When the form containing the listbox is opened, I want the listbox to be defaulted to today's date. I sort of accomplished this by using the following in the Load Event of the form...

I would like to have a query that shows me just the totals of each field for the month. I have the following query: SELECT T_Receiving.ActivityDate, T_Receiving.ActivityTeam, T_Receiving.EmployeeNumber, T_StatNew.StatID, T_StatNew.RosterID, Sum(T_StatNew.Dispatched) AS SumOfDispatched...

I have the following code on a main form command button that is intended to pop-up a second form. This second form is supposed to synchronize using the RosterID as a common field. This second form, based on a different table allows me to enter data. But the code does not seem to populate the...

I have tried several variations but I just can not get this to work. =DLookUp("SpvName","T_Supervisor","Title='Crew Leader' And #" & [Reports]![R_MasterWatch].[txtActivityDate] & "# Between [StartDate]and [EndDate]") My Table (T_Supervisor)is laid out as follows: ID Number...

I have a listbox that contains dates from a table. I have the dates listed in descending order but for some reason, it believes that 01/01/2012 should be listed below 12/31/2011. I have MS Access 2003 if that is needed. Any suggestions?

I have the following code on a command button. I want to check for duplicate values before closing the form. It works fine if there are duplicate values and the message box pops up properly and both the yes and no buttons work. However if there are no duplicate values, the form does not close. I...

I am trying to carry over values from a list box that is on another form. The first column (Bound column) is the RosterNumber and the second column has the date. I have the following code in the OnDirty event of the current form: txtRosterNumber = Forms!F_MainNorth.List88.Value...

I have a query that gives me the values in the T_Attendance table.The query works properly, getting its criteria from text boxes in my input form. I have this code on a command button that is supposed to give a message if I am trying to duplicate a date and a watch number: ------------ Private...

I have an input form that retrieves records from a table called T_Template. This input form is actually a subform on a main form (but not linked). I have the subform deliver the records to another receiving table (T_Event) by running an Append Query. It works fine for moving the records on the...

I am looking for help on a problem I can not solve on my own. I have a form for data entry that opens up in continuous records. I want to populate the first few records on this form with existing records from another form called "template". This template form would hold names of employees and...

I am trying to limit the input in a text box. It is for event numbers that are supposed to be in the following format: 11-12345. I need the hyphen in the number after the first two digits. There can be 1-5 digits after the hyphen. I just can't find exactly what I am looking for.

I have the following code that I have found and adapted on a form. I am trying to pop-up a message box when the DLookup shows that there is already an employee number and date that exist together in the same record. When the user sees the message, I want the user to choose "yes" if he wants to...