Search results for query: *

How can I sort time records chronologically? Given that a file contains: 10:30a ... 08:30a ... 11:00p ... 09:15a ... 01:30p ... ... how do I make them into the ff. (arranged chronologically)? I've tried the sort -n command, but obviously it just looks at the time itself and...

Thanks for the big help! I really appreciate it! =)

Thank you! I've figured out the date format already. The only thing left is the time. Since the user input input should be in hh:mmX format (ex. 10:30p), how can I cut this up in 3 sections? I have to cut this up since I have to convert the entered time into 24-hour basis (military time)...

Hi pmcmicha! Not really. I'm after the format check of the entered date in the command line. If an error in format it detected, the user is alerted. I've checked the man pages for date but I didn't find anything that seems to answer my problem.

Hi! How can I check the format of an entered date and time in the command line? For example, I want the date format to be dd-mon-yyyy while the time, hh:mmT (with T as either a or p). Is there a command I can use that does these? Thank you!

total number of rows/records

How do I determine the number of rows returned after using an AutoFilter?

Hi! I want to get the value of a specific cell and display it in a textbox (separate from the datagrid). For example, my datagrid has the fields Name, Birthday, and Address. When I click on a particular record/row, I want the textboxes txtName, txtBirthday and txtAddress to get the respective...

I'm not star. =)

the last 10 autonumbers. =) Thanks!! =)

Hi! What sql command can I use in order to get the last 10 records of a table? One of the fields of the table is an AutoNumber. Other fields are dates, version numbers, etc. Thank you in advance! =)

It worked!!! Thanks a lot!!! =)

tom, it's not working. I think there's something wrong with qryMaxDocument. An error keeps popping up saying "You tried to execute a query that does not include the specified expression 'Doctype' as part of an aggregate expression." What do I do? big thanks for you help! =)

I am working on this document library and I want to display only the latest versions of the available document titles. For example, under the Analysis document type, there are the Hardware document title (Analysis_Hardware) and the Software document title (Analysis_Software). These document...

Hi again gransbpa! I manipulated your code a bit and there's no problem with it =). The error seems to be coming from another line of the code(specified below). "Error 2001: You cancelled the previous operation " appears. We are almost there (thanks to you!). Function...

Hi! thanks for the fast reply! I followed your code already but that error still keeps appearing. The frmImmunizationRecord is definitely open as this is where this function is called. I am getting desperate already...what seems to be the defect of my code?

Orion45...I can't figure out why this error keeps popping out when I run my code. It always says that frmImmunizationRecord cannot be "found" by VB. Function decreaseStockOnHand() Dim stock As Integer Dim computedStock As Integer Dim strSQL As String Dim vaccineCode...

I can't figure out why this error keeps popping out when I run my code. It always says that frmImmunizationRecord cannot be "found" by VB. Function decreaseStockOnHand() Dim stock As Integer Dim computedStock As Integer Dim strSQL As String Dim vaccineCode As String...

Thank you Orion45 for the very helpful tip! I'll try this asap and let you know what happens. again, thanks! =)

Sorry, it is me again! =) I am making an inventory database, and this concerns two tables- the tblVaccine (stores info about a Vaccine including its stock on hand) and the tblImmunization (records that contain the patient, vaccine, and date of vaccination). I want to automatically deduct 1...