Search results

Just a quick note to say my employers made me an offer I didn't feel like declining so I'm retiring to become a full time rock star. I'll pop in here from time to time to see how the UK vs US war is going but my Access days are probably over. Thanks to everyone who helped me over the years and...

If we must have a Scot for Prime Minister ;), let's at least have a decent one. Come on Stewart get into politics and we'll vote for you, we might get some action!:D

Originally Posted by Tim Brewer I can walk away from all of you at any given time, and there is nothing you can do about it. Vote now folks:rolleyes:

A good friend of mine found himself in the position of being made redundant by a less than brilliant employer. However there was another job he was encouraged to apply for within the group. Here is his person spec for the application. I am a dynamic figure, often seen scaling walls and...

Aceess 2003 FE/BE One of the admins for my Complaints database is getting a debug error on a form on If Me.RecordsetClone.RecordCount = 0 Then that no-one else gets. I've tested on several pcs on the network with no errors. Any ideas?

Please donate a large bottle of alcoholic spirits (real not imagined) or any spare puff you may have so I can arrange for my next experience. :D

An email is sent on close of my form. We have three shops (CCCs) and I’m trying to eliminate a line of hard code so the email selects the correct shop name depending on the value of field txtShopID. The hard code line below works fine and the email is sent using: strSubject = “New feedback...

Ooops! Should say "FIELD" name! I've been through dozens of posts on this and can't get my head around the solution. Is there a simple way to change the name of a table field?

I have a report which has a different picture for each record. Using 4 different types of command button syntax that I found here I've been able to send the report successfully as an email attachment but the images are blank. I presume this is because the jpgs are stored in a file folder and...

Is it possible to display a textbox if a condition is met. For example if a date diff is less than two days then display a text box in each record meeting this criterion with the text "Fail" and one showing "Pass" if greater than 2 days? Reportsmith allows this function using a macro suchas...

I'm reasonably competent (ahem) with Access vba but Word is giving me a headache. I know how to add a message box on opening a word doc. The doc has form fields. How do I code for a message box to pop up before or after a field is updated? Thanks

Hi Swopping from crummy Reportsmith to Crystal but can't find how to set the default save folder.

I'm using the code below to prompt users to fill in two combos before moving to the next tab page on my form. It works when both combos are empty but if I update the first combo and press the LOST button again it fires the setfocus event. Is this a "null" problem? Private Sub cmdLost_Click()...

I'd like to use the OnTimer event to make a control label blink a couple of times and then remain static and visible. Normally the code below would run a piece ofcode once only after loading the form but the blink code doesn't work inside this Ontimer event as it stands. Any ideas? ‘Put: Dim t...

I know I'm slow but when did we lose the ability to search on thread title in advanced search, and why?:confused:

I'd like to use a particular graphic for the background to all my forms. Is there a way to do this globally or do I have to add the graphic to each form? No problem doing that - I was just wondering. Cheers

My form is now opening correctly filtered using OpenArgs but I'd like to set the form caption depending on the filter used. I have three different OpenArgs filters in all opening the same form with different criteria but I can't even get a simple if statement to work. I also tried a Case...

I'm opening a form based on a query. The OpenForm filters the query. I'd like to put in a warning Msgbox if there are no records to display and stop the form from opening but I can't work how to do it. RecordsetClone brings an invalid reference to RecordsetClone error If...

Hi I can't get my head around the logic on a small problem. I have a form set up where on the onClose event an email is sent using sendObject this works fine. However I want the user to be able to cancel the entire record if they've screwed up the entry so there is a cancel Command Button using...

I’m using the following code behind a command button to send an email with field contents from a form and generally it works fine. Code Application.FollowHyperlink "mailto:joe.soap@somewhere.gov.uk;&subject=About improvement logged on QMS1 &body=Record number: " & Me!txtIncidentID & " Raised...