Replies

Ok, I guess I am going to need more help. I tried copying and pasting the code from that post you listed above and I am not even sure where I went wrong, all I know is it didn’t work.

I guess to start out, I would like to create a button to upload one document at a time from the user’s machine up to the server where the database is located. I’ve been trying to read all I can about the FileSystemObject and it’s properties and methods, but I don’t see anything about opening a “dialog box” and allowing the user to select the file they want to upload. Can anyone elaborate further and provide some well documented code to get me started?

Thanks!

Amanda

Worked like a charm! Thanks so much!!

Regards,

Amanda

Nope. Still shows up, grayed out. Strange huh? I did the CanGrow=True and CanShrink=True to the subform properties and where the sub report appears in the main report. Bummer.

Hummm…ok, I see where you are talking about the Transparent, but it is “grayed out” and I can’t select it. I can only select a color…I selected white, but it was what was already selected so it didn’t make a difference.

Any more ideas?

Amanda

Cecilia,

Set what to transparent? The background on the sub report? Or the element on the main report that brings links to the sub report (if you can even do that…?)

I’m so dumb when it comes to Access…

Thanks,

Amanda

I just went out and looked at the example you posted – it was exactly what I was looking for! Thanks Hans!! And thanks to everyone else that helped me! I’ve got it working now.

Ok, I am not sure I am following you. Right now, the form is set up with the list box (RRAListing) and 3 combo boxes. I am using the AfterUpdate event on the combo boxes to set the RowSource of RRAListing. Like this:

RRAListing.RowSource = “RRAReportsList1”

where RRAReportsList is a query set up in access.

Each combo box has it’s own query so each AfterUpdate event of each combo box sets RRAListing.RowSource to a different query (ex. RRAReportsList1, RRAReportsList2, etc.) I want to create some buttons that will allow me to sort the query results show in RRAListing list box. You are saying I can append “ORDER BY” to the end of the existing SQL? Can you show me some code so I can see what you are talking about?

Thanks,

Amanda

Great idea! I think I’m going to split the actual DB from the forms and reports that use it. Thanks so much, you are AWESOME!

Regards,

Amanda

Thanks so much guys! I understand the the approach of not letting them see the Database Window – trust me, I’ve been burned before too. But, when you are a small pawn like me there isn’t much I can say to make them change their minds (other then laugh in the faces when they delete a table…)

Thanks again,

Amanda

Charlotte,

Yeah, when I say “application” I’m talking about the actual database itself and the forms and reports that are included in it. There are some cases in a form where I am calling the function to create and open the Conn object so can use it to grab a recordset from the tables in the database so I can manipulate and use in the in VB behind the form. So the database is accessing itself I guess – does that make sense? Anyway, so on the Conn.Open the DataSource is set to location of the database itself. But then I can’t move the database into another directory without changing the data source in code. So, is there anyway for the database to “know” where it is and input that dir/path into the Data Source? I was thinking about the DAO use of CurrentDb, but then I’ve got to go through all of the code behind the forms and reports and look at how I am using the Conn object and redo it to fit with the DAO format. If this doesn’t make sense let me know and I will try to explain it better….

Thanks again!

Amanda

Charlotte,

I’m sorry, guess it didn’t occur to me that I could change the subject otherwise I would not have cross-posted the question. Oops!

Everyone,

I am going to close the connection in the unload of the form again and see if it fixes the problem. I think I tried that already, but it is worth another try…

Thanks for everyone’s help! I don’t know if I have ever found another thread that is so helpful and responsive!

Amanda

Yup, tried compacting and repairing too. No luck. *sigh* I’m about ready to go crazy! Just can’t figure it out…..

Thanks for everyone’s continued help!

Yup, closed and re-opened the DB a couple of times just to be sure.

Thanks for you help. I really do appreciate it.

Regards,

Amanda

Rory,

1. Yes, Conn is declared outside the procedure and is Global
2. I am not sure why I am putting the function call in Current instead of Open or Load….?? Must have been developing and put it there by mistake. Good catch!
3. I commented out he GetDBConnection = Conn line (good catch again!) but am still stuck with the same problem. I am still getting the runtime error when I switch from design mode to view mode.

Is there a setting in Access that I may be missing that would not lock the database when a form (or other object) is in design mode? I still think that the database is getting locked while it is in design mode and then when I flip back to view mode and the VB ADODB connection string tries to execute it fails because the database is still locked from it previously being in design mode.

Any ideas?

Regards,

Amanda

I tried that already too (closing the Conn object), but I don’t think the Conn object itself is causing the problem. The database seems to be getting locked while in design mode through it’s own processes, not through the VB connection that I created (cause VB code attached to a form is not executed if you are in design mode). Then, when I flip into view mode, the VB Connection I created gets executed, but because the database is locked (from previously being in design mode) the connection I try to create in VB causes the error because it cannot connect to the database because it is locked. So, how do I close or cancel the lock that was placed on the database while I was in design mode? Is there a setting somewhere that would change how a database is locked when a user has it in design mode?

Man, I am stumped … thanks for all of the help, and if you (or anyone else for that matter) have any other ideas, PLEASE let me know.

Regards,
Amanda