Search results

You cant add the SQL straight to the TextBox control but there are a couple of alternatives.... You can use Dlookup in the text box control source and point to your table. Or you could run code on the refresh of the form to populate the text box. Hope that helps

Just use the DateAdd function to add x amount of time onto a date. So.... DateAdd("d", 7, Now()) The first parameter is for the interval... d for Days, m for months etc etc the second parameter is the number of intervals, in this case 7 days. And the final paramter is for the date to add...

All security information is actually stored within the .mdw file. When you create users and groups within the mdw you have to enter a 'PID' value. This value relates specifically to the user you have created. You then use your created workgroup and set permissions to objects etc within your...

You are passing those in as strings arent you? I'm guessing that PARKSQAADMIN is a string variable that contains the name of your DSN? If not and that is the name of your variable then it should have qoutes around it... Otherwise it should work fine. Let me know how you get on:p

I wouldnt dismiss Access (.mdw) security straight away. For a start replacing a created security file with the standard .mdw file will not give anyone access to your database. It is possible to get hold of software that will rip a .mdw file and give up all the user names and passwords but your...

I'm guessing that your using access security here and have created a ReadOnly workgroup? So what you need to do is either.... On click of button establish whether the user is in the read only group and if so pop up a message saying sorry bud.... or my preference.... On open of the form...

Yeah the codes pretty handy, should really be updated to work for more data sources than SQL Server... so If someone fancies updating or already has something please post!!!!!! I run this function every time my database opens, usually this will be opened on a PC again and again so the DSN...

That should have read.... call fexporttoExcel(me.recordsetclone, "c:\", "Test.xls")

You need to add a reference to DAO to in your application to use the code suggested. Open a module and click references, then find microsoft DAO and add the reference. I'd probably use a different method though.... Ive pasted in two of my functions for you. One is a simple function to open...

first up you should try and get used to using "dd mmm yyyy" for all your date formats, stops potential confusion with US / UK date formats. Then I would put "#" at the start and end of the dates this tells Access that this the following value is a date. so I'd have something like this...

Didnt think u were stupid tay! Sorry if I sounded rude, didnt mean to!!! Unfortunately not able to convert everybody at once due to the number of users involved in the migration, about 1000+. The users migrations are staggered which means I need to have users logging in from 97 and XP machines...

Parts of it came from the net, unfortunately I forget where, with improvisations from myself! This code has been checked in 97 and XP so should work ok for you.

Moving the BE to XP is not possible at the moment as the 97 users need to be able to access the data as well.

Try the following bit of code, call the fCreate_DSN function and pass in the name of the DSN you wish to create as well as server name and Database. It assumes a few things but you can probably see the options for yourself in the code. The function will also check for existing DSN and only...

Ive searched the archives for some previous postings on this but found none so accept my appologies if youve seen this before. Does anyone have experience of running an FE, BE Access solution that has different format FE's accessing the BE data? For example.... 10 Users with locally installed...

Ok I found out how to do it... I noticed that a few people had been stuck on this without resolve so....... dao.dbengine.SystemDB = "c:\Secu.mdw" Then use the createworkspace command with appropriate username and password, then use OpenDatabase as normal. Cheers

Not too sure what your request is but if: Your trying to send 2 reports in 1 email then send object wont work I'm afraid! You can only send 1 object at a time with sendobject. However you can of course send the report twice in 2 emails. Otherwise its a case of having a look at the Outlook...

Quick one this, and probably easy as well!!! But we can't remember how to do this here!!! I'm using Excel 97 and want to connect to an Access 97 database to retrieve some data. The database uses access security. Were connecting to the database using DAO... First creating a workspace object and...