Search results for query: *

I am working with one table that has a field indicating: FiscalYearEndMonth, UnitName, LocalUnitType. I need to get a summary information by fiscalyearendmonth and localunittype. I'm not certain how to get this aggregrate information.

I have a table: LocalUnitAudit which provides me CountyCd, LocalUnitType, LocalUnitCd, FiscalYear, AuditRecDate. Currently I have information in there for a local unit which indicates the last auditrecdate was 6/1/2006 and it was for FiscalYear 2005. However, there are also two additional...

Awhile back I was getting help with what I call some complex queries. While most of the issues were resolved at the time, one was not and its resurfaced. In reference to thread 701-1351569(last couple posts) I have a query: SELECT A.LocalUnitCd, A.LocalUnitType, A.CountyCd, L.LastAuditDate...

Just discovered that....thanks Remou Have a great weekend

I have a form which I was in the process of adding several new buttons to, now no matter what button I click on I get the following error: The expression ONCLICK you entered as the event property setting produced the following error: Ambiguous Error Detected, Cmd8Click What does this mean?

I have a form I created, with a field that I put in as a calculated-read only, run-time property set to current date/time. While it does display on the form as it should, I was hoping to have it come through with the other fields when the data file is sent, however it does not. Does anyone...

I guess I thought the following was element-centric and it imported with data when I tried with my access program at home but not work. The only difference there was I'm running 2003 at home and 2002 at work. <?xml version="1.0" encoding="UTF-8" ?> - <form1> - <!--...

I'm still trying to resolve this issue. I'm trying to import a simple xml document into access. At the access end, I'm selecting "get external data", highlighting my xml file, and clicking ok. I then indicate to import "structure and data" however I only end up with the structure. Can anyone...

Alright, at work I have OS of XP, Access 2002. I tried running this import at home, where I have OS of XP, Access 2003 and it worked there. Unfortunately however that doesn't help me at this end for work getting the structure and data to import.

I'm working with Access XP, does anyone know if that would be causing me any issues?

I have a file being received from a user that is in .xml and when I go to import the document into Access, it only imports the structure, no data. I am selecting the option to import both data and structure but I'm not getting any data. Any ideas what could be wrong? <?xml version="1.0"...

Appreciate the help, thanks.

Thanks, one other question. Can you set the page to open via enter mode only like you can a form? I would like it to open up to an empty page.

I've not worked with Access Pages much, however I thought users could edit or enter new data into a page. On my page the buttons are greyed out to add a new record or delete a record. I wanted to create a page so users could use it to input data into our database, instead of having them...

In the past I worked with OmniForm software, the forms you created in that software allowed you to import the forms into a database. Not being that familar with Adobe I was merely wondering if forms created and saved had any similar options. But what I'm hearing is that it does not I guess.

Would I have any other options available with dealing with many forms completed in Adobe so I could utilize that information?

I've not worked with Adobe very much but wondering if there is a way to work with the data from forms that are scanned.

I'm working with a table that has the following structure: [autono]pk [quest_num]pk [quest_yn] [quest_weight] The table holds a yes no reply to a series of 15 questions. Each question has a certain weight factor. later. I need to be able to perform 2 task. The first is to come up with a...

Thanks that works good.

So how would that look in this query given the primary key field is AUTONO and the form name is REVIEW INSERT INTO AUDITRPT_RESPONSE ( AUTONO, QUESTION_YN, QUESTION_NUM ) SELECT [AUDIT REVIEWS].AUTONO, [AUDIT REVIEWS].[05-10], "3" AS QUESTION_NUM FROM [AUDIT REVIEWS];