Recent content by fatbloater

Thanks for the help - worked a treat.

Hoping someone can help, i have a table named TXNS. It has 3 fields; they are ID, Date_of_TXN and qty_on_txn. There are records from 5 years in the table, example of data held: ID | Date_of_TXN | qty_on_txn 1 | 01/04/09 | 20 2 | 10/04/09 | 3 3 | 20/04/09 | 100 I want a query to sort them...

any luck with this post?

I expect it to be hours, would be great if you could help.

I want to send web url commands. I have been told that the INET control would best suit my needs but have now idea what or how this works, anyone help?

Still no joy, got it all working aprat from the code i need to look at the start time and the finish time and work out how much is off peak and how much is on peak - someone must have an insight, i have started to go grey!

was extremly close

Can ANYBODY help? I am getting desperate, can anybody help me with this problem?????

I have uploaded it again - glad you like pool tables!

in the query criteria put =null

Attached is a copy of a database in the making, had to start again due to new requirements! On pressing stop i need vb code to look at start_time and finish_time and work out the on_peak and off_peak duration (using tbl_tables), that will let me work out the cost. Was thinking about doing if...

i have the following code on a button if isdate(start_date) = false then start_date = now else end if This is looking at start date and if it is null entering the date and time (now) else leae what is in there. The problem i have is if the user keeps pressing the button then a new date and...

The activex didnt use the web, it just sent the commands to a serial port that used an x10 modem (a modem that uses your home wiring as the medium) because this is unreliable i will be using software that is web based - its a real pain in the neck situation!

I have some software that sends commands via the web (i press a button online and this in turns uses a web address to send a command, e.g. www.something.com/on and www.something.com/off) I want to incorporate this function in Access, i need a button that will send these commands with the...

Sort in the before update? I will have alook at the PDF file - cheers.