Search results

gold007eye, I had a look at SciTe but I'm not sure what to do with it in relation to what we're talking about. I would be very curious to see what you have finally come up with as your copy front end solution, so will await your next post. I need to create some kind of startup logon script that...

Hi, I have similar environment and have got the automatic updating of front end to work via the batch file etc. But - a lot of users on the network have slower pc's and connections. If the db closes, copies from server, and as it is copying the user opens it - the database corrupts. I have...

wow that was a blast from the past, forgot about that. Yes it fixed itself, I "think" it was after installing the latest Office 2003 updates. Have you checked if there's updates available ?

nope, tried that also. VERY reluctant to reinstall windows - he's got so much stuff on there. Must be a solution?

Thanks Wayne - tested on a network db and still same error messages, and yes they can put a notepad file in the same folder. Everyone else has exact same databases and computers - no problems, and nothing's changed on his pc or setup and it's been working fine until now. Even with several...

Thanks, but don't think that's the issue - it's been working perfectly for months, then all of a sudden this comes up - no change to any settings or the computer. The folder the databases are in has full rights to the user. Also the Northwind db that comes with access gives the same error.

Been using Office 2003 since it came out without a glitch. Yesterday one of our users is getting some strange errors when trying to run Access. Error: Microsoft Office Access Workgroup Administrator couldn't create the workgroup information file. Make sure that you have specified a valid path...

Thanks that worked. As I will never be enabling it, only disabling for good - do I need all that code. Is there not just one command that disables it when startup form opens? Maybe not. Either way is it possible to do the same for the min/max buttons?

popup and modal don't quite work - I lose the top bar where I have a custom print icon. So again I have everything hidden that I need except the min/max/close buttons of the actual database...

Thanks, I seem to have everything now except for the minimise / maximise / close buttons hidden. I disable these on the form, but it's the actual database ones that are still there at the very top right. How do you get rid of these? Just saw reply above, I need the database maximised on opening...

Thanks, that's excellent. One more - how do you disable the minimise, maximise and close top-right buttons on each screen/report?

Thanks Len, copying tables from another database wouldn't be an issue here. Using Citrix NFuse to port Access db onto the web - all they see is the one database, they have no way of creating a database and linking to the tables, all behind a secure firewall. So could you tell me how to do the...

We are allowing a customer to access one of our Access (2003) databases online. How to you secure access so that the following apply: No right-click menu on any screen or report No toolbar or menubar except for an icon to print and an icon to close form/report Absolutely no way of getting into...

Have been using sendobject commands in Access 2002 for creating automatic emails in Outlook 2002. Seems after upgrade to Office 2003 you cannot insert message text?? For instance: DoCmd.SendObject , "", "", "Jim", "", , "This is the subject", "This is the message detail" sends an auto email but...

ok I give up, I tried bits of the code from the link above but am getting nowhere. All I want is to extract from a specified excel sheet (say C:\testexcel.xls) into an existing table. For instance cell A1 goes to [table].column1, cell C8 goes to [table].column 3 etc. Can someone please supply...

ok I'll try, but am a bit struggling for time and my VB is pretty lame. That transferspreadsheet says you can specify cell ranges though...

no idea where that smiley came from - it's a :

well if you get a minute that would be great, I've tried using the following which is built in but it doesn't want to work: DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel8, [test], "I:\testfolder\1234567.xls", , "D19:D21"

jeez, my vb is a little em "rusty"... How would I go about adapting that to what I want? Do you write code yourself? Could you put something on here that would do it?

I did a search but couldn't see anything specific enough.. ?