Search results

Hi, I have two backends on two different servers overseas. I have a button which synchings up the data. The only problem now is, it seems to corrupt the backends (without actually corrupting any of the data) So, now when i go into the backend (to synch up) it produces 73 (ish) messages about...

Hi there, I have a list box used as a table for the user to select a particular work meeting to view. Now, is it possible for the user to manually change the size of the columns rather than having to define them in the properties section? Many thanks

also, when i export a table ("workProductTable"), a new table appears in my table list called workProductTable_ExportErrors. Any ideas on how to prevent this table appearing if there are errors?

I have looked through the forum, and cant seem to find the answer. What i want to do is export all my tables to 1 excel spreadsheet. Im using the code DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel7, "workProductTable", "C:\Documents and Settings\My Documents\My...

actually, i managed to link them another way (as the only way i knew was to split it again) so it was kinda my own mistake, many thanks for your help :)

thanks, a second question, on my backend, i want have set a password so only i can gain access to the backend data. But when i try and relink the tables (and ive read that i should be prompted with the password screen so i can enter in the password and it stores it for future use) but currently...

This may seem like a silly question, but I can’t find the answer to it on this forum. People only say 'Remove the table links' but never how. I can’t seem to be able to remove the table links completely, so I only have one database file (no backend or frontend). I can’t seem to do it though the...

unfortunatly, if i try and relink the tables, it comes up with invalid password (again, its trying to access the data on the tables (backend) but cant as there is no place to enter the password) and no area to enter a new password. Any ideas?

I managed to password protect my backend (as the backend is on a server and anybody could access it) so i have it password protected so only i can gain access to the data. Now, when i try and access the backend from the front end, the frontend prompts me that the password is invalid (indicating...

Thanks Bob for that. I shall try this out and see if it works, if not, then i might take you up on that offer namliam.

i know this is probally a silly question, but how do i delete all the links from the front end to the back end? and how do i add new links in?

Ah ok cool, but where can I change this to the full UNC path? As when I split the database using the database splitter under 'Database Utilities' I don’t get the option to change it, but only save it to the server (where it picks up the letter drive) many thanks

I have a database that is split with a backend of a server, and a front end on each PC using the database. Normally, the server the backend is on is mapped to drive ('W'). Although, some people have mapped this server to another Drive (say 'X'). If the people who have it as mapped 'X' try and...

lol, true, but as the backend of the database is going to be on a server, so i was hoping that it could automaticly synch up through some sort of method :(

you can put that code in the Onload event so everytime you open up the form, it will check that the data is present or not and disable/enable the button as approprate. Although, as soon as you press the import button (if the import is enabled), the button should disable aswell. so add this to...

Set db = CurrentDb Set r = db.openrecordset("Table") r.MoveFirst Do Until r.EOF If isnull("anyfield")Then importbutton.enabled = true Exit Do else importbutton.enabled = false Exit Do End If Loop something like that, it will check the table, and if there...

actually, i forgot, if you put the top code in to the combobox onchange event (where you would select either "Yes" or "No") then that will work!

thats the thing, ideally, i would like the PC to be off. Just out of interest, how can i create a windows scheduler to schedule a synch time?

if you have continuous forms, then in theory the Oncurrent event property could would be the closest, but im not sure if you will need to refresh the form to do, but namliam may be right, it may not to anything. If you have a button that will go onto the next record (say a next record button) a...

something like this will work: if field = "Yes" then button.visible = true field.visible = true else button.visible = false field.visible = false end if the top field being where you select 'Yes' or 'No' and the comand and field being the opbjects you want to hide.