Search results for query: *

We are using SAP B.O. version 4.2 support pack 4. We have been successful with using hyperlinks to various t-codes in SAP. However, we are experiencing a problem when using the t-code CATS_DA. The situation for this hyperlink application in a B.O. report requires the use of the Key Date...

I am currently using MS Access 2010. I would like to create a macro that exports the results of a query to an Excel spreadsheet. I see that I will use the ImportExportSpreadsheet action in the macro module. How do I export the results to a specific worksheet within an Excel workbook?

I am using Access 2010. I have a combobox in a continuous form view of a subform that is based on the results of a combobox in the main form. Everything works fine input-wise! I am able to populate all the controls/fields as intended. However, when I view the records the subform combobox is...

I have inherited an Access 2003 database with user level security. that is, an mdb file with a corresponding MDW file. I want to use this database in access 2007 or access 2010, or at least make a copy of it and modify it. But I am unable to copy or export any of the objects, or open certain...

I am using Adobe Acrobat, version 10.1.5. I have certain documents that I would like to blank out certain amounts, but in a nice clean way. They have been scanned by our photo-copier/scanner. I do not want to type over these amounts, as it looks unprofessional. The recipient is not expecting...

I am using Access 2010 and have a linked table of Cost Code values and each cost code can have one or more Cost Type values. The linked table is a spreadsheet from our main ERP. I would like to have a report that shows all cost types for each cost code. e.g. Cost Code Cost Type...

I have split a 2010 Access db and users have a FE on their computer's hard-drive (C:) and the BE is stored on a network drive. Every so often a user will experience the following message when opening their FE, The Microsoft Access database engine cannot open or write to the file ". It is...

I am using Access 2010 and am developing a form where the user provides a full address - street number, street name, city, province and postal code. I want a control to calculate the distance from this address and a fixed address. I'm not sure where to start. Any input would be greatly...

I have inherited an Access 2007 database and have successfully maintained it in now for several months. I plan to split this database into a FE and BE. However, I have also decided that I want to migrate to Access 2010. What should I do first - split in 2007 then migrate to 2010 OR migrate to...

My company has acquired IBM Cognos Connection Version 8.4.1. This is a great utility because our main ERP has become quite dated and very limited in it's functionality. I have created queries and schedule the output as Excel spreadsheets for distribution through e-mail. However, there is...

I am using Access 2007 and created a split form based on a table. There is a field called cost code. A cost code may have one or several records from this table. I created a combo box based on cost code to select the records that appear on this form. I have raw data (hours) from the table on...

I am using Access 2007 and have a form that was primarily set up for viewing and editing data in a table. I have a combo box - from an unbound control - that searches and displays records based on a field called Cost Code. It is not the primary key for this table. Now I want to give the user...

I am using Access 2007 and have created a split form. Using the wizard I then added a combo box for the user to select records based on a field called Formatted Cost Code. The wizard left a macro in the After Update property of the control for the combo box. I converted this to VBA using the...

I am using Access 2007. I have a split form that reads from a table that I created. I have created a control on this form that uses DLookup to get a rate from an imported table based on data in the form. I have tested several records manually and the rate that appears is correct. Therefore I...

I am using Access 2007. I have a subform with a bound control (Control A) and it wants an input value from the user based on two other controls on the Main Form, (Control X and Control Y). The user can select either value or enter a third/different value! The user now wants Control A to show...

I am using Access 2007 and have developed a parameter prompt query and then a split Form based on this query, named Form1. Now I want to use a combo box instead for the user to select values instead of the parameter prompt. So I added a combo box to Form1, and it was assigned Combo26. In...

I am using Access 2007. This is the continuation of a posting in the Queries forum called "Using DLOOKUP in a Query". I have a query that runs properly and now I want to set it up as a Split Form and allow the user to make changes to the data. I used the 'Split Form' wizard(?) in access 2007...

I'm using Access 2007 and struggling with DLOOKUP in a query. There are two tables - PayrollTransactions and RateMaster. They are joined properly. I have tested for this. My formula is =DLOOKUP("[RateMaster]![Rate]","[RateMaster]","[PayrollTransactions]![TransDate] between...

I am using Access 2007. Form A is based on a query that has a parameter prompt for something called Formatted Cost Code. Later on I developed Form B based on a query that also had a parameter prompt for the Formatted Cost Code. I have Form A set up on the Main Menu. I then set up a button for...

I am using Access 2007 and have inherited a database. It has linked tables of information in the form of Excel spreadsheets, that have been extracted from the main system. The user wants help in developing a much faster and customized approach to billing the customer for payroll related...