Recent content by Jim Dudley

Thank you for your input. I suspected what you have said but was hoping that I had missed something. There are 6 or 7 forms that are not compliant, so I think what I will do is make new forms, add the controls and link the new controls to the existing code. That way they will work with Themes...

I have several pop-up forms that were created by a contract programmer. I do not like the colour scheme (theme) used. I have tried using the Layout View and Themes to change the appearance of the forms but to no avail. I cannot get them to change to the standard Office colours and fonts. I...

I will create a list of the issues, I am still working on defining them. Please forward me an email so that I can send the code and data structure along with the issues to get an idea of what help I need. Thank you. Regards, Jim jac.dudley@live.ca

Last year, with the help of many members of this forum, I created an Access application for a local College. Several issues with the code have arisen. What I am looking for is someone to work with me on the code to resolve these issues. The problem is that this request probably exceeds any...

Yes, I have tried what you suggested in the past and am aware of how it works. That is why I created the templates with the date column and the SNum column pre-formatted. But if a user makes a mistake and erases a row or several rows of entry the pre-formating is destroyed. I like what you are...

In other words forget about what excel does and query the temporary table the import creates to find any 8 digit identifiers and update them to a 9 digit identifier by concatenating a 0 (zero). The temporary file when created is treating the [SNum] field as Numeric not Text. How can I force this...

Background: There are two different Excel Templates that are filled in at various campuses and then forwarded to a Central Administration office where the contents are Imported into Access 2010. The import function is automated via VBA code and inserts the contents of each spreadsheet...

I have a form that has two sub-forms in the main form side by side(Pop-ups). Below I have a series of 10 tabs. 9 of them contain additional sub_forms which are created by up to 4 queries. Query on query etc. Some of them involve Cross Tab queries. Issue: When I load the consolidated form with...

Thank you that works. Jim

Thank you for your input. I will try your suggestion and report back on my results. Jim

Situation: I have two Cross Tab Queries that Pivot on Text fields and return a Count for each category. Occasionally, one of more of the categories may have no data/activity during the period/date range of the query's criteria. What I want to do is to force a column for those categories. In as...

Here is the alternate solution that appears to resolve the original posted question. I tested it one incident and it achieved the desired results. Solution: Rather than in the crosstab query, I'd suggest calling the Switch function in a query on which the crosstab query is based, e.g...

Actually, each section in the Excel sheet is linked to a specific Excel sheet that was exported from a form, which was created from a summary query. In Access I have a form with 12 tabs/sub-forms representing the results of the queries which supply the data. Each of these sub-forms is exported...

[Credits] is a number field. Background: Students earn credits for attending workshops/seminars. When we summarize the [Credits], we report on the number of students with one credit, two credits, 3 credits and 4 or more credits. If in a given period for reporting there are no students say with...

I have a query that worked using the "Switch" option in the Pivot Statement. I needed to ensure that if in some instances there was no data available in a given Selection of records for one of the fields the Pivot would create, that the query not crash but return a null or "0" value in that...