Search results

You are correct CJ, but that is ok for my application as it is returning the data I need. I'm building a test item analysis db (analyzing results from individual questions); multiple exams with multiple versions and revisions for multiple courses (over a hundred courses) with different amount...

I've discovered another way to count fields, this method only counts the fields in a query that have a number value (can be modified for Null or other data types). I created the following module and then use RCount ([fieldnames],[fieldnames]...) in a query expression. This allows me to use...

Good point CJ, thanks again. I corrected that as it will be used in a calc.

Mailman; if it were easy, everybody would be doing it!

Thank Worked CJ! Thanks. I'm not sure why I wasn't thinking about the field count, must not have had enough coffee this morning. I'll tweak it with some criteria and then I move on. Dim FldCount As String FldCount = CurrentDb.QueryDefs("qrytest").Fields.Count Me.txtTestItemNumber = FldCount

Thanks CJ, I'll give it a try and let you know how it turns out.

I'm looking for an expression or SQL for use in a query that will count the number of columns in another query. I do not need to count the records, I just need to know how many columns. I can't seem to locate a reference to a column count - everything points me to record count. Thank you for...

Thanks Paul!

If you split a database and distribute the front end, do the selected VBA libraries stay with the front end or do the users have to reselect the appropriate libraries? (i.e. are the selected libraries used in a file a function of the file or the application).

My post count is <1,000. Speed is not a problem when I'm in Linux and using FF, in fact the site loads pretty much instantaneous. I do get slow responses this site from time to time when I'm in W7 and using IE but its not detrimental to my productivity. I haven't noticed much of a difference...

Bob/Dan, Thanks for the quick reply. After walking away from the screen and having a nice Manhattin, I came back, stared at the code and recognized the issue. I put in Me.Form.RecordSource = "qryGetTasks3" after the code for building the dynamic query. That updates the form for me. Thanks...

I have a form bound to a dynamic query. It is similar to a search function, the user enters a keyword and the query is updated, however the continuous form does not show the updated query results unless the form is closed and reopened. Requery methods do not work. It's something simple but I'm...

I got the Teac when I was deployed on WestPac, that was a lifetime and another world ago. Picked it up in Yokosuka and like you shipped it home (no room for it on the sub). The Teac handled 7" and 10.5" reels. With the 10.5" reel, you could record up to 6 hours of music. There lies the problem...

Mr. B, I just realized that if I use the Enter key after entering the Standard the code works just fine. Its a lot cleaner your way! Thanks again!

Many Thanks Mr. B, That will get me started. I'll need to play with the code a bit as the Add Standard button is not available after entering a Standard unless I reselect the Task. But I get the idea and will repost here if I get it to work. That's how I'll learn!

Casettes? I still use my Teac X-2000R reel-to-reel!

I wear a Seiko Solar. I don't always have my Blackberry (a.k.a. "Dingleberry" cuz it's always hanging off my a$$ when I'm on the road) handy in the office so a watch is a necessity. I also teach and a watch is handy to keep track of time at a glance when instructing.

I am a beginner user in MSAccess and VBA code. I'm developing a form for data entry. I'm using a combo box to select a Task from a table and a cascaded list box to select the Elements from a query based on the selected Task. I have a text box to enter Standards for the selected Element. When...