Search results

JustMaybe PDF will work Essentially many of the PDF writers just "Print" a file to a default selected "printer" that is not a real printer but a file that is created in PDF format. This file is easily sent as an attachment and virtually everyone these days has a PDF reader. You have to buy...

I have an application with BE on server, FE on individual computers. Typical simultaneous access for my application is 5 - 15 users. Altogether the network has 11 servers and over 500 users (mostly students who do NOT use my application thank you very much!) Two or more of my users are unlikely...

Make another summation query I've run into this before, usually when I have a row total calculated that is not in the detail section. I think the problem has something to do with Access not keeping results from one section to another. It's not elegant, but the way I get around it is to make a...

It's not that bad A few years ago, I had to convert a whole bunch of dbase 3+ into Access. As Pat said, the tables are easy and, on the whole, Access does a lot of things automatically that dbase made you do programmatically. I'll NEVER miss those fragile *.ndx index files! Relationships are...

This is so slick it IS easy Simply copy over the year's back-end data to another (archive) file, then go in and delete all the existing records and then compact the data part of the database. Bingo--autonumber starts at the beginning and you can always look at prior year's work if you need to...

ghudson, you're the man for menus! I should have attributed the code to you, but I didn't want to embarrass you if it caused the problem. Your idea to "reset" the menubar worked, but only after I used the commandbars(I).enabled = true before and closed out a trial database. That command has...

When trying to protect one of my applications, I really messed up my whole Access system. I no longer have the "Tools" button on my menu bar. It reads as FILE EDIT VIEW INSERT FORMAT but no longer shows TOOLS. This locks me out of many things (Startup options, compact, make MDE etc.) It...

split the database Use the database splitter and store your data as a separate .mdb and then back up only that.

Compile error solved Rich -- I took your advice and went looking elsewhere for the problem. I found it in a textbox on the form that I had deleted from the form, but not the code in the module. I didn't get a runtime error because the deleted box never had any data and the extra code was...

Rich - code interfers with mde Rich. The code works great as I said, but it is causing my application to not compile / and make an mde file. I've searched many sources. One suggested changing the Error$ to "MsgBox Err.Number&""&Err.Description" The code works, but still doesn't compile...

Great job, Rich -- but how does it work? This little bit of code is exactly what I have been looking for for years. My question is -- how does it work? What is the Macro11 and the MsgBox Error$. These are totally foreign to me. I don't use macros very much (VBA instead). Thanks again.:cool:

I have a database with over 50 reports and their source queries. I want to import some of these reports into a new database (a "lite" version, with far fewer reports). I created the new database, linked the tables in the back-end and then "Imported" the reports I need. Easy and quick. The...

Make sure you create your .bat with a simple text editor, no formatting. Also try adding a CTRL-Z at the end of the .bat file before you save it.

Would a QBF work? Although I like to use the The_Doc_Man's "Like and wildcard" because of its flexibility and ease of use, if I have a number of different choices on whether or not certain criteria are used or not, a custom QBF makes it easier to predict the outcome. Try the link below...

Temp file not really a copy The client already had a UPS -- in an unopened box. They will install it this week. In regards to the "temp" file -- I don't know if it IS just a copy. I didn't manually copy it, but it was present in the directory as "db1.mdb" when the compact operation failed...

Still looking for answers I used the JetComp.exe on the original file; it seemed to work but then still wouldn't compact normally. There is no way that a spreadsheet got imported. I am still concerned with the reliability of the temp.mdb that was created just before the compact operation...

I have a very stable (2 yrs) application running in Access97 on a 5 user network. Suddenly the front-end wouldn't compact and I see error messages "Not a valid Notebook" or that there are mulitple users doing the same thing. It looked like the typical hanging .ldb -- but it wasn't. The .ldb...

How do I close a print preview on reports? I used the hide/unhide viz.ghudson and it worked great. I hide on main form open and unhide by a command button that is visible only on correct password of supervisor. Works great. The problem is that I have a number of reports that open as print...

Do a search on "Age calculation." It's been covered in great detail on this forum.

I am using Access97. Users are on a network that controls access to the directory where the application resides. Their network password lets them use my program. When they start my program, I ask for another password I've given each one (actually a 5 digit number). I then run this number in...