Recent content by PraizesLiberato

This code already works but I will be using several different forms and this may come in handy.

Private Sub RelationshipHistoryArt_DblClick(Cancel As Integer) If counter = 0 Then RelationshipHistoryArt.Height = RelationshipHistoryArt.Height * 2 DateofArt.Height = DateofArt.Height * 2 Me.Detail.Height = Me.Detail.Height * 2 counter = counter + 1 ElseIf counter = 1 Then...

:eek: I cant seem to open the one with the MDE file (Screenshot attached). The other files, I don't know how to use them?

How do i add a gif image to Ms Access? I have tried to use the link below but step four in this doesn't happend on my PC. :( http://www.ehow.com/how_7407641_animated-gif-files-ms-access.html Am i suposed to do something more to enable something on my PC.:banghead:

Hi Vila,:) could you tell me why the queries wouldn't be any faster as compared to "Accessing the queries stored on a Shared Drive is an MS ACCESS FILE". Since this would be a dedicated access to the server and from my guess this would be better than a shared drive being used for so many other...

Hi, I am thinking of using views for many of my existing queries in MS Access. and then specifically querying those views from the forms. I read up to day that views are stored queries. If that true there has definitely been an improvement in the speed of accessing data from the front end(as...

LightWave, Man that adds an ample amount of knowledge on the matter from what you call 'done a bit'. Thanks for the Part on the Auto number. Sounds like i have a lot to learn on the new features of SQL Server. ;) Yes its is practically as well.

Hi GalaxiomAtHome, That is probably the approach i may be taking. I have improved our MS Access systems as much as i can. but i still think i could do better. Do You have any good links/Book Names for which i could ref to for more on this subject.

Hi Vila, That Could be improved with better queries right? Thanks Vila.

Hi Pat, I only will be querying required data (Max 100(Prob not) Rows; Min 3) at a time. Would it be ok for Data being bound to a form using a custom query (Generated by the system based on the users clicking on the options/filters/customer in the form). I mean, would the form take time to run...

I have very little background in SQL Server but im sure IT here could help us in getting the connection between MS Access and SQL Server. I am also willing to learn the differences and do the conversion of all the systems myself. But we need to be convincing in making our proposal. Could use...

Wow. Thats a gr8 answer. Truth be told i am a bit relieved to know that i can use ms access as a front end and hence improve the functionality in terms of both the front end and back end being much faster(Than the current setup). An more pros and cons and ideas of any of the possible stumbling...

Hi Developers out there, We have 4 access databases stored in our shared folder developed by yours truly. As our table and query structure are quite complex for some of the Databases, also the front end being access itself makes the same very slow. Just recently we had a discussion...

Hi, I have a List of amount and a column next to them that indicate the balance after subtracting the opening balance with each amount in the rows below. If incase the user decides to change one of the amounts, the balances need to change and be saved into the database. This is where i face my...

:confused:IS MY DATABASE CORRUPTED@!@!!! :confused: I NEED TO FIX THIS FAST. BUT HOW???:eek: ATTACHMENT IS BELOW. I tried to compact and backup. but it still show me this message. Is there something im missing.