Recent content by BikeToWork

Andy, thanks for the response. I tried exporting from Adobe Acrobat in all of the export formats it supports. The data still came out garbled because it is not a real table (although it does look like one) but rather OCR data. Some of the pages were fine but most were not. I also tried export to...

I am attempting to get data into Access from a pdf file which was created by OCR. The pdf file has a table format to it but if I attempt to export it to Excel, some of the data shows up in cells while the rest of it puts all of the fields from one row into one cell. In addition, I've tried the...

Thanks for the info @LamarW. Once I deleted the printer the report was printing to and went into design view on the report and saved it, it changed from "specific printer" to "default printer." Go figure. I never did anything with the report to set it to "specific printer" in the first place...

I have a function on a form that prints a series of reports. Most of the reports print to the default Windows printer, but for some reason, one of the reports prints to a different printer. I cannot find anywhere in Access to set the default printer for a report. I tried modifying and saving the...

Your advice is spot on. Thanks, PHV.

I am making a crosstab query based on a fiscal year of invoice amounts in monthly invoice periods. Is there some way to make a crosstab query show periods such as months, even if that period contains no invoice amounts? Currently the query does not display invoice periods as column headers if...

Yes, I understand now that if a function returns a table, the SQL syntax calling the function must refer to it as a table. Thanks for pointing that out. It makes sense now.

Thanks, @philhege. That works like a charm!

The function shows up in Programmability/Table Valued Functions and has two parameters. It is used for splitting a string with delimiters. The function is: ALTER function [dbo].[ParseString](@String varchar(500), @Delimiter char(1)) returns table as return ( with Results as (select 1 as...

I should point out first that I am a relative newbie to SQL Server, with more experience in MS Access. I do not understand why I get a "Cannot find either column "dbo" or the user-defined function or aggregate "dbo.ParseString", or the name is ambiguous." message whenever I try to use a...

I think you need a "FROM" clause in your UNION ALL SQL statements. You don't tell Access from which table(s) to select the fields from. You need to put FROM DAVLOGIC_TAPOPS in each of the SQL statements.

How about checking the ldb or laccdb lock file? That may not tell you which user has a specific table locked, but at least will let you know who is in the database. Just open the lock file with a text editor and it will contain the usernames of people currently in the database.

When a user enters a value in a combo box then deletes the value, the message in the subject line comes up and the user cannot exit the combo box until a non-null value is entered. I've tried to trap the error but have been unsuccessful so far. I tried putting code in the Change event for the...

The main form's recordsource is Select * from tblMain. There is a PK field in tblMain called Autonum that exists as a foreign key in all related tables, including tblConsent. If I take the form named frmConsent based on Select * from tblConsent and drop it directly on the main form, it lets me...

MajP, thanks for the response. The main form and subforms are all bound. That's why the error msg makes no sense. However, the subform is not physically inside the main form. The main form and sub form are on the same tab control, but different pages. What I'd like to do (if this is even...