Recent content by splats

Thank you PHV and dhookum for your assistance. I was able to rectify the issue. I found that in the table that held the Personnel data, had a couple of fields that has the setting "Allow Zero Length" set to No. As well, I recreated the queries with the following. They both run off a single...

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

Thank you that works great. You made my evening!

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

thank you all I have it working now. y'all rock! tinatab

Hello Thank you for your response, Unfortunately, this did not solve our problem as we still do get the calculation working when the h9 field is left blank. Therefore, we would like the calculation to not work when h9 is 0 or blank. Any ideas? thank you tinatab

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 again Remou I have 25 records that are being recognized that should not be. when I type in "report quality" I get 237 records of which the following 25 are also resulting. I do not know why I am getting these records when I should not be. Any suggestions would be appreciated. I...

Interesting take Remou. I have not thought of that. I will check to see if double spaces are the cause of the problem. How can I remove them from the results? The results include the data and other data that should not be picked up. Perhaps this other data has double spaces thereby creating...

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

We are running all Windows XP Pro workstations and Windows 2003 Server. Could it be that the server is causing this issue?

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 Kjv1611 I do not think that the queries would work as there are several different levels to this search. There is an unbound text box that looks up data in many fields. [txtSearchFor] There are 3 options for the combination of data that is found, All Words, Any Words and Exact Phrase...