Search results

So below is the current code I have been using I want to add this code for "Frame16.Value = 2". But I cant get it to work Any thoughts? Thanks RB

Hi, I have a form that I use in my access database. I choose the names of the individuals and hit the send button. The button has the below I want to add to my vba code a voting option that's say "Review with comments and Review with NO comments. Can I do that? as I send a lot of emails...

I have attached a sample of the database. As you can see my goal is to choose the parent item number from the combox and once I click on the button in the subform I will populate it with the subitem numbers using the logic I explained in post #1 Table 1 and Table 2 are created by append...

"The_Doc_Man" I agree with you I cant control the database that have the data and hence that's why I appended the columns that have the data that pertains to what I need accomplished. I also figured out the sequence/logic for how to get the output but I needed help in writing the vba. I...

The "NEXT_COMP_NBR" is the name of the column in the ERP system that I am linked to using OBDC. I am using an Append query to download all the required columns into my database So the output I am hoping to accomplish whether using a QUERY or VBA is to have a column that list the main item...

How can I add all the criteria I mentioned into the query. I couldn't wrap my head around it

Hi, So I have this database and I am trying to create a way to update a subform using criteria from the combox in the form. I have been thinking about how to go around accomplishing this and couldn't make it work using the queries (I might be wrong). I believe a VBA of some sort might be...

I fixed the quotation per the link pbaldy sent me. Also thanks for catching my error Below is the working code for anyone who might need it in the future Private Sub Form_Current() Dim rs As DAO.Recordset Dim db As DAO.Database Dim strSupplier As String If IsNull(Me.shipto)...

But the "shipto" should be auto filled by the value "Address" from tblSupplierAddresses if "Supplier" in frmDMRform = "SupplierName" in tblSupplierAddresses

How do i use strSupplier that's were I got stuck

pbaldy, I am sorry I am not following can you elaborate more.

Hi, I have been struggling to get this to work. So hopefully someone can guide me or help me out with this I have a table called tblSupplierAddresses with 2 columns "SupplierName" and "Address" I have a form which has a subform and both are called "frmMatRRSubform" and "frmDMRSubform" In...

OOPs I know what I did wrong I fat fingered I typed "du_Name" instead of "dur_Name", I never noticed it was asking for "du_Name" until I paid a close attention. Fixed it and it works like a charm Thank you so much for the help

Thank you Plog, I created a table and Chart_Sub1. When I run 'Chart_sub1' I am asked to enter "Duration.dur_Name, is that suppose to happen

Thanks, I took the quotation out and the ABS function. So how do I create the query to give me the data as you showed

Hi, I am trying to create the attached chart using access. Below is the query I have so far SELECT Abs(Sum(IIf([DurationOpen]<=30,"1","0"))) AS [0 - 30 Days], Abs(Sum(IIf([DurationOpen]>31,"1","0") And IIf([DurationOpen]<=60,"1","0"))) AS [31 - 60 Days]...

sneuberg thank you so much, that's exactly what I needed. I would have never thought of the way you did it. You made it look so simple wow Thank you again for taking the time to help out RB

I thought that's how to do it from when I was designing database. If it's not to much to ask can you show me how u group them.... I am open to suggestions if it resolve the issue and make the database better Thanks RB

The issue I am having in the report is when the NCR has multiple part numbers other than that its all good. Currently I have to save the report as PDF and use PDFCreator to delete the duplicate pages and then use it.

I looked at your "test mod" database but it still shows if you look at NCR 16-0155 a duplicated report when you click on "Print/Email SOP MT005F1". The report should be 2 pages but its showing 26 pages