Recent content by Pace

So there is a way around this, but it aint saving as 2003, which is my whole point in this topic.

Ok Friday... first off there is no need for that attitude... second, you tell me then, why I save a db from access 2002 it gives me a choice of this... 1)"Microsoft Access Database" AKA .mdb The same as every other Access database... the difference's in the versions are all in the available...

no problem ijamal! :-) Im by no means having a dig, its just I can see you have the right kind of idea and I think if you do this for yourself, you'll learn an awful lot and find your new goals much easier! Good luck! Pace

hmmm... so you can save from a program in a format that as of that time diddnt exist??? news to me! ;-) Try looking here: http://office.microsoft.com/en-us/assistance/HA010916581033.aspx

ijamal with all respect you could carry on forever here, If your original question is answered, please start another thread for a new one, but as a tip you really need to read a book on database design because you seem to be confusing yourself and I really think you need to learn how to do...

Hey I got it, prob not the best way to do it, but hey it works and on the plus side I did the lot me self egh ;) If anyone is interested I have posted the edited code; Private Sub btnAdd_Click() Dim UserName As String Dim Initials As String Dim Password As String Dim...

hmm ok I see what you are saying. I know that this is NOT the best way to do things, I just sat up and thought hey ill do that... so now I have started I really want to :confused:

I dont need all that to clear the controls :( I want to clear the controls afterwards and let my user know that the data in the recordset has been added ;) Im new to all this so I am just making bits and bats here and their and having a good play integrating them into the larger application...

Hey all, I have some code that looks like this to control a form; Private Sub btnAdd_Click() Dim UserName As String Dim Initials As String Dim Password As String Dim OutlookName As String Dim rst As DAO.Recordset 'Check each control, is their a value? if not, set focus...

Hi, This old argument again egh... well to start with in my opinion their is no best application, its horses for courses. Access is the best fron end for Access... bescause its Access... Now Access also makes a great fron end for SQL Server. But you could always have a web based UI. ASP is...

the timer control is more of a property than a tool ;)

Yes I agree with what you say but I have found that our app (approx 140+ tables) runs a hell of a lot quicker running off SQL Server than Access. Thats even with DAO :eek: Cant wait to convert to ADO :)

:eek: u think so :confused:

Hey im doing this for my company :p Yes it will be quicker "out the box" but the real way to make it quicker is good database design. Do you know how big the database is ? You could split it up into multiple .mdb's to start with to make it quicker. Its not hard to get the data onto SQL...

hmmm everything still seems fine :confused: