Search results

  1. S

    Open database with task schedular problem

    i had this problem. very similar. i used the bat file to kill the access process. then used scheduler to open it. i couldnt get it to work but i resolved what i wanted to do another way. what is it you are trying to do by closing and then reopening
  2. S

    VBA Access Compatability issue

    you could always get them to open it in runtime. you would have to change the extension to .accdr and they wouldnt be able to get into the back end but if they are only using the database then that shouldnt be a problem
  3. S

    write conflict on main form when change on subform

    i a little frustrated and confused with this. i have a check box on my subform that when clicked enters an amount in the main form record. it changes automatically and when i do this i get a write conflict asking to save/cancel/drop. ive tried to save the record on this event but it doesnt...
  4. S

    introducing mysql trouble

    refreshing links!! i thought that the links where permenant. how do i refresh links. also i have managed to get all of my data (tables) into mysql. there are some errors with data type. does datatype differ from access to mysql? i did think it was a good idea to start all this now but i am...
  5. S

    introducing mysql trouble

    regina, thanks for the blog. it seems like alot of work. is there a program that will check my table systems for me and tell me what column, table, record has conflicts. im not lazy but i would rather a computer do the work and it be without errors rather than human error coming into play. i...
  6. S

    introducing mysql trouble

    i am trying to move all my tables over to my sql but i am having trouble with the functionality of my forms. in particular updating and creating new records. for instance i have a form that goes to new record on open, however the unique id field is empty. there isnt a new record being...
  7. S

    designing web booking.(new territory)

    i have built an access database that we use day to day in our business. it is primarily an appointment book with reports and stats that go with it. now i want to take it to the next level. online booking. i am planning on exporting the access tables to mysql, this will be hosted on my pc not...
  8. S

    2 front ends and one table structure

    sounds like its exactly what i need. ive been looking at sharepoint sites all day and i still havent got any idea how to set it up. do you have any experience of how to set it up.
  9. S

    2 front ends and one table structure

    i never thought it was straight forward but i did think this was the most straight forward way. not easy by any means no matter which way i turn. if i set up a sharepoint site, had my tables in the cloud and kept the front end on my desktop would that work and if so coul i then add further...
  10. S

    2 front ends and one table structure

    for back ups i use cubby. it is backed up nightly and auto saved in the cubby folder and then uploaded to the cloud. also if that fails the cubby folder is connected to 3 different pc and each download the file(syncing). how good and expensive is sharepoint. i like the idea of having the tables...
  11. S

    2 front ends and one table structure

    i want client to be able to book appointments via our website. that would mean www. our pc is never off and hasnt been for around 3 years. it is permantly connected to internet so i think we have that part covered. i like the idea of sharepoint. reason being is that i know how to build forms in...
  12. S

    2 front ends and one table structure

    i have recently asked about being able to use my table system online. i have just thought. what about creating a front end that works online. still have the front end on the desktop and the table system on the desktop but have both of them connecting to the one table system. will this work?
  13. S

    Publishing access database on web, how and which way is the best?

    i have started a new thread asking how i would link my database to the cloud or put it in the cloud altogether. i think i may have found my answer but i feel it is way out of my league. what i want is for clients to book appointments online. so i need to either drag data to the cloud as and when...
  14. S

    going online with database

    i have nearly completed my database for an appointment system. now i want to take this online. i know that there is 2 ways of doing it. putting the tables in the cloud or having the cloud communicate with my database on the desktop. i have concerns with both ways. tables in the cloud. how long...
  15. S

    automated twitter messages

    ive completed my automated text reminder system and today ive been thinking of sending direct messages through twitter and facebook. some of our client dont want to give us their mobile number to send txt to so i would like to be able to do it through twitter. has anybody got any idea of where...
  16. S

    Open Calendar Control Replacement on a certain date

    i have just solved this. the key was in my coding. i tried [Forms]![frmDiaryMultiView]![frmCalendar].Value=#01/01/2012# but i forgot to refer to it as a Subform so it needed to be [Forms]![frmDiaryMultiView]![frmCalendar].Form!.Value=#01/01/2012# all ok now
  17. S

    Open Calendar Control Replacement on a certain date

    a couple of months ago i found a celndar control replacement that microsoft kindly provided. i have made a few mods that allow me to change the day/week etc. i would now like to tell it to open on a certain date. the reason is that on each of my client records i have 'Future Appointments'. i...
  18. S

    system resource exceeded

    way2bord: thats the thing, it doesnt happen all the time. when it does happen, i compact/repair and then continue. it works fine for a bit then it does happen again. so im confused what makes it happen. rzw0wr: the timer event on the password form runs continually which is intefering with...
  19. S

    system resource exceeded

    sorry i put it in a win rar file. its pretty good for compresion. alot better than zip. ive put it in zip now. http://www.chrysalis-beauty.co.uk/http://www.chrysalis-beauty.co.uk/SalonDatabase-Copy.zip
  20. S

    system resource exceeded

    http://www.chrysalis-beauty.co.uk/SalonDatabase-Copy.rar
Back
Top Bottom