Search results for query: *

I am writing a series of crosstab queries like the one below TRANSFORM Nz(Count([macs-US].[loggedBy]),0) AS CountOfREFNUM SELECT Format([ALRTDATE],"yyyy-mm") AS monthu, Format([ALRTDATE],"mmm-yyyy") AS [Month] FROM (SELECT [macs-US].LOGGEDBY, [macs-US].ALRTDATE, [macs-US].COMPCODE...

I am sure there is a simple trick here I am missing so I am asking for help. I have worked with Access97 for 2 years now and just been moved to Access2K with no books to reference. In 97 when I add a subform when designing the form, it appears as a flat reference which you can double click on...

I have been using some of the modules available (from microsoft support and also EZ tools from Database Creations Inc) to get information from the msldbuser.dll. The code I am using now gives the computer information rather than the username. I need a list of users currently logged on listed by...

I have started to do a lot of tasks in the autoexec file and my users are starting to complain about the opening time. I would like to use a database shell purely to do these tasks and running it at some point in the early am. I do not have a lot of experience with task scheduler so I am...

I have forms that need to have data entered but have a field Status (Yes/No) that indicates the data entry is finished. But there are fields that must still be open such as the comment subforms. I am trying to use the tag field to let the form know which fields to lock and the "for...

Is there an easy way to get the minimum, maximum and average value of a recordset. I currently have a recordset that works on an union query and that is filtered for dates and selection query. I then take two values put them in a function to create a number. I wish to return the average, the...

Is it possible to use a Dlookup as a sort and Grouping category in a report. I have a report that brings in an employee's ID# but I would like it to sort by the employee last name. I know the lookup works (I tested it in a temporary report (as a control source for a field) but it doesnt work as...

I feel I have a good grip of the basics of SQL and I am trying to grip the more complex. I just wrote a query that starts with one query which grabs the selection criteria from a form. I then bring that into a second query which using totals counts the number of time a field occurs. I then...

Is Treeview purely for Access 2000 or can I attempt to use it with Access 97? (If it does work with 97 any hints apart from searching the archives - my first plan?) Thanks for any input.

I am building a form to track rejected product and doing fine until I got a request for a little more complexity that just takes it past my immediate knowledge. I have the following fields- RejectType, Action (Added, Destroyed, Issued) and Number of Product. I need to keep track of total...

I am trying to get a date from an input box. Obviously it returns a string, how can I get this to be changed to a date to allow it to be added into a date field in a insert query that creates a new record? Do I have to go through a variant varaible? Any hints?

We are starting to have our users converted to using windows 2000, and the sendobject code which worked fine in win 98 is now causing an error message. has anyone dealt with any such problems before. Old code DoCmd.SendObject acSendNoObject, , acFormatRTF, "Recipient", , , "Change...

This seems a ridiculously easy problem but when I resized a form to allow more buttons for a query, Access (97) seems to refuse to recognise the change in size and opens to the old size. I am not a novice programmer but this is driving me CRAZY, please help me figure why this bug is occuring...

If you have set up your database to have different levels of security I was wondering if there was a way to detect the level of authority in VBA and set up locking accordingly. I know you can use CurrentUser to identify a user but I want to be able to allow or stop a person changing a field...

I have been handed a Access 97 db that I figure was overdesigned. My problem is that the employee table has relationships with other tables with referential integrity being enforced. BUT the designer did not set up cascading updating. I can understand that cascading deleting will cause...

I was wondering if anyone had solved this problem before me. I need to get the alpha symbol in a table set up in font Arial. Using the Character Map I can see easily how to add betas "registered trademark" and "copyright" symbols but cant seem to figure this one. Thanks...