Search results

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...

That fixed it. It was looking at the wrong column. Thanks

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...

Cbritgton, That makes total sense when you say it like that. I couldn't get the information I wanted from a query, but it was just me not setting things up right. I got it working now. Thanks for all the help

Thanks Gemma. That being said I am going to try to describe my situation as best I can, and ask that you tell me how you would go about getting the records returned that I am looking for. I have a table that has a batch number field, a waste units field, and a yes/no checkbox field for...

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...

Thanks Nigel. I managed to get it to work. I ended up putting the split files in a shared folder on the server as apposed to mapping its own network drive.

I am having this same issue right now, It doesn't look like there is much for hope for us judging by the number of responses haha. did you happen to figure it out?

Thanks Gemma I will give that a shot. In the mean time I have come up with another possible culprit. I have it running flawlessly on 3 computers now, but there is one computer there is a fourth computer that is a problem. It is the same computer I have been dealing with from the beginning...

I have checked the permissions related to the server drive. All of them are set to full access. I am currently trying to get this to work with only two computers. For a while the computer where the database was originally created and then split worked just fine, but the computer I copied the...

I understand where you two are coming from, and please understand that I find that these forums are a huge help. I could not complete many of the tasks I undertake without the help of the forum. The point I was trying to make in my previous statement was that basically, I don't have a choice...

MSRookie, The way I look at this forum is as follows, there are there are two types of people on this forum. Their are the people who know the answers to the questions and the people who are trying to complete a project and learn along the way (question askers). I am a member of the latter...

well sadly enough, at this point that is me. Building this thing from scratch.

That could be the case. How would I go about setting those permissions?

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...

Thanks for the quick reply. I am assuming by BE you mean back end. That all makes sense now that I think about it. Where would I go to learn the correct way to split the database? I am assuming I put all of the tables, queries and reports on the server, and use the forms to call those...

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...

PLOG, I figured it out. It was trying to display the product code as opposed to the description. The description started with A, but the product code started with C. When I used Like "C*" I got what I wanted. Thanks for the help Jason

thanks for the quick response. Is there any reason why this wouldn't work with the letter A? If you use the letter O it works great, but the word ALI doesn't work, and neither does just the letter A. It returns nothing. Thanks