Search results

ok, so apparently, it wasn't obvious, but i tried that (moving the code around). however i gave up on trying to do it the "proper" way. and i have decided to do it my way. i remedied this by doing what i wanted to do with NotInList by using On Error code as follows: Private Sub Form_load() On...

actually, the afterupdate part (albeit later in the code) takes precidence over notinlist.

Well, i hadn't tried that yet. However, once i did. it didn't work. With the statement like this: Private Sub Form_Load() If Not IsNull(Me.Item_Name.Value) Then 'set all variables to be used in frm_AFREP_Order PNSN = Me.NSN.Value PPN = Me.Part_Num.Value PUI =...

sadly, i have, but it only answers the notinlist part- which is ignored completely because of the afterupdate part of the combo box.

Hello, i have a problem, and i am stuck. Sorry if this seems a bit easy- but i am new to access. I have a combobox, and i have it get information from another form AfterUpdate. However, if the item is not in the list, then i want it to open another form to input the data- then go back to the...

Do you have access to a share point server? If so, i'd recommend that- as it has these features built in. if not, databasedev.co[dot]uk/get_username_or_computername.html replace the [dot] with . sorry, i don't have 10 posts yet

ok, so i figured out how to do it. it took a few more lines, but it works just as i hopped. Here's how i did it... in case someone may need this in the future. Option Compare Database Private Sub Cmdref_Click() DoCmd.GoToRecord , , acNewRec Dim me_yy As String Dim Day_count Dim count_ly...

Hello, I am having a problem with my VB code. I am trying to count the records in a table based on what date they were input. I can get it to count all records, but it doesn't want to count specific records. I have tried several ways of doing the if statements, and ways of entering in...

Hello everyone, I am relatively new to access. I'm ok with forms, queries, and reports (built in functions), but there are certain things i don't know how to do yet. I am trying to learn VBA so i can really use access more efficiently. I am actually working on a front end that has way too...