Recent content by spock1971

Hi all. Can't seem to find a similar thread although I'm sure there must be one. I have a macro that runs update queries when exiting the database. What I'd like to do is display a message whilst the updates are running. However, I only seem to halt the macro until the user clicks the ok button...

First idea sounds perfect. Will give it a go. Cheers

Hi all. I have been tasked with replacing an external database in house and obviously the external database has multilpe tables joined by various id fields. I'm assuming when they created the db they were assigned autonumber qualities etc to create unique numbers. However, I can't replicate...

If you right click the text field and chose properties there is an 'On Click' option. Here you can tell access what to do or where to go when the user clicks the text. Hope it helps

Excellent - had decided to try that route and got it working. Good to hear I'm thinking like the experts tho. Cheers again

Ok that's working great. I was originally planning to show the results of the query and the user make a mantal note of the eposno and then enter it manually on the navigation form. However, your checkbox idea sounds a much better prospect. How do I do that then. I tried putting a checkbox...

Thanks all. This appears exactly what I need at first glance. Will put it in and see how it goes. Thanks again.

Thanks for replying Gemma. Yeah I guess we can exit the sub aftre the first dcount but it appears to be doing that anyway. My code now is: Dim stdocname As String If knownno <> "" Then Dim int2 As Integer int2 = DCount("[property]", "property", "[known_as] Like '*" &...

Can anyone help please? I have used dcount to check the number of records for a query. If there is more than one matching record then a window pops up allowing the user to identify the correct record before proceeding. If there is only one record then the front end form opens with the data...

Can anybody help please. I've set up a database and built a query to export records to excel. However, it appears to truncate the export at 150 rows. I've run the query in access and it brings back 170 rows. Ideas? D

Yeah - I've got it on a form currently and the company want a tick and date. So how do I do it on the form? Cheers D

Hi Everyone I need to change a fields properties on a form depending on another fields data. i.e. If a user ticks a Yes/No box saying they've done something they must also complete the date they did it. I can't set the date field in the table to be 'Required' as if ther is no tick then it...

I'm building a macro and part of the macro will be to delete a worksheet. How do I code not to say :'You are about to delete a sheet - proceed' message box. Cheers

Cheers all Never used address before so will give it a go. Think I've got it working with offset too. Using a hidden cell as the count I've got: =sum(a2:offset(a2,0,newvariablecell)

Hi all I'm looking to build a report detailing 12 months figures from opening date. I'm comparing them to budgetted figures. My problem is that the budgetted figures are for a full 12 months so I'm comparing 3 months actuals to 12 months budget. What I'd like to do is tell excel how many...