Search results

To The_Doc_Man One the screen it is ticked (True) if I stop the code, on the table it is ticked (true) As per the example above the four are ticked (true) but only three are changed the last one ticked is the one left and not changed

The code that is supposed to reset the GeneralFlag to false is UPDATE DocumentLibrary SET DocumentLibrary.ParentFolder = [Forms]![DocumentLibraryFrm]![ToFolderFld], DocumentLibrary.FolderName = [Forms]![DocumentLibraryFrm]![ToFolderFld], DocumentLibrary.GeneralFlag = False WHERE...

I have a screen where the user selects rows by clicking on a tick box. ( e.g. user selects 4 out of 6 rows, I check the Table after this and the flag in turned on in the 4 records selected) I have an update query that changes two fields in each row if the flag is turned on. The update query...

thank you everyone for your input. I was a bit strapped for time so I made 2 different reports to overcome any problems Thanks Again:) Atrium

Forms sorry, yes the form is modal

If OpIdFld = 10 Then ' For Luke - Check Me.ABABranchIdFld = 1 DoCmd.OpenForm "DdCreateABAFileMonitorFrm", acNormal, , , , , Me.ABABranchIdFld Me.ABABranchIdFld = 2 DoCmd.OpenForm "DdCreateABAFileMonitorFrm", acNormal, , , , , Me.ABABranchIdFld...

The exclamation Mark changed to a dot made no difference. Inserting the NZ worked Thank you very much guys Especially to the DBGuy

I have a query as the source of a search program. I want all the different phone numbers to be stripped of their spaces. I have put in the query ClientPhone: Replace(([Clients]![Phone])," ","") When I run it I get a "Date Type mismatch in criteria expression" error The phone number is a short...

Thanks guys, Syntax beat me again. ;) Thank you for all of your help

I'm using the following =IIf([TranSType]=2,DCount("[DocId]","DocumentLibrary","[TransType] = 1 And [FolderName] = '" & [FolderFld] & "' AND [ClientId] = & [ClientIdFld] & "),"N/A") to fill a filed on a form. TransType = numeric, FolderName = String, ClientId = Numeric This is a continuous...

Thanks to everyone that had a suggestion, much appreciated My problem was that the source file was corrupt - as simple as that Thank you again

I need to use a form I also want to write the vba that will shrink and grow the field size to accommodate the incoming field data. This is a continuous form and If I do it On Current It happens for the first one and then only if you click on each record. I just can't seem to get it working for...

No matter what I do this report is showing over my other forms. If I go into design mode so does the report. I can't find where it has been activated. I have tried closing off and rebooting , same thing happens. It seems to be acting as a subreport to every other form in my database Any help...

Thanks Micron, I will have a go at that after closing tonight(exclusive use after 6.00pm) So to see if I understand you. I have not placed the report in the container under the TAB. In form view when I click on the TAB the report opens with all information but as soon as I click on it it goes...

Thanks for replying theDbGuy There is no code to execute if you just click on the screen, but even if I click on one of the buttons or links the same thing happens. Sending an abridged version of the database will take some time to organise because the project is very large.

I have a TAB menu across the top of my screen and subforms under each tab. I have one TAB that has a Report as the source. In form view the report is displayed as it should be, but when I anywhere on the report it goes blank. I click back on the TAB and it returns but if I click on it again it...

Yes I will give the PDF method a go. Thanks heaps

I need to create a help system. I have the topic, keywords and the description. In the description field I want to be able to insert images to show the true screen image amongst the text I'm having trouble taking the help notes from word (with all the images in place) and copying that file into...

Works well mate, thanks heaps:)

Thanks MajP for the super quick turn around. I never thought of using it like that. Thanks heaps.