Search results

I would like to offer my deepest sympathys to all involved in running this forum. Its a fantastic resource and for beginners like myself its worth its weight in gold, I for one would pay for a resource like tihis. Why would anyone want to attack such a specialised and inocqueous site like this...

try talking to SHEA, seems to know what he is talking about

try this from SKEA I know what you are trying to do.Deleting a Record and wanting to store it in another table.Hope iam right. Ifts its not that then Remove the DELETE Query from the code below. Make sure that the table where you want to store your deleted records is present(i called it...

you could use a yes / no field and then query using yes / no as your criterior and then base a report on the results.!! i think?

I think he is trying to have a system that shows which calls have been delt and which have not?

Datapig has a good tutorial on this subject http://www.datapigtechnologies.com/AccessMain.htm

Or preferably on seperate lines in the text box,thanks.

SJ McAbney, could you tell me how to add commas between the selections added to the list box! I used you r code and it works great but I need the seperations, Dim var As Variant For Each var In Me.MyListBox.ItemsSelected Me.MyTextBox = Me.MyTextBox & Me.MyListBox.Column(1, var) Next...

Carl I use photshop cs and cut the file down 48pix for an icon and 150 at 14cm for a watermark. to as small as possible save as bmp and use as watermarks or icons. But I am by no means an expert, I am sure there are better ways of doing it. look at the zip to see some of my images.

Thank you Pat and Rich for your help. What I have done is copy both FE & BE to a flash drive which i will place on the lap tops, once records are added on the laptops i will then hopefully sync back to the desktop. I think this is what you are trying to instruct me on.?

This is driving me crazy!! all I want is a front end on 2 laptops that are not connected in any way to each other or the desktop and periodically to sync with the master on a desktop. I had hoped to do this with small usb flash drive and copy the front end on the laptops to the drive, then...

Thanks Pat :) , I think I am beginning to understand the principle behind all this. So to continue further, I split My Db into front end and back end yesterday and replicated the front end to go on a laptop. However when it came to adding records to the front end on the laptop an error messgae...

Thanks for that RG i will check it out :)

To explain further; I have an ID field in my tables that increments sequentialy by access, as I understand it Access changes this field to random numbers. My queries etc use this field to run, will these queries still work after replication? or will i have to change everything? :confused:

Thanks for the reply Rural, I have looked at the posts and help files, but still unsure if its the right way to go with this. Do I split the Db into front end and back end first? When syncronising do the machines need to be connected to sync or can a disc be burnt with the front ends of the lap...

I have exactly the same problem. Posted the question before i saw this thread. Pat if the sequential id numbers generated by access are not a problem for reference, is your previous post the way to go with this?

Please can anyone give me some advice on sycronisation. The scenario is this. I have created a database to hold records of patients. The database will be used by 2 people in different locations on seperate machines. Periodically I would like to sycronise the records on both machines so that all...