Search results for query: *

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

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

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

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

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

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

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

A client wants me to develop an Access database to hold 3,000,000 rows of data that they have in a different format. I know the size limit for an Access 2007 database is 2GB. Although having a table with 3 million rows of data won't necessarily make the database over 2GB, it would be pushing the...

I have a main form with a subform in it. The subform table has a one to one referential integrity (cascase updates, deletes) relationship to the main table based on the autonumber ID from the main table. The subform is linked to the main form on this ID field. What I want is for users to enter...

I am working on a a denormalized database that has about 5 main data tables, and about 70 lookup tables. It is currently set up with lookup fields and multi-valued fields which I am replacing with normalized fields. The goal is to make the database upsizable to a SQL Server back end. What...

I am rather new to Access 2007 and am working on a database with "multi-value" fields. I know most people oppose designing databases with lookup fields and these multi-value fields seem like lookup fields, only worse. They not only denormalize the database but make it so you're wed to Access and...

What would be a good place to find such an Access database? I have been tasked with designing and implementing such a database for a 50 person office. Thank you in advance for any leads.

I support a networked fe/be Access 2007 application. There is never a problem with the backend but the frontend frequently gets corrupted. Multiple users share the same front end. Unfortunately there is no workaround for this since there is no way to access users' hard drives to copy the front...

I have a networked Access database that someone (or some process) keeps deleting. Does a user require r/w + delete permissions to the folder where the database resides? Is delete permission required to delete the lock file? If possible, I would like to set it so that users can have r/w...

I have several queries with the below nested IIF criteria. The field Project's 2nd character determines which option year a project is. If it is 4, the option year should be '4OY', if it is 3, the option year should be '30Y', if it is 2, the option year should be '2OY' and if it is 0 the option...

I want to use a two dimensional array to pull file properties such as Date Created, Size, etc. for a given file using the filesystem object in vba code. The first dimension of the array is the index of the file number in the directory (0,1,2,3, etc.). How can one redim preserve the first...