Recent content by arichins

Yeah! I figured it out, hopefully this will help someone in the future. Basically, if you are using a query to select the data to be output, and the columns of your query don't match the table from which you built your export spec (in my case, they were in a different order), it'll cause this...

I'm not sure how to share the export spec. I create it by going through Access export data wizard (right click on table---> export data---> to text file). There's a point where you hit advanced, and have the opportunity to remove the text qualifier and save the spec. As far as the code, that...

I'm trying to export data to a csv file from access. It works great, so long as I don't specify an export specification in the vb command. But the reason I need to use an export specification, is that otherwise, Access will use double-quotes as a text qualifier, and I need there to be no text...

I figured out what my problem was, I had to put the requery statement in the report open event. I had it in form load.

Right, I can set the record source of the sub form to look at the value of the drop down fields, and it'll work fine, for one route. What I'm trying to do, is allow someone to select a route, and have a report that shows data pertaining to the route, and the sub form has stop data for all that...

I made a form, where a user can select the value of 3 fields from a combo boxes. The values of these fields are passed to a report as parameters. The report parses out the parameters and uses them in the record source query. So far so good. My problem is, the report has a sub report, which...

Thanks for your reply Linq. I was having this same problem, and I knew how to handle it with a 'close' button, but wanted to know how to handle it if the user closes the whole window Access rather than using the form button. I tried the on_close event, but found the record had already been...

I've got a master form, which is used to search for records, and display links to them in a list box. When the user selects a record, they get the full details of the record on a subform. At the top of the subform, I have two buttons, an edit button, which allows them to make changes to the...

I'm having an odd problem with a form. We noticed this since migrating it from adp to accdb. It's a form with two subforms in datasheet view, that contain data on a certain employee, which is selected on the main form. If you use print preview before printing, it all prints out fine...

CJ/Shadow, Yes, I had tried running the compact/repair, but I think this was a problem relating to the use of ADP, which was on it's last ropes. I did have my own development version of the database that only I would be in, but it would freeze up in both databases. I don't have this problem...

I can think of a way to do this with derived tables in a query, or with using code to loop through a record set...I like to use queries whenever possible though. So you'd make a derived table that has the JobID, procedure_IDs for the job in question, and the count of total procedures needed for...

Ok, I figured out what you meant, in the where clause, I determine if the difference between the time in the database and the user parameter is greater than or less than 0, to determine of is less than or greater than! Nice job! I don't know I'd ever have thought to try that.

Good to know I'm no the only one having this problem: In my case though, I'm trying to return records whose time falls between time A and time B, which are times supplied by the Access end user. How are you using datediff?

I have a linked table in my access accdb file to a view on a SQL Server DB. One of the columns is a date column, where only the time value is important, so it's stored in the default format, like 12-30-1899 12:00 AM. In SQL Server, I can query records that fall between a certain time frame...

I had a form in an ADP database that the user could print. It's a simple form which brings up rows in datasheet view. But I had to convert this form to accdb, and as part of that process, the source of the form was changed from a stored procedure to an ado query. The ado query usings...