Search results for query: *

Hello I have a command button on a form that runs an append query and then an update query in Access 2007. The update query works no problem. However, the Append Query does not work. Here is the code that I am using. Anyone have any ideas to make it work? Append Query (this one results in...

Hello Here's my code. Unfortunately, when the checkbox is clicked the code works, however, when I uncheck it, the code still tries to email the report rather than just show the report. Basically, the code is ignoring the fact that the checkbox's status is changed back to being unchecked. any...

Hello I have a column in excel 2003 that displays date and time such as 22.08.2008 00:25:00 (dd.mm.yyyy hh:mm:ss) I need it to convert to this format though (dd mmm yyyy hh:mm:ss) e.g 22 Aug 2008 00:25:00 I would like to create a macro to do this so that we can recreate this automatically or...

Hello I have a column in excel 2003 that displays date and time such as 22.08.2008 00:25:00 (dd.mm.yyyy hh:mm:ss) I need it to convert to this format though (dd mmm yyyy hh:mm:ss) e.g 22 Aug 2008 00:25:00 I would like to create a macro to do this so that we can recreate this automatically or...

Hello We are using an if... then statement, however, it brings back a circular reference. Anyone know how to require a field in a calculation? I want field h9 to be required and the value 0 or less is not allowed. Therefore, I want field i9 to be calculated with the value of the field h9...

Greetings I have a search that is just not working the way it should. Textbox with an option group and a command button on a form. It works great for "All" and "the exact phrase" options but includes records that do not meet the criteria for "Any" option. Basically when I enter in a couple...

Tried the calendar as in Pop-Up date retrieval calendar faq702-639. However, some users are having trouble with it. These calendars are still displaying the wrong correlation between day and date – June 6, 2007 is showing it to be a Thu when in reality it’s a Wed. – Also, all months are...

Hello I have a complicated search that is not returning the correct records that I would like. #1 I have an unbound textbox [txtSearchFor] that checks many fields to see if the data is in there. There is an option group [fraUsing] here as well that determines the combination of the words...

I have a list box in a subform that when selected, should enable or disable some of the other fields on the form. However, with the code as below, it does not work at all. Any suggestions would be greatly appreciated. (Access version 2002-2003) Thank you Private Sub ListTypes_AfterUpdate()...

Hello myh code works great with access 2000 however when it is in 2003, it does not work. Any suggestions would be greatly appreciated. Thank you Private Sub cmdEmailEmplSum_Click() On Error GoTo Err_cmdEmailEmplSum_Click Dim stDocName As String, emailTo As String, emailCC As String...

Hello I have a report that works great with the exception that when it prints, it is missing the calculated fields for the date ranges. These are on the print preview but not on the print out. The criteria for the report are chosen from two text boxes for the date ranges on a form and then...

Hello I have a Main form (frmApplicantCostsCombo) that I would like to autopopulate a subform (sfrmPayment)based on fields from the Main Form. It is working except that it only puts out one record. I would like it to put in as many records as there are stated in the Disburse field (that says...

Hello Here is my code, I want it to link to the form and fill in automatically for the ApplID if it does not exist already in the second form - frmApplicantCostsCombo Any suggestions would be greatly appreciated. Thank you! Private Sub cmdAppCosts_Click() On Error GoTo Err_cmdAppCosts_Click...

My query works fine in SQL however it does not work in a report. Here is the code: SELECT [DCR Incidents].IncidNumber, Employee.EMPNO, Employee.NAME, Employee.OCCUPATION, Employee.STARTDATE, [DCR Incidents].* FROM Employee INNER JOIN [DCR Incidents] ON Employee.EMPNO = [DCR Incidents].Empno...

My query works fine in SQL however it does not work in a report. Here is the code: SELECT [DCR Incidents].IncidNumber, Employee.EMPNO, Employee.NAME, Employee.OCCUPATION, Employee.STARTDATE, [DCR Incidents].* FROM Employee INNER JOIN [DCR Incidents] ON Employee.EMPNO = [DCR Incidents].Empno...

I have a folder (BeforeImport) that has only one .xls file in it at a time. I would like to get the code to work to import this file, then move this file to another folder (AfterImport) and rename it. It did work fine when I put in a specific file name. However, i would like it to work with...

This query is not recognizing the subform record sfrmDCR Incidents]![IncidNumber] although the record is there on the subform. Any suggestions would be appreciated. Thank you! SELECT Employee.EMPNO, [DCR Incidents].IncidNumber, Employee.NAME, Employee.OCCUPATION, Employee.STARTDATE, [DCR...

Hello I am trying to get an append query to work properly. Basically, I am able to import the updated employee data into a table (ImportData). I would then like to have that data added to another table(Employee). There are 336 records in the ImportData table (which is current employees)...

I have two tables and a query that I would like to be on a form. the form has data from the Employee table and links to a subform DCRIncidents with data from the DCRIncidents table. On a separate query, I have an Age field calculate according to the Incident Date that is on the DCRIncidents...

I have the title in the code for the website but for some reason it is not working. I do have it set up as a frames site. Even on the frame page, the title does not display. Any suggestions would be greatly appreciated. Thanks