Search results

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

Hi Experts, I'm looking for a way to send a document to docusign print driver. the code below when it works launches docusign print driver with the document in the print queue. The code below works inconsistently. sometimes it works, sometimes it doesn't work. if i step thru the code it works...

Thank you plog. I'm working on it and so far it works with the testing table. I'll update final results later.

I'll say this it shouldn't be null. that record would be an anomaly. Also cannot be less than 1.

Hi Experts, I'm trying to write a query that will return only the record that only have RoleID = 1. Group BY ProjectNum. E.g. the record that should be returned is 18003-101-1 because all other project groupings include records with RoleIDs different from 1. Last bit of info to consider, all...

Yes i had an interesting situation with the PK for this table. this table uses a composite key. I imported this table from another sql server database then linked it to access. I lost the PK when importing and some duplicated records were entered. Ultimate i created a local table ran the...