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

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...

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...

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...

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...

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...

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...

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

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...

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...

Hi i have another fairly major issue that i need to fix asap. Heres the code: Dim statusFlag As String Dim response As String Set db = CurrentDb Set r = db.OpenRecordset("defectTable") r.MoveFirst Do Until r.EOF If Forms!afterDefectViewForm2.flag1 = "1" Then statusFlag =...

Hi Sorry to be vague in the title, im not completely sure what it falls under. I have an issue that in theory, should work (I think) but its not. I have been sitting here for the past few hours pulling out my hair thinking hard to why it’s not working. My access isn’t that great so im sure the...

Hi there I believe what i want to do is fairly tricky. I have a defect form where the user can enter in defects and click 'ok' to save the record and goes to the next free record for another defect to be entered, while an auto number is generated for the ID. You can also cancel out which wont...

Hi there, i have a master reset to delete all the data in the database. Although, as there is a username and password entry to get into the admin module, i wish for one entry in the table participantTable to not get deleted (to save one password/username so its possible to log into the admin...

Hi I have a subform on a form. All the fields on the form and subform are locked and not enabled. I have a amend button which should unlock and enable the fields on the form and subform, although, i can unlocked and enable the fields on the form, but cant seem to do it on the subform, the code...