Recent content by spiralmind

making external function calls does have some associated overhead, but this should not be significant here, and calling the external function allows you to reuse the same code elsewhere if you want another progress bar, so you should probably leave that as it is. - may seeds of dreams fall from...

the window will expand as the detail section expands - may seeds of dreams fall from my hands and by yours be pressed into the ground

2*(int(x)/2+1) - may seeds of dreams fall from my hands and by yours be pressed into the ground

i'd try setting the button's position based on the detail's height, something like this: me.mybutton.top = me.detail.height - 500 of course the 500 is just some arbitrary number. you would want to replace it with one that gives your button the amount of spacing you want it to have from the...

if you are just trying to get a count of records in the table you can do that by looking up the tables properties in vba. this would look something like: lngRecords = tables("tblSomeTable").recordcount you might have to use recordsets for this, though. it's been a long time since i...

You can try Data Access Pages if all people using your application will be running ms office and internet explorer 5.5 or better on windows. otherwise i would suggest you either learn java or look into using it over an intranet (if possible) where the file would be centralizes - of course you...

your problem is probably the speed at which you are testing it. when you are using a progress bar there is normally some computationally expensive work going on in the background between progress updates. you can still update on every step, as opposed to every 10 or so, under such circumstances...

for an easy way to send e-mail using access vba, try looking up automation for MS Outlook. there are a simple set of commands you can then use to create an e-mail, add text to it, add attachments, control who it goes to, and set the subject header. you might need to add something to your...

http://www.mvps.org/vb/index2.html?news.htm this site: Ken Peterson's One Stop Source Shop has all sorts of info on APIs presented in a vb/vba specific format. if you don't find what you need here there are other sources, notably microsoft iteself, but they are usually presented for C++...

if you want to print just the numbers use the FileSystemObject to create a text file and fill it with the barcode numbers. you can use access to open a text file (or any other file) by setting a hyperlink on a button. this will automaticly pull up the file in the application windows associates...

there is a RecordsAffected property - of the QueryDef object, i believe - that can give you a count of how many records will be added. you could also access the Count property of the table being appended to, and have your code look at it again after running the query to determine whether it has...

check your references under tools:references and make sure the DAO 3.6 library is checked. also helpful, btw, to check the microsoft scripting runtime if you plan on doing a lot of work with the file system. - may seeds of dreams fall from my hands and by yours be pressed into the ground

Display a custom icon for an application On the Tools menu, click Startup. To display a custom icon in the title bar of your application, enter the name of the .ico or .bmp file that contains the icon you'd like to use in the Application Icon box. If you don't know the name of the file, click...

no, there is no way to change the built-in order of the access events. what you can do is make use of that order when sequencing you code so all prerequisites are filled, and create functions that explicitly lay out the order of steps. if you know where the value for "num" comes from...

go to "Tools:Startup..." on the menubar of your open database. here you can change a number of things - including your application icon (which is the one used on the main access container window and all of your forms) just have a bitmap ready and browse your way to it. i don't know...