Recent content by Cavman

Hi, thanks for replying! So, I'm not quite sure if I'm following your line of thinking. Which part on my graphic would be in the continuous form, and which part would the textboxes be? Thanks, Simon

Morning! I'm really hoping someone can help! I'm trying to achieve the effect of having 2 nested continuous subforms (see the graphic) which doesn't seem to be possible currently. I need the form to cascade down by date and then by each Temp name on that date. Can anyone suggest how I can...

Is there an easy way to fit the main window to the same size as my report?

The ribbon isn't the problem - it's the huge expanse of empty main window that sits behind my nice neat report and hides all the other software our HR admin guys need to use at the same time! I guess I'm just going to have to open the main window at the end before I open the report. Very...

Hi, I'm working on a database that produces employee contracts. To make it look as professional as possible I hide the Access main window when the splash screen loads using the ShowWindow function. The various forms to check and enter details all pop up without any problem, but when I get to...

Yes, all the variables are initialised. IDSelector is a function that creates a combo box to retrieve the correct ID from the user if there's more than one. I've just tried using Me.Requery and that seems to work ok without upsetting anything...

I tried using a Me.Repaint instead of Me.Refresh, but that causes the quitting problem again. It has to be some kind of bug within Access, surely? It's really frustrating to get stuck on something so simple when I have a whole load much more complex work to complete on the database!!

I tried that for you BlueIshDan, doesn't change anything. Problem I have now is that when the button is disabled and the caption changed to 'please wait...', that doesn't actually display until after the queries have run. That's why I needed the Me.Refresh in there!

Right, I think I've fixed it. But still not sure why! Sorry about the nondescript textbox names - I didn't build the original database, I've inherited it - you wouldn't find any Text4's if I'd built it! lol. I did try a DoEvents right where you suggested, but it didn't work. What I've just...

Ok - if I step through, it all works perfectly. If I shift-open the database and manually run the form, it works perfectly. If I run the database and it opens the form itself, it doesn't work.

CJ_London - lol - the second thing you said. If no message box is displayed then the database quits. If I add a messagebox in, or a messagebox is displayed by the piece of code, everything then runs fine!

Ok, so I've imported everything into a new database, decompiled it, compacted and repaired it and relinked all the tables from the back end. Still no joy :(

Hi CJ_London, No, that piece of code is there permanently. It checks to make sure the user has entered a reference code before proceeding. What I'm saying is, if the user doesn't enter a code, that piece of code displays the message, and then exits the click routine. If the user then enters a...

I'll try moving everything into a new database. I'm using Access 2010. Is there an easy way to import everything at once, or do I need to import everything individually?

Scripthold is a simple timer routine to slow down the code and allow the form to update. If I remove the Scripthold line it doesn't make any difference. Here's the code: Private Sub ScriptHold(PauseTime) Dim Start Start = Timer Do While Timer < Start + PauseTime DoEvents Loop End Sub It's...