Search results

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

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?

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

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

I have a combo box that is generated by a query. The query looks at a table that contains date and time values, the problem i am having is with the order that combo box displays this query. i have gone into the row source and told the query to display most recent date first and this works, but...

I have a button, when the user clicks this button i want an 'OK' (only option is OK) message box with a title of Name to pop up that says 'Please enter name'. Then when they press the OK button what they have typed is saved to a text box called 'name'. I would like to make it impossible for them...

Help !!!! New User - Without shutting db down. I have a database that has about 10 users (its static on one pc but they use it at different times), is there a button i can use that a new user can press and will log off the old the user and log on the new user without shutting the db down?

I set up users etc on my database and it was working fine, i then downloaded an example from this forumn and now i am getting the following message, i can not find the .snp file (dunno if that helps but cant find it on my machine). It comes up with my user name but thats it, when i put the...

Is their a way that a user can log off so that someone else can log on WITHOUT ACCESS being shut down? :confused:

What is the easiest way to roundup a currency value to the nearest 10pence? :confused:

I need help with something i think is tricky and would appreciate any input people can give. I am helping my uncle and i cant do what he would like. I have a table that has a peak_time_start, peak_time_finish, peak_price off_peak_start, off_peak_finish and off_peak_price. I also have a form...

I am having a nightmare! I have a main form; on this form i have 10 sub forms. Each of these sub forms has the same fields and a button. I need a module that i can run from this button and will conduct calculations using the fields in the sub form and putting the result into another field on...