Search results

In my ID's on_click event I have: Private Sub ID_Click() On Error Resume Next If (Form.Dirty) Then DoCmd.RunCommand acCmdSaveRecord End If DoCmd.OpenForm "Issue Details", acNormal, "", "[ID] = " & Nz(ID, 0), , acDialog If (IsNull(ID)) Then TempVars.Add...

That's a good point. Our department is small in size and I know them all by names. So I know that none of them will run into duplicate usernames. But still I would like to do it the right way. I'll try to do it as you suggested plog. Thanks. Will update.

I have a table of contacts that has the first and last names of employees. I want to use the full given name and the first letter of the surname to create a login username. For example: Wondering if I can make the username field as calculated and create an expression to use the names to...

So that first code, that's going into the open event of the "Issue Details" form and the 2nd code goes into the open event of the "Issue List" form? Have I interpreted that correctly, because my problem hasn't fixed?

Hi, I tried this but it doesn't fix the issue. Form is blank on startup (which I want) but remains blank when trying to open a filled-out form using the "Issue List" form.

Sorry that was vague on my part. I mean like the "Issue Details" form opens a blank record (when I click on the ID field in my "Issue List" form) instead of the record that pertains to that ID field. I only want the "Issue Details" form to be blank on startup. So I want the staff to see that...

Sorry for the confusing title. Let me explain. I created an issue register type access database to have better communication between staff and technicians. I found a template that I have tweaked to better suit my requirements. The startup form that the staff interact with looks like this ...

Just realised you've actually answered that here already. Everything works fine now. Thankyou Arnel.

When I change the form property back from data entry = yes to no, everything works again.. i guess I'll have to leave data entry = no In saying that, are there any other alternative method to display a blank record when form_open?

Well the database has already been created, so there are quite a few form events for example. I was wondering if any of them can interfere record navigation.

Ok so datatype is supposed to be a number. I actually had it set as: rs.FindFirst "[ID_Index] = " & Me.cboMoveTo But I've just been experimenting to fix my issue and changed the PK to a text type and so used: rs.FindFirst "[ID_Index] = """ & Me.cboMoveTo & """" But neither is working..

Ok but my issue now is the navigation of records. I just want to know why my form isn't opening the record selected from the combo box. My code in the OP works, but only after I've made a new record and before I've closed the form/database. Once I close it, the form does not navigate to that...

Well I wanted the form to display a blank record whenever it is opened, that's why I set Data Entry = Yes. Not sure if this in anyway affects my above problem though. Also if I wanted to disable additions, I could just set the Form's properties for Allow Additions to "No", right?

I want to navigate to records on my form, via combo box selection. In the afterupdate event of my combo box, I have the code: Dim rs As DAO.Recordset If Not IsNull(Me.cboMoveTo) Then 'Save before move. If Me.Dirty Then Me.Dirty = False End If...

Oh, so I wanted it to work the other way around. FE user inputs data, BE user is prompted of addition/deletion. Is it not possible for it to function this way?

No sir, only the other user had the FE with the form opened. I had the BE with the table open.

So I've done everything. And I saved it on a network location where I asked another user to add some records to the FE. But I didn't receive any message box to refresh my records in the BE?

Yep I did all of this, but received the error for some reason. EDIT: so i just deleted the file and re downloaded the zip.. it works for now lol.. not sure what happened, but as long it works hey

Hi Arnel, Just been receiving a run time error using the sample. I've added the screenshots below: Thanks.

Hi Doc, Thanks for the response. The FE/BE explanation was probably not a good way of going about trying to explain myself, sorry. Thanks for informative reply. I'll give your two ideas a try and inform you of the results. Thankyou. As for the EDIT, Database A is a split database yes. And...