I have a problem retrieving my Design Master. I regularly backup my DB onto a separate hard drive. And in doing so have lost my designing capabilities. I have tried replicating and retrieving the DM per the help section, but I receive numerous error messages telling me Error accessing file, network connection lost rollback error, etc. Any ideas would be greatly appreciated.
FT
I appologise but I am useless with Access but am trying to learn.
I have a datababse that we use to log calls onto, There are five members of our team and each member has thier own replica of the datababse. At the end of each day we have to re-sync our replicas to the design master.
It would be nice if we could put a button on the form we use to do the synchronization for us. Is this possible and how do you do it? bearing in mind that I am not too good with access so I need laymans terms.
TIA all
Hey, Happy New Year to all.
I have a replicated access database, and I want to move the design master to another computer. I have tried using the Windows 'Copy and paste' command, and the 'Save as' command, both result in creating a replicated database.
I have also tried chnging the design master status to a replicated database, but then I am unable to view any VB code behind the controls when I go to design view.
Can you help?!!!
Cheers, Adam.
I am trying to replicate a database for mobile working. When I attempt to 'create a replica' I get this error:
"MS Access can't convert to design master
Cannot make the Table "[TableNameHere]" object in tables container replicable."
The table in question is fairly large and has 248 columns and is linked to 3 other tables of similar size as well as 3 smaller ones. Got about 2000 or so records and set to cascade deleted and updated records. 248 columns should leave enough spare columns for replication though, shouldn't it?
Any suggestions as to what I should look for to fix this?
I have an application that when in design master shuts down when I attempt to open a certain form. I have traced the problem to a linked field from another table, by creating a new form and ommitting the said field, problem is its a required field!
If I copy the database (Backup) and run it as a replica it does not happen, if I then convert the replica to design master it happens.
Any suggestions please??
Steve
Hello I have a perplexing problem …
I have been using replication successfully for years. Recently the PC where my Design Master resided crashed taking the hard drive with it. No problems I thought, I used a replica to recover the design master and placed it on the new hard drive (the OS and Access was upgraded from 2000 to XP, however the Access 2000 file format was retained – there are still a couple of laptops with only W2000 software). I understand that moving the path of replicas or design masters is no no, so I proceeded to start from scratch and create a complete new batch of replicas based from the new design master.
Everything was going to plan UNTIL a replica was routinely synchronized with the design master. The design master reverted back to a replica. I recovered the design master again, everything looking fine until again a synchronization causes the design master revert to replica.
Next plan of attack to hopefully fix a potential corruption problem: create a new blank database, import all (non-system) tables, compact and repair, and create a new replica from scratch. From the design master, I created the complementing replicas and sure enough the Design Master again reverted to a Replica after a routine synchronization.
I repeated this “start from scratch” procedure, and the same results prevailed. I am at a loss especially since I verified that the hidden system MSysReplicas table had only two entries after the Design Master and Replica were first created.
I would greatly appreciate any ideas of where to go next with this problem.
Thanking you for your time.
I am using Access 2003. I have developed a split (front and back ends), replicable database. As I make changes to the design master, I want to either keep old copies of the design master or ideally, maintain the design master under source code control (e.g.:CVS). This would allow me to be able to retrieve older versions of the database. The problem occurs what I make a copy of the design master, or when I try to pull out of my source code control system (CVS) an older version of the design master. When I open any of these copies, Access thinks this database is a replica and will not let me make any changes to the design.
Is there a way around this problem?
Or am I trying to do something in Access that does not make sense?
Thank you for the help.
David
How to structure some MS Access 2007 Forms for the following scenario.
My table structure is as follows:
Product
++++++
ID (pk)
ProductName
...
Tag
++++
ID (pk)
TagName
ProductTag
+++++++++
ProductID (fk)
TagID (fk)
I want to have a main form that allows me to search for and displays a list of all products (and the dozen or so attributes for each product) that meet that criteria (I'm thinking a continuous form view of products).
So far so good. No problems.
Now I want a "tagging" form to the right of my continuous forms product list that is linked to the product which currently has focus. The tag panel should always show a complete list of all Tags. I want a checkbox next to each tag that I can switch on and off whether that tag applies to the currently selected Product. I also want to be able to add tags on the fly (without leaving the main form).
I think I have three forms in play :
Main Form
Product Form (subform to Main) my product search criteria is probably on this form header.
Tag Form (also subform to Main)
But with this approach I'm have trouble linking the two sub forms to each other. Actually, I'm having huge trouble figuring out how to display the list of all tags with a check box that when checked on and off creates / deletes a record in the ProductTag table and I really want Access to do as much of the CRUD as possible. I would prefer to avoid writing screeds of SQL INSERTS/DELETES on events. Am I asking too much of Access?
I have had to use my first crosstab queries.
I now understand that when opening and saving crosstab queries Access (2010) runs that query to ascertain the column names. Unless you hard-code them. Running the query takes at least 20 minutes.
I have hard-coded where I can, but one report takes arbitrary dates so I can't hard-code them.
I believe that turning off AutoCorrect might make a difference to whether the query runs - but I don't want to turn it off.
I have a sub form in DataSheet view and I would like to lock the design so that the User should not change the layout
Even when I set the property of the Datasheet “Allow Design Changes: Design View Only” users are able to unhide the hidden columns and they can also change the size of the column by dragging the column end line
Does any one know how to lock the design of datasheet ( I am using this sub form datasheet for data entry but do not want users to change the layout)
Thanks
Rahul
Dear all,
I have a table "Project Master Code", contains: Project code, Cost Code, Description, Budget Amount, Total Purchase, Left to Complete.
For each project, we enter all above field except Total Purchase. Total Purchase to be taken from Transaction table.
What I want is that, I want to creat a query based on Project Master Code table. I will call all field from Project Master Code and in Total Purchase column I want all Purchase from Transaction table.on based of Project Code & Cost Code.
thanks
mithani
Hi there,
Is there an event for a form object, which is triggered whenever any control in that form is changed/altered?
I have tried the suspect looking ones, but to no avail.
Thanks!
I'm going to make up names and values -- I'm interested in the structure.
Table ALPHA:
COLA DAT1 DAT2 DAT3
1 5 7 9
2 4 14 8
Table BETA:
COLA_IND DAT1 DAT2 DATN
1 a b c
Table CHARLIE:
COLA_IND DAT1 DAT2
2 d e
Table DELTA:
COLA_IND DAT1 DAT2
2 f g
Ok, the idea here is that the data in table ALPHA contains data with COLA a key such that selecting 2 would yield the data row "4, 14, 8."
Now, COLA_IND is a "COLA" key for table ALPHA (sorry, I can never remember which side is called the foreign key). So, from tables BETA, CHARLIE and DELTA, I can access any row in ALPHA based on the key "COLA_IND"
Here's the fun part. When I build my query, it wants to use an inner join on the keys from all these tables... In order words:
SELECT blah blah blah INNER JOIN blah ON (ALPHA.COLA=BETA.COLA_IND) AND (ALPHA.COLA=CHARLIE.COLA_IND) AND (ALPHA.COLA=DELTA.COLA_IND)
What I'm looking to do is expand BETA, CHARLIE and DELTA with the information from ALPHA based on the key COLA_IND. I don't think this is doing what I want.
Any comments?
Thanks in advance...
Hey,
I've got this problem and im 95% sure its going to need a query in order to achieve this answer im looking for.
I'm creating a Software Licensing Management db and its all working lovely. However my only problem remains is the graphical representation (text box within one of the forms) of howmany licenses are/aren't(doesnt matter if this number is a +/- number) available.
In order to achieve this answer I dont think you'l need the table structure of any of my tables other than these two:
tblLicenseInformation
License_ID
LicenseDescription
NumOfLicensesPurch
SoftwareOverview_ID
tblHardwareSoftwareLicense
HSL_ID
Hardware_ID
Vender_ID
Software_ID
AppEdition_ID
AppVersion_ID
SoftwareOverview_ID
License_ID
However I would like to add a column to either of these tables named 'Availability' or something similar which will show the licenses available.
I've tried a number of Update/Append queries but all have failed. I want this Available running variable held within the table due to it not changing to much of the current db design as i baisically finished the project and they asked for it! any ideas of how to efficiently achieve this will be much appreciated!
cheers
I have created a master & replicas and sorted out synchronisation across a VPN and overall l am very happy with what l have achieved (lots of thanks to to help l have received todate from this forum that has made that posssible).
I now have a couple of questions which are niggles rather than full blown problems.
THe first is my master keeps reverting to a replica version of itself, l press the reinstate master and it keeps it as the master for a period but it keeps dropping the master status. Firstly any ideas why ? and secondly how do l stop it keep changing?
Next every now and again synchronisation slows a relicants version down to the point that it VERY slow to open (almost like it is on a VPN itself not a local copy) No amount of synchronation from their end fixes it, however it would appear that a synchronisation from my end solves the problem.
Agani the two questions - any idea why ?
and how do l fix it ?
Hope someone can help me
AndyB
HI everyone, I have a Sales Invoice form with a Receipts subform showing what receipts have been lodged against that invoice. It works fine as long as there is one receipt or more.
The problem is when no receipts have been lodged and there are no receipts to show in the subform. When I open the Sales invoice form I get a "you entered an expression with no value" error, then the Sales invoice form opens. I tried suppressing the warning with DoCmd.SetWarning False, but that hasn't worked.
Anyone know a workaround?
There are total three tables tblInternal, tblExternal, tblCourses. Table
tblInternal and tblCourses is one to many relationship by reference foreign
key InternalID from tblCourses to tblInternal. If I just use these two table
to set up Master form and subform in ACCESS, you can in subform Field Linker
window of subform property Data tab select primary and foreign key to
generate link between Master and subform. So if you select user name from
tblInternal in Master form ComboBox, you can see the detailed information the
user relates to.
Same relation between tblExternal and tblCourses.
Now I want to merger tblInternal, tblExternal to list user name in ComboBox
by Union statement. But in SubForm Field Linked window I just see one primary
key from one of these two tables instead of two primary keys from each table.
How to solve this issue?
I can't get it to work in a subform. It works great when I just use it in a regular form.
I tried to break it down as much as possible.
Do I need to go into more detail?
This code is located in a Module
Option Compare Database
Option Explicit
Public frmName As String
Public ctrName As String
1st set of the Form Calendar
Private Sub CmdCloseandUpdate_Click()
Dim FormandControl As Variant
Forms(frmName).Controls(ctrName) = Me.ActXCal.Value
DoCmd.Close acForm, "frmcal"
End Sub
This is where the problem lies
tblPayEstimates Subform
Private Sub DtdRec_DblClick(Cancel As Integer)
frmName = Me.Name
ctrName = "dtdRec"
DoCmd.OpenForm ("frmcal")
Error ‘2450’
Microsoft Office Access can’t find the form ‘tblPayEstimates Subform’
Referred to in a macro expression or Visual Basic code.
Trying to learn VBA.
The above code is from a online teaching http://www.vtc.com.
Once again
many thanks
Hi,
We all know we're not supposed to duplicate data right? So was wondering how people deal with the deletion of Master records.
For instance let's say I have 3 tables.
tblSales
tblSalesSub
tblProducts
tblSales - lists the sales summary - stuff like SaleId, SaleDate, SaleTotal
tblSalesSub - lists the products contained within the sale.
tblProducts - is the Master list of products storing the product specifics
Now to prevent duplication of data I should just store the productId in tblSalesSub then reference that to tblProducts with an innner JOIN of some kind.
But what if the Master record gets deleted? The reference is broken and NULL values are returned.
How do you deal with this?
Don't allow deletion of these records?But just hide them when deleted?
Duplicate data by storing the product title and description within tblSalesSub?
Tell the user - tough cheese you shouldn't have deleted it should you?
Any other ideas?
Dan
Hello,
I am putting together a database for a charity and am having some problems. At present I am working seven days a week and my time for research is so limited that I can only ask here for advice since I have neither the time nor resources to seek it out myself.
We do mail shots to various trusts and businesses to appeal for donations. At present we have two large, bloated MS Works Databases (one for Trusts and one for businesses) that contain names, addresses and so on. I have taken on the task to make our mail shoots more efficient. My vision is that the majority of time should be spent searching out new business/trusts and organising events while actually doing the mail shoots should basically be done at the touch of a button (it won't quite work like that, but previously the actual mailshots took up about 80% of the time. I want to drive that number down)
Having no Access experiance whatsoever I set about creating a Database with twelve tables, one for each month. Each month would contain a list of places that we would "hit"
I then came across a problem. When I am searching out new addresses I would have to cross reference them on 12 different tables. This struck me as being impractical but at the time of creation I didn't have the foresight to create a masterlist. Although I do have the list on my Works DB, it would be useless as time passed since no more entries would be inputted on there.
I was hoping someone could tell me how I can put together a masterlist using the data I already have and maybe if possible setup the 12 tables in such a way that by inputting an entry on one of them will automatically crossover the name of the business to the masterlist without me having to enter it twice.
I realise this may sound confusing, and if i had more time I would research the answer myself but I am stretched to the limit and know too little about this application. I did try to take on a Lyndia (sp?) course but again I just don't have the time. If you have any questions, I will check back later to answer them.
I am using Access 2002 (but my DB is in Access 2000 format - so it says)
Thanks kindly.
I have a large database of Purchase Orders
Orders can be placed by people in one of 4 departments
I would like to automatically make 4 separate databases (so each department can access their own) from the master
Is there a way to do this?
Hi,
We have quite a large Db which always requires the updating of new features etc. I update some bits while my collegue works on others.
I was just wondering if there's a good way of "merging" the 2 Db's together? Is this the syncronising bit, or does that just refer to data?
Basically, we shouldn't update the same forms/ queries as we are assigned specific jobs so no they're not going to effect each other.
It's just that when we come together it's a case of "OK, what have you updated?" and we have to through each section, hopefully we've written them all down!
:o
Any suggestions as always, much appreciated.
Matt
Hi,
I have a form with a subform. In the subform (based on a different form) I need a button to close the master form. In the subform I need to find out what the master form is so I can close it. Since I use the same subform in multiple forms I can't really hard code the name of the master form.
Can someone help me?
Thx
Luke
I need help! I've set up a database with a subform that worked until recently. I get an error message that says: The LinkMasterFields property setting has produced this error:'Invalid outside procedure'
I had added a date and time stamp for when something gets modified it changes the date/time. I even backtracked and took all that out from tables, forms, queries etc. but the error keeps appearing when I'm trying to update my subform.
Thanks,
supan
Hello I have a small problem that seems weird. I have a form which displays a subform with all correspondending jobs for one individual. The problem is the sub form displays the main form information with the other jobs. Im trying to stop the subform from displaying the current mainform's job information. So it won't look like there are more then 1 of the same jobs to other individuals. Can someone help me with the correct method to stopping this. Thanking you in advance,
I'm working on recreating my church's records in access and was originally wanting to take people from the Visitors table and automatically move the to the Members Table (and same with Deceased & Moved), but after some searching found that's not really do able. So now my question is, can I have a master table that has everybody (visitors/members/deceased/moved) and then split that into different tables while keeping the main table (that way I can go into the main table and reassign the person)?
View 7 Replies View Related