Recent content by ramez75

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