Invalid user of Null: Runtime error 94. Getting error when textbox is Blank. How to handle this error:

[pedie]

Original code. username below is textbox name.
Please help.

[/FONT]
[FONT=Courier New]Private Sub Command9_Click()
If Me.Username.Value = "" Then MsgBox "Username cannot be blank", vbInformation, "OK?": Exit Sub
MsgBox Me.Username.Value
End Sub

 

[alansidman]

Suppose i have a form in database1 and want to add the records to database2 then how is this achieved?

An alternative here is to link the table in Database1 to Database2 and run queries to extract your data as needed. No need for any VBA code to do this. You do not then have to re-enter or transfer any data. It will automatically update because it is linked.
Alan

 

[xenou]

An alternative here is to link the table in Database1 to Database2 and run queries to extract your data as needed. No need for any VBA code to do this. You do not then have to re-enter or transfer any data. It will automatically update because it is linked.
Alan

That is what I would do 99.99% of the time. You can open recordsets on tables in other databases if you really need to do so (here) Then instead of the current database you'd use the database you'd opened. If you are working with large scale projects with many users across a network, you can worry about all these remote connections using up resources. Otherwise, it's no big deal. Better to link tables though.

 

[pedie]

Thanks again guys for the very usefull piece of information...

I have no idea till now how linking table works or how to even link it for the start

I have tried building append query, delete query etc. I tried append query to other database but wont work.

And what 'm trying to do is for users to have Database1 as frointEnd and Database2 as Main Database and then use Form in Database1 to run code and update records/data.

I am also wanting help in FORM pop up as soon as Database1 is open and then when form is close, i want event to triger and close Database1 too is that possible?


Thanks again Xen and Alan, I will also need link for linking tables maybe i'll need it soon.


THanks again

 

[alansidman]

Pedie,
In addition to Xenou's advise on getting a book on Access, here is one of my favorite resource sites. You can find a ton of things to read and practice here.

http://www.databasedev.co.uk/general.html

Alan

 

[xenou]

Linking tables is easy - it's on the file menu:
http://www.techonthenet.com/access/tables/link_table.php

Once you've linked a table you can (for all intents and purposes) treat it as if it were part of your database.

 

[pedie]

Thanks again, now that I know few things i am sure I'll return with a lot of questions You guys have been very helpfull. God bless and enjoy Weekend!

I am going through the link.

Thanks again!

 

[pedie]

[FONT=Courier New]Under the File menu, select "Get External Data" and then "Link Tables".[/FONT]

'm using Access 2007, 'm home now so where is "File menu"?
Tried searching but cant find link table too...

In case if you guys are still around then...

I think it is import access table in Access 2007 in external data tab, correct?

 

[pedie]

That was it, I have linked it only to table [I also came to know that codes, queries etc too can be linked...]

Thanks again guys for giving me a start!!!!

You guys Rock!