Search results for query: *

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

Hi, I am working with MS Access 2003. I am trying to get a total of a field where the value of another field = to a certain value: For example this is the report: Name, Count, State AAA 5 CA AAB 4 AZ AZA 10 CA ACA 3 CA I am looking to get a sum of the counts...

Hi, My boss asked me to create an access database to manage the inventory of some sample products that we receive from vendors. My challenge is adding to the current inventory and deducting from the stock when something is dispensed. I created the tables and the forms and they look good. But...

I like this solution a lot: In a cell to the right of all the imported data, type 1 (this should be right-aligned, indicating that the cell is formatted as a number) copy that cell select the cells that are giving you trouble* Go to Edit > Paste Special > Multiply Now try applying a new format...

Yes, they are numbers. I put the cursor in the cell and hit F2 to edit and leave out of it and it works. I am not sure whey do I need to edit it to take affect. Mo

Hi (MS Excel 2003). This happens to me once in a while and not sure why. I copy some information in a spreadsheet and try to format the column to a currency format. I hit the $ button from the top but it does not show the $ sign or correct decimal points. I go to format cell and choose...