Search results

Hi all, I've got a parameter query that works fine, I just don't know how to display the result table. It's set up in DAO right now but it is not required to stay that way. This is the query and it gets in to memory just fines. Set qd = dbs.QueryDefs!queryArchive2...

TY Many thanks PB

I've got a query that pulls data. When I have the data, I want to sort it, but the numbers are text. When I sort text numbers it comes out wrong 110 1123 113 114356 115 Can I type cast this query to make the data retrieved be numeric (currency)??? SELECT [Prolift].[Fleet#]...

Hi, everyone. I'm calling Excel from Access. Is there a way to convert .Range("B1:D1,B4:D4").Select into an Excel function using Cells() instead. .Range(cells(w, x), cells(y, z)) works for solid ranges but "B1:D1,B4:D4" is selected on non consecutive rows. .Range(cells(a, b):cells(c,d) ...

Great! Hey, thanks for the tips guys. In my inexperience, I overlooked the easiest method of all. DoCmd.RunSQL. Sorry to have bothered you. PB

Hmmm I still get the same error..... The Microsoft Jet database engine cannot find the input table or query 'costRecord'. Make sure it exists and that it is spelled correctly. A more succint way of doing it would be more than welcomed as well as long as it uses a string SQL statement. Thanks PB

Hi, all. I'm trying to do an update on a database using an SQL statement built from a string. What's wrong with this code snippet? Sub addDate() Dim db As Database Dim qdf As QueryDef Dim mySQL As String Dim lastMonth As Integer Dim reportYear As Integer...

Hi, everyone. I have a DAO connection and I need to run a query String on it instead of a saved query. I already have this Dim db As DAO.Database Dim rst As DAO.Recordset Dim mySQL as String Set db = CurrentDb mySQL = "SELECT * from table where dept ='" & myDept & "'" Set rst =...

Can anyone suggest a VB6 forum similar to this Access Forum? PB

hmm That is fabulous. Thank you. The only problem is... I don't quite see what the query is doing. Any clues you can offer. How is Select DeptCode, TruckN, sum(P1), sum(N1), sum(A1) from Query1 Group By DeptCode, TruckN only telling it to combine when they deptcode and truckn are equal...

Hi all, I have two tables from two vendors. Vendor1 DeptCode......TruckN.....PMC.....NormC.....AbnormC F4000............F100.......$100.....$500.......$10 IA702.............F110.......$100.....$500.......$10 MA702...........T150.......$100......$500.......$10 etc Vendor2...

I have a recordSet from a form. Dim rst As DAO.recordSet Set rst = Me.recordSet When I type rst dot and look at the pop up list of methods, I don't see any indication of the ability to query this recordset. Am I just missing it? If there's no way to query a recordSet, are there...

Thanks Thank you both. I've got it working. To think that I had so much trouble because I was trying to write the parameter query with the # signs...... between #[Enter Start Date]# and #[Enter End Date]# LOL. Just about every problem I run in to in Access is syntax based. Is there a...

If I put: Like "*" & [Enter a Field_Name] & "*" in the criteria for non dates, I get the prompt I need but I'm not sure how to structure this type of criteria given the ## around the dates And the fact the I need 2, the start and end dates for the query... Between #3/1/2003# and...

hmmm Well when I do that it tells me Runtime error 7874 MS Access can't find the object 'Select * from tableName' This seems ... to be used for saved queries. This query is built on the fly in code. I suppose there's a quick way to tie a prompting query in to all of this but I'm not sure...

Hi all, I have a query that is built from a string variable. (the date is variable by input from the user). myQuery = "Select whatever from tableName where date_field between #" & myDate1 & "# and #" & myDate2 ";" DoCmd.RunSQL wants an action query. What command could I use to get this to...

Hmm Would the ActiveX be included in normal Chrystal Distributions or do I need to find it somewhere? Thanks PB

Hi everyone, I was just wondering if one could launch a chrystal report file from Excel or Access with some sort of connection command given the path the the file. The obvious example, launching an Excel workbook from Access. That's easy. If it's a big chore, a link to info would be great as...

Hi, everybody, I have a query that is displayed in Excel. I receive a variable that tells me how many columns were returned from the table. I need to select the region of the data for a graph (in code). Since Excel spreadsheets header the columns with letters, the only method I can think of...

Aaarrgghh I do apologize for wasting anyone's time with this. DistinctRow did Exactly what it was supposed to... I just changed it to Distinct and it only looked at the one column. Sorry. PB