Recent content by AmberO

Rob, Thank you so much, this is exactly what I was looking for! Amber

I would like a user to be able to enter a time using three combo boxes - one for hours, one for minutes and one for am\pm. I would also like the time to be displayed on a search using a similar setup, so that the time could be changed by the user. What is the best way to approach this? I have...

Yes, I tried that as well, but then the user has to enter the AM or PM every time - I am trying to get it so that the default is AM and the user can change it if necessary.

I need the users to enter a clock in time. I am trying to get the time to default to AM, but I need the user to be able to change it to PM if necessary. I tried using the input mask 00\:00" AM";0;_ but this does not let the user change the AM to PM. I was thinking I need to use a drop...

Thank you Calvin, This is the second time today that you have really helped me out. Thank you so much! That is just what I was looking for. Amber

Should I take it that it is impossible to change the sort order of a table directly using code then? I know I can do it by clicking on the A-Z button on the toolbar, which is why I thought there must be another way Thanks for the response though!

Thanks for the reply, Actually I am not viewing the table - I am trying to change the sort order of the table from code that is called from a button on an unbound form. I am using access to import data from text files, manipulate it (add columns, change certain fields and sort orders) and...

Is it possible to sort a table by a particular field using vb code? I tried using order by, but can't get the syntax correct. (I know I can use a query, but I need to sort the actual table). Thank you! Amber

Thank you Thank you Thank you Thank you Thank you !!! NB - I did have the DAO reference, and setting it to a higher priority allowed the code to run. Just thought I would add that, in case it helps someone else. Thank you Calvin, the code does exactly what I wanted!

Thanks Calvin! When I run this, I get an error "Method or data member not found" and the rst.edit is highlighted. I should probably have said that I am using Access 2000 - does this make a difference? I tried changing it to rst.editmode, which is an option on the drop down, but then it...

I need help writing a loop. I want to go through the first 12 records in a table and mark them 1,2,3 ... 12, then do the same for the next 12 records until I have marked all records with a number. This way I am hoping I can print the records by number in a somewhat randomised manner, yet can...

That's inspired! Thank you!

Is there a way in the before update event to prevent the after update event from running on a combo box? Records are brought up on my form by the user keying into a combo box. They should not be able to exit a record (by selecting another in the combo box) unless certain criteria is met. I...

Thank you very much!!

My database may have many payments for a client. Each payment record has a code to show whether it is valid or not. Each payment record also has a payment date. Is there a way to only look at the valid payments (code = O) and then mark then as payment 1 of 3, 2 of 3 and 3 of 3, depending on...