Recent content by mohebk

There was an extra perent in there but i removed it and it worked fine. Thanks as always Mo

Hi, I am writing a query and trying to convert the date to print the 3 letters month and the 4 digit year. This is the column code Entered Month: Format(Month([Suggestions].[date_entered]),"MMM") & " " & Year([Suggestions].[Date_Entered]) It does print but a different month altogether not...

Hi, I am moving a simple batch file with a few FTP commands to copy a test file from a Unix box to a mapped drive on the Win 2K PC. It was working on the WIN XP PC that I developed the script on. But now I am getting an error on the WIN 2K PC that says: Log in incorrect, invalid command. Do I...

Thank you both. I did that and got rid of the compiling error. But I have this function triggered by a command button on a form. It seems to run with out errors but it does not process the data. It opens the code window and nothing happens. But if I step through the code it works fine. Not...

I should add that I placed a couple breaks and it does not look like the rst is getting loaded with data. Mo

Hi, This is the entire function code: Thanks Function HerniaRepair() Dim sqlStr As String Dim rst As DAO.Recordset Dim sqlInsert As String Dim lName As String Dim lMrn As String Dim lInvNum As String Dim lCpt As String Dim lCpt54640 As Boolean Dim...

Hi, Using MS Access 2003 I have some functions that I created in module long time a go. I am getting a compile error on all of them on the loop line. The error said "Compile Error: Loop without do". They were working at some point. I think I am missing a reference library or something...

The second post was the perfect approach. Thanks a lot for your help. Mo

This is exactly what I was looking for. The only thing left is actually an answer to your question, if both are null or zero I would like the result be 0%. Where can insert that. Thanks Mo

Hi, Using MS Access 2003. I have a formula in a field that looks like this: =([Curr_Vis_Out]-[Prev_Vis_Out])/[Prev_Vis_Out] to get the percent of a change between two periods. I am getting a 0 if either fields is a zero value. How can I program this to accommodate when the zero is in the...

dhookom was right. I changed the data type in the table and it worked great. Thanks Mo

Hi, It is a bound text box and I am using the standard text box properties to format. I was able to do it for many other fields on the report, but not able to for this specific field. I did try #,### and it did not work. Thanks Mo Mo

Hi, I have a field on the report that holds numeric values. I formatted it to show standard numbers with 0 decimals. But it is not showing the thousands separator. When I go try to change the format property, the drop down does not show any options now. Not sure what changed it and how to...

Oh, I get it. Thanks a lot. Mo

Hi, I am getting an error that says "Enter Parameter value" Count. I am not sure what is the count for. Thanks Mo