Recent content by denileigh

All, Good morning. I've searched the forums for an answer to my problem but still being a novice I haven't found anything that makes sense to me. I have a main form that contains Work Order information. Job #, date, customer, PO#, etc. I have a subform with all of the detail of what to do...

It's not working. Is it because it's an ifthen statement being pulled down from a subreport? =IIf([InvoiceExpSun].[Report].[HasData],[InvoiceExpSun].[Report]![Text19],0)

Ohhhhhhhhhhhhhhhhh! TY so much! I'll try it!

Hello all, I have a report that has 3 subreports in it (expenses, hours, and costs) per job. I have them hidden and have it grouped by customer then by job as I've been requested to create a summary report showing the above in groups. It's running and calculating fine however in the group (by...

Plog - I need it to pull those cars in all three scenarios (A blank, B blank or both A&B blank) Will that if then work for that?

I've tried a ton - including giving them values and calculating them. I'll go play with some of those ideas. I think part of my issue is the if A is blank or if B is blank or if both A and B are blank. That last part has me stumped.

Thanks for your input however, after further questioning I've been told that there can be multiple work orders per purchase order and multiple purchase orders per work order. NOW WHAT?

Hello all, I have a database that we've been working in for years. We have a purchase order table (form, etc) as well as a work order table (forms, etc) for all the jobs in house. I've been asked to set it up so that up to 10 work orders can be linked to each purchase order. I went into...

Hi all, I have a query that I just can't figure out. We are a facility that works on rail cars. We have over 200 cars in house at the moment and the database has a daily production report in it with the status of all of the cars. I need a query that will pull out the "AAAA" and "XXXX" cars...

I need to do the same thing. Can you tell me how you did that? The table is in a sql backend and the form is in access. I need to open pdfs from the table list in access.

Thank you but I'm still a bit confused as to where to put that. Can't seem to figure it out. What would it look like for this path? Z:\Company\Quality Assurance\HCCPT Quality Assurance Program\AAR Documents\CFR 49, Responsibilities of Tank Car Facility, Section 180.513(b)

Hi all! I have an access front end database with an SQL backend that resides on the server. I need to add a field to the Employee table that links to a folder for each employee on the server that contains their training docs (word and pdf). I created a text field but don't know how to get it...

Thank you Paul - I'm reading all of that. We need the guys in the plant outside that inspect railcars to be able to add estimates into the database as well as access pdf files and such on the servers as they walk around outside.

Someone said it had to be web based. Pardon my ignorance but what does that mean and what program do you use for development?

We do have an sql backend. How would you recommend making it mobile?