Search results for query: *

Brilliant, thats exactly what i wanted, many thanks :)

Hi all, here is what im wanting to achieve... I have a Count() on a few forms which obviously counts all records, what im wanting is to do is display brackets around the count number so rather than looking like this '1' on a form it looks like this '(1)' like most microsoft products discplay...

Thanks to you both, i think ill give Roys idea a go and build on that :) Thanks again Chris

Thanks for the reply Zameer but the query results are shown on a tab form, not in table view therefore i need a solution where the user can either 'select all' or 'individually' select records for deletion. Chris :)

Hi all, any help on this would be much appreciated... Basically what i am wanting to do is run a query that shows all records that are 'bad' records ie. where data has been missed out etc and are no use in the database. I have the query setup and also the form that shows the records but i am...

Hi guys, thanks for all your help, ive tried and downloaded a few of the things you have pointed out to me. They're all what i want but i am struggling to adapt the code into my database but at least im heading in the right direction now :) Thanks again Chris

Yes i have! And i wouldn't post a question before posting. All the topics pre-posted do not describe what i am trying to achieve, if you look at the following link you might get a better idea as to what i am after...

Hi all, is there anyway that i can create a 'progress meter' to show the status of a task being performed? Im talking about something like the one you get in the bottom left hand corner when you run a query or do a compact and repair. I am wanting to display the meter on a form, any ideas...

I dont think i made myself very clear, what i am wanting to achieve is a 'bar' that shows the progress of an action when being performed like the one you get when you install something onto your pc

Hi all, i am wanting to create a custom status bar on a form just to show the user that something is happening when they run/open query that takes a bit of time to open. Has anyone ever done anything like this before? I know you can make the bottom status bar show that is standard in access...

Hi there, yeah i got as far as putting the calendars on the forms but im not sure where i should put the codes that you put and what fields are required on the form with the calendars on. Chris

Hi thanks for replying, im not too up on the calendar controls in Access so im strugling a bit with your answer :( Would it be possible for you to email me the screen dumps? It would be much appreciated! Thanks Chris

Hi all I am currently writing a "Scheduling" database for all of our engineers to book them in on jobs etc. I was just wondering if anybody knew a way of doing a calendar form or function in Access which will display all jobs booked, completed, cancelled etc. I know you can export to the...

Cheers PH ive had a look, looks like a bit of a mine field but ill have a look through all the info. Thanks again Chris

Cheers Mike that works great, however i now get a dialog box pop telling me that another program is trying to send an email on my behalf and i have to click Yes to allow this, is there any way of avoiding this too? Thanks Chris

This is part of the main program. Go to the Tools menu in Access and then to Options, then to the Edit/Find tab and remove the ticks under the Confirm section. Chris Ps. You may want to leave Confirm Record Deletions ticked!

Hi all I have an IT Callout database which logs all calls to the IT Dept, i have a form where the call is logged and what i want to do is upon completion of the form it automatically sends an email to the caller. I have it 90% done but what i cant do is get the email to send on its own, what i...

Hi If you go to the properties of your Form and then go to the 'Event' tab you will see an option for 'On Open', select [Event Procedure] and then click the ... Now type the following code in the VB window: Private Sub Form_Open(Cancel As Integer) stDocName = "Query1"...