Hi I have a subform called 'fSubProblem' in my main form. I need to set the value of the 'ProblemID' field of this subform to 0. This is my code: Form!...
AccessUser: First, you must reference the name of the subform control, which is not necessarily the same as the name of the form inside the control. With your...
Bob You might also need to refresh the table links. Take a look at this article: http://support.microsoft.com/kb/291264 Bill ... isn't getting ... in your ... ...
David Sorry to leave you hanging for so long. The network folder has to be trusted. Click on the Office button>Access options>Trust Center>TrustCenter...
Hi James I can't help you with removing the extra space but I can help with the indenting. To indent each paragraph you can use a function. Open the report in ...
This probably fundamental but I haven't done it before. How can a build a second query to use the results of the "Count" query below (without using a loop)?...
Mike Save your query as MyQuery. Then create a query using MyQuery SELECT MyQuery.[Security File], Sum([CountOfLOAN NUMBER]) AS TotalCount FROM MyQuery GROUP...
On the first tab of a tab control, I use the wizard to create an event to add/create records via a sub-form. There are some mandatory fields required before...
Hi, John's suggestion worked. I deleted as many references as I could and still compile the code and that got me past the road block. I had some old refernces...
THanks, Bill! I got rid of the extra space when I switched the formatting from rich text to plain text. Now the only issue is the indentation, and your...
James McAlister
forums01@...
Aug 1, 2008 6:01 pm
63576
In VBA, how can I get the second query (below) to use the first query for its results? Thanks in advance! Mike 'CODE------------------------------- Dim rs As...
Bob Nine times out of ten when a built-in function fails, it means the DAO library is not registered. Try registering it. The runtime install should have done...
In case someone needs the solution, here it is... Mike 'CODE--------------------------------- Dim rs As DAO.Recordset Dim passThrough As QueryDef Dim strSQL As...
Mike thanks for posting your soultion. It appears that you are using an SQL Server back end (passthrough). You could also have made a temporary table using...
Mit- All that should be in your GROUP BY clause is [Security File]. I have no clue what that NOT syntax is doing. If you're doing this on the query grid, ...
Bob- Reports are quirky. Is there a control with DateOfAdd bound to it on the report? If not, the report might not see it. The report engine actually builds...
The function works well, Bill, but when I use it, the mysterious extra white space appears again for those occasions where the Comments field is supposedly...
James McAlister
forums01@...
Aug 1, 2008 11:44 pm
63586
I use a union query to collect all known email addresses into one recordset. It starts with an empty record. How do I remove that? Thanks, Robin Chapple SELECT...
Robin- Maybe this will do it: SELECT [Email] as Emayle FROM [qMembers] WHERE qMembers.Email Is Not Null UNION SELECT [Email2] as Emayle FROM [qMembers] WHERE...
'Morning, John! I'm going to completely rebuild the Db per suggestions received here. I'm hoping to have to redo it [only] this once, so am trying to get as ...
Earl- Not a bad start, but I see several problems. A record in a table should be about one and only one subject. You have at least three subjects in this ...
Thanks again for all your help, John. I can see that you're putting considerable time and effort into your replies and I truly appreciate it. Just please have...
See my additional comments below... John Viescas, author Microsoft Office Access 2007 Inside Out Building Microsoft Access Applications Microsoft Office Access...
Hi David I steps I gave you were for Access 2007...obviously not the ones you need. I'm not using Vista on any of the machines I have so this is just a shot in...
That's it Bill, I open IE, selected Tools>Internet Options>Security tab>Local Intranet>sites>Advanced>Add I'd previously copied the full path to the database...
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.
