Search results

Hi, I have a drop down list populated by a query as below: SELECT id, name, name_start_date FROM tbl_name ORDER BY name_start_date DESC; I would like this list to still be available but the default value to select the closest id for the record with the name_start_date that is nearest the...

Hi, I now see Access has been removed from Office 365 susbcriptions - the only alternative is buying a single license by the look of it. Is there a way to migrate Access Databases to SharePoint (which I understand is included within Office 365 and obviously allows access online). Thanks, we...

Hi, We have an access database that is mission critical to our small business. We use to track orders etc. It has been stored on Dropbox for over a year which has worked fine as only 1 person has been accessing it. Unfortunately we now have a few employees and need to move to a solution that...

Hi, We have recently migrated the employee's computers from Windows XP SP3 and Office 2007 to Windows 7 and MS Office 2010. Since this upgrade our helpdesk has received a high number of calls related to MS Access databases that were working fine in Access 2007. Unfortunately whilst some of...

Hi, Help - My Add New Record button doesn't work....The backstory is a little complicated but essentially this was an Access 95 database that was upgraded through office 2003 to Office 2007 a few years ago (.accdb converted). The database became corrupted post Office 2010 installations a few...

Hi, I am really hoping to use a continuous form to allow users to quickly enter any number of records. One of the fields in this continuous form is an ID (not a foreign key, actually not a key in the database but crucial for other purposes) which is incremental from the last one stored in a...

Hi, I have a table (tbl_invoices) with a field delivery_description of type memo. I have another field on this table invoice_type_id which is a number acting as a foreign key to another table (tbl_invoice_type). When I run a query against tbl_invoices everything is fine, I can see the...

Hi, I've tried searching for this and am struggling a bit... I have a form with four unlinked sub forms on - I am hoping to 1) add a value from one subform to another and more importantly 2) update 1 subform when the other is amended...how exactly do I reference subform 2 from subform1. I...

I have some data that I want to display in a chart: Theme Type Count(Type) Blah1 1 5 Blah1 2 5 Blah1 3 8 Blah2 1 1 Blah3 2 5 Blah3 3 10 Blah4 1 111 Blah4...

Hi, Can anyone advise how to open MS Excel from a MS Access database (plenty online really) but then select a worksheet and a row in the excel sheet (can't find anything)? I also need to open MS Access from the Excel worksheet and I was hoping to use Set oApp =...

Hi, I have been developing an increasing complex access database. It doesn't have a whole heap of data in it yet but ranges in size from 6mb-30mb depending on when I run the Repair/Compact database utility. It really isn't huge at around 25 tables, 60 queries, 15 forms, 15 reports. I need to...

EDIT - I have solved this. I wanted to query a Many-To-Many relationship in an invoice system, I wanted to select all the invoices which included only certain products. However as there were multiple products on the invoices it duplicated the rows. To solve it all I did was create a query to...

hi, Can anyone help - I'd like a button click event to go to a specific tab and that tab contains an sub-form which should open at a specific record. I imagine it's a combination of: [forms]![form1].tab_ctl = 2 Followed by: docmd.openform Struggling to find the answer in google so came...

Hi, I am trying to subtract 4 fields from each. These are "totals" within a sub-form. On the main form want to take 1 of those fields and subtract the other three. For some reason I keep getting the #!type error after I include more than one text box. Any help would be appreciated:The...

Hi, Every time I re-open Access 2010 it pops up stating the following with a blank text box: "[Forms]![Frm_system]![sub_frm_invoices].[form]![invoice_id" I hit ok and the usual invoice_id param text box message box appears again. Once that is over, I gain access. I can browse to the form...

Hi, I have a Dashboard (sort of), a home page with a couple of sub-forms to display data to users easily. One of these dashboards is a list of incomplete invoices, I would like the user to be able to click a button on each of the sub-form (continuous form) rows. This button will then take the...

Hi, I am creating a sample app to mimic an Auction House. It is basically an invoicing application with some product(lot) tracking included. I am happy with the customer/lot section having split buyers from sellers to make things a bit more simpler. I now need two sections - seller_invoices...

Hi, I am currently developing a database to provide a friend with an auction tracking and ordering system. I will have a number of questions the first is related to the Home Page/Dashboard/Summary form I am creating. I basically have a few sections, one of which is a combo box offering the...

Hi, I have a button which runs some VB, it brings up various message boxes as it prints a report to file, runs a query etc etc. I am hoping to display a basic form, which simply covers most of the screen and states "Please Wait" or something. I have already built the please wait form...

Hi, I am looking for some advice, best practice or guidance. I have a form, which the users obviously enter data onto. When the data is entered the click a button which runs a macro. The macro saves the record (which produces an ID displayed on the form), then it runs a query which is output...