I made a little Access app for a friend, to do his invoices. Access wouldn't allow me to copy the db to a CD, but advised me to convert it to a Master. I followed all the instructions (honest!). Afterwards, I could burn his db to a CD and, on his computer, it opened but wouldn't allow edits or new records - not terribly helpful for an invoicing program :eek:
Since then I've tried creating a new admin in his name, re-setting all permissions, blah blah ... Basically, it looks like there is loads of help on securing a database but very little on un-securing it enough to be transferred to another PC!
The dang thing persists in allowing everything except edits & additions :confused:
I can't find out how to convert it back from a Master to ... what, a slave? :p
Even so, that wouldn't be the answer coz I'd be back at square1.
I use a PC running XP and Office 2003. My invoice-less friend has a PC with Win[NT]2000 and Office 2000. I converted the database to Access 2000. I am way out my depth here, but hoping you Access swimmers will be able to advise :cool:
can anyone tell me how to stop additions and edits on a particular record in a form, plus the subform that the main form contains, im trying to put the event behind the change of a text box, shipped date, so when its changed you cant add or edit the record which is the order.
i opened up my database this morning and it has been working fine all day, suddenly where it is located a copy of my database has been worked, and the original when opens shows nothing, anyone knows what happened?thanks
I have a table that collects training information for our company. Some training is limited to one or two employees and that is easily entered by using a form linked to the table. However, some training is mandatory, company-wide training that all employees must attend. How can I add a record for each employee reflecting this training most efficiently? Is there a way to do a mass update?
Long time ago some computerdude made a database for my dad so he had a place for his customerinformation. When I open the file on his computer the file sort of "start" or "run" - there appears a little window where you can click buttons like "find customer", "remind me in two days" etc. That's how it always has worked and how it should work.
We have bought a new computer. We want a new database for me, where I can type my customers in the exact same way as in my dads access file. I have managed to import all the tables etc. without any data, BUT
I CAN'T GET THE DATABASE TO "RUN" OR "START" WHEN I OPEN THE ACESSFILE! HOW DO I GET THE LITTLE WINDOW WITH THE BUTTONS TO APPEAR IN THE SAME WAY AS ON MY DADS COMPUTER?
I only get the tables and the kind of "edit mode" when I open the program.I have tried to change the securitysettings, so access dosn't block any macros.
I'm not sure if there is an easy way to do this...... Maybe someone has run into this problem. Have a DB.....Did a split...BE is on the server "F" drive.. fe is on stations. I retained a full copy of the DB NOT split. I still wanted to expand it. So now I have problems by working this way..I have not altered the tables that are on the "F" drive.. But I have added more tables to my unplit version. I need to copy the tables and info from the BE on the server BACK to my full DB. Then split it again. IS there an easier way??????????? Thanks
I have a customer who is concerned that their access database may be copied and used by a competitor. I have told him to set up passwrods for all users amd hide the system file which stores the password info so database won't open off site if copied. He doesn't want to do this though. Is there any other way, possibly by encrypting it?
Hi! I'm relatively new to Access (2003) . I had to modify a shared network app so I copied it off and renamed it, made my mods and everything is fine. I then went to another app that connects to the original app to obtain data for display and synchronization, modified the call to open the new app including the new mdw. When it hits the new mdw, it can't open it because it says it's being used exclusively or the workgroup file is missing. It's not being used exclusively and it doesn't appear to be missing. The network path is correct. If I use the mdw from the original source app, it works fine. Please advise! :(
I want to have a dropdown box in a form but allow additions to be made, but after they are made, instead of them not showing up in the box like usual, I want them to become a part of the list. Plz help! Thanks
I have a report in my DB that displays the results of several queries. How can I have the information displayed on my report entered into a table as a record when the report is generated?
I'm trying to add records to a junction table based on additional record added to one table via form in the many to many relationship. Junction table = ClientAssociation Main table = ClientMain (qry_NewClientNullAssociation identifies new record added) Many to many table = Associations
I'm trying to do this upon clicking a command button that then opens ClientAssociation based on Client_ID. Then allows user to select mutliple associations (Asoc_ID) for Client_ID.
Here's what I have - I'm new at this...
Private Sub ClickAssociations_Click() On Error GoTo Err_ClickAssociations_Click
'Open recordset with new client records Dim db As Database Set db = CurrentDb Dim recClient As DAO.Recordset Dim strClientID As String
Set recClient = db.OpenRecordset("qry_NewClientNullAssociation", dbOpenDynaset) 'Loop through new client ids Do While Not recClient.EOF strClientID = ClientMain.Client_ID
Dim recAsoc As DAO.Recordset Dim strAsocID As String
Set recAsoc = db.OpenRecordset("Association", dbOpenDynaset) 'Loop through asoc ids Do While Not recAsoc.EOF strAsocID = Asoc_ID
'Open junction table and update records Dim recClientAsoc As DAO.Recordset
Set recClientAsoc = db.OpenRecordset("ClientAssociation", dbOpenDynaset) With recClientAsoc .AddNew !Client_ID = strClientID !Asoc_ID = strAsocID !CheckBox = False .Update End With
recAsoc.MoveNext Loop
recClient.MoveNext Loop
Dim stDocName As String Dim stLinkCriteria As String
I have a report in my DB that displays the results of several queries. How can I have the information displayed on my report entered into a table as a record when the report is generated?
I have been searching and can't seem to find how to solve my problem. I have a sub form that allows adding new rows to a database. The detail contains a combobox and a few text fields. When I enter data everything works fine. However when I accidently tab into the next row (new blank row) and then try to get out of the form without adding a new row I get an error about "Index or Primary Key cannot be null" or something like that.
It is very frustrating because I can't exit the form until I add data to the new row and then leave without tabbing to much (thus creating another new row with no data).
How do I trap the new row and only allow the insert if it has data in it?
I have a form which acts as a search function for users looking to amend existing records. This is based on a query, where users enter a parameter (PolicyNumber) and this returns only the records which match the PolicyNumber in a form view. I have also added basic navigation buttons to move between all records with the same policy number. I have a problem in that I can't disable the option to add a new record in this form once people navigate to the end of the records.
The user clicks a 'search' button, manually inputs the policy number, and the records are returned in form view. The code for the button is as follows:
How I can disable the addition of records in this? Also as a sidenote if no records are found I would like it to display a MsgBox, but despite trawling the internet have been unable to find a solution I could get to work.
While I was trying to test one of my forms (which was NOT working and I had to totally redesign it), I somehow created a bunch of stores in my Store Information table...some with no names, some with the first letter of an existing store, and there was even a duplicate of the store which is creating a problem now because some products exist in Store 1A and others exist in Store 1B.
I've created a query to identify the wayward products and am changing those. I'll delete that store then.
My issue is...can I set it so that the ONLY place a new store can be created is in the Store Information Input form? That if someone makes a typo when entering products, it doesn't create a new store?
So I have this killer report that took me hours to set up. I run it daily and it is great.
I now need to filter it slightly for 1 specific user. So what I did was I copied the query and renamed it. I added the filter I needed. But I don't want to have to re-create the report. Even though I know what I need it will take quite a bit of time to recreate it.
Is there a better way? Can I copy the report (using the same query) but add the filter on the report side?
i made an attendance db for work and got it to work. i then copied it and made two more for years 2 and 3. Years 1 and 3 work perefectly but for some reason the year 2 db won't allow me to write the data.
this is driving me nuts as i have already spent a few hours putting the students in and their course selections. i've tried making the forms again and as soon as i use a joint sub form to get the students first name the problem occurs. i've looked at the properties of the forms and they allow edits etc..
if anyone is feeling kind and has a spare moment, could you let me know why it doesn't work.
I have a form with a duplicate record button to allow records to be copied. I used this code (I think from Allen Browne), but it only copies the last record in the recordset?
If Me.Dirty Then 'Save any changes Me.Dirty = False End If If Me.NewRecord Then 'Check there is a record. MsgBox "Select a record to duplicate"
So i have a union query pulling together about 3,000 records from other queries.
I arranged all the counts and data I need to fit onto one page, but the report is copying that page (minus the header) for each record in the union query. I'd much prefer a one page report rather than a 3,000 page report.
Why does it do that? All I want is a one page report, how can I make that happen?
I've got a database that allows all users to review an address register. If they find errors or mostly get updated information they have another form they can fill out to make the recommended changes. Only I have access to the main DB to make the change permanent.
The question I have is there a way for Access to send me a notification that someone has requested the change?
I know that sending an email is doable - in Access. However, that's not an option for our network here. I was thinking something along the command prompt "Net Send" command. However I've not been able to get that to work by itself - let alone within Access...
I have used VB code in the past to store what PC is using the database, I could modify that to alert me whenever I open the DB up from my PC. But I was trying to get away from having to open this particular DB up every day and check for changes.
I want to allow users of a database to view data through a form but not to edit or delete it. I have set Allows Edits, Deletes and Additions to "No", but this causes the record-finding combo box I have to search for records to stop working. It works again if I enable Allow Edits, but then users can edit the data through the rest of the form. Is there a way I can allow edits to the combo box but not the rest of the form?
i am relatively new to databases so this is a fairly basic question.....
I have a form. Within this form all records are locked as i do not wish users to change details. However i am told there is an option allowing the editing of existing records upon request. is this true?, as it would improve my form greatly
I have a db where a planner inputs a commit date. The problem lately, is that the commit changes day to day before the part if filled. Management is looking for a way to count the number of times a commit field has been updated? Is there a better way to do this? I have minimal VB knowledge. Please help!
I have a check box field in table, i want this field to be work as if once checked cannot be unchecked again... no worries if done through queries, vba etc
We have 3 different sizes 1x3 2x3 4x6..I want to make 3 separate forms that have multiple sections that can be chosen.Upon Request I can Supply each separate Label with arrows to show what fields need to be changed for each Sales order.For the 1x3 Labels we Make:
1. ETL - We change model # - We Change if the Labels Says Dry Damp or Wet Listed.
2. MISC. -One Plain Txt Box that can be edited in the center
For the 2x3 Labels:
1.Box Labels -Customer -Item -Sales Order# -Shipping Location (For the Box Labels I was thinking I have a Table that holds all this data and all I would have to make is a Query then a form)
2.ETL -Change Model -Wet Damp or Dry 3.CSA -Change Model -Change the Wattage (3 Different Places) -Wet Damp or Dry 4.MISC -6 Text Boxes (From top to Bottom not side by side)
4x6 Labels: 1.HID Box Labels -Item -Watts -Color -Medium or Mogul Based
