Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: goslincm
  • Order by date
  1. goslincm

    Aggregate Information

    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.
  2. goslincm

    Thread 701-1351569

    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...
  3. goslincm

    Thread 701-1351569

    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...
  4. goslincm

    Code behind button on form

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

    Code behind button on form

    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?
  6. goslincm

    data file

    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...
  7. goslincm

    .xml file into access 2002

    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> - <!--...
  8. goslincm

    .xml file into access 2002

    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...
  9. goslincm

    Importing an xml file

    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.
  10. goslincm

    Importing an xml file

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

    Importing an xml file

    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"...
  12. goslincm

    Cannot edit new page

    Appreciate the help, thanks.
  13. goslincm

    Cannot edit new page

    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.
  14. goslincm

    Cannot edit new 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...
  15. goslincm

    Scan form into database

    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.
  16. goslincm

    Scan form into database

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

    Scan form into database

    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.
  18. goslincm

    Best way to set up this query

    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...
  19. goslincm

    Update query for current record only

    Thanks that works good.
  20. goslincm

    Update query for current record only

    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];

Part and Inventory Search

Back
Top