Search results

I am using a linked table and have created a create new record button but discovered that the linked table has an important secondary reference number field(userid) similar to the primary key(id) but isn't the primary. The userid field is sequential to the last record but gaps appear where...

works works a treat, thanks

anybody know of a good site with access databases for download, specifically for employee hour tracking?

Found some code but error occurs I found some code that does it except I get an error. Worth noting that I can handle very basic code but thats it. code is: Private Sub TxtEmail_BeforeUpdate(Cancel As Integer) 'create a variable in memory Dim MyString As String 'fill the variable with data...

thanks thanks I'll try that.

How can I calulate an age for a loaded form (with DOB in form) without using a query. I can do it with this: Year(Now( ))-Year([DoB]) in a query but get no where when trying to caculate it on the form. Ideas anybody?

Can anybody tell me how to write a validation rule for an email field ensuring the @ symbol is included? thanks

have managed that but... Have worked out how to do that but if I need to see all the "smiths" for example and then select the correct one how can I display this in another form or subform? In other words.. I get 30 smiths and need to select one of them called John. results should look like...

I have read lots of search related messages but haven't found how to do this.. I want to search on surname, and have all the relevant surnames show with the first names so 1 record can be selected. I can find plenty of ways to find the first surname records but not then the first name. Each...