Recent content by jsdba

Can someone help with some code that can make a list of empty vba functions and procedures in my access application? I need to do some code cleaning up. e.g. Private Sub Form_Load() End Sub

I do care. I need to know where there is no backup

Interesting. i never thought about breaking up the table. This is not an actual table but i knew a good answer would point me in the right direction. Thanks a mil. But out of curiosity is there a way to do the above without breaking up the table? like using a nested query?

Hi Experts, I have need of a sql query to pull some data from the table below. Premise: Every project is assigned a project team. Every project have multiple phases. Each phase is assigned to a few employees. Each employee is assigned a role. I need a query that retrieves records for each...

I didnt realized i had some sql code updating the same record. i feel stupid. just had to change the sql to MainForm!Field=PopupForm!Field. thank you though. solved

i'm trying to force a save before the error handler triggers. a refresh would do the trick but the refresh cause other code to run which i don't want. i'm trying to force a save on the main form without using refresh.

pop-up form

Sorry i cant. let me try and shed some more insight. the write conflict only happens with when the error handler triggers. so the data is updated bu the user submit button, then gets updated again by the error handler. does that help?

forms!frmMainForm!Field1 = me.Field1 (pop-up form) forms!frmMainForm!Field2 = me.Field2 (pop-up form)

Hi Experts, I'm in need some help. I have 2 forms. Main form bound, pop-up form unbound. I need to be able to change and save data on the main form using the pop-up form. Using a refresh command to the main form will eliminate the write conflict error but causes a different error because my...

Debugger - I've stepped through with no luck. the code just literally stops running at docmd.Outputto. no errors. IncrementalInvoiceNum - is a control on the report Agg Data - While not the best practice it just makes capturing this data easier (pretty sure irrelevant to the problem) Looping...

Thank you but #2 works fine.

Happy Holidays Experts, I have some code that has been working for years but new business rules required me to make to some updates. I have some code that creates a report (expense invoice) and export it to PDF via DoCmd.OutputTo acOutputReport. New business rules now require me to capture some...

Worked like a charm. Thank you

Hi Experts I have a table tblNote with the following fields: NoteID TaskID ReminderDate Note I need a select query that will retrieve the record with furthest date group by TaskID. The query must include the the Note field. Heres my starting point.SELECT TaskID, MAX(ReminderDate), Note FROM...