Search results

Hello. I am trying to sort every line of a table; the table has 1000+records with data as follows: LA60RH90RW23LE9LS10RE12RA140LH2RS5RK780LW2LK7 Every line has TWO letters and THREE "digits" twelves times. I would like to sort every line in ascending order. For example the end result would be...

I have a tb with 2 fields name and time(timestamp).Daily 140000 records are created, they cannot be modified, deleted,etc. Each person can have over 4000 records, which are sorted by name and time. I am trying to find the daily gaps over 15 min per person if any. Previous postings to this one...

I was reading the posting ( http://www.access-programmers.co.uk/forums/showthread.php?t=136643&highlight=programmatic+message) and one of the replays adivsed: "(1) Advise the user via programmatic message they they must exit the program for maintenance. If they don't get off after a couple...

Hi everyone . Please I need help with this I have a db with 22 records: (A123,B456,C789...Z999) I want to be able to read each record and extract from each one the same data fields and make a big single record out of the reading:A23+B56+C89...Z99 The reason of doing is I want to be able to show...

DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70 What do the parameters mean in the line described above? *Does the sequence "has to be " that way? *What's the meaning of "," Thanks for your answers I am trying to learn the sintax.

Hi. I want to be able to save multiple records sequentially by date for the same person. I have a ssn, a date and number of days field. I imagine I need a loop to get it done. I really don't know how to write the code for this I tried couple things and I ended up with nothing. Thanks for your help.