Search results

My mistake. I'll need you to include the tables with it. If you could just create a duplicate with the tables included (not linked) that would be helpful. Also, which form was it that you were getting errors one?

Need to see the frontend forms

Hey Navyguy, The thing about autonumber is that once you've got records in a table you can't change any of the existing fields to it. You can create a complete new field and set it to autonumber. Can you post your db here for me to look at?

I am running a pass-through query on an Oracle server. I'm trying to break down a date field to see only the month. Is there an equivalent for Oracle to using Month([Date Field]) in Access?

Well I'll give you the code you can put in a class module to use anyway. I got this out of Access Developer Handbook's. Gotta give credit where it's due. Just copy and paste the whole thing into the class module. Then you call it like this: Dim cdl as New Commondlg Then setup the...

Pat - I can always depend on you to swoop in and give a more simple answer. ;-) I'm losing credibility because of you.

I see. I have a class module in a db at work that uses the Windows open file window to let the user select a file and its path. Then it will return the file as a string variable that you could use in your code. You could have the code test whether the file is still in the same place and if...

This was the first time I got to look at the posts since my last reply. Bad weather where I'm at. Thanks for all the replies. I'm going to try some out right now. Originally I set up the db so they could only open one form at a time and so I understood why they opened multiple copies. But...

Why does the drive change? Is the user moving the application around?

Not the case. Multiple users hooked up at the same time. What I'm finding is they're opening multiples so that they can have different forms open at the same time and it's causing a lot of headaches.

Is there a way to prevent a user from opening multiple instances of a database?

You need to create a custom toolbar and then set its properties so that it's a popup menu. Then you can setup a form with its shortcut menu set to your new toolbar.

From my experience in replication it's best to never let any frontend connect to the design master. I keep that on my computer only where I can make changes as needed. Do you have a replicated BE on each laptop to which the laptops FE connects? That's the structure you need so they can be...

Are most or all of your tables on the SQL server? If all then you're better off using an Access Data Project. They're designed specifically for connecting to SQL Server.

YES!! Thank you. That did it.

What is it with crosstab queries?? I have one based off another query. In the first one there is a criteria that references a combobox on a form. Running that query works fine on that criteria. But when I run the crosstab off of it it says it doesn't recognize that parameter as a valid field...

GHudson Tried your code. All I changed were the names of the paths and files. It runs through the whole thing and gives me the message at the end but no zip file is created and no error is given. Could this be because I don't have a registered version of winzip?

I tried your suggestion but got the same error. Is it possible I need to use something other than dbo for an Oracle db?

Hey everyone, I'm trying to use pass-through queries for the first time. Trying to access an Oracle server through Access. I've had tables linked from the server for a while so I know I can connect to it. For my first query I tried something simple just to try it. I setup the connection...

Is there anything I can do to prevent this?