Search results

Beloved Gurus Attached is an MS Access database zipped one. This db has two table with few common fields and few uncommon ones. Please help me to come up with a Union Query for these tables, am desperate. Regards Amuna

Dear Gurus Can someone help me fix the error I am getting when running my query I have attached? Please download it and run the 'Union Query'Query1 Regards Amuna

Dear Guruz I have attache my simple database. What I want is to create one query i.e. a union or anything that can put all the information from the five tables together. After that I want to design a simple report containing all the information from those different tables. Yours Amuna

Please help me with this union query from the tables provided. Amunafc:D:D

Dear All Happy new year guys... I thank you all for the good work you did to me in 2010. Amunafc

I have attached a database and Excel sheet. Please write a code so that when I click the button it should automatically take me to where an excel sheet is. Thanks

Import Excel into Access database Guruz I have attached a copy of a database. I want when a button is clicked, it should automatically import an excel file I have attached. thanks

GURUS, I have more than 80 Excel Spreadsheets, and I want to automatically import data to a particular table. I dont want copy and paste, but using any VBA Code or Macros or any command, e.g. if Excle A has 20 records, Excel B has 30 records, then Excel B should start from record 21 to 50...

GURUS, I have a combo box that show an ID and Product. I want two text boxes in the form header to show the data that is in Combo box when ever I select any from the Combo box. i.e. ID=20 and the Product Name=Sugar. I want the Combo Boxes to show 20 and Sugar

Beloved Gurus, Is it possible to limit number of records in a form? e.g. I want to enter only five records and not more than that?

My Windows can not format my 800GB flash (Sony). Please is there any software that I can use to format it?

Guys I have MS-6506 ver 1.0 Motherboard and I just bought a NEW CASING for it and I cant even know where to put POWER , Resert Switch, Power LED etc. Please send me some users' guide or tips for it. Thanks in advance.:confused::confused::confused::confused::confused::confused:

Guys, am not against the rules of this forum but am only looking for assistance. I have Windows 7 on my PC and I cant load Drivers for my above stated scanners. I tried to visit this site: www.mercury-pc.com, but no help. Thanks

Gurus I have the following fomular to find sum/ total in an MS Access Query: Total: [Q1]+[Q2]+[Q3]+[Q4]. in Q1 and Q2 there is Data, while in Q3 and Q4 there in none, not even the Zeros or I can say there are null values. To my surprise I can't get anything, but when i exclude Q3 and Q4 I get...

Folks I have lost my data on a partioned disk. It used to be called D: and now its E: Folks how do you I recover a letter and the data in it? I hope there is a simple way of doing that.:mad::mad::mad::mad:

I am using an HP Laptop. This machine misbehaved and I thought of recovering windows by pressing F11. The recovery program automatically saved my data. No the problem is that when ever i click on "My Documents" folder I cant access it because previously my Windows had a log in PASSWORD. please...

Mates is it possible for me to ask any Windows question apart from Access only?:eek:

Guys I am sending this for the 3rd time nothing has been done yet. I have attached an Access database. The database has a table, query and a report. When I try to run a report, all the totals are showing without any problem. when i try to save my report in Excel it doesnt show some of the...

Hi Guys I have re-uploaded the database with few field names. Please download, unzip and open it. then run the report and export it to an excel or analyze it with excel. You will notice that the totals in the spreadsheet are not showing. it is only showing the following. Is there any way in MS...

Replace Text with actual totals in MSAcces Hi Guys I have re-uploaded the database with few field names. Please download, unzip and open it. then run the report and export it to an excel or analyze it with excel. You will notice that the totals in the spreadsheet are not showing. it is only...