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.
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
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.
I have a form that has a check box. If the box is checked then I would like the next field to be available for data entry, however, if the box is unchecked, then I wish for the next field to be grayed out and not available for data. I suspect that it is a simple bit of VBA, but I am not fluent in VBA and need help everytime, I find something new. Thanks for all your help.
Hello, I am developing one softwater in ms access for small scale engineering industry. I have created switchboad wich comes at the center of the ms access gray screen. I wanted to change this gray screen of ms access and replace with my own. How to do this? can I change this screen? Early reply on this is appreciated.
Hi, I'm running into a problem where parts of a Report are printing with a gray background. Not all of the report does this, just certain sections. Background colors aren't set to anything.
I did find this thread: http://www.access-programmers.co.uk/forums/showthread.php?t=16054&highlight=background+print+color
problem is.. the print IS from a report-- and I don't want to see a color on screen, I want it to NOT print gray.
I have a form that some fields have gray font instead of black. All of the properties seem to be the same as the other fields. The issue has to do with the 'Manage Sales Order' Form in the 'Products' Database.
I have a report that generates an in-house physical invoice for an event. On this report is a small section for a staff member to make hand written notes regarding when we call a week before the event as a final confirmation.
I want to have an empty check box in this section for the person to put a hand-written check. I tried creating an unbound check box in the report but it defaults to the gray fill of a null valued check box when printed.I tried setting it's default value in the report to 0 but for some reason I can't find a Default Value field among it's properties in the Property side bar. I did some research and thought that setting the Triple State value to No would solve this issue but it didn't.
How I can get rid of the gray fill when the report is printed? The field is completely unbound--this check box is purely for hand written notes, it has nothing to do with the database itself.
A2010 - on an existing form I have a few controls that I want to hightlight. I thought I would create a rectangle covering only the desired controls and then make the back colour a light grey. But if I do then I cannot see the controls. If I change the back style to transparent then the colour reverts to nothing and I'm back to square one.
It feels like I want to bring the existing controls to the font - but how?If I create new controls on an existing grey rectangle then it works fine.
how can i disable a textfield or two in a form when the textbox is unchecked also how do i add a default value for it while the textbox itself is disabled, can i get away with it by adding a default value on the textbox?
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.
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?
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.
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
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!
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?
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:
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.
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?
I have created a floating toolbox much like the floating toolbox you see when you design a form. I want my buttons to stay depressed the same way they do in a real toolbox. It must be possible... I just have no idea how..
I am a newbie at Access and I am currently learning it for my job...I have a database going and I am wanting to do two things and I can not figure it out for the life of me.
Little background, the database I made is a continuous form. I am wanting a command button that when pushed will put it in data entry mode, and when pressed again will put back in a 'view all' state. I know it is a simple If Then, but I don't know VBA very well =
Other thing, is I wanting to be able have button that when pressed will output to an excel sheet, right now I have it when it is pressed it asks me what kind of format I want outputted, and I want it automated to just go straight to excel.
