Search results

When text is being inputted into a Memo Field is there any way that specific text or say.. the time & date, could be assigned to a set of keys such as [Ctrl+D] or a F key. Is this possible?

Thats working a treat for me... thanks

Thanks Pat, I think the global variable is the answer I'm looking for but I don't know if you or anyone else is up for a bit of hand holding, I'm a right novice. Since your suggestions I have searched the Threads and found similar problems but the answers aren't explained at my level. How would...

Having just entered a Suppliers details in a table that has the usual fields, SupplierID [autoNumber] SupplierName [Text] SupplierAddress [Text] etc I now need to enter a Products details in a table, ProductID [autoNumber] ProductName [Text] ProductSupplierID [Number] etc The Supplier of the...

Thanks... works a treat!

I'm using an VB 'Event Procedure' to display a Message Box strMsg = The message is quite long and it displays right across the screen. Is it possible for me to make it display on 3 lines?

Thanks everyone, "Sites" is the underlying Table and OTCustomerID is a Field on the parent Form. The following calculating Field works great and returns a 0(zero) instead of an #Error =DCount("[ContractID]","[Contracts]","[ContractCustomerID] = [OTCustomerID]") Thanks again!

Have tried that John_W but it never enables the button and when there are 1 or more records and I'm getting a 'Run-Time error "2427" You entered an expression that has no value' when there are no records. The expression I'm using is, where CountTotal is a field on my Form that displays the...

It may be easier to help me if I explain what I'm trying to achieve... When my Form activates, I've set a Command Button to be either Enabled = True or Enabled = False depending upon the number of records found in a query on a Subform... 0 records it should be disabled whilst 1 or more records...

Thanks boblarson but that still returns #Error when the query doesn't find any records.

Im using Count([ContractID]) to count the number of records in a query used on a Subform. It works great when the query finds 1 or more records but if there are no records it returns #Error and I need it to return 0(zero)... Any ideas how I can achieve it?

Thanx 4 the idea but I can't open my database to copy any objects into aa new one!

I've been using an Access2000 database I've developed for about 18mths now. Last week I was using it on one of my network PCs, the data is stored on my Main PC, when my network PC crashed. Since then every time I try to open my database, even from my Main PC, I'm getting the error messge...