Search results

Hi Guys I am going to have two databases in two different regions (half way across the world) and i want them to synch up. I know how to do this. But what I want to know is if it is possible to synch them up offline (i.e. when nobody is currently using the database) so I can synch them up...

Ah, thanks :D i shall try using that. Just out of interest, is it possible to write some vb code to synchronize say everytime somebody logs into any front end of the system? edit: ah, just saw your second post :) i shall have a look on the web many thanks for your help

Thanks for that bob, although, i only have Office 2003, do you know if there is a way similar to the replication manager? as synching isnt too much of an issue, just once a day would be fine, is there a manual way of synching?

Ok, thanks, 'Append Queries' could work as i could copy all records in all tables (effectively). But the main question is, as the 3 backend databases are not linked in anyway (I don’t know if you can link 2 (or more) database applications together) so is it possible to append queries to copy all...

Hi I have a database, but its going to be regional (one in UK, one in India and one in North America), as the database is currently on the UK server, the other two regions take a while for it to load. I am going to put a database in each region and then export all tables into the other tables...

Hi I have a master reset switch on my database, which erases all data in all my tables (execpt for a few important details). I know if you then repair and cascade the database (via Tools>Database Utilities) then it will reset the auto numbers back down to zero and start again. As i know of only...

i managed to do it now with the following: Set db = CurrentDb Set r = db.OpenRecordset("workProductTable") r.MoveLast DoCmd.SetWarnings False r.Delete DoCmd.SetWarnings True DoCmd.Close Many thanks for your help :)

yeah, i guessed that could be the only reason for it being saved. But does anyone have an answer? Is there an SQL delete command to delete the last record in the table?

No, it only clears the last field entered when you press Esc! from looking at the table, as soon as you enter in detials in one field it assigns an auto number, and the record is saved in the table, regards of anything else. Thats why if i cancel, im hoping theres an SQL statement that can...

yes, im not all that bothered about the auto numbering skipping, but currently, the record isnt deleting on an undo, or a record delete, thats why im hopeing an SQL delete can do it!

Hi I have a form, that you enter detials on and when you select a field and enter detials in, it creates the autonumber! Now i believe the database saves this record to the table. If i select the Cancel button instead of Save, i want the entered data to be deleted from the table. I have tried...

Hi When i startup my access database, i get a warning message (see attachment) I dont want this warning appearing everytime somebody opens up my database, how can i remove it? I can't seem to find it in the startup area or anywhere else. Many Thanks for your help David

Thanks guys :)

I have a List box which shows a number of records. It is looking at a table, as the column sizes of all the record's is larger than the width of the list box, im using the header names. Which works fine. but my header names are named like programName, productName, workProductID. Is it possible...

My database will be locked when I release it so that nobody can enter the deign view and the VB code. There is an admin log in section, and I would like a button that i can gain access to the design view and VB code. I know its possible because ive seen it done a while back but im not sure how...

Ah, fantastic, i decided to close form1 when i closed form2 and then reopened it straight away, this causes it to update. Many thanks for your help Barry :)

ok, ill try and explain further :) Form1 is the meeting Form, here it displays all the detials about the meeting. including the peerReviewStatus field. There is a button called 'Close Defects', This will bring up form2 (defect form). Here you can close each defect off, when you hit the close...

Thanks, it kinda works, but only if as you said both forms are open. The problem is, you close Form2 to get back to Form1 (its on the close button command that changes the Flag from "1" to "0" or vice versa!) Shall i change this cancel command to another place?

Hi I cant seem to find the answer for this question. I have tried many types of refreshing and none seem to work. I have two forms (form1 and form2 (for ease of understanding)) I have a flag (flag1) on form1 (this indicates if the peerReviewStatus is open or not). When all defects are classed...

I have a database created, and I would like to have it so when a user loads it, all the menus aren’t there and neither is the access window, all I want is the form itself sitting on the desktop! is this possible? I can get rid of most the menus, except the main menu at the top and whole access...