Search results

Thanks for the link LPurvis. I have read and ensured that I have followed before re-testing. I finally got around to retesting the DB in our training room on multiple machines simultaneously and unfortunately I am still experiencing some anomalies!!! After implementing GUID it is clear each...

I have implemented GUID this morning in my Trial / Test MDB & all seems to be good & work as it should. I will now split to FE & BE and trial with multiple users again. Hopefully all is good, thanks for the help

I think we could settle on it being a combination of both! I have research GUID and found the following post's on this forum http://www.access-programmers.co.uk/forums/showthread.php?t=108630 http://www.access-programmers.co.uk/forums/showthread.php?t=159401&highlight=guid The latter being...

I have looked at GUID and would like to check that I understand fully what you are suggesting;- Current DB From opening the FE form it assigns the next ID in the sequence to PK autonumber field in the BE, im guessing what you are suggesting is that if the FE form is open simultaneously on...

I have since removed all records to try and duplicate the error so cannot post the table with errors, sorry. I will research what you have suggested and let you know how I get on, thanks for the help so far

I have always had my PK setup as an Autonumber with the indexing set to "Yes (No Duplicates)" so cannot understand this either!! I have since done some more testing and cannot get it to recreate the error above. This doesn't mean that it won't happen again so any suggestions would be good...

In reference to the second question, the FE and BE were built with acc2003. Unfortunately I have tried to persuade the powers that be to upgrade all software to the same version but they will not budge so I have to implement a non cost system!! In reference to the first question when...

Not sure whether this is the correct area to post this in so I apologise n advance I have been working on a projects database and have got to the point of multiple users accessing and writing data at the same time. The Database is deployed via an MDE FE across 03,07 & run time machinery. The...

This post might help you http://www.access-programmers.co.uk/forums/showthread.php?p=820781#post820781

Thanks to both of you, the last piece is now complete & I am a very happy Bunny as this is my first full scale package and deployment project complete! I now have the joy of user training to contend with!!!!!!!!!!!!!

No I haven't, do I place this before the my query action ie: DoCmd.Setwarnings False DoCmd.OpenQuery ("QueryName") DoCmd.Setwarnings True Thanks for the quick response

Not sure if this should go here or in the queries forum? I have a projects database near completion that I need to distribute across 30 + users, some don't have access while other have 03 and 07. I have split my database into FE & BE, I have compiled my code and created an MDE front end to...

Sorry haven't replied sooner, a family emergency has kept me from work. As soon as get my head back into things I will re post Thanks

Eventually I decided to run with the SQL statment that I posted as an append query within access which is run from my button and VB. The function now takes approx 5 seconds to complete. The DB is only a test system with 5 records in it so I may have to alter this at a later point in time I did...

Thanks for the feedback. I am relatively new to all this and have only been working with access for 2 years, being self taught I also have a few gaps in my knowledge! I would like to say that this forum has been an invaluable recourse, thanks again:D

I have had a play around, is the SQL below how you suggested or is there a way to use the Dcount function just once? INSERT INTO GateKPI_Tbl ( TSTATUS1, NDSTATUS1, DSTATUS1, ODSTATUS1, CSTATUS1, TSTATUS2, NDSTATUS2, DSTATUS2, ODSTATUS2, CSTATUS2, TSTATUS3, NDSTATUS3, DSTATUS3, ODSTATUS3...

This is my completed Sub, it takes approx 30 seconds to run. If I understand you correctly are you suggesting I omit the Dcounts stored as variable and add the Dcount function to the SQL sequence? Private Sub Command2_Click() Dim strSQL As String Dim TStatus1, NDStatus1, DStatus1, ODStatus1...

That worked a treat, Thanks a lot

Hi need a little help with how to get an SQL insert string to recognise VB variable as the insert values. Basically I have a Project Management Database I am working on. Each project has 281 standard steps split into 8 gates. The powers that be have a meeting every Monday to discuss and...

Heres a piece of code it put together recently to import delimited txt files into an access database. you basically hit your button, it brings up a file open dialog box, select the file you want and it will import into your table. Hope it helps Private Sub Command2_Click() Dim filename As...