Search results

thanks for the help AGAIN!. im trying to contruct the message now that it is working. im trying to refer to text boxes within the form. i have tried Private Sub btnTexts_Click() sendSMS "118-324-1616", DLookup("[MobileTelephoneNumber]", "tmptblTextReminders", "OrderID = " &...

ive tried to do it as it should be, through creating a module and then putting Private Sub btnTexts_Click() sendSMS "118-324-1616", "7919158140", "Sending SMS is easy with Twilio!" End Sub behind a btn on click event. i have now got a Compile error variable not defined with accountSid...

im looking to use twilio sms services. i am integrating it into my database. to begin with i want the code behind a button on click event. twilio help has given me some code that will work but the way it is set out i am strugling with to put in a private function i am wanting to structure...

i am wanting to create an audit log. i have already started but stopped when i had a few questions. i am wanting to know what kind of tbl structure i should have. should i have just a master tbl that stores uniqueID | tblName | UniqueID(of tbl) | type of change(delete etc) | date...

just to add to this. i have many pc's that i need to connect to. i connect to these using log me in. it is pretty basic and and it is basically desktop sharing. its free and they even do an iphone app that is pretty swift to. you can purchase pro versions but i have been using the free version...

i want to start automating a few things in my database. i have recently discovered task scheduler which will allow me to open a file, program etc. however it wont let me close an open file, program etc. so i am building another database to open via the schduler, close the other open database and...

i want to create a report between dates but group the results by day. ie. monday tuesday wednesday etc. i can group by date but not sure of how to do this one. i thought that i would have to use format in the date column of the query and then select group. is this the best way or is there...

sorry cj. for some reason it didnt post my most recent post. i cant remember what i said now. i didnt receive your email. just to check the email address. gshutzy@msn.com. also that means i dont have the updated version. but after reading your post i dont want anymore txt boxes on the form...

hi cj. ive just been looking at the function and i think it needs to include in the sql statement that OrdersItemsID < OrdersItemsID. ive tried but i am getting errors. this is i think a simple fix as no new item added will ever be < any other as it will always be the newest. thanks

hi cj, oooh nearly. the problem i have come accross is that it seems to be chrcking against the tblOrders.OrderTime rather than tblOrdersItems.StartTime. the reason i think this is that when i first go to add a new appointment iit is working but it works with its own time. ie. i tried to book...

can you please put in the forms. i dont think they copied over. a better way is to copy the database file(completely) and then delete the tables and data that you dont want me to see.

you can just upload the whole database as it is. what i usually do is make a copy. copy and paste. go into the copy and delete the datat yu dont want me to see. you need to keep some records tho. so data is needed but no data indicating any client personal details. then just upload the copy...

do you have any forms in your database or do you just work from the table directly. if its just tables then how do you input the data etc. is it automated in any way. to upload a file. click post reply. then below the text screen there is a btn called Manage Attachments. click this then...

do you have your forms to upload with the relevant tbl's. remember to remove the personal data(stuff you dont want people to see) is it a set date every time. ie. 30 day account or a given date each month?

i know im not meant to contact you through this forum to ask this, but im of the understanding that you are a programmer. if this is so then how much do you charge p/h. you see, the diary view was built by someone called andrew. although he has done everything i have requested(paid for) he seems...

thanks for your suggestion. basically this is just a back up for employee error. most of the work is done by the most powerful computer(us). when a client phones up they generally let us know what they want or their needs and we calculate the time in our heads for the treatments. we then ask...

i thought it would be best if i uploaded the relevant forms etc. to get to the correct form open frmClientMainScreen click Diary btn either dbl click an appointment that is already there or a blank space. if clicked blank space then at the bottom select a name and click 'Choose Treatments' btn...

sorry, im not trying to pick holes in this but StartTime+OrderTime the ordertime is from tblOrders. im not exactly sure why you are calling this. should it not be to get the finish time of the item. if this is what you are wanting StartTime+TreatmentTime the treatment time is the duration...

i dont have the start time in my form. i an use update query to input the start time. i do this because i have many items to an appointment. so the times have to run in order. the rpoblem lies when and if i remove an item that is for example 3rd in the list of 5. all the times need to be...

thanks cj. im not really a programmer. just a beginner. i can follow most of it and i can see the query that would bring up all records for the same date with the same employee that are greater than time. the only thing is i am not familiar with function, modules or public subs. i have only ever...