Search results for query: *

I'm having difficulty with the below query (actually just a portion of a much large one - thus the structure.) I am told "invalid identifier" at line 2, allV.AllVoters. However, if I swap the fields, I get the error at line 2 again, this time on allV.AllDate. Any ideas what is wrong? SELECT...

I have a 2000/2003 format database used only for reporting. It has linked tables to an SQL Server database. It automatically opens a form with two buttons on it (no data) and hides the database window and the regular menu, replacing it with my own toolbar. The default open mode for the...

So I know this is all over the web as well as this forum - but I'm adding to the mess. :) I referred to this thread and followed instructions accordingly: http://www.tek-tips.com/viewthread.cfm?qid=1245067 The problem is, although I don't get an error, my field is completely blank! Based on...

There is a query that has been in use for over a year, runs fine. Recently, I made a copy of the db to make some edits. I added a single field from a table already there, gave it a criteria, saved and ran it. Got the message "ambiguous outer joins." Of course, I can't open the SQL view to...

I created a file dsn looking up to SQLServer. I used that dsn to create linked tables in an Access db. I then deleted the file dsn (long story - basically, testing everything I can think of.) Why can I still read the linked tables? If I delete a machine datasource the tables that used it for...

I have an access mdb with linked tables - not for data editing - just reporting. Currently using a machine DSN, though I want to move to a file DSN - but that's another issue. :) Being a cautious person, I have multiple versions - new version for every change. Previous versions are shareable...

I don't know if this is an Access question or an SQL question. But hopefully someone has encountered this before! We have an Access database (2003) used just for reporting that links to views on an SQLServer (2000) database. A year into implementation it was determined that a column needed...

I have a form which a control with a default value of now() so we have the date and the time. The format automatically is date hh:mm:ss Meridian The users sometimes change the date and time in this field, and they don't like the seconds. Is there anyway to get rid of them easily? BTW -...

I've seen a few threads on this, but not exactly like what I need. Here's a brief description: Table1 columns: EventDate, EventId, CaseID, typeID Table2 columns: typeID, statusID Table3 columns: statusID, statusDesc I am creating a case statistics report. Desired output: TotalCases...

I have a stored proc (abbreviated here) that works in the query analyzer: ALTER Procedure dbo.CSF_UPDATE_Address_SP ( @Address_ID Integer, @Line_1_VC30 Varchar(60), @ReturnID1 Int OUTPUT) AS exec sco_db.dbo.address_update_sp @address_id, @Line_1_VC30, @ReturnID = @ReturnID1...

I have a stored proc which is calling another stored proc. Here's a shortened version: ALTER Procedure dbo.CSF_UPDATE_Address_SP ( @Address_ID Integer, @Line_1_VC30 Varchar(60), @ReturnID Int OUTPUT) AS exec sco_db.dbo.address_update_sp @address_id, @Line_1_VC30, @ReturnID OUTPUT...

Ok - so there are numerous ways of handling execution of commands on the database. There are two that I use regularly. (FYI - I program almost exclusively in Access projects, so I don't know if there may be yet others when dealing with linked tables or an Access back end.) My examples follow...

I have a query that the user frequently exports to excel. It's a linked db to SQL server, if that makes any difference. We use "1/1/1900" as a default in date fields when the user does not have a date, so a number of our queries show that date. What's odd is that when exported to excel...

I am attempting to use the principles outline in this help article: http://support.microsoft.com/kb/234907 My problem is in actually getting the Property Set to work properly. Here's the part in my class module: Private WithEvents rpt As Access.Report Property Set Report(rptIn As...

I have a main screen which I may be opening from any number of locations. I want to close whatever I am on after opening the main screen without having to code an individual button. Instead, I'm just using a menu button with a macro telling it to run a function which opens the main form and...

I have a database in which the recordsource for reports are set using VBA, not the properties. So on the onOpen event of the report I set the recordset. On the onFormat Event of the report header I set the values of any calculated controls which will be in the report header. This is fine for...

I have a report which is not bound in the property but is instead bound in the code (on the open event of the report.) All works fine except the calculated control I have in the report header. If I put that control in the page header, no problem - but apparently Access tries to calculate the...

I have the following line in my VBA, attempting to open a recordset. I am getting a server syntax error near ",". Does the error happen to jump out at anyone? CurrentProject.Connection.Execute ("ReportName (" & longVariable & ", '" & dateVariable & "', '" & dateVariable & "')")

Using adhresize, from http://www.developershandbook.com Usually, this works beautifully. But on on screen, it actually resizes twice - making it much to big. I thought maybe I had put it the code in there twice, but it turns out I didn't. I know this is unsupported freeware, but I was hoping...

I am unfamiliar with DAO objects, though I have been reading up on them. I have mostly used ADO (though i'm very new to that, too.). My db is using linked tables to an Access backend. Anyway, I need to save a record and return the id (unbound form.) I have basically the following code...