Recent content by Jupie23

Thank you - where does this code go?

Update: I did a compact and repair on front and back ends. I changed the query as suggested to Pend1Date<date()-14 and indexed the field. I made a copy of the backend, saved to my computer and linked tables. It was significantly faster. I then re-linked to the original backend on the network and...

Interesting - I had no idea of this method - I am not in a tech role, more of a "citizen developer" type. I will look into this option. Thanks!

The users have been instructed to save it to their desktops and always open it from there. Clarification - this has always been the case, I did not mean that I just instructed them now.

Thank you for the ideas, I will try them out as soon as I can - but just to fill in info - the main table was just cleared out at the beginning of the year and currently only has 1645 records. Before cleanout it was about 20,000. The query is pulling 675 records. I have noticed in the past that...

I haven't used Access much in several years now, so I am rusty on how to use it and also never knew the full ins and outs, so I may need a thorough explanation. I am hoping to clean up a 5+ year old database that hasn't been used for a while but they are picking up again. The database is split...

Thank you!

I came across this function and it seems to be working! Thank you. Public Function GetUserName() As String GetUserName = CreateObject("WScript.Network").UserName End Function

Hello, A user is getting a compile error that the code needs to be updated for use on a 64-bit system after getting a new computer. I don't know anything about this and am just trying to help out, but I appear to have a 64-bit system and don't get any errors. I am not well versed in coding but...

That is a good point! I don't have much knowledge about web apps but assumed they were probably better because it's actual developers creating them vs. me making what they call a "homegrown solution." And actually, the only one I've seen made by them doesn't look all that fancy! How ridiculous...

I like that idea, as I can do enough VBA to get by but struggle a bit when it gets more complicated. This database will hopefully be replaced by a web app once the developers can get to it, so it doesn't necessarily have to be fancy, just need it to work! I will add those columns to the main...

It is currently adding a new record for each pend action. I would like to keep the history. Could I somehow use a checkbox to check the most recent one and uncheck the previous one, to be used in the query?

One button would open a form to show new records they haven't looked at yet, and one button would open a form that shows all records where the pending time is over, be it 15 days or 45 days. I would like to have just one place for them to click to see anything they need to work again. Example...

I'm building a database for work. I've got a good start, but I'm having trouble with part of it. This is what they want: Import a spreadsheet of accounts with missing documents (done) User will view the record and see if they have received the documents If yes, complete from database If no...

I understand what you are saying, I just didn't know how to fix it. That works! Thank you so much!