Recent content by btalon

I've always used the DoCmd to open the report, but it doesn't really give you any programming flexibility besides the criteria unless you do the coding on the report itself. I haven't been able to find another way to open a report using VBA where I can set the recordsource when it is opened...

My next goal is to open a report passing the parameters down to the query the report is running off of. I haven't been able to get this to work successfully so far. In the past I have set the recordsource for the report to a recordset in the Report_Open sub, but I had to code the Detail_Print...

I should mention that I couldn't use the qd.execute. The execute won't work with a select query so I opened a recordset off of the queryDef object. Set db = CurrentDb Set qryDef = db.QueryDefs("qryBookedInvoicedByGraphic") qryDef.Parameters("[@startDate]") = txtStartDate...

I should mention that I counldn't use the qd.execute. The execute is only allowed with an action query. So I opened a recordset off of the queryDef object: Set db = CurrentDb Set qryDef = db.QueryDefs("qryBookedInvoicedByGraphic") qryDef.Parameters("[@startDate]") = txtStartDate...

I should mention that I couldn't use the qd.execute. The execute won't work with a select query so I opened a recordset off of the queryDef object. Set db = CurrentDb Set qryDef = db.QueryDefs("qryBookedInvoicedByGraphic") qryDef.Parameters("[@startDate]") = txtStartDate...

jsteph, that worked beautifully. A star for you. Thanks.

I have created queries in the past with a form input hardcoded in the query "WHERE....LIKE txtTextbox". That is not what I'm trying to accomplish. I want to call the query in from the VBA code similar to the following: db.execute "queryname", variable1, variable2. I don't want to hardcode the...

I am wanting to use a query like a stored procedure and pass it variables on the fly using VBA. In the past I have assigned the variable to some sort of input control to get the information, but I don't want to hardcode that object into the query. I wan't to pass it the information when I call...

Still doesn't work. I never get the "200 Port command successful" message. Can anyone tell what the 200 port command is or does exaclty? After the 200 Port command successful there is usually a "150 Opening data connection for 'the filename'" and I don't get that either.

ftp ftp.url.com I enter username I enter password binary I'm sitting in the directory where the file resides that I want to ftp. I then use: mput JM*.us5 Then it asks to confirm the mput and I put "y". Then it hangs there for a little bit, then gets dropped. I've checked the FTP server...

I'm not using a client. I am in DOS executing the commands manually.

I'm having intermittent problems with DOS on XP and the FTP command mput. DOS hangs when executing the mput command until the connection is teminated by the host. I don't see firewall or router issues blocking the request to the FTP server. The actual FTP server never receives the request to...

We've had the same problem here. I've posted about this issue on a couple of forums and have had no luck. When the Macs are indexing the directories, it's leaving the resource forks open on the server (using a SMB mount on our 2003 server as opposed to the AFP mount on the NT server we used to...

Does it boot into the Unix shell? From there you can copy the files back into the system>library>fonts folder (assuming you know Unix). I had a user do the same thing two days ago, was having problems with extensis and fonts and moved the system fonts to the desktop. I copied the fonts back to...

It wasn't a permissions issue. I ended up having to turn off the Apple Menu Options Control Panel under the extention manager for classic. It runs fine now.