Search results

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...

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...

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...

Hello, Working in Access(2007-2013). Form opens to a record set from a query, form contains a button to pull/populate the form with a preexisting record and stamp with User's name(similar to an IT ticket system). Form works fine as long as the user has at least one record assigned to them...

Hello Everyone, I consider myself a new Access user, been creating a database for work and have been using your advise to help me along the way. Work for a Forklift manufacture in the states and enjoy Warhammer 40K and reading. Look forward to chatting with you.