Search results

Hi All I remember reading a tut on how to count records using Running totals in a report - but I cannot remember where I read it. It went something like this. In the section that you want to count, add a field with record source '=1' and make it a running total for the group. In the header...

Thanks for your suggestions. I think i now have a working solution. Just to comment on your data validation solutions....I couldn't agree with you more. Central Australia is an interesting place. Most of the population is nomadic, semi-literate with no fixed address or telephone number. Birth...

Quite often, my users are too lazy to check whether a patient record exists or not. Consequently, we have a number of duplicate records that I would like to merge. My problem is finding a way of linking 2 subforms to a parent that is not based upon a query. On the parent form, I want two...

Hi MegaTronixs I found this code on the forum Function GetLogonName() As String ' Dimension variables Dim lpBuff As String * 255 Dim ret As Long ' Get the user name minus any trailing spaces found in the name. ret = GetUserName(lpBuff, 255) If ret > 0 Then GetLogonName...

Thanks namliam I'll give this a crack shortly.

Hi all I have the 'Source data' (as per the sample data in the attached spreadsheet) but now I need to count groups of records to get the results to display as per 'Count Of' This data is selected between Start_Dt and End_Dt which I have on a form called 'Frm_Reports' I cant create crosstabs...

Thanks guys - Got it working. Gina - I was very close to your solution - just did not have it calling a function.

Awesome thanks. If have got it working (to a point) as follows. (Im not at work anymore, so I'll try paraphrase it from what I recall) for each ctl in MyForm '(I think it was 106,109 and 111 for textbox, combo and checkbox) if ctl.controltype = 106 or ctl.controltype = 109 or ctl.controltype...

Hey Trigon I'm keen to implement the drag and drop thing on a project that I'm working on, so keen to see how you have done it. As for a solution.... What if you get the user to drag the file first and then update the password. Just move the code to the 'afterUpdate' event on the password...

hi Annisw On my main form (which is a navigation form) I make a call to the getLogOnName function. In my DB, I have table (called User_ACL) that has the fields UserID,FormName,CanEdit,CanSee Here is a sample of my code. On the main forms 'on load' event MyUser = GetLogonName() Me.LogonName =...

Hi All I have created an ACL table (access control list) where I have the fields UserID,FormName,CanSee and CanEdit. When the user opens the db, the on open event gets the LoggedOnUserName and then check my ACL table to either prevent viewing or editing. I have got the prevent viewing part...

Hi ms Kathy In the 'on current' event you could put if isnull(me.Fieldname1) then me.fieldname1.allowedits = false else me.fieldname1.allowedits = true end if ditto for field 2 to n If you know how to use a 'for each object' loop (look it up) you could say for each object in my form if...

Thanks Burrina Unfortunately, there are way too many variables that need to be checked to confirm whether a patient is a duplicate or not. As for the hiding/unhiding conundrum. When form A is opened, the detail section is hidden. The user should search for a patient. If the patient is not...

Hi Pickslides Unfortunately you haven't given us sufficient information to be able to provide a specfic solution, but here goes with a general answer. To APPEND items - This is quite easy. Create an APPEND query (with whatever rules apply) and run it. You can run it from a button on a form if...

I have a 'master' navigation form called 'NPYWC' On it, there is a subform called 'patient' - this has a number of subforms in the detail section (Linked on a one-to-one key). When the patient form loads, I hide the detail section until a user either A. Finds an existing client record or B...

Hi all I have tried searching for 'Combo Box not working' and I get tons of solution that are unrelated to my problem - so I have tried posting with this title instead. My problem is that (on SOME machines - why is there always one?) when a use types in a drop down box, the selected item...

Thanks for the response Burrina. Unfortunately, that is not the solution. When the tab is created, access names the button. eg. 'NavigationTab23' or 'NavigationTab137' I can us a case statement as in; Select Case MyBtn Case 23 me.NavigationTab23.visible = false Case 25...

Its been a while since I use CR (XI) - But if my memory serves me well, I think you need to make an ODBC connection to the SQL back end. I remember that I stored my reports in a commonly accessible location on the network, then create a hyperlink from the DB front end to launch the report(s) in...

Have you tried to set the forms 'On Timer' value?

Using Access2010, I have created an app using both Horizontal and Vertical navigation buttons. I want to hide (different) buttons for (different) users - depending on the permissions. When the user opens the front end, I pick up their domain username and use that to review their permissions...