Search results

Pat, I plan on making the changes to database after hours, but I also know that asking everyone to log out of the database before they leave will result in about a 60% success rate, and I'm going to need to be able to get them logged out when they are not here.

okay, so no short cuts haha. How do you go about kicking a user out of the database. I haven't done that in the past.

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

Sounds like it should work then. I'll dig into it more. Thanks for the help guys

DBguy.. Thanks for the response. I'm not familiar with APPEND queries, but I'm sure it is something YouTube can help me figure out. Will the Append query still allow me to keep the old record? I want the completed work to be searchable. Thanks again

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

Arnelgp, Thanks for this, I looked through it, and it basically does what I want. I will need to modify it to give me the correct date I think, as it currently just give the completion date. I really struggle with understanding the code, but I am going to pick through it, and I think I will...

Mark, I think I got it, that makes total sense, limit the possible entries in the form instead of the table. Thanks for that.

Moke, forgive me ignorance, but what option would you use to get away from using the lookups the way I have? Jason

Thank for the help guys. As you can see I know nothing when it comes to writing code. I try to use the standard stuff inside Access as much as possible because it is all I know. Do you guys have any suggestions for a good place to learn to write VB. I'm talking starting from the very very basic.

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

Very good points Mark, I will take these into consideration as I move forward. I'm pretty new to this, and sadly, right now, just getting the checkboxes to mark true with a button is my biggest hurdle.

Thanks for the response. I'm going to try to tackle the first one first. I have built the basic tables of my DB, and am working on testing the portion that re-schedules the work. Would I do this with VB code, or is there a way to do it inside Access. Do you have a sample of the code? Thanks

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

thanks again, I knew it would be something simple like that, but I had no idea where to look to figure it out other than here. Is there a website that has examples of stuff like that, that is easy to access?

Hello again, I am working on this exact situation again, except, I am using text fields as opposed to numeric fields. I thought I could use the same code, but it is not working. I am assuming it has to do with the fact that the fields are text fields, and not number fields. Can you please...

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,

Figured out how to post the SQL. here it is SELECT tblEmployees.First, tblPackerEntry.WorkOrderNumber, tblSku.Description, tblPackerEntry.NumOfBoxes, [NumOfBoxes]*[PackageAmount] AS [TOTAL PRODUCTS], ([TOTAL PRODUCTS]/[PackingTime])*60 AS [TOTAL PACKED], tblPackerEntry.PackingTime...

Thanks for the help. How would I go about posting the sql?