Search results

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...

Hello again Am not giving up but am very disheartened. Anyway I am using the code in a module which you gave me and according to the message box it is working fine. But then... a warning box appears saying the following: The OpenForm action was cancelled You used a method of the DoCmd object...

Hello again the code I input into the macro where condition doesn't work properly, I just end up opening a blank form. is this because it doesn't recognise my refernce to the primary key in the listbox (because this primary key actually originates from a query), or is it beacuse my list box is...

Hello again I have got the FIND part of my form to work wonderfully (hurray). I have a macro in the double click of my list box which opens the next form (which is supposed to show the record I have choosen). I can't , however, make it display that record because I have no link between the...

Thank you for your quick reply yesterday. I just have a couple of problems... I do not fully understand the criteria I am using in my search query, and am having problems because rather than letting me input my search items into the 4 boxes, it is automatically bringing up a parameter box...

I am desperate, trying to figure out a way of entering up to four fields (but possibly only one) and using this data as a search to list all the known records which have this criteria. i think i can do this with a query but can not seem to get the query to take in the data that I input. but...