Search results

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

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

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

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

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