Search results

Unrelated to the thread title, but no one responded to my other post so I thought I would see if you know Minty, because your my guy. I am having trouble distributing my split database. I split the database, have it on shared mode, made the shared folder a trusted spot, and both me and my...

PS: Sorry Doc Man, as I posted earlier I do not know how to create new posts/threads

I split the database, have it on shared mode, made the shared folder a trusted spot, and both me and my co-worker have read/write permissions. Why when my co-worker tries to open it,while I have it open, she gets a "already in user" error. If I don't have it open then she can get in, but then...

My data is really rough because some S/N are the same because the way workers deal with returned parts they just create new records for them with the same S/N. I need to find a better way for the workers to input units that gets returned. I just realized I have no way to really pull what...

Thanks. I attached it

https://vector.leidos.com/sites/SS/Lists/Announcements/Attachments/4/Q.png I attached a link to the image.

I get a nambiguous outer joins error. Both data types are the same

Current SQL view. I already have them linked with serial numbers from Depot Contract Report but want to link the dates from AH Supply Depot to dates in Repair table, and only show field diagnostic from those similar dates SELECT [AH SI Depot].SerialNum, Assets.Unit, [AH SI Depot].Received...

I have duplicated Serial Numbers in a Repairs table along with dates received. I want to only pull info from a certain field( Field Diagnostic) in that repairs table where the received date is the same as the date I have in another AH Depot table. What relationship or joint properties would I...

What are the limitations of a front end database. Can tables be directly edited from the FE?

I should gain access to shared LAN folders soon. I am under the impression I just save my back end there, email the front end to the dozen users that will be using it. Have them download it and it will all work fine. I know it cant be that easy. What problems will I face.

For some reason I cant figure out how to create a post so info on how to do that would be good to, but back to splitting databases. I just split a database and would like more info on where I need to store the back end. Do I need to ask my supervisor for contact info to our network administrator...

Thank you again. I completed all the fields I wanted in my query and am ready to explore the various ways of email :)

You are the Man! I also changed all my field names so they follow your advice. That query worked so now I see all my SerialNum values in that field, and the date I received them in my other field. How would I show calculate a third field to find the total days, and even more complex send a...

Could I still format a new calculated field for total depot days in that Querie? Also I tried running that Querie you instructed but I am new to code and got a error message for having characters at the end of my SQL statement. This is what I had typed(I also tried replacing -20 to =20)...

I am creating a database on using serial numbers on inventory. We receive back certain defective inventory and manually record those dates. I want a automatic reminder email to be sent to the repair people when inventory has been in repair depot for 20 days. I would imagine in one field I put in...