Search results

I came across this in the help file: Try changing your code to :Set rec = db.OpenRecordset(strtable,dbOpenSnapshot)

It should say Loop Until i >= intNewEntries I mislead you on my initial post, sorry. You could also switch it and say Do Until i > intNewEntries If you put the code in the Do section, it will exit the loop before the code executes. If you put it in the Loop section, it will exit the loop...

I never knew about the built in zoom box (Shift+F2 in case anyone else stumbles across this). Is there a way to call that up through code, in case I want to assign a different event to do it? I have created similar boxes myself in the past, but it would definitely save time to use the built in...

Unfortunate, but that is exactly what I needed to know. I won't waste my time anymore. Thanks.

What I posted above is an example of a quantity driven do loop that adds entries to a table. You would just integrate it with your code that generates the serial#. Change your original code to a function that returns the serial number (without changing the code itself, the following would...

I set the can grow property for my text box to yes on a continuous form, but nothing is happening (it's not growing when the text is longer than the textbox). I read the help file and the only culprit I saw that should keep this from happening is if the controls are overlapping, but there are...

Thanks for the explanation. I can see the foolishness of allowing the user to scroll through all the records on an extremely large table. Though my database is not that big, we intend for it to get big; so I will try to start changing my thought process now. I'm sure you're asked this...

Pat, I read what you wrote above and was afraid I may be one of those unknowing developers. I am a self taught database developer who learned most of what I know within a MS Access environment. I am at a new job now and am attempting to work with a MySQL database through ODBC. I am...

I'm missing what your code is actually doing, probably because I'm not seeing the form. But if I am understanding the question properly, it is simply whether or not you can use a do loop to add entries to a table x times. The answer to that is yes. Dim rstTableName as Recordset Dim...

The code is the same as counting controls in a regular form, but you need to include a .form after the subform so that it accesses it as a form and not another control. Sub CountSubControls() Dim ctl As Control Dim i As Integer For Each ctl In Forms!frmMainForm!subform.Form...

In = Count(*) you could replace the asterisk with a field name if you choose, but the asterisk represents all the fields in your row of data. So you are basically saying count the rows. If you count your name field, you should find the same result. Avoiding the use of the word name is not...

Thanks for the link. My biggest problem was that I wasn't properly adding or removing objects from the collection. I've included the shell sort in case anyone who stumbles across this post is interested in using that particular sort method: Dim lngLoop1 As Long Dim lngHold As Long...

I know that my biggest problem is that I need to become more familiar with collections, but I wanted to post this here in case I don't get very far in educating myself. Is there an easy way to sort a collection? I was going to try the Shell Sort method, but I am running into a few...

Pat's right. If you do this at the query level, it will be much easier to lookup records, etc. I don't know if there would be a performance gain/loss either way, but your life will be easier by doing it in the query. If you were to use VBA, you would use the OnCurrent event to run the...

I think any difference in performance caused by assembling/dismantling this value would be negligible. If you know for sure that all of the numbers will always be the same length, the code for creating the value and dismantling it would be rather simple. As long as you don't plan to store...

The only difference between y and d is that y represents the day position in the year and d represents the day position in the month. The distinction becomes clear when you use these with the format function ?format(#4/03/03#,"y") 93 ?format(#4/03/03#,"d") 3 However, when using this with...

If anyone wants the full URL to the paper Pat Hartman referenced above, it is here: http://www.fmsinc.com/tpapers/math/index.html I'm a little confused by the very last post on this thread. If you wanted to know the minutes between the two times, why did you just not use...

I have often done this from Access through VBA. I would imagine you would do the same with VB. First, make sure you add a reference to the Microsoft Excel 8.0 Object Library (I'm using office 97 so this might be different). The following code will reference a cell on an Excel document: Sub...

I'm not sure if this will be helpful, but I had a database where I stored a Word document in a table. I was then able to retrieve it from the table through code and insert it when I needed it on my form.

It's been awhile, but I believe all I had to do is create a tiny form, just big enough for a button to fit on it. I removed the record selector, scrollbars, and navigation buttons. I then set the popup property to true. Add code to the report that opens the button form On_Open and closes it...