Search results

Have you tried windows Scheduled Tasks in control panel?

If this will be of any help to anyone in the future, I found a solution. In my batch file, before opening the database, I had it create a token file. In the db, create a new module which looks to see if the token file exists. If it does, run the export CSV macro and exit. If it doesn't, open...

Have you tried toNumber(x) ?

when putting it at the start, cmd flashes up and dissapears, but the macro doesn't run. I spotted /runtime too, but this throws up a DLL error on MSo97rt.dll. is there anyway round this without having to install the developer version on 97?

Thanks for this. I did notice /Nostartup but couldn't get it to work, and dismissed it thinking it wasn't the correct way of doing it. However, your link suggests this works. I am also using a workgroup information file. currently by adding /nostartup in, it still runs the autoexec...

Thanks for the advice. I was hoping not to have to alter the access database if possible, but I don't think there is any alternative.

Hi all. Access 97. I know that holding shift will take you directly to the db window. However, If opening through a batch file, is there a switch I can use to tell it to open as if I was holding down shift? (ie, the autoexec macro is ignored and it goes directly to the db window). Many thanks...

Thanks for the reply. found this elsewhere which seems to work. It means I no longer need a batch script. Running directly from excel (forget to mention I was also tying excel into this). DatabaseName$ = "dbpath" Set acapp = CreateObject("Access.Application") acapp.Visible = False...

Hi all, I currently have a batch script that opens an access 97 db, runs a macro, then closes. The user currently sees the app open up and close. Is there a way to hide the access application when running the batch script? Many thanks Kempes

bump!!!!!!!

I think you can just tick the check box for use trusted connection (in crystal when it prompts). try that! Then no password is needed.

Hi, you need to create a datasource for the normal user, otherwise crystal doesn't know what data to access. Go Start/settings/Control Panel/Admin Tools/datasources. Configure the relavant source type (under system DSN) for your database. Now when the user runs the report, select your newly...

acc97. I have a db which uses a secure file to access it. (usernames, passwords,etc). How can I link to a non secure db without having to set up this db with the same security? Is this possible? Thanks in advance. Kempes

Thanks guys. I'll give it a blast.

Hi all, Not sure if this is possible in access but I currently have a continuous form showing all records from a table. when the records exceed the page space vertically, you can scroll up and down using the scroll bar, or scroll wheel on the mouse. However, I don't want to use this as there...

Ah, in that case you need to seperate out the time as a stand along object. Create a new formula field, and enter the following Time(yourdatetimefield) Add this formula field to your selection criteria as between time and time. Now, change the date to between {?from} to {?to} This should do...

OK, right click on the figure you want to sum on (volume) within your details section, choose insert summary. Now choose Sum from the drop down this, and Insert group. Group at the lowest level. This will put a group on your report. Drag the value from group footer to group header so it's on 1...

Out of interest, what dates did you put in to return 02:00?

Could you explain a bit more. I don't really understand what you're trying to do.

you don't need the in ('TS') part. You could change that to = "TS"