User Profile

JenZzz · Jun 27 '14, 11:22 AM

Hi Ricardo,

A .mde file is made so people can't change anything anymore. The code is never viewable anymore.

I would suggest you to split your database. By keeping all the tables in a secure back end the data keeps the same. It's very simple if you follow the wizard. The following link provides you with more info on the subject
http://office.microsoft.com/en-us/ac...010342026.aspx...

JenZzz · Jun 19 '14, 07:01 AM

Could you be a bit more specific.
If you simply want to check the value in your textbox and if it's empty, prompt the user to either enter or leave it 0 I would try something like this

Code:

If "" & Me.Textbox = "" Then
     answer = msgbox"Enter data?", vbYesNo
End If
If answer = vbYes Then
    'let the user enter his value
Else
    me.textbox.value = 0
End

...

JenZzz · May 15 '14, 01:21 PM

So the .Edit in my code here does nothing? Because it keeps giving me an error without it.
Anyway, thanks for the help :)
Jens

JenZzz · May 15 '14, 12:29 PM

Problem has been solved using the following code, seems I have made the problem seem more complex than it was.....

Code:

   Set rstdeleteuser = CurrentDb.OpenRecordset("Tbl_Users", dbOpenDynaset)
        With rstdeleteuser
            .FindFirst "UserID= '" & gvSelectedUser & "'"
            If .NoMatch = False Then
                .Edit
                !UserID = gvSelectedUser

...

JenZzz · May 14 '14, 02:01 PM

I'm sorry, It seems I haven't been clear and made a few mistakes. Let's start from scratch.
I have a Table named 'Tbl_Users'.
I basically want to delete a record from that table.
I have a Form called 'Show Users'. On this Form, there is a subform called 'Qry_Users subform'. This subform shows a Datasheet on the main form and gets it's data from a query, which in turn gets its data from 'Tbl_Users'.

So we have a main...

JenZzz · May 14 '14, 12:45 PM

Am I correct in saying that depending on whether or not you are trying to make a multi-user enviroment you either choose an Unbound Form for multiple users or a Bound form for a single user? Depends on the use for your database, abadaysheker2!

JenZzz · May 14 '14, 11:31 AM

A form is unbound when the 'record source' of the form is empty. You can check this in the data tab of the propertysheet.

Creating the form itself is simple. In the create tab above you can start by creating a blank form et voila.
Next, go into design view and after creating some textboxes you can enter the Visual Basics Editor.

Assuming you have basic knowledge in visual basic, you can start asigning the values in...

JenZzz · May 14 '14, 10:49 AM

If you are trying to create a form on which you can add records to multiple tables at once, use an unbound form and multiple recordsets.
If not, please be more specific.

User Profile

Profile Sidebar

Leave a comment:

Leave a comment:

Leave a comment:

Leave a comment:

Leave a comment:

Leave a comment:

Leave a comment:

Leave a comment:

Delete records from Table open in Form