Recent content by polymatt

I can't afford to be that fatalist about it. Thanks for your advice anyway.

Those were example fields; while reflective, the actual database is huge & is approaching the field limit & I don't have the time/resources to redesign it & the staff who created it is long gone. There are existing client records that have confidential data that, from this point on, we're...

I created a sample database based on mine (as a lot of the data is sensitive). I have 3 tables, all linked via ID (tbl_clients is AutoNumber, others are Number): tbl_clients last_name, first_name, title (a look-up) tbl_clientsJan x_widg_buy, x_widg_col (a multi-select look-up), y_widg_buy...

Thank you; but the way this business works, there is no "order date", & no way to group the numbers that way. Only "Totals" are tracked for each month & there's no data re: when the transactions occurred. I'll edit this info. in to my OP. Do you have other suggestions for me?

I'm altering a database to have certain fields be recorded monthly. For example: instead of a client's file having "Total X Purchased" it would now be "Total X Purchased - Jan", "Total X Purchaed - Feb". I want to spin the monthlies out of the master clients table & in to ex. tbl_clientsJan...

I'm working on a database of client info. The table houses info. on individual clients over the course of our serving them (name, marketing info. [youth, senior, etc.], which services they purchased, % satisfaction with service, etc.) What my boss wants is to be able to compare a snapshot of...

I added the DoEvents, but I'm still getting the error; it feels like it's occurring less often, but that's probably just my own bias.

The ones from the main database. I figured it out, though; I just added VBA to a button to clear the table with a Yes/No confirmation. However: I'm now having the first problem again. After updating my code to include the ".accdb" extension, the TransferDatabase code executes 90% of the time...

Adding the extension worked; thank you! I'm going to mark the thread as "Solved", but if anybody's still reading, what would be the best way to delete the records? Adding "delete" to the code of the same button, or to a separate button?

I need to move data in a table to tables in new databases for archiving; & being able to click a button & have the data append & delete is my goal. I made a test database to work on the code. I'm an Access beginner & so go easy: This code creates the archive & runs ArchiveTables (below) when I...

In my database, I have a Table for our clients (tbl_Clients) & how long they were active with our service (StartDate, EndDate), with each client tethered to an ID. My dilemma is: what if a client reactivates? I want to avoid redundant records, & instead detail additional StartDates & EndDates...

So: I have a Report (rpt_ServiceRequirement) which lists clients (from my Table tbl_Clients) & some variables re: those clients, which I've built into tbl_Clients as a Lookup & Relationship (where I've entered the values myself; there will only ever be a choice between a few static options). My...

I'm a long-time lurker. I've used existing threads (& their solutions) for my own database projects; however: recently, I have elected to build small databases for work, & am interested in learning more about MS Access features. I've done some online training, but it hasn't been adequate to...

Hello! I apologize if my title is indecipherable; I'm (relatively) new to Access & am uncertain re: how to accurately qualify my dilemma. I'm building a simple database at work; it contains 1 main Table (tbl_Clients) & another, (tbl_Employees) that are related by "EmployeeName" in both. My...