Search results

Rich, I feel we're getting closer, but this is still not quite what I'm looking for (although the code you provided may prove useful in the future!) acSysCmdGetObjectState only has 3 return values: - Open - New - ChangedButNotSaved I need to be able to determine between a report open in...

Yes, I've already looked at that and that is for forms not reports, the CurrentView property doesn't exist for reports!

How do you detect if any reports are open in preview mode? With a Form you can use the CurrentView property, but this doesn't exist for reports. I can detect if a report is open (Reports.Count), but I need to know whether this is in design or preview mode.

Thanks Rich, Now sorted.

I've have a report which contains 3 sub-reports and the totals from these sub-reports form the calculations appearing on the main report. This works fine until one of the sub-reports returns no data. Then the calc on the main form returns an error as the control the calc is based on no longer...

Just when you give up hope, along come 2 solutions at once. Many, many thanks :)

This isn't as straightforward as the title suggests! Does anyone know of a way to call a procedure by using a variable that contains the procedure name rather just typing the procedure name into the code. For example, if I wish to run a procedure called 'Calc', usually you would just type...

Yes, it is an option - but messy! If it were to be done via code, the Access would have to be restarted for the registry changes to take affect.

I've found the answer, well a reason why it's happening. It appears that when Access is originally installed and the Text Data Source database driver is set-up. The default settings are Format = CSVDelimited This setting is stored in the Windows Registry and not in Access. If anyone wants...

If I import a tab delimited file into Access by hand it auto-detects it as tab delimited. Why then, if I try to replicate this using VBA does it exist on thinking it's comma delimited:mad: The line I'm using is this: DoCmd.TransferText acImportDelim, , "Import", strPath & strFile, True Is...

I've experienced a similar problem to the one you describe. I had a form that was used to import a large data set into an existing table. But sometimes, not always, this process returned the error 'record locked - in use by another user'. This other user was always me:eek: . I knew I was the...

I'm about to start work on a BIG multi-user database (big in terms of records, not complexity). I'm considering two potential ways of setting this up (both constructed as BE / FE). Either putting all the data on one BE .mdb or splitting the data into 2-3 BE's. The data involved can be easily...

If you create a SELECT query based on each table that contains all fields from the table, but include the following field in place of the tel.no fields. For the Customer table use Tel: Right(Trim([Tele1]),7) ie truncates the text field to the last 7 chars For the ProspectiveCustomer table use...

Have you tried repairing the database? Under Tools, Database Utilities.

The following line will delete all records from the table. db.Execute "DELETE * FROM BalanceTable" HTH

You've hit the nail on the head in your last paragraph!! You're 'undeclaring' [frm] at the end of each procedure by using {Set frm = Nothing }. That's why you're having to redeclare it at the start of each procedure. While I agree it's prudent to conserve memory by freeing up declared...

My email system has just crashed, so I'll have to answer your question here. (It's also useful to keep all questions and answers on the forum, that way when people do a forum search on a topic they then get the full answer ) Anyway, in your original post you state that 'I find that I am...

Rather than using Dim, use Public instead. Public frm As Form_frmOneWindow You'll also need to move the Public statement to the top of your code, i.e. outside any procedure. [This message has been edited by PearlGI (edited 12-13-2001).]

If you're sure you've got the PowerPoint library loaded rather than just the Office library, I'm not sure why you still get a compile error!! Try the following lines and see if you get the same error. Dim objPPT As Object Set objPPT = CreateObject("PowerPoint.Application") objPPT.Visible =...

You need to have the library Microsoft PowerPoint 8.0 Object Library. Then it should work.