Recent content by Spott

Fantastic!! B-) Both codes work beautifully!!

You guys are good! That worked. :) New issue, if I run the update query again, another 0 is added. I'll be importing data to this table every two weeks. Is there a way to do that within this query? Only update the new <9999 data? My other thought is create a table for the new data, update...

In SQL it looks like this: UPDATE [DLH REPORT] SET [DLH REPORT].[FILE#] = "0" & [FILE#] WHERE ((([DLH REPORT].[FILE#])<="9999")); Still pulling all records. Ugg! Changed to: UPDATE [DLH REPORT] SET [DLH REPORT].[FILE#] = "0" & [FILE#] WHERE Val((([DLH REPORT].[FILE#])<="9999")); Still the...

Thanks, PH. It helped somewhat. It didn't do anything until I changed the field from number to text. Then it added a zero to all of the numbers including the 5 digit ones. I had criteria <=9999 and update to "0" & [field] Now I need to figure how to only pull the 4 digit again. <=9999...

I have a field with 4 digit and 5 digit numbers. I want to filter to only the 4 digit numbers and then do an update query to add a leading zero. I think I have done this before, but none of my search criteria or pattern matching ideas are returning me the 4 digit numbers. Thanks much!

My goodness...if it would have been a snake!! Already found one error, off to copy the formula a lot!!

Hey gang - this could be done in excel or an access query, whatever you think is easier. I've been looking at too many numbers and am now clinically brain dead. In my db I have 4 fields Start time, start date, end time, end date. I need to get the difference of time between end and start. If...

Well - I tried that...it didn't let me edit the existing records, so that's a plus but it wouldn't let me enter anything for a new record either. I inherited this db and a lot of it is coded in vba if that helps. I'm code-clueless...

I have a form that shows trouble reports on equipment. It brings up any existing entries first so people don't enter the same thing twice, they have to scroll through or press a &quot;new&quot; button to start a new entry. Problem: they can type over the existing entries! How can I make...

I think I tried it correctly and my numbers still come up 1111, 2222, 3333 instead of 01111, 02222, 03333... [field1]=Format([field1],&quot;00000&quot;)

I'm working on a form that pulls up training data linked to an employee number (from odbc table) I need to get the name to show up, so we can tell who's sheet we're looking at. If we just drop the name in, it locks the data so it can't be edited. I'm trying a dlookup...

We're updating employee numbers from 4 digits (1234) to five digits and padding the existing numbers with a zero in front (01234) I know there's a simple way to update this, adding the zero in front through a query, but I'm stuck! Help!!

I need to work at it (I'm of the macro clueless) but I think this will do the trick. I somehow got it to work on the wrong table, undid it and killed the macro and couldn't get it to apply to any more tables in the document. I'll look through help and faq's and see if I can figure it out...

I have a report that looks like a table when it pulls the data in. Is there any way to do a graybar on it like I can in excel? I'm stuck with Access97 at work, so need something that would work in that format. Thanks, Spott

Hi, I'm &quot;graybarring&quot; tables in word to make them easier to read online. None of the auto formats do what I want exactly and they don't auto-adjust if I add or delete rows. I just want gray, white, gray, white. I can format this in excel using conditional formatting and formula...