Recent content by SillyMcGilly

Chris, WOW. Thanks. I took a quick look at the attachment, and boy, what a lot of work to compact it! I will have to take a longer look at it to understand it better, as my VBA experience is mediocre. If anyone has any easier method to do this, please respond. I have a custom toolbar ONLY...

I have read numerous threads on this, but no one has really answered the question the way I need it answered. I am looking to Compact on Close in a Access97 database. I know Access 2k has this option in the Options, but 97 does not. I know I can use code like: sendkeys "{F10}", true sendkeys...

Thanks Guys, I was looking for the answer to this one and found it here to! I also had a chart on a form that was causing the above error. The chart data came from a query and the criteria of one of the query "Date" field came from another form where the user inputs start and end dates. The...

Thanks! Hey, I needed just this info for the same reason. I have a form that the border style is "Dialog" and there is no "Close" option on the window when the form pops up. The user must click a button "Return to Main Menu" to update the record. The problem I had was that if no records were...

Pat, I figured it out. Yes, I believe I could have simply used an integer for the # of People box, but I do use Single and Double on others, that still would pop up with the wrong # of decimal places. All I did was goto the tblTargetInfo and change the format from "Fixed" to blank. I don't...

Pat, I tried to set the properties of the SQL statement used in the row source. I clicked on the "3dots" to enter the query builder, selected the "#of People" field and chose Fixed, 0 decimal places. It then asked me would you like to save the changed SQL, I said yes. But the 2 decimal places...

I have searched this forum and found everything I need to know about combo boxes...BUT this. I have a table "tbldata" with 3 columns (ID, #People, Target). In table design view the #People and Target are set up as Single precision, Fixed numbers with ZERO decimal places. On my form I have a...