Search results

I have recently upgraded to Access 2007. An application that runs perfectly in 2003 was converted to 2007 format. A command button on the main menu runs a Quit macro to return to Windows. When I use this in 2007 I get the message "The 'Quit' macro action cannot run with the specified 'Options'...

I have recently upgraded to Access 2007. An application that runs perfectly in 2003 was converted to 2007 format. A command button on the main menu runs a Quit macro to return to Windows. When I use this in 2007 I get the message "The 'Quit' macro action cannot run with the specified...

I have extensive experience developing application in Access 200/2003. I've been presented with an opportunity to develop a manufacturing process database but the client wants it developed in 2007. What is the learning curve for 2007 for those with prior Access experience? This is a great...

My contract developing Access applications ends in two weeks. The first of July I head to the Andes mountains of Venezuela to work with my non-profit organization Andean Aid. I love this work - even more than working with Access. :D Visit us at andeanaid.org if you get the chance. I'll be...

Can I develop Access 2000 an 2003 applications in Access 2007 using the right compatibility mode? I know I could run the aspps in 2007 but can I develope and maintain previous versions in 2007?

What's up with peanuts? When I was a kid EVERYONE ate peanut butter and jelly sandwiches. No kids died at school or went into spasms because they touched a friends sandwhich. And I surely don't recall anyone dying from kissing their sweetheart with peanut breath. Now shcools in the U.S...

I need to enter a date field into an appended table that is the same day but one month prior. For example today is 6/5/2008 and if I ran the query I want the date to appear as 5/5/2008. Thanks for any help on this.

I have an array module which opens a report and sends vendor report cards (245) as RTF files to a folder. The reports are based on the vendor name. All was going well qwhen the client decided that the file name needed to use the vendor number vs the vendor name. The vendor number is a field...

I have a vendor report card application which creates an individual RTF file for each of 245 vendors through a module with an array. The files are named as shown below. for example a file name might be April 2008 - ford motor company.rtf . DoCmd.OpenReport "Report Card YTD", acViewPreview, ...

I have a report that provides report card performance information for 245 vendors. An array in a module sends each page of the report (By vendor name) as an RTF file to a specified folder. In this module the report is opened and each report (page) is viewed (DoCmd.OpenReport "Report Card...

I inherited a report that shows performance for 245 vendors. An array creates a seperate report (one for each page of the Access report) for each vendor in RTF format. It works beautifully except for thwe fact that the output winds up, usually, in my C drive My Documents folder though it can...

I have a table with more than 700,000 records. There are no unique fields or unique combination of fields. I would like to add an AutoNumber field but when I try I get the message: File sharing lock count exceeded. Increase MaxLocksPerFile registry entry. If I answer yes I get an error that...

I have three queries that count non-compliant records in each of three catagories per month. One catagory has records for both Jan and Feb and returns the rersults as follows: Jan 3 Feb 4 The other two vatagories however have no non-compliant records for January so they return as follows...

I have a database where the majority of fields are the same record to record. For instance the only thing that changes is the line item number for a purchase order. I have a button that copies most of the fields to the next record (code is below). The problem is that if any field does not...

I have a form with two required fields. I have used the following code to show a message box and set the focus to the proper field. It works great if a field at a tab stop after the required field is chosen. The problem comes when a user begins a record the goes straight to the create a new...

I have a form from which I send and Email to the responsible party for a task. The e-mail address is picked up from a fielsd in the form named Email and the VBA runs on an on click event from a button on the form. The only problem is when someone clicks the button but there is no email entry...

I have a continuous form that shows quote information for a geographical area. On this form is a command button that opens a form based on a query based on a linked table from another database. The related field is purchase order item number. The form shows communication between the company...

I have a large table (over 20,000 records) where the text fields were all set at 255 - even those requiring a single character entry. Is there a way to determine the highest existing character count for each field so I can set the text fields to a reasonable setting? After a compact and repair...

I have a form for table data enrtry. Data entry using this form will take place during a phone conversations with customers. One of the fields I would like to capture is the date and time of the call. If I use the Now() function the date time changes and does not fill in the field on the...

I have an Access query that lists completed company forms by days to complete in descending order. I want to use the reccord number and total record count to present the percentage of forms that were completed at each completion date. Ther purpose is to quickly show that 80 percent of forms...