Search results

Hi all, I am trying something very different and I need some help with coding. I am trying to do a running sum of defects over time per area discrepancy missed. I have searched and the net and this forum, but I can seem to find for results are running sum according to date. I have attached...

Yes, I have tried this. I finally got it.. All set

OK, do I just learned about the new feature in Access 2010. I have my setup all complete and everything works great. Now, I have a subNavigation form within the Navigation form. Thing is, I am not sure how to go about the code for the query to pick up the Beginning and End Date to generate my...

Hi, I am trying to add the name of the employee show up in on the opening form after logging into the database. I am able to get the user right (Admin only), but not the name. In the Default Value in Properties, I have it set to =CurrentUser() and I have the Employee field in the Control...

When creating an incoming inspection database, I want to set it up so when I am in a form to add data, I want to have a command button where I can pull up the associated CAD drawing based on part number and drawing number. I would like to enter the directory location into a table so I could...

OK, I found a work around. What I did was to build queries for both Location and Causes comboboxes, everything works now. :) Thanks for everyone's help.

Which is why I had the tblecatches included in with the SQL for the Catches combobox. Not sure how else to include the LocationCategoryID and "true" values from the tblCatches table.

Good morning, I forgot to mention which form I am using to input data, which is frmQCatch, hope you were viewing that one. The reason I have it set up this way is because I have tblCatches with the catches listed and using it to select catches for the Location Category (tblLocationCategory)...

Sure thing, here it is. AS far as data, there is nothing sensitive in it. Thanks for taking a look. Steve

Yes, I have already tried all that... Here is the weird thing, if I select the Catch (key value), close out of the form, then reopen it, the value appears. The value goes away and the key reappears upon Requery when I select a value from the Location Category combobox...

I am trying to get get 2 comboxes to refresh from one when cascading. The first combobox (Location) works, but the second one (Catches) doesn't. All I get are the Key values of the catches rather than the values... I am wondering if it my relationship set up of if my VBA needs to be altered...

Already took care of it. Thanks

One question I do have. Do need to use the "Parameter" statement each time I create a chart or do I only need to use it when pulling from a query? If that is the case, then pulling data from the table would be best, right?

Thank you. Works now with any errors, but not its not showing all data in the graph. I'll have to tinker with it. Thank you so much.

OK, it's all cleaned up. Thank you so much! I really appreciate this...

Sorry, I thought I had cleaned that up... Was doing a lot of trial and error testings...

Can you believe I have tried this? I still get the same results. [Forms]![frmChart_LocationCat].[BeginDate] to... [Forms]![frmChart_LocationCat]![BeginDate] It is obvious you are toying around with it also. Are you getting the same error message? I am running 2010 on both my work and...

Actually, this is a new development, not an existing db. Honestly, it''s been a few years since I have created on and hard coding isn't my thing... I have built many databases in the past where the data was more complex. However, when I look at them, I see I have set them exactly in the same...

Why is it that all of a sudden, I need to use parameters when I didn't need to in the past? My data is pretty simple...

OK, I have never had to do this. How would I go about doing this and is this something I will have to do is I try to run a query for a Chart and Report that I want to develop? Thank you, Steve