Search results

I'm trying... just can't get the hang of the DCount Syntax. I am just now cracking open my Access VBA for Dummies book, and this is my first if then else statement, not to mention my first DCount! Here is what I tried: If DCount("[Event ID]", "tables![Confirmation]", "='Me![EventID]'") = 0...

Hi, I have inherited a database that writes contracts and invoices and I now need to add something to it that's beyond my pay grade! Right now a command button on the contract form (Me!) opens vendor contracts (called "multi-confirmations") that match the contract number (EventID). It was...

Thanks for the code ideas - I tried something like these and it didn't work, but I'm wondering if I was just asking Access to do the impossible. When the code is associated with the button to open another form, it works great but... now both forms are still sitting open. The temptation is for...

I have to admit, I never though of that! I've been a user of the program for years and only recently have inherited it's maintenance, so I'm seeing the issue through a paradigm! Most all of the pages could be put on tabs: Contract, Addendum, Invoice - even pages with a one to many relationship...

Hello all, I have inherited as part of my job a small database that writes contracts, addendums and invoices. ONE contract will normally have only ONE addemdum, so the fields for these two documents are all in the same table - makes sense. Except, our people often like to have both the...

Hello Pat, Sorry to just reply out of the blue, I read this thread with great interest - I have a similar problem that I've been dealing with. I have inherited a small database that writes contracts, addendums and inovices. Since ONE contract will only have ONE addendum, all of the fields for...

Hi all, I inherited a small Access program that writes contracts, invoices, etc. and want to add some features to it. Whenever someone clicks "add new contract", Access uses an auto number field (which is the primary key) to give that contract it's unique number, which seems like a good idea...

Thanks, jwhite! There are actually two databases at work here, one that I wrote to track overdue contracts (the one that shrunk so much when compacted that it alarmed me!) and one that I inherited to actually write contracts, invoices etc. Since 2009 is upon me, I'll have to keep the inherited...

Thanks, HiTechCoach! I didn't realize how much impact design mode could have on the size of the program. Lately, I had been getting "Microsoft Access has encountered a problem and needs to close..." messages when trying to do more design. I bet that's because I never compacted it! Haven't...

Wow - had no idea it could compact that much. Thanks!

I guess I could have Inadvertently compacted it, but what gave me pause was how MUCH in compacted. From 12MB to 5.48MB and all the data is still there? Does that sound feasible? This would be the first time in it's 2 year life that it's been compacted...

Compact on close is not checked and I'm not using a backup utility - only copying and pasting the entire program to another folder and giving it a different name. The only thing I can think of is that I did compact a DIFFERENT database a few days ago - one we use to write contracts. Every year...

Hi all, I have a simple little database that I created to keep track of overdue contracts, payments etc and I periodically make a copy of the whole program as a backup. Up until now it's been slowly growing in size as more bits of data get entered in records and was up to just over 12MB, but on...

Worked great! Wow, that was brilliant - worked first try! Thanks so much!

Hi everyone! I'm working on creating a small database for the company I work at and just can't figure out the syntax to make this work. If I create a query that looks for clients Like '*Smith*' , it returns records where the client is John Smith, Smith and Company, Edward Smith & Jones, LLC...