Key Database, Need Help With Delete And Add Buttons
Jun 3, 2005
Hello
I am planning a key database
I have planed to use access and visual basic.
VB to add and delete keys.
Access to do the rest.
Is this a good solution? Do you have a better one, pleas let me know.
I need help setting up the delete and add buttons, I am bad i vb.
And I need help with the Delivered button, when I push the button I want it to delete all the information on the page. But print a backup or save it as a file, do you have a good idea.
When I press the “add key button”, I want I to add a key.
If you have 3 keys, and press ADD key, then it adds a 4 key and it must be a scroll window. Then I can choose the key I gave him
There is a image of the plan I am having.
View Replies
ADVERTISEMENT
Apr 26, 2006
i've created a dap that connects to a sql server database. It was working at one point but I've been moving the data around from server to server and finally ran into problems using the dap. The dap is used to hold information about different agents that my company writes business for.
For reasons unknown, the dap can view the records in the database, but cannot modify the records or create new records. The new & delete buttons in the navbar are gray. All the textboxes have readonly set to false.
I can use query analyzer to insert and delete records using the same user//pass as the dap. Anyone know why I can't modify this database?
I've recently tried exporting the database to an access file, deleting the sql database, recreate the sql db, and import from the access file.
View 2 Replies
View Related
Feb 27, 2007
Is there a way to delete the borders from a form? You know the ones from the bottom and right hand side which have the buttons on for you to skip between records?
Also the one on the left which has the arrow in the top corner.
View 2 Replies
View Related
May 30, 2005
Hello everybody,
I’m new here and I have a question for you..
Is it possible to place round buttons or oval buttons on your forms instead of the normal square ones?
Greets,
Tom
View 2 Replies
View Related
Mar 20, 2006
I have an access database that is used as a front-end application to a sql server 2000 database. Users have adequate permissions to access database and functionalities but a few are receiving the following error message:
"Connection Failed. Invalid connection string attribute."
View 4 Replies
View Related
Feb 25, 2013
I'm trying to build a database of car dealers while using Access 2010. They only sell three types of cars. Once the user select which car dealer they want to look at, I hoping to populate three radio buttons based on values from the database. From what I've read, it seems that the radio button, while using the option group wizard, that the radio buttons are meant to populate a database field, rather than having the database record populate the radio button.
how to do this, so that I am able to show three radio buttons in my form to show which three types of cars this specific car dealer sells?
View 5 Replies
View Related
Apr 18, 2015
I have been writing a database for a medical facility. Currently, I have a box to check if a patient in the database is admitted. What I would like to do is create two radio buttons: one to admit and one to discharge.
When the patient is discharged, I want the data in some of the fields on the form(s) to clear, but not all the fields.
I realize the I will need some scripting here.
As an example: the fields for Unit and Room number will clear upon discharge. As well as fields for diagnosis and informed consent signature located on another form within the same table.
View 3 Replies
View Related
May 8, 2007
Is it possible to delete an entire seperate database from within a database via code after an uodate procedure has been carried out on a click event of a commad button, what would the code be to acheive this if its possible??:rolleyes:
View 3 Replies
View Related
Mar 17, 2006
Is this possible? I can't seem to find this q anywhere here so I thought I'd post.
I changed the colour of my form to white, but the Navigation Buttons at the bottom and the command buttons that I 've added stay at the default grey.
Is there anyway to change this? I right-clicked and tried changing it to white through the properties but there's nothing there that does this.
:confused:
View 2 Replies
View Related
Mar 17, 2006
Is this possible? I can't seem to find this q anywhere here so I thought I'd post.
I changed the colour of my form to white, but the Navigation Buttons at the bottom and the command buttons that I 've added stay at the default grey.
Is there anyway to change this? I right-clicked and tried changing it to white through the properties but there's nothing there that does this.
:confused:
View 4 Replies
View Related
Jan 23, 2008
I have tried to rename or delete in MS Explorer, but this just creates confusion. The databases still show up in bits and pieses on various screens. I've purchased 2 additional how to do it books on MS Access 2007 and find nothing on deleting or renaming an entire database and all objects or references to it. Does anyone know the magic bullet?:confused:
View 3 Replies
View Related
Sep 23, 2014
There is a way in order to auto delete a database after e.g. 7 days ...
View 11 Replies
View Related
Apr 13, 2007
I have recently gotten a handle on ASP and found it to be a very powerful tool.
I am wondering if there is a way to design a page where I can list my database tables, and by using a command, I can use asp to do the following.
1. Add or delete table
2. Add, delete, or update fields within the tables
for instance: rename a field 'PersonName' to 'MyName' without change the original values in the field 'PersonName'
I have searched all over the net and could not find information on this subject.
Thanks in advance.
View 3 Replies
View Related
Nov 1, 2013
I just upgraded to Access 2010. I can't delete or paste database objects in the table, form, query lists, etc.. Is there a setting that allows this?
View 6 Replies
View Related
Aug 16, 2013
I have a database with a main database that has 2 related tables...my problem is that i only keep data that i really need, in the main table. My problem is that i sometimes need to go back to old data that i erased. so i have to keep old data too. but i can;t on the same database. so i need to move the old records from the main table and all the related data to another database that will keep all the erased data, so if i need to find something i will search on the "deleted records" database.
View 6 Replies
View Related
Nov 3, 2014
I have a database that is used by managers to log activity of staff. We wanted to allow staff to write to the DB, but not allow them full access. We decided to accomplish this by adding a VBA function to an Excel sheet that they already use every day. It allows them to select a description, start time and end time and writes records to a database containing just 1 table.
The database used by the managers periodically runs an append query, and then a delete query to update with details of entries made by staff, and then clear the table to avoid duplicates during the next append.
I'm sure those of you with experience can already guess what's been happening and are shaking your head right now. It seems like entries made while the append query is running are being deleted when the delete query runs. So potentially I append 4 records, but delete 6 as 2 new entries were made before the delete query ran.
Is there a way to delete only the records that have just been appended? Or is there a more acceptable way of achieving this without using a delete query?
View 3 Replies
View Related
Jul 26, 2007
I wrote the following statements to update a SQL server database:
Dim MyDb As Database
Dim MyRs As Recordset
Set MyDb = DBEngine.Workspaces(0).OpenDatabase("AMD", dbDriverPrompt, False, "ODBC;DATABASE=AMD;DSN=Remote")
Set MyRs = MyDb.OpenRecordset("SELECT AllAttendanceEvents.* FROM AllAttendanceEvents ORDER BY AllAttendanceEvents.EntryTime DESC")
MyRs.MoveFirst
While Not MyRs.EOF
MyVal = MyRs!EntryTime
Debug.Print MyVal
MyRs.Edit
MyRs!Ix = 50099
MyRs.Update
MyRs.MoveNext
Wend
When it execute the red line statement, it generates the error:Cannot update. Database or object is read-only.
This error is generated isnpite that I already checked the boxes: SELECT, INSERT, UPDATE, DELETE in the Permissions page of the tables?
Please advise.
View 3 Replies
View Related
May 6, 2014
All I am trying to do is insert to have a form with a "Delete Record" button on it. The problem is I don't want anyone to be able to delete a record, I would like someone to have to insert a password to confirm the delete.
View 13 Replies
View Related
Apr 2, 2007
I have a query based on two tables, joined on one field (this field is the primary key in Table A. Table B doesn't have a primary key). When working inside this query, it gives me the option to delete records. However, when I try, the row disappears from the query but then if I save and close and either re-open table A or the resulting query, that record is back. It doesn't actually delete. If I go to table A directly and delete it, it's gone for good.
How can I make it so that when I delete the record inside the query it actually deletes? And if that's not an option, can I make it so that it doesn't seem like I can delete records inside the query so that people don't make the mistake?
View 2 Replies
View Related
May 19, 2011
I have two simple tables. I want to delete the records from Table1 that are on Table2. I've created a select query that gives me what I want but when I change to a delete query, I get this message: "Unable to delete from specified tables"
I think my problem has something to do with security but I can't figure out what to change.
View 13 Replies
View Related
Feb 21, 2005
i have constructed a switchboard/main menu and have set up buttons which link to forms. i have also made a 'return to main menu' button which does as it says, the only problem is that after going back to thge main menu both forms are now open...any ideas on how to stop this problem
View 12 Replies
View Related
Feb 22, 2005
how would i get a button to be able to delete a record that is present on screen?
any help would be brilliant :confused: :confused:
View 1 Replies
View Related
Mar 16, 2005
I have been making some custom buttons and noticed that the size of my db went up 360kb after I added two buttons. One button consists of two images and the other button one image. The original file size was 2kb for each image. Is 360kb a normal increase in db size after converting images to buttons?
There might be a hefty price to pay, in db size, if I get carried away and add my "up market" buttons to all my forms!
View 6 Replies
View Related
Dec 19, 2006
Hi everyone,
I am trying to create a button on a form that will export only that record. On the command options I do not see there being an option to do such. Can anyone help? Thanks. I would like to export to excel or anything that will capture what I am looking at. I have noticed that Yes/no boxes do not export to excel?
View 3 Replies
View Related
Feb 13, 2005
I have a form that's unbound (Music) with a subform (Arist Info)that is bound. This subform also contains two other Subforms (bound).
Their names are (Album Info) and (Song Info). The subform (artist Info) contains some pagebreaks, which I'm trying to use to bring up
the two other subforms .The cmd buttons used to control the pagebreaks are located on the main form (Music). My problem is with the third & fourth cmd buttons. I can go back & forth nicely with the first two, and even go the the third. That's were the problem starts. I can't go back to the secound or first from the third or go to the four. The VB code haults and the GoToPage line is highlighted. The code use on the on click event is as followed:
Forms!Music.SetFocus
Forms!Music![Artist Info].SetFocus
Me.GoToPage 1
The only thing that changes between all four of the is the page#. I hope someone can help me with this, it's driving me crazy not knowing what i'm doing wrong. If you need to look at a smaple DB there's one on a post called "Problem dealing with macros". I just posted this one a few days ago.
Thanks,
Rich M.
View 9 Replies
View Related
Apr 7, 2006
I'm a bit tired of the buttons I have been using both default MS and my custom ones. I'd like to find some more interesting versions that I can use and have been searching on google etc but the options are limited. Does anyone have any favourite links I can follow?
View 1 Replies
View Related