Search results

Hi all, I have a folder on our network that contains several backends. They've been working fine for quite sometime. Just in the last couple of days people have been getting errors when they try to update a record that says record is currently locked could not update. Then the FE just...

Trying to export the newly opened db to a text file

Is it possible from one database to open another database in code and do a transfertext command on a table in the database opened in code?

well it let me do it in My Documents folder as the path to save. But not in the one I was trying. Any idea why?

won't let me

It's asking for a schema file. I've never created one of those. Can you walk me through it?

Thank you. That's what I was looking for.

Is there a docmd or something else where I can export a query to a csv file?

There's a couple things you can do 1. You can setup your form on it's BeforeUpdate to open the Oracle table and update the same record before it updates the local table - or - 2. Setup a field in the local table as a Yes/No. Then on the BeforeUpdate have it mark this field as Yes. Then on...

Kevin, Let me know if you find anything on this. I'm gonna look myself.

I was thinking about doing something like that. Kind of like your own version of replication. When the user changes a record do you have the form update the same record on the server?

Kevin, If you do this using an Access backend and a DAO recordset, will it keep it disconnected from the backend? I've been trying to figure out a way to do that since my dbs run so slow due to all the people connected to them all the time.

Sounds like you know more about adp files than I do. But I thought that when you created a stored procedure in adp that the processing occurs on the server. But I could be wrong. Hope you find the answer.

Lol! I just realized you're a different Kevin than I thought I was talking to. Anyway, better to use an access project (adp) to access SQL Server. That way you set the recordset of a form to a stored procedure. Man I wish I had realized that earlier. I know you put it in your original...

Are you using a mdb file or adp? I didn't pick up early that you were accessing a SQL Server.

Don't think you can. You can take the SQL of the recordset and plug that in. But then there's no reason to actually create the recordset. I really don't think Access was designed for that. And although, a lot of us have figured out ways around Access' design, I think this is one that's...

I think the issue is that the form needs a string and will calculate the recordset on open. But an ADO recordset is not a string so can't be assigned. Not sure where to take it from here. :rolleyes:

How skilled are you in VBA? What you want to accomplish would be a lot easier if you first setup the main form, the one subform with page breaks on it. And then on the last page have a button to submit the new record. Behind that button would be code that would walk through all the fields in...

Look up conditional formatting. That'll do what you're looking for. It's under the format menu.

Hey Kevin, been awhile. I've tried to do this before and have never been successful. But now that I know a little more I think I might be able to. First question, is the form set as continuous or single. I think single would be easier in this situation. Then you would have to setup custom...