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

Thanks lameid. I have followed your suggestion and was able to achieve my goal. I was able to obtain a user's id and password and was successful in converting the database to Access 2007, (accdb file format). Thanks again lameid.

Thanks SpamJim. I am referring to blank out as in erasing an amount completely and leaving that space as blank. I do not want to do a "XXXXXX" over top of the amount. That looks sloppy and unprofessional. When I apply your suggestion I do not see an Edit Object tool as you describe it. My only...

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

Thanks DHookom. I think this is exactly what I need. I will follow the instructions on your link and let you know how it turns out. I am using a single table and its records look like this, Cost Code Cost Type .00.00.0.01 E .00.00.0.01 L .00.00.0.01 I .00.00.0.02...

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

Thanks Duane for the quick response. Yes, all users have the same rights to create/delete files in the network folder where the BE resides. Yes, I did notice a laccdb file in the same folder where the BE resides. I understand that this is for record-locking purposes. Is this connected to the...

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

Okay then Dhookom and Skip, if you are interested. I need to know the distance 'as the crow flies'. I have confirmed that calcluation basis for my task at hand. Any help you can provide in implementing a solution would be greatly appreciated.

Thanks Duane. I do not know if it will be 'as the crow flies' or a distance by roads. Thanks for the API link. I'm not familiar with doing code for something like this. What is involved here?

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

Thank you Dhookum, that makes sense.

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

That worked! It makes sense too. Problem solved. Thank you Dhookom...and PHV.

Okay Dhookom. The table is called tblTransactionsWorkFile, and the form is called frmTransactionsWorkFile. The Record Source property for the form is set to tblTransactionsWorkFile. The Data Entry property of the form is equal to No, and the Allow Additions property of the form is set to Yes...