Recent content by hbtousa

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...

Re: Elapsed time. I am stuck This is how far I am, but got message: "Compile error:Loop without do".Please help/ThanksPrivate Sub Command7_Click()On Error GoTo Err_Command7_ClickDim rs As New ADODB.RecordsetDim record01 As VariantDim record02 As VariantDim name01 As StringDim name02 As...

1AARO 7:37:09 1AARO 7:37:09 1AARO 7:37:09 1AARO 8:51:401AARO 8:51:40 1AARO 8:51:40As you can see there is gap between 7:37:09 and 8:51:40 which is the elapsed time that I would like to find out. The table has only 2 fields and.All records are sorted.It is not wat to add o delete...

I would create a temp table and run for append queries. The 1st query will have project1 and project1 hours, 2nd query will have project2 and project 2 hours....I will have a small table with all records from the same project. Thanks

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...

I cannot open it. Thanks

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.

I got it and I want to share it. Instead of using the add button record I used the duplicate record button. Works awsome. Thanks four your answers. I will try the adddate part. I think I should not have a problem with it. This is the code . Thanks Private Sub Command43_Click() On Error GoTo...

I didn't acomplish to much with the debugging. Dont know how to use it properly .Still the same result. What could be the cause of not doing the multiple recording with the loop. Thanks

I don't know how to "debugg". I have and add record button and a save record button. Both buttons are working since I am able to add the record and save it, but is ignoring my loop and my variable that allows me to contol how many records I want to duplicate Thanks

Thanks for your answer. I tried this but is only saving one single record instead of the number of records determined by the numeric variable. I am not using the dateadd part yet, since my single loop is not giving me result I am looking for. What I am missing?.Big Thanks.This is the code...

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.