Search results

ok, so the computer that 'hosts' the back end is working fine. the other pc that is accessing the back end over the network cannot ope the back end as 'it is in use' by another user. i can open the back end tables independently but it states 'it is not updateable' the host is running win 7 the...

have not tried that yet, will try on tuesday. thanks

on the xp machine the backend was in a 'shared' folder I have moved to a new machine running windows 7 and saved it in the root c:\ and 'shared' the drive. Both front ends can find the BE and read all the data but cannot add or edit :(

hi, im using a front end and back end and sharing the back end. i have had to move the location of the BE. i have linked the tables to the new location but when the front end is opened i cannot add or edit the records. i can view and search but not add?? the back end was on an XP machine and...

Now that sounds like something I can do ! Thanks for your help !

hi, i am just trialing sharepoint and i am trying to publish my database to the web - the compatibility wizard finds a problem with a table called eqldata - the only problem is i dont have or cannot find a table called eqldata!! im sure in my past it did have one but it was deleted ( it was part...

tried it ans still not working - ive put the stuff in using the 'wizard' as shown in the image. if it wont work what should i do?

hi, i have a field on my form for balance which is a straightforward adding and subtracting to give me the balance. what i would like to do is if the balance is less than 1 or zero i would like it to apply a check into a tick box called 'paidinfull' i have tried running an afetr update action...

hi nigel ( you seem to be the expert on this thread!!) im sorry to bother you, ive been trying to use your code to find/delete appointments and i really am struggling. when i make a command button on a form which bit of the code to i use and where do i put the rest of the code? im sorry but...

i current have a database that i have cobbled together from bits of stuff i have found on the internet - and if im really honest i do not understand VB :( I currently have a button that adds an appointment to outlook. here is what ive got and it works. Private Sub btnAddApptToOutlook_Click()...

Thanks for that, i accept what you are saying is right but it may be more difficult for me to change what ive done than it would be to create version 2.0!!:eek: the image shows the form and what it does and what info i have - even with my ham fisted attempt would it still be possible to have a...

Sorry to bother u but I'm struggling to find what I need. I have a database which by your standards would be fairly basic but has taken me months yo get nearly right. I have only one table which is filled through a form with name dates and other info on. I have a general notes field that I...

thanks for your help............. but explain it to me like im a little slow!! how do i change my table to have my reference number different everytime and not uise it as a primary key?

i have just opened my front end and tried to add a record, each time it failed but added one number!, i have now opened and closed the databse 120 odd times and the autonumber has caught back up with the records! and all good again. thanks for your efforts :)

thats what the autonumber is ( i think/hope?) it should go up by one every record.

i dont understand sorry ?!? my reference field which is the autonumber is currently at 226, there are 174 records in the table. i have deleted records in the past from both the table and via the form and not had any problems:(

is that something i do the table (back end) or the whole database?

i am using autonumber as a primary key so that each 'job' has a different number and it shows it on the form as YORKS**** ( *being the autonumber) all of a sudden it has stopped working! i am upto record 175 on my table and up to autonumber YORKS0225 on my form, if i go to add a record is...

hi i have a database that i would like to be able to search to return entries between two dates and filtered by specific person. each person has a unique number. i have done a basic query that has a pop up asking for the required dates - how do i get it to pop up to ask for the persons number...

Thanks for all your help, shame you don't live down the road, you sound as though you know what you are doing!! will give it a blast and see how we get on :)