Search results

Hello, My database has been split, and the BE is on a server. I have about 15 user terminals using the database front end through out our facility. I need to add a column to one of the tables in the BE, but it It keeps telling me it is read only because the database is in use. Is there any...

Hello, It's been a while since I have posted on this forum. I am running access 2016, and am really not a pro a making these databases. I am attempting to make a database that will work as a preventative maintenance schedule for our equipment. What I would like to do is have the "PM" (record...

Hello, I am trying populate a record with the click of a button. I have attached a copy of my DB. You can see I am just trying to work the little bugs out at the moment before I put it to use. This is what I am trying to make happen. As you can see the DB is designed to track and schedule...

Hello guys, I haven't posted in here in quite a while, but you were a big help in building my last database, and I thought I would ask for help again. I'm running Access 2016, and am trying to build a database to help manage our Preventative Maintenance program at our factory. My first...

Hello, I am trying to compare production scrap rates. I want to compare the the scrap of a current run of a product vs. the yearly scrap rate of the same product. I currently have a table that contains the data for every run of product during the year with the scrap rate for each run...

Is it possible to create a line or bar graph as a report in Access 2007? If so, how would you go about it? thanks,

Hello, I am using access 2007. I have checked my table, and the record is only entered once, but when I run the query to sort the table, it returns double records. The table would look something like the Column 1 (name) Column 2 (w.o.) Column 3 (boxes). There would be a name in the name...

Hello all, I am running Access 2007. I have a report that is based on a table. The report show the productivity of different employees. I want to use a form to pull the same report, but only display the employee that is selected on the form. I have made it work using a text box, but when...

You guys have been great so far. I am really getting this database working like I wanted it to. I am working on the plant maintainence side of the database now. I want to be able to schedule PM's (preventitive maintainance) on my machinery. Some of them are done once a week, some are once a...

I am calling for a little help once again. I have recently spit my database I guess you would say successfully haha. I am trying to add another table to the database. I thought it would be straight forward, just open the backend database and add the table. The problem I came across is that I...

Hello, I am running access 2007. I have created a database. The database has been split, and is mapped to a network drive on our company server. I then copied and pasted my front end files to anther computer on the company floor. I also mapped that computer to the network drive. Using...

hello, I am currently running a database using access 2007. The database is only used on two computers, and the access file (the whole database) is stored on a server. The database us accessed simply by opening it from a shared doc location. In other words the database is not split. I plan...

I need to know what to enter into the critera area on a query. I am trying to include all of the records that have a certain word in the discription field. To explain, the discription field contains different part numbers, some start with A and some start with B. (a12, a45, ect.) I want to...

I am really green when it comes to VB. I have written some code to print a report in Access 2007. When I press my command button, the print properties window comes up just like it should. If I select print in the print properties window, the code runs fine. But, if I select cancel, then I...

To start I am using Access 2007. I have a form that has a combo box on it as well as a control button. When the button is clicked access will open a report, and print the record matching that of the selection in the combo box. That is all well and good. However, I would like it to also open...

I have a report that works from a query. The report has three colums: date, cutter1 and cutter1 total. I have made a form with a view button that has two fields. One is the date, and the other is cutter 1. I would like to view the report based on the records that match the date, and the...

I want to print labels when the enter button is pressed on a data entry form. I currently have my database doing that successfully, however, the database prints one label for each record in the table that is tied to the form. I want it to print a sheet (20) labels of the record that was just...

To start out, I would like to say hello to everyone. I just joined the forum. I have built a small database in access 2007 (my first time). It works, but not as well as I would like, so I'm trying to refine it. I am trying to do it the correct way this time as opposed to making it work which...