Search results

Thanks Paul!

I have a situation where I'd like to look up a query that has a date field, along with an estimated hours field. This query may represent 20-100 records. I'd like to sum them up the estimated hours by date, then loop through the sums in a recordset. If the sum for a given day exceeds X, I...

Thank you soo much for posting this....I just had this exact issue in Access 2013. very frustrating!

Scott, did you eventually can write access to it? If not, did you add your own linked "sister" tables?

Pbaldy, That is an excellent point you bring up about linked tables. I can see that working in certain cases, where fields are lacking. The instance for me that started this thread is the inability to import estimate or project level information into the program. We are working on a web...

I've had experience with 3 out of the box software programs that used an SQL back end. 2 of the 3 allowed an open read/write connection. Our current ERP system at work only allows a read access connection via ODBC. Frankly, it doesn't meet all of our needs moving into the future, and I...

Has anyone looked into this,or is using it? What are your thoughts? I'm interested in something that is Access-like, but allows me to make a great Web database, with potential to go mobile if needed. I need something that is easy to use/ easy to learn/ minimal code. I'm fair at VBA, and I...

Julian, Thank you for posting this. I've been wondering for a while now how people are making out with 2013 web apps. I have an application I may have to make with online functionality, and was dreading learning another tool. Mine will need to integrate, but I believe I can use the Azure...

I am the general manager and potential owner of a cabinet shop. I have been using access for a few years now and am pretty comfortable developing with it, including VBA. Our ERP system is one that is for my industry. While it is "out of the box" software, it is not too bad, because it's...

Hello, I've created a desktop application in Access 2013 that uses excel automation. This works great on my development computer, but it doesn't want to work on my production computer (which has excel 2010 on it. ) It barks at me about a missing reference for excel v15. I've tried to...

Pbaldy, Your excellent response couldn't have come at a better time. I found exactly what I needed in your db.

Hello, I'm trying to satisfy my need for a custom dialog box. My box needs 3 options. Ignore Products Choose from all Products Create a Placeholder product This will be called within a code block (Recordset Loop). I would usually use a custom popup user form for this, but I need the...

OK, thanks for the tip, I'll give it a try

Jdraw, Thanks for your response. My question is this: Is this worth creating a junction table, and the 2 tables (QuoteAssembly, and EngineeringAssembly), when I can get it to work with just one table? (EngineeringAssembly) Running through it in my feeble mind, I'm having a hard time...

I'm creating a database whose sole purpose is to look into my ERP systems quoting module, and output a spreadsheet that I can suck into my engineering software. The quoting module has relevant "Assembly Codes", which is the assemblies primary key. The engineering system requires the product...

Doc_Man: I don't have any way of storing a query inside the SyBase db. Will Pass thru queries help?

HiTechCoach: Thank you for the information. I will definitely be using unbound forms for this project.

Everyone; thanks for the responses thus far... Doc_Man: Yes, the ERP is Real...We've been using it for over a decade. It is a strong, well supported platform. We are on support with the company who made it, and update at least bi-annually. I have dug into this back end several times...

I wanted to make this a short, to the point thread, but I don't really see a way to. So...here is my conundrum. We have an ERP system that is overall really good, but I have the power to read (Read only connection) data from it and display as I want, making it better. We are a...

Rx, I'm now done with this challenge. I was able to accomplish more then I thought through conditional formatting, including highlighting a cell that needs input, then un-highlighting once it was populated. The only VBA I needed was to unlock 3 cells in a row, based on another cell...