plog's latest activity
-
Pplog replied to the thread Change YesNo Value in field in Tbl1 based on value in control an active form bound to Tbl2.1. Use CODE tags when posting code, not screenshots. People can't copy and paste and edit your code otherwise and we will be able to...
-
Pplog replied to the thread Change YesNo Value in field in Tbl1 based on value in control an active form bound to Tbl2.You're missing a table. I have no idea what all those numeric fields named after numbers are for, but I do know they shouldn't be in...
-
Pplog replied to the thread Daily, hourly and monthly average..Can you provide sample data? Two sets of data please: A. Starting date from your table(s). Include table and field names and enough...
-
Pplog replied to the thread Solved Copy the Primary Key [ID] and Place It In a Different Control in Same Form.Not to play captain hindsight, but a little planning and a little post-migration work could have made moving your database a virtually...
-
Pplog replied to the thread Sum days_month_years.Thinking about this more I see some points of failure: If TotalDays >= 60 it will still only add just 1 month to TotalMonths If...
-
Pplog replied to the thread Sum days_month_years.I really question the structure of your table. But here's what you need: FinalDays: TotalDays Mod 31 FinalMonths: (TotalMonths +...
-
Pplog replied to the thread Multi Field Selection.Agree with Gasman and would like to expand. Now, I'm sure those aren't your field names, but whenever you feel the need to numerate...
-
Pplog replied to the thread Filter and export multiple reports by same field with loop ability.Divide and conquer. One of the main errors I see on this site is somebody trying to do 6 hard things all at once and they have no...
-
Pplog replied to the thread Opening Access - NEED HELP!.Problem solved.
-
Pplog replied to the thread Opening Access - NEED HELP!.Do you have a shared network drive? Something you all map to and have read/write access on?
-
Pplog replied to the thread create a field in a table.Data storage and data display are two different things. If you always want 'PC' to appear before a field you can make a query and use...
-
Pplog replied to the thread create a field in a table.Yes, but why? Why not just prefix 'PC' onto the record's autonumber? Another method is to create a numeric field in your table, use...
-
Pplog replied to the thread At a crossroad and clueless.Tables -> Reports -> Forms That's how you should develop in Access. Make sure you have the correct tables to accomodate your data...
-
Pplog replied to the thread Solved Running sum of query, report with opening and Closing balance.First you need to fix your table structure. 1. Debits and Credits should be in the same field--[Amount]. Then you either simply use...
-
Pplog replied to the thread Hop do I format the contents of a bookmark in certain documents with access.I'm confused where this upper casing is to take place. We are in the VBA forum, but you mention upper casing a field like it might be...