Search results

Originally Posted by Gasman View Post Select records whose percentage would total 80% ? You're correct Gasman, need to select the records that total to around 80%. Luckily the percentages are 0.06% so the jumps wont be as drastic. "Select SKU where Sum of Percent =80%" i think something like...

for my own sanity I hope this isn't as simple. I will try and let you know.

Hey Gang! Been :banghead: a while trying to figure out how to do this and definitely need help. Have a list of SKUs along with their usage percentage. Need to create a way to have Access(or Excel, depending on which is better equipped) list the SKUs that make up 80% of my usage. let me know...

PBaldy, Yeah, it was an odd one. Best way i can explain it, for some reason "me.txtbox.value" wouldn't not pull the value into an outlook email generator or message boxes. But it worked in showing up in a hidden form, so I used that. lol.

(Solved)Playing with Emails! Thank you all for the help. I solved the issue by using a hidden form with the values of the primary form. Still dont know why the code wasnt working tho.

Sadly, i have yet to be victorious on my adventure. I have changed to simply trying to pull data from the form through message boxes. I have added this line for testing. Msgbox "You have sucessfully added " & cboPartNumber.value & " to the list" Everything works, but the value is not listed...

Yes Pbaldy, i have confirmed the email address is the correct data in that column(text box is visible for checking). Thanks Mark, always forget about using message boxes for these things. It is pulling up blank. I think i know whats wrong, let me try a few things and get back to you all next...

Tried varName = Me.[txtRequester].[column](1), same thing. thanks!

Hello Everyone! Today I am exploring the wonderful world of sending Emails automatically. Please see code below: Private Sub btnEnter_Click() If (DCount("*", "qryDuplicateRequest") = 0) Then DoCmd.GoToRecord acForm, "frmRequest", acNewRec End If DoCmd.Close...

Good day All, I created an If statement in a New Record button to check if the new entry is a duplicate, if its unique then it allow the record to be saved. If the new record is a duplicate it will not add the new entry. Unfortunately it seems to be allowing the entry. I thought i had it...

Thanks Minty, I agree with your observation, guess its what happens when you are self taught by youtube and forums. Have a lot of different style code interacting(like a combustion engine made out of duct tape and pottery). I will work on cleaning up the relationships now :) The database is...

Here is the relationship table

Plog, you totally broke my head. I currently have a requester table being used, but not sure how this would help in this instance.

This would work for a default but I need to have it changed depending on the requester. Can i place a If statement in the Control Source?

Yep, i read that earlier. I'm trying to use nested if statements to take the autonumber into another field and add a letter. for some reason i cant get the field to be populated

Hello All, Title is a little confusing. Need to add a character to an auto number with an If statement. The scenario I am working with is, we have requests coming in through three channels, Emails, Cycle Counts and Recounts. These are identified by who is requesting them. ie MDiGregorio is a...

Thanks for the help CJ! I added the IF DCount statement in the login button, works fine now.

Oops. Ill try it and let you know. Thanks for the help!

True. So i should run the Query and DCount prior to the opening of the Form, and if the count is 0 then run code to import a record then refresh? If so at what point in the code would i run the Query, Dcount and IF statement? Sorry for the basic questions. here is the code for the main form...

System is to work like an IT Case assignment form. Essentially we have other departments request Inventory counts of a particular part. Our counters would log into the form and click a button to "activate" a count, by tagging the counters name. Then the forms record set would show the activated...