Search results for query: *

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...

How does one go about doing this? I have a main table (tblMain) with several other tables related to tblMain in one to many relationships. Is it possible to have a tabbed form object with the main form (tblMain data) in one tab and subforms in other tabs of the same form for the related tables...

There is a networked Access database shared by some users with Office 2007 and others with Office 2010 installed on their computers. The database is set up in 2007 (whose accdb format opens natively in 2010). Unfortunately, if a 2010 user changes the design of an object, the database...

I have a main form with two subforms in it. One of the business rules is that there must be data in the two subforms before the record in the main form is saved. The problem is that the record in the main form is automatically saved when either of the subforms is entered. Therefore, if I test...

How about me.undo?

I understand that it is a cardinal sin to save duplicate data in a database and was wondering if someone could suggest an alternative to my current approach. I import a log file of user logins into a database every month. The user's active/inactive status for the month is dependent on whether or...