Search results for query: *

Is there a way to use a variable in the select_statement part of the DECLARE CURSOR? For instance I would like to do the following SELECT @SQL = 'SELECT [' + @FieldName + '] FROM [QueryName]' DECLARE CURSOR_1 CURSOR FOR @SQL However this does not seem to work. Is there any way to do this...

If I were to make a report that includes an intersectioin table in the query it would contain multiple records for a particular Field in the primary table. This would then make my reports show one line per record, when I'd rather have all the intersection field data in one field. Example...

Somehow, I can no longer right click on objects in design view and get a menu in Access 2002. Does anyone know how to turn this back on? Thanks for any help

I have a page that has a 2 list boxes and a combo box. The first list box is populated from a database with all the names of our associates. The other list box is empty as is the combo box. Here are the identifiers for each item: List box #1 Available Users List box #2 Selected users Combo...

What I would like to know is if there is any way to take a standard one to many relationship and then displaying only 1 for each related item. For instance, say i have a table: Exceptions: ExceptionID <-- Primary Key LoanID <-- Foreign Key ItemID <-- Foreign Key Instead of in a...

I need to build a report from a query that has 3 tables joined, however I would like the 2nd level grouping to go accross the top instead of down. ex. Table 1 ------- Contract # AffiliateCode CustFName CustLName Loan # Table 2 ------- ExceptionID ExceptionCode ExceptionDesc ExceptionType...

How would you get field names using VBA? I want to do this so that I can create a custom query builder that end users can use via a form. i have the table part of it. Function ShowTables() Dim mytables As TableDefs Dim currenttable As TableDef Dim currentfields As Fields...

I have some code: if not isempty(Request.form(&quot;Submit&quot;)) then do code end if This works if the user clicks on the submit button but not if they hit the enter key.. Is there a way around this so that it will always run that code in the if statement if they click on the submit or hit...

Anyone have any idea at all what is up with that error message! I am almost to my breaking limit here! I get the above error whenever I try to Save for Web in Photoshop 7.01 and when I try to open a file in ImageReady 7.01. I can open a file in Photoshop and then &quot;jump to&quot; ImageReady...

I have a table callled classdate which contains these fields dateid classid instructor1 instructor2 instructor3 instructorcredit There can be as many as 3 instructors for one class on any date. One instructor could teach the same class just on different days. I wanted to develop a query that...

I have a report that has a typical Report Header, Group Header, Detail, Group Footer, Report Footer. In the Group Footer I have a subreport. I was wondering if there was any to reduce or eliminate the Group footer height if the subreport contains no data for that particular record. Thanks.

I am getting an error message: Microsoft OLE DB Provider for ODBC Drivers error '80004005' [Microsoft][ODBC Microsoft Access Driver] Disk or network error. /rlwentry.asp, line 6 whenever I try to pull up any pages that have a DSN in it. Pages that just have ASP and no DSN connection work...

I have a project table where employees enter their time they worked on a project. What I need is a query that will determine which dates each employee has not entered anything in. Or something that will notify them that there has not been any time entered for each specific date. Any...

Do global variables have a time out limit? I find when I set a global variable it loses the value after a certain amount of time. Is there anyway to hold that value the whole time they have the application open??

I have set up to record who is logging in to my database based on their network log on. What is the procedure to set certain permissions depending on who logs on. I tried this code below: Function SetVariables() Dim rs As Recordset Dim doc As Document Dim db As Database Dim con...

I have a form that has a list box on it then when they select a name and click on my print preview button they will get a report listing only that person. How do you code it so I can make the list box a multiple selection? I assuming it has to deal with arrays and a do while loop? I'm not...

What is the best way to include an SQL statement in my VB Code and then assign the value to a variable? For example, when my form opens I would like to be able to select the max value from a table and then store it in a Global variable??

Can anyone tell me how to get rid of the windows installer pop up that appears everytime I start an Office application? I would appreciate any help thanks

Is there any way to automatically run an update query whenever data changes in another table?

Is there a way to replace double quotes in ASP? I usually use the Replace function but I'm not sure how to use it to include double quotes &quot; I need to change them all to \&quot; so that when they are inserted into my javascript function it will display the double quotes and not give me an...