Search results for query: *

Thanks for your reply. They are all in general format, for some reason now when i erase teh cell values and type the EXACT same thing again it work.....Excel confuses me sometimes.... thanks for all your help!

Thanks for your reply. It's unchecked, the problem must be something else. Any ideas what the problem may be, perhaps the 2 parents cells must have the same formatting?

Hello, I am using a Concatenate function =Concatenate(E9,H9) However, in the cell it displays just that without the value. When i open a blank spreadsheet and do it, it works fine but for some reason on my working sheet it shows the formula. Any ideas what the problem is? Thanks!

Hello, This is probably an easy question but I'm new to this stuff. I have both Lotus Notes and Outlook Express installed on my computer system, and whenever I send an email using lotus notes, the receiver always gets the address that has been installed with Outlook as the sender, not the one...

Thanks for your reply Bill!

Hello, I have the following code i am using to change the recordsource of a subform at run time: Dim recordsource Set db = CurrentDb Set recordsource = db.OpenRecordset(??????) Me![employee].Form.recordsource = ?????? I want to use the query named "Employee" as my recordsource, but...

Joey, Doc Thanks very much for your replies!

Hello, I have created a front end that cycles through a bunch of records and updates them automatically. When all records have been updated, i wish to open some results in excel immediately, based on a query. I know i can just use a report, but I have a lot of headings in my query that...

Thanks very much brother, i appreciate your help :)

Hello, I have 2 questions about manipulating text in data fields. I have a field that contains records that are typical of the following: FS32 T NA5204 U ZGT R I wish to eliminate everything from after the first group of letters to the end, in other words i want FS32 NA5204 ZGT And my...

Thanks very much Tony, i think that is a cleaner method, but they both work!

Just came back from lunch and i noticed 8 replies! Thanks very much for your help, I always acknowledge help when i receive it!

Hello, I am using DoCmd.GoToRecord to cycle through a bunch of records automatically. When the program runs and it reaches the end, an error msg pops up and says that there are no more records and asks to debug. I don't want the user to see this message, i want the program to know when it...

Thanks Very much folks! I got it work!

Thanks for your reply. I thought about that, but since the subform is linked to the main form, anytime a record is selected it should automatically update to show the results of the selected record. So just to give you guys an idea what i'm doing, here's an example that illustrates it: On the...

Thanks for your reply. I am now using GoToRecord, it is a lot faster, however the same problem exists. For some reason it continues to update the previous record, its always lagging by 1 i.e even after it goes to the next record, the subform continues to show the information that corresponds...

Hello, I am using the Sendkeys function to cycle through a bunch of records. Using code, as the sendkeys function goes through the list of records, a subform is being updated. The problem is that sendkeys appears to lag, what i mean is that even after it goes to the next record, the subform...

Thanks very much!

Thanks for your reply. I think for some reason regardless of whether or not it is 7Y or 10Y, the length of the string is constant. This means that if i use -1 in the argument, it eliminates the Y from 10Y , but not from 7Y or any other single digit number. For those i would have to use -2...

Hello, I am using a dlookup function to get a string from a table. The problem is that the strings are formatted like this: 7Y or 10Y etc. Basically I want to drop the Y at the end. Is there a quick way of telling VBA to only read until it reaches a non-numeric character? Or am i forced...