Search results

Basically, I have an input on my form which is related to a field and most of the time (2/3 of the time I'd guess), the person using the form will have to type a 9 digit number in but this number varies with no pattern so setting the field's default value is no help. Is there a way to make it...

I've been asked to make a database which does the same job as the attached excel document. Someone on a machine enters the details of the job they've just done like the length of the metal and the alloy it was and it should all get stored. At the top of the page, there's the information...

Access VBA - if worksheet "budget.xlsx" is open, close it Hi, I have a button on a form which the user presses when they're done in access. How can I make it so that when clicked, this button will close an Excel workbook called "budget.xlsx" only if it's open? I can close Excel files from...

I'm running Access 2010. I have a macro which exports my table "tbl_orders" as an excel file called "orders.xls" (I'm exporting for graphing purposes). The details are: ExportWithFormatting Object Type: Table Object Name: tbl_orders Output Format: Excel 1997-2003 .xls Output File: ??? Auto...

In Excel 2010, I go to Data -> From Access -> database.mdb -> hit OK -> hit OK What pops up is a list of all the tables in my access database when what I really want to be able to do is select a query instead of a table and display the table of results from the query in excel. Is there a...

I have made a calculator (for a factory where I'm doing work experience) in access and it basically works out how long a specific task will take to be completed depending on inital conditions etc. My query datasheet view basically has the fields: Task ID; Priority; Duration With the way that...