This where I show myself up as a total newbie...the function below came from the Northwind sample db...I was following a procedure in the help file that...
Thanks John, I've had a problem getting the data from Access to Excel, but have now succeeded using the following code... DoCmd.OutputTo acOutputQuery,...
Again out of curiousity, could you post the code that was in the 2000 version? I only have sample db's installed for all versions, and just at a glance, I'm...
here you go... 2000... Option Compare Database Option Explicit Function IsLoaded(ByVal strFormName As String) As Boolean ' Returns True if the specified form...
Hmm, I guess the IsLoaded function on the form object must be new. I don't have the time for experimentation right now, but my guess is that the 2000 version...
Hi, I want to write a SQL query in Access as follows : select year, ((count[field1] from table1 where status='Y')/count[field1]) i.e. I need to calculate a...
Brett- Don't get me started on Help. They trashed it in Access 2000, and it has never recovered. It's the #1 complaint item amongst MVPs. John Viescas,...
Julie- The name course_id implies a number, so get rid of the quotes: CurrentDb.Execute "INSERT INTO tblCourseStats (course_id) VALUES(" & Me.course_id & ")" ...
What error are you getting? The syntax look OK based on the information you've given us. Are there other fields in the record which are required? Charles ... ...
Nige- Pardon me for saying so, but "limited level of knowledge" and "clients" don't belong together. As a client, why would I want to take my automobile in...
Daniel- I agree. You're pretty safe as long as you're not developing an Access project (.adp), you're not using Data Access Pages (they're broken in 2000 and...
... I know, I know ... :( Most of the Property-F1's work, the SubDataSheet one is the first one I have come across that doesn't. I wondered if it had been...
Nige- Go find the post "controlling excel from access" sent on Monday to this group. You basically need to start a session with Excel, open your workbook, and...
Hello All, I have written a public function in the VB code section of a Switchboard form, and I'm trying to get it to run from a switchboard button using the...
The 2000 (and earlier) version uses SysCmd: Function IsLoaded(ByVal strFormName As String) As Boolean ' Returns True if the specified form is open in Form view...
I hope you're being honest about your "level of ... yes, I am very honest...I am not a programmer/developer...and never pretend to be one! in the course of the...
In Access 2002 the "triple state" property of a checkbox form control doesn't work when I try to use it. When I enable the triple state property, the check...
Dave- The Switchboard code uses Application.Run to execute the procedure. Public procedures in a form module are actually methods of the form, so you can call...
Nige- Ah, good! So, by "clients" you mean people who have hired you for your expertise in other areas, but some of the things they've asked you to do just cry...
Dan- Works for me. Make sure the Enabled property is set to Yes. Is the control bound to a field? Is that field updatable? John Viescas, author "Microsoft...
That function will not work in 2000. The below function works in 2000 and 97. I'm guessing it will also work in XP and 2003. Function IsLoaded(ByVal...
Hello All On a report I have 3 differents sub-reports not linked to each other, I need to print 5 records on a page for all the three reports on the main...
Julie, Create 2 identical queries. Suffix one with a 0 (zero) and the other with a 1. The 0 query is your base query. Then use the following code: dim qdf as...
John, Thanks for your response. I have done as you suggested: I put my code into a public function in a module (named CodeModule), but I'm still getting the...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
