Search results

Good morning, I think i'm snow blind on this and can't see to figure this out today... I have a workbook that has my master project list: EE - Projects I have the data stored in a table here. I have a separate workbooks to calculate expenses and timecards: EE - Timecards I enter my data in a...

Thanks plog. I'm cleaning up the tables now. some of that was just some residual messiness from me trying different things (but definitely not all of the garbage). I think I understand your recommendations. A couple quick questions. I don't understand your suggestion regarding how to...

Hello, I've been working on a project that incorporates Subcontractors with a State, a region (that i define by county) and then by City. My goal is to enter information about a subcontractor, select a state and a city. Then i want to be able to query subcontractors by state/region/city. I'm...

Bob Fitz - Thank you very much. I appreciate you taking the time and looking at my problem. I made the modification that you suggested and it appears all is working well. Cheers! rob

I'm so close, I think! haha I'm running Access 2016 on a Windows 7 machine. I'm working on a project that incorporates subcontractors and their respective scopes of work. I have built my join table, developed the 'subcontractor' main form,and insert the 'scope' subform onto the main form...

Update. I originally posted that the development machine was windows 7, 64 bit. While this is correct, MS Access 2013 itself is 32 bit. Microsoft doesn't offer a 32 bit run-time environment. I downloaded the most recent alternative, MS access 2010 32 bit run-time. When I tried opening the...

Thanks for the vote of confidence. The Backend will be getting backed up as part of the general computer file backup process. The backup will go to both an external hard drive and I believe a cloud platform for both general remote access purposes and for duplication. Would there be a MS...

Access 2013 Development machine: windows 7 x64 Operating machine: windows 10 x64, access run-time (20xx?) Hello all, I've been searching and reading threads about creating and distributing split databases as a prepare to distribute mine. Nearly all of the threads I've been reading are geared...

That did it! The problem as eluded to by robslob was that the column count for cboDoctor was set to 10, not 11. This problem was resolved by going to the Property Sheet for cboDoctor, looking at the Format tab of the Property sheet and changing the column count to 11. Once again, the forum...

Good morning folks, I've come across a problem that doesn't make sense to me. I have a form with a combo box on it. Each time the combo box is used or the form is moved to another record it triggers an event to update the text boxes. I get the information for the text boxes from a query...

Thanks for both of your responses. I agree with CJ_London that utilizing mileage would be an ideal way. Unfortunately, my wife sometimes 'forgets' to keep her receipts/keep the record for us to enter into the DB. As such, her entries are spotty for her car. The intent behind this project is...

Forum, Access 2013 windows 7 I am working with fueling up cars. I have a table tblFuelEntry in which data associated with fueling up a car is entered. Information such as Fuel date/time, tankMiles, Gallons, CarID, GasStationID are all entered. In my qryMPG I calculate the MPG for each fill...

I have put the code you provided in, and by all accounts it seems to run just fine. No hang ups. This is great! Checking for null rather than length is a better approach. Thanks for taking the time to help me troubleshoot my little problem. Much appreciated! Able to search our family...

Thanks for your reply. I tested what you asked. I entered the wildcard search in the form's field and ran the query manually. No problems. Then i opened the report manually which triggers the query to run, no problems. It would appear that pressing the button on the form and subsequent code...

Hello Forum, I have been having a little bit of an issue with a query crashing. I'm using a touch of VBA to run the operation so have landed in this forum but the query forum might be just as appropriate. I have a form made to help query a database in a variety of ways. One of those is...

And that Pbaldy is why this is the best forum on the web. Your link provided the information to solve my problem. Thank you. My working code is below. I've commented out the section where I've saved the value to a variable, and then printed. It was nice to have to help walk through the...

Good afternoon Windows 7 Access 2013 I've been trying to work up a where clause that is generated by a button click event on a report. The workflow that i'm trying to obtain is as follows: 1) A report is run to determine the remaining work orders that need to be processed. 2) A button that is...

So to clarify, i'm my computer is 64 bit but my version of office is 32 bit...Still a little confused about why this is but that's a tangent. I've tried running the product on my old labtop which is a 32 bit machine running windows vista and access 2007. says it isn't using the most up to date...

Windows 7 Access 2013 64bit Hi all, I have a product that i compiled to a accde but my machine is a 64 bit machine. My friend whom I'm sharing with has a 32 bit machine but will run the product in a run-time environment. First of all will this work? Second, what happened to the packaging...

missinglinq- thanks for clearing up checking for zero length strings and the ability or lack there of, of setting focus to a control on a report. Those were a couple things I wasn't sure about even after me finding my solution.