Search results for query: *

Ok heres a good one. I'ts probably just me being blond I'm sur there is a simple answer. I have a table with an alphanumeric field that I need to sort.The field is formated as text. There can be between one and six numbers leading the data. There can also be zero to three letters trailing the...

We use an account number that consists of 3 different elements. 1)A four leter code that indicates the type of account (these are finite and so are listed in their own table) 2)A 3 digit number (has leading zero's) 3)A text code that is used as a booking code (this is a code generated from the...

I have a wierd problem I think the route of the problem is in the design of a lookup query but I am unsure. I have a tbl (Table1) that has a number of lookups to other tables. The lookup that appears to be causing the prob. is a lookup to a tbl called "tbleHomeAddress" I split...

I would like to pasword protect certain controls in my Access db, namley a text control box and a tabsheet control. The textbox needs to have it's value visable at all times but only certain users able to change it's contents. The tabsheet control needs to only be visable on the entry of a...

I have a subform displayed in datasheet view. By default it displays records in assending order. How do I change this so that I get the latest record at the top of the list? I've tried using the 'Order By' property but I can't seem to get it to work. Any ideas? Pete

I have a subform runing from a table linked to the main form by a customer ID field. This subform is also linked to a query. The subform displays orders that are related to the customer ID on the main form. This works well. However I cannot enter a new record onto the subform. I used to be...

Anyone know how to change the mouse curser when it travels over a button on a form?

I have a contacts db with 2 address tables and a table that lists towns& counties in it. HomeAddress (tbl) related to Contacts (tbl) BusAddress (tbl) related to Contacts (tbl) TownCounty (tbl) related to HomeAddress & BusAddress All the information for these three tables is displayed on a...

Hi I have a subform called orders that is displayed within a form called clients. The subform is displaying in data sheet view. How do I get the subform to sort so that it displays the latest entry at the top of the list insted of the botrom? I have tried using the 'order by' property in the...

Hi Can anyone tell me how to fix the display size and position of a form on screen without making the for Modal?

Hi everyone congrats on a great group -- most questions just answered in FAQ's or by watching and searching posts. Anybody know a way of snatching the caller id string produced by a modem? I wan't to use this to popup a clients record, in edit mode, when the phone rings or if no record, to...