Search results

im not sure if you have alrleady tried but i uses twillio api for a access sms introgration and it works great in batch sms and individual sms.

hahaha i doubt that my employer is footing the bill dont worry ;-) and ive literally pulled the software apart so.... ;-)

quick question is there any major difference in speed between sql exp and sql developer and which do u guys recocomend.

so after using a msg box popup between each line of code ;-) i no longer think this is a networking speed issue but rather the way the individual computer handles the code. the code on each system is the same so it must be something to do with the software installation somewhere maybe something...

yes covered this mate . ty tho

hahaha, I did make the entire thing local on one version of my DB to see if that helped and I thought it would be lightning fast. but guess what it was just as slow using local on tables :(

yes i tried this incase cable quality or port location made a differnce , it didnt make any effect , the difference seems to be the computers rather that the cabling or what not . despite them bein very similar

hmmm im not really sure where to begin with this idea. ive never set or allowed any user any particular access everyone just logs into the sql srever using data connection and the SA pw which i know isnt the most secure but it works.

i did do this to some degree and it appear the part of the process that drags its feet is writting the data to the sql server ,, downloading it and reading it from the table is fast but the write speed seems to be slower on every machine im not sure if the issue is down to the write speed fully...

the front end is running on the desktop on both pc's and obv the back in is sql using data connection

id be interested in a copy of the list if you could please share one ? it's not something I've looked into before but I'm willing to give it a go.

hi all it has been a while since I last posted but here we go, I'm after some advice if possible So I purchased isladogs (such as clever and nice guy) postcode lookup code and added it to my existing database, not every part just the very basic postcode lookup form. works great and I'm happy...

@Pat Hartman took on board what you said and rechecked the record set for the sub qry, made a slight change and removed one of the tables that wasnt critical and it works perfecly , very strange,. but done thank you .

this is great stuff thanks all invovled.

thank you for this pat i will look into this now and see if i cant simplfy thing a little.

i completly agree mike the word new should be in the new record but using sql the word new dosnt show up what i usually see on other forms is the id field staying empty untill the record is saved, and this form does do that perfectly untill you try adding a record after the delete, im going to...

im not sure i can do that as this db uses 3 data links 1 to a local sql server and the other 2 link to 2 web based databases setup in phpmyadmin so without the data the forms dont really work and you wouldnt be able to test it very well. this single form is the main form order form in a massive...

just in reply to ur question mike i think i tried a reqeruy before and it works fine the record does disaprear if i use the delqry but not the accmd command. in any case it doesnt mater if i click the record 1st or move focus off the subform , untill i close and reopen main form i cannot add...

i will add all of the forms and there subform are based on qrys not tables themselves as the qureies cobine multi tables to provide the info

DoCmd.RunCommand acCmdDeleteRecord is highleghted yellow on bebug this i presume is becuase it cant save without a primary key, so its not the code itself at fault the issue lies with the record not getting the key it needs to be saved. very strange. when the key is a auto number field