Search results for query: *

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...

...As Long) ' Assumes box is 3.5" or 5040 twips wide fpnStep = 5040 / lngTotal ' divide only once Me.rectProgressBar.Width = fpnStep * lngCurrent Me.Repaint End Sub You might have to play with the datatype of fpnStep, but this general idea should reduce the computational power...

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...

you can reference it like this: me.somecontrol.ControlTipText = "Your Tip Text" you might also be able to get the CHr(13) line break to work with the property sheet from the form's design view, i've just never tried it that way.

i know that if you set it from code you can use Chr(13) to force a line break, like so: me.somecontrol.controltiptext = "Line One" & Chr(13) & "Line Two" which should display like this (minus the cheesy ascii art tribute the days when DOS was the best OS you could find for...

make the listbox unbound, and set its rowsource to the field you wish to use for criteria set the recordsource of the form to a query using the value of the list as critera. do this from code that is activated after a value is selected on the list, or that selects a value (such as the first...

do you have a control named "keyword", if so you might want to try putting a ".value" at the end of the SQL parameter, or naming the form explicitly to clear up any confusion access must be experiencing when it asks you who "me" is and what its "keyword&quot...

you can put you totals textbox on one tab, navigate to another in design view, and put a secont totals textbox there, just the same as you would put any control on a tab other than the first.