Recent content by slcollie

The code priovided works great for me and I will look at tutorials too - many thanks for the help

Sorry im not too good at SQL. Its just an MS Access 2010 database and the layout above is what all the websites say to do. I tried to follow your instructions but it keep putting an extra " after the first line. Private Sub Status_AfterUpdate() If Status = 4 Then CurrentDb.Execute "INSERT...

I am not too good with writing code but I researched INSERTS and cant understand why this code does not work. It seems to be unhappy about my table TbL_IF but I have no idea why. Any ideas Private Sub Status_AfterUpdate() If Status = 4 Then INSERT INTO Tbl_IF(ready) VALUES (True) Else If...

I am trying to work out the source of a pivot table within someones form. The OLEClass is Microsoft Excel 97 and the class is exel.sheet.8, but the source Doc and Source Item are both blank. Is there any way I can find out the name of the excel spreadsheet that this pivot table was created from?

I have 2 problems in the reports I am creating: 1. I am using a calculated text box to work out summaries. here is my code: =DCount(AppointmentOutcome","CUSTOMER","AppointmentOutcome='ACTING'") This code works fine and returns the total number of customer we are acting on behalf of...

No, still nothing. This code was given to me by someone - do you think the 3022 part is not recognised?

I'm afraid it didn't work, nothing happens and I don't know why. SARAH

Now the system is being used by a lot of people this refresh won't be enough. I need to update the listbox of user 1 machine even when user 2 is the one who has entered new information...... My head is spinning!

I am trying to create a warning which tells the user they have violated a multiple index by adding repeating data, but it does not work. Here is code. private sub form_error(dataerr as integer, response as integer) if dataerr <> 3022 then exit sub Call msgbox ("You have entered repeating...

Thank you so much - just the job!

Here is my macro which occurs under the close form property of my form. condition: if [forms]![customer]![name] is not null Action: StopAllMacros condition: 6<>msgbox("This record will not save. Close form anyway?",36) Action:CancelEvent What I wanted it to do was close the form when the...

here is the code that is bringing up the error message 'type mismatch' private sub print_click() On error goto err_print_click dim stdocname as string dim stlinkcriteria as string stlinkcriteria = "[deceasedID]="& Me![DeceasedID] stdocname = "track report" docmd.printout...

I have a form which has details of customer includins customer ID. I want to be able to press print and another form to be printed out showing that particular customer record. (it is basically the same information, but in a different format). So I set up a command button which prints the...

Afraid it didnt work. So the user still has to click into the list box to update. Any other ideas?

I am having problems updating my list box. The first form contains a list of information drawn from a query. Then i am able to open a series of froms to update some or all of that information However on returning to the original screen the changes are not updated within my list box. The only...